About Postgres
These are the posts I've written over the years, archived here for you and Google. I've decided to move away from blogging here, and moved my stuff over to my newsletter site, up on ConvertKit (love them).
- Designing a PostgreSQL Document API
- Pulling Documents From a Relational Query in Postgres
- Using Custom Types in Postgres
- Inserting And Using A New Record In Postgres
- It's Time To Get Over That Stored Procedure Aversion You Have
- Embracing SQL In Postgres
- Document Storage Gymnastics with Postgres
- Membership In a Box with PG-Auth
- PostgreSQL Document API Part 3: Finding Things
- JSONB and PostgreSQL: Work Faster By Ditching Migrations
- My Writing Process (This Week)
- My New Book About PostgreSQL, Data and Saturn: A Curious Moon
- Interview On .NET Rocks About A Curious Moon
- A Pure PostgreSQL Document Database API
- PostgreSQL Tools for the Visually Inclined
- PostgreSQL Document API Part 2: Full Text Search and Bulk Save
- PostgreSQL Document API Part 4: Complex Queries
- Importing a CSV Into PostgreSQL Like a Pro
- Using Entity Framework 6 with PostgreSQL
- A Better ID Generator For PostgreSQL
- How To Backup Your Postgres DB To Amazon Nightly
- PostgreSQL Rising
- Handling Dates and Times Properly in Postgres
- Creating a Full Text Search Engine in PostgreSQL, 2022
- Striking Gold in My Archives
- The Easiest Postgres Experience You've Ever Seen
- Using Constraints to Protect Calendar Data in PostgreSQL