# posterize
[](https://travis-ci.org/talentdeficit/posterize)
an erlang wrapper for [postgrex](https://github.com/ericmj/postgrex)
documentation at [hexdocs](http://hexdocs.pm/posterize/)
## data representation
postgres erlang
---------- ------
NULL nil
bool true | false
char <<"é">>
int 42
float 42.0
text <<"hallo world">>
bytea <<42>>
date {2016, 2, 3} :: {year(), month(), day()}
time {15, 17, 45.3} :: {hour(), min(), sec()}
timestamp {{2016, 2, 3}, {15, 17, 45}} :: {{year(), month(), day()}, {hour(), min(), sec()}}
interval {{6, 7, 8}, 302, 7} :: {{hour(), min(), sec()}, day(), month()}
array [1, 2, 3]
composite type {42, <<"title">>, <<"content">>}
uuid <<160,238,188,153,156,11,78,248,187,109,107,185,189,56,10,17>>
hstore #{<<"foo">> => <<"bar">>}
## todo
* ranges, numerics, time zones and all the other missing data types
* figure out how to encode/decode `undefined` instead of `nil`
* more tests, especially integration
## acknowledgments
this thing definotely wouldn't exist without [ericmj](https://github.com/ericmj) and [fishcakez](https://github.com/fishcakez). all credit to them