random pg scribbles

Announcing pgxmock v3 - Elevating Mocking for PostgreSQL in Go!

I am thrilled to introduce the much-anticipated major release of pgxmock v3! This release represents a significant leap forward in enhancing your PostgreSQL database mocking experience in Go.

3 min read   ·   September 20, 2023

2023   ·   golang   pgxmock   what's new   postgresql   personal  

Indexing `LIKE` Filters

1 min read   ·   September 08, 2023

2023   ·   index   FTS   tips and tricks   postgresql   personal  

PGDay Belgium 2023 reflections

As a senior database consultant and developer at CYBERTEC PostgreSQL International, I recently enjoyed presenting at PGDay Belgium 2023 at the UCLL campus Proximus in Haasrode.

1 min read   ·   June 14, 2023

2023   ·   community   events   pgday   pgconf   postgresql  

LZ4 and ZSTD pg_dump compression in PostgreSQL 16

LZ4 and ZSTD are additional pg_dump compression methods added in PostgreSQL 16. Find out how to use them, & how they compare to GZIP.

1 min read   ·   April 25, 2023

2023   ·   compression   pg_dump   pg_restore   update   upgrade   postgresql   what's new  

Underscores in numeric constants in PostgreSQL 16

PostgreSQL 16 includes support for underscores in integer and numeric constants. Learn how to use them in large numbers without errors.

1 min read   ·   April 18, 2023

2023   ·   sql   postgresql   what's new