Postgres - Big Machine

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

Importing a CSV Into PostgreSQL Like a Pro

Database, Postgres

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

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

Database, Postgres

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

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

Database, Postgres

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.

PostgreSQL For Those Who Can’t Even, Part 1

Database, Postgres

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

Fine Tuning Full Text Search with PostgreSQL 12

Database, Postgres

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

Virtual, Computed Columns in PostgreSQL 12

Database, Postgres

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

PostgreSQL Tools for the Visually Inclined

Database, Postgres

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,

Transactional Data Operations in PostgreSQL Using Common Table Expressions

Database, Postgres

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

Simple Monthly Reports in PostgreSQL Using generate_series

Database, Postgres

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