Posts

Jul 15, 2024
Implementing UUIDs v7 in pure SQL
Jul 1, 2024
Looking at the new built-in collation provider in PostgreSQL 17
May 13, 2024
Advanced psql scripting with coproc
Mar 13, 2024
Using binary-sorted indexes
Dec 14, 2023
Global search inside a database
Oct 20, 2023
The collation versioning problem with ICU 73
Sep 27, 2023
Using traditional calendars with ICU
Feb 21, 2022
A psql hack for select * except some columns
Feb 14, 2020
Isolation Repeatable Read in PostgreSQL versus MySQL
Jan 27, 2020
Multiple strings replacement with plperl
Oct 14, 2019
Nondeterministic collations
Jul 6, 2019
The CSV output format in psql
Apr 24, 2019
OIDs demoted to normal columns: a glance at the past
Mar 28, 2019
Text search: a custom dictionary to avoid long words
Feb 8, 2019
Postgres instances open to connections from the Internet
Aug 27, 2018
Beware of your next glibc upgrade
Jul 25, 2018
Exposing more of ICU to PostgreSQL
Jun 19, 2018
Static and dynamic pivots