All Stories

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).

Bringing The Power of Postgres to NodeJS

I’m building out an idea I have and, as you may have guessed from the last few blog posts I’ve written - I’m using Postgres to do it.

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...

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...

It's Time To Get Over That Stored Procedure Aversion You Have

In the .NET world (and beyond), data access is a cluster-fucked echo chamber of half-assed rocket engineering and cargo cultism based on decade-old cathedralized thinking and corporate naval -gazing.

Inserting And Using A New Record In Postgres

A Problem Postgres Can Solve Easily

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...

Using Custom Types in Postgres

Using Types For Fun and Profit

Being a Nomad for a Year

In Summary Form…