Boris Novikov in PostgreSQL Making Temporal Databases Work. Part 3: Saving Data The temporal database is a database that can keep information on time when the facts represented in the database were, are, or will be valid.... 11 September 2024 19 min read
Grant Fritchey in PostgreSQL PostgreSQL Backups to Support Point In Time Recovery: Learning PostgreSQL with Grant The focus of your backup strategy should not be backups. Instead, you should be focused on restoring databases, because, after all, that’s what matters. Simply... 07 September 2024 12 min read
Lee Asher in PostgreSQL Solving the Overlap Query Problem in PostgreSQL Range queries are a very common task in SQL: selecting dates, numbers, or even text values that fall within some specified range. For instance: all... 03 September 2024 10 min read
Lee Asher in PostgreSQL PostgreSQL Partitioning: The Most Useful Feature You May Never Have Used Partitioning in PostgreSQL was for many years a feature almost entirely ignored, and even today is often thought of only as a means to increase... 16 August 2024 10 min read
Aisha Bukar in MySQL MySQL vs PostgreSQL: Which Open-Source Database is right for you? When I joined a growing startup company as a backend developer, we were at crossroads choosing between MySQL and PostgreSQL for our backend. Our team... 12 August 2024 12 min read
Boris Novikov in PostgreSQL Making Temporal Databases Work. Part 2: Computing Aggregates Across Temporal Versions The temporal database is a database that can keep information on time when the facts represented in the database were, are, or will be valid.... 16 July 2024 20 min read
Boris Novikov in PostgreSQL Saving Data Historically with Temporal Tables: Part 1: Queries In this article we discuss how to store data temporally in PostgreSQL. Temporal database store data in a way that allows you to see not... 28 June 2024 16 min read
PostgreSQL Ryan Booz in PostgreSQL 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... 22 April 2024 15 min read
PostgreSQL Ryan Booz in PostgreSQL Using Common Table Expressions: Transforming and Analyzing Data in PostgreSQL, Part 2 In the first article in this transforming data series, I discussed how powerful PostgreSQL can be in ingesting and transforming data for analysis. Over the... 08 April 2024 13 min read
PostgreSQL Ryan Booz in PostgreSQL Transforming and Analyzing Data in PostgreSQL In our data hungry world, knowing how to effectively load and transform data from various sources is a highly valued skill. Over the last couple... 12 March 2024 20 min read
PostgreSQL Grant Fritchey in PostgreSQL Functions and Procedures: Learning PostgreSQL with Grant One of the most useful constructs in SQL Server is the stored procedure. It gives you a way to do several things. First up, you... 15 February 2024 9 min read
PostgreSQL Grant Fritchey in PostgreSQL Index Types in PostgreSQL: Learning PostgreSQL with Grant As with any other relational data management system (RDBMS), PostgreSQL uses indexes as a mechanism to improve data access. PostgreSQL has a number of different... 09 January 2023 15 min read
