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... 12 August 2024 12 min read 31
Boris Novikov in PostgreSQL PostgreSQL Temporal Aggregates: SUM, AVG & COUNT Across Time How to compute temporal aggregates in PostgreSQL when values change over time. Covers custom SUM, AVG, COUNT, MIN, and MAX... 16 July 2024 20 min read 11
Boris Novikov in PostgreSQL PostgreSQL Temporal Tables: Querying Historical Data with Time Dimensions Store and query historical data in PostgreSQL using temporal tables. Covers valid time, transaction time, and bi-temporal models with SQL... 28 June 2024 17 min read 11
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... 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... 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... 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... 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... 09 January 2023 15 min read
