Postgres

PostgreSQL Document API Part 3: Finding Things

In parts 1 and 2 of this little series I showed various ways to save a document and then update its search field. I...
Rob Conery
5 min read

PostgreSQL Document API Part 2: Full Text Search and…

In part 1 of this series I setup a nice save function, as well as another function to create an opinionated document storage table...
Rob Conery
4 min read

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 –...
Rob Conery
4 min read

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,...
Rob Conery
3 min read

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...
Rob Conery
3 min read

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...
Rob Conery
8 min read

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...
Rob Conery
7 min read

It’s Time To Get Over That Stored Procedure Aversion…

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...
Rob Conery
7 min read

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...
Rob Conery
2 min read

Using Custom Types in Postgres

Using Types For Fun and Profit In my last post about pulling documents from queries I showed an interesting way to return a result...
Rob Conery
3 min read