posterize (0.13.3)

an erlang wrapper for postgrex

documentation at hexdocs

data representation

postgres        erlang
----------      ------
NULL            'null'
bool            'true' | 'false'
char            <<"é">>
int             42
float           42.0 | 'NaN' | 'infinity' | '-infinity'
text            <<"hallo world">>
bytea           <<42>>
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">>}
date            {2016, 12, 14} | 'infinity' | '-infinity'
timetz          {12261247241, 600000} | 'infinity' | '-infinity'
timestamp       381783411081267571 | 'infinity' | '-infinity'
timestamptz     381783411081267571 | 'infinity' | '-infinity'
interval        #{ years => 1, months => 3, weeks => 3, days => 3, hours => 17, minutes => 4, seconds => 13, microseconds => 5 }
json            <<"{}">> | <<"[]">> | <<"{\"foo\":\"bar\"}">> | ...
jsonb           <<"{}">> | <<"[]">> | <<"{\"foo\":\"bar\"}">> | ...
range           #{ lower => 1, upper => 3, bounds => '[)' }

todo

• numerics, geo and all the other missing data types

acknowledgments

this thing definitely wouldn't exist without ericmj and fishcakez. all credit to them