Step by step guide to setup PostgreSQL on Docker

Learn how to get started with PostgreSQL using a container to practice database skills.

Timescale Brings PostgreSQL into the GenAI Era with pgai Vectorizer

Timescale embeds advanced AI into PostgreSQL, the most popular database, leveling the playing field and equipping every developer to build AI—fast and hassle-free.

Getting Started With Azure Cosmos DB for PostgreSQL

This article shows how to get started with the PostgreSQL API in Azure Cosmos DB.

Migrate a SQL Server Database to a PostgreSQL Database

Learn about various options to migrate an entire SQL Server database to a PostgreSQL database.

PostgreSQL UNION, INTERCEPT & EXCEPT Operator

Another article on how the SQL language works in PostgreSQL. This time we examine the UNION, INTERSECT, and EXCEPT operators.

Recursive CTEs: Transforming and Analyzing Data in PostgreSQL, Part 3

The first two articles in this series demonstrated how PostgreSQL is a capable tool for ELT – taking raw input and transforming it into usable data for querying and analyzing. We used sample data from the Advent of Code 2023 to demonstrate some of the ELT techniques in PostgreSQL.

The "ORDER BY" clause behavior

SQL Server to PostgreSQL Database Schema Conversion

In this tip, I will demonstrate how to migrate an existing database schema from SQL Server to PostgreSQL.

Daylight Saving Time

Try, Try Again, Until It's Right

A cloud migration for DoorDash interested Steve, primarily because it didn't work, but they were able to back out and try again.