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.

Is your organization using MongoDB? Help the Redgate Flyway team understand your pain points

Is MongoDB in use within your organization? The Flyway development team is adding MongoDB support into Flyway and would like to better understand the current pain points. If you are able help, or are interested in finding out more, please participate in our 5-minute survey.

Timescale Launches Dynamic PostgreSQL, the Cost-Effective Alternative to Serverless and Peak-Allocation Pay Models

New solution allows developers and teams to “buy the base and rent the peak” when provisioning for variable workloads without wastage or performance tradeoffs

PostgreSQL 101: A guide to PostgreSQL documentation & useful resources

In the latest webinar of our PostgreSQL 101 series, join Ryan Booz, PostgreSQL Advocate at Redgate, and Grant Fritchey, Microsoft Data Platform MVP, and discover:

How to navigate PostgreSQL documentation
The essential things you need to know about PostgreSQL documentation
Other useful learning resources to help make your journey to using PostgreSQL easier

Please register to watch the recording.

PostgreSQL Basics: Getting started with psql

PostgreSQL has a separate command-line tool that’s been available for decades and is included with any installation of PostgreSQL. Many long-term PostgreSQL users, developers, and administrators rely on psql to help them quickly connect to databases, examine the schema, and execute SQL queries.

Knowing how to install and use basic psql commands is an essential skill to have for anyone that will connect to PostgreSQL.

The PostgreSQL Role Part 1

Learn the basics of PostgreSQL security with roles in this article.