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.