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 a chore.
I am not a fan of migrations - never have been and probably never will be. They were interesting when Rails first came out, but now they're pure friction.
Storing documents in PostgreSQL is a little easier, now that we have some solid save routines, a way to run Full Text searches, and some basic Find and Filter routines. This is only half the story...
In parts 1 and 2 of this little series I showed various ways to save a document and then update its search field. I also showed how to do a Bulk Saves of many documents transactionally. In this post...
In part 1 of this series I setup a nice save function, as well as another function to create an opinionated document storage table on the fly. This works well and does what’s needed, but we can...
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...
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...
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. I like SQL a lot – but that...