How I deployed a Fast API application on AWS Lambda.

Keep databases schemas in sync across multiple environments with Liquibase.

Manage a single database schema with Liquibase.

Create daily reports from a PostgreSQL RDS instance's logs using pgbadger.

Explore the basics of Liquibase, an open-source tool to manage database schema changes.

How to use SQL window functions to calculate a running total

How to use SQL window functions to calculate a running total percentage

How to use SQL window functions to calculate a moving average

An introduction to window functions in SQL.

Easily create pivot tables in PostgreSQL using \crosstabview.