Extend postgres to json fields

For a little side project I need a very easy, “slow” and simple database to contain very few NoSql data.

Even MongoDB was overkilling, so I thought about use a tiny instance of PostgresSQL and use the type “json”.

Unfortunately jdbc does not support (as far as I know) the JSON type, nor for Postgres, so I started google around and two awesome guys did exactly what I needed to do.

First Andrey Antukh “niwibi” in this blog post and then Travis Vachon in this other blog post.

However none of them wrote a library to reuse such code, so here is born postgres-type.

It is just very few lines of code, but it is been thought to be extended, could be interesting, for example, support also hstore.

;; Simone

I am available for freelance work, I am specialized in IoT and distributed fault tolerant systems, if you are interested in working with me you can get in touch here: simone [at] mweb [dot] biz