Working with Common Table Expressions in PostgreSQL is easy and straightforward. You can insert, update and delete data easily, all in one operation, within a single transaction.
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 set this up? Better yet: when should you use full-text indexing and how would...
This last month has been intense. I'm writing the second volume of The Imposter's Handbook with Scott Hanselman, I moved back to Hawaii, and I'm trying to finish up a sprint for a contract I've...
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 get going with right away!
I'm in the middle of writing the next volume of The Imposter's Handbook and I found myself down a Rabbit Hole from the very outset: how can we, as programmers, justify the existence of null in our...
Going out on your own as a solo developer can be terrifying! That's why I made this 1-hour video: to share with you the things I did to scale myself from a solo developer to a successful online...
I was interviewed on .NET Rocks! while at NDC London.
The smallest comment from a good friend can lead to introspecting your life choices. This just happened to me!
I just released a new book about PostgreSQL, Saturn, and Cassini! Quite possibly the most fun I've had writing about data and databases.