Postgres
Running PostgreSQL on Azure was always a bit of a sideshow. One of the reasons I returned to Microsoft, however, is that they are...
Working with Common Table Expressions in PostgreSQL is easy and straightforward. You can insert, update and delete data easily, all in one operation, within...
Working with dates and series of dates is easy in PostgreSQL, especially using generate_series.
One of the joys of working with PostgreSQL is the ability to run full-text searches right out of the box. But how do you...
Another day, another database project in my repo! This time it's a pure PostgreSQL JSONB document storage API that you can drop in and...
I was interviewed on .NET Rocks! while at NDC London.
I just released a new book about PostgreSQL, Saturn, and Cassini! Quite possibly the most fun I've had writing about data and databases.
Writing a book is fun and can easily consume you. Just like writing software, however, if the tools get in your way, writing becomes...
I am not a fan of migrations - never have been and probably never will be. They were interesting when Rails first came out,...
Storing documents in PostgreSQL is a little easier, now that we have some solid save routines, a way to run Full Text searches, and...
