Using psycopg2 to Connect Python to PostgreSQL

Learn how to connect to a PostgreSQL database from Python with this popular library.

JSON in PostgreSQL

Learn how to work with JSON in PostgreSQL with this article.

Giving Thanks

My last two months have been packed full of activity. I’ve had the amazing opportunity to be with PostgreSQL friends in New York, Greece, and Seattle. In between, it was a treat to be back in Pittsburgh for the first SQL Saturday since before the pandemic. The strength of the database community at each event […]

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