Abusing PostgreSQL as an SQL beautifier
Even though SQL is pretty easy to read, developers often use SQL beautifier. Is it possible to format queries nicely only using PostgreSQL onboard tools?
Updates for the Postgres Showcase project
The showcase project provides a compact and "hands-on" set of commented samples to help newcomers get up to speed with PostgreSQL.
PostgreSQL: Trivial timeseries examples
How to use the PostgreSQL function lag() and corr() - see basic examples and get familiar with window functions for trivial timeseries.
1-to-1 relationship in PostgreSQL for real
How to implement 1-to-1 relationship in PostgreSQL? Tricks with UNIQUE constraints? Check how to achive that using DEFERRABLE foreign keys.
Triggers to enforce constraints in PostgreSQL
by
Laurenz Albe |
04.2019 Sometimes you want to enforce a condition on a table that cannot be implemented by a constraint. In such […]
DECLARE CURSOR in PostgreSQL or how to reduce memory consumption
This blogpost is about using cursors in PostgreSQL, their purpose and limitations and what DECLARE CURSOR and FETCH have to do with it.
It is a frequent complaint that count(*) is so slow on PostgreSQL. In this article I want to explore […]
unaccent: Getting rid of umlauts, accents and special characters
Unaccent is a useful PostgreSQL extension for improving user experience. Get insight into this extension and its purpose.
Looking at MySQL 8 with PostgreSQL goggles on
Compare MySQL 8 and PostgreSQL for available features, general querying experience and documentation clarity.
Implementing “AS OF”-queries in PostgreSQL
Many databases such as Oracle provide "AS OF" queries (timetravel). This blog explains how to do time travel in PostgreSQL.
