Designing a PostgreSQL Document API

PostgreSQL as many know, supports JSON as a storage type and with the release of 9.4, Postgres now supports storing JSON as jsonb – a binary format. This is great news for people who want to...

RethinkDB 2.0 Is Amazing

I just turned in my next course for Pluralsight: RethinkDB Fundamentals – almost in time for their announcement that 2.0 has been released. This is very exciting – it’s a...

Membership In a Box with PG-Auth

I mentioned in a previous post that I threw together some ideas one weekend on how to do membership completely within Postgres (users, roles, logs etc). It was fun and quite a few people asked if...

Document Storage Gymnastics with Postgres

With the release of Postgres 9.4 came the additional datatype jsonb. This is binary JSON, the same type of thing that MongoDB uses for internal storage. Postgres has had the json data type for a...

Embracing SQL In Postgres

One thing that drives me absolutely over the cliff is how ORMs try so hard (and fail) to abstract the power and expressiveness of SQL. Before I write further let me say that Frans Bouma reminded me...

Inserting And Using A New Record In Postgres

A Problem Postgres Can Solve Easily Let’s say you need to insert a record into a table and then use that record immediately to push data into another table. This happens a lot with parent/child...

Staying Hungry, Staying Foolish

Playing The Fool Again I’m building a new little venture right now and, for the first time in years, I’m flipped out excited. No no not because I think it will change the world and make...