Spectory Blog

Postgres with JSON, works for me :)

By Amitai B, Mar 20 2016

When designing a web application, one of the first decisions is where and how to store the data. There are many alternatives, and the most popular ones these days are PostgreSQL, MySQL and MongoDB. PostgreSQL and MySQL belong to the SQL camp or storing data in a structured manner that is easily queried while MongoDB belongs to the NoSQL camp that promotes storing data in a semi-structured manner that scales very well but is more difficult to query. In this blog post I will focus on PostgreSQL and on its feature of JSON support that aims to provide some of the benefits of both worlds. This post is not meant to be a SQL vs. NoSQL debate, we have plenty of those :)

Read More