databases

PostgreSQL Tools for the Visually Inclined

I started my career on the Microsoft stack building forms and websites using drag and drop tools. Over time that became a punchline, which...
Rob Conery
8 min read

Transactional Data Operations in PostgreSQL Using Common Table Expressions

Working with Common Table Expressions in PostgreSQL is easy and straightforward. You can insert, update and delete data easily, all in one operation, within...
Rob Conery
5 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

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
>