Creating a Full Text Search Engine in PostgreSQL, 2022

A few years ago I wrote about how to “fine tune” a full text index in PostgreSQL 12, but that was a few years ago and things have

Read More

Importing a CSV Into PostgreSQL Like a Pro

Importing data into PostgreSQL can be time consuming and painful – unless you toss the GUI tools and use scripts. I get into this in SQL in Orbit (which I

Read More

Postgres For Those Who Can’t Even, Part 3 – In The Real World

This is part 3 of a series of posts I’m writing for Friendo, a web person who wants to get their hands a lot dirtier with Node and

Read More

Postgres For Those Who Can’t Even, Part 2 – Working with Node and JSON

This is part 2 of a series of posts I’m doing for a friend who’s a JavaScript developer that, according to him, knows next to nothing about Postgres.

Read More

PostgreSQL For Those Who Can’t Even, Part 1

Just yesterday I was talking to a friend about Postgres (not uncommon) and he said something that I found shocking: I can’t even with Postgres, I know JACK

Read More

Fine Tuning Full Text Search with PostgreSQL 12

I’ve written about Full Text Indexing in PostgreSQL before but I was a bit more focused on speed and general use. Today I want to focus on something

Read More

Virtual, Computed Columns in PostgreSQL 12

The PostgreSQL team has been jamming out updates on a regular basis, adding some amazing features that I hope to go into over time but one of these

Read More

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 is unfortunate because honestly,

Read More

Transactional Data Operations in PostgreSQL Using Common Table Expressions

PostgreSQL has a ton of amazing features, often overlooked by developers who prefer to use abstractions to work with SQL and their database. This is a big topic

Read More

Simple Monthly Reports in PostgreSQL Using generate_series

I have a reporting backend for my book/video business that has one chart which I stare at every day: the daily sales: I use Google Analytics religiously, but

Read More