Last Updated: February 25, 2016
·
1.737K
· mdobson

Use Postgres hstore to store schema-less data

While working on my latest product I found out that I needed to start storing schema-less data in my database. While non-traditional NoSql databases appealed to me coordinating the data between two systems was a pain. Thankfully PostgreSQL has hstore. A simple hash storage that allows you to store schema-less data. It was a fantastic solution to the problem, and with the integration via a simple ruby gem it was easy to use.