random pg scribbles

pg_timetable v5.3 is out!

pg_timetable v5.3 release is here - new logging features include: disable database logging, plus 4 new ways to control file logging.

1 min read   ·   March 15, 2023

2023   ·   bloat   logging   postgresql   scheduler   what's new  

ER diagrams with SQL and Mermaid

Generate an ER diagram for a PostgreSQL database using plain SQL and Mermaid. Explore entity relationship diagrams for architecture/dev

1 min read   ·   February 21, 2023

2023   ·   architecture   development   diagram   ER   visualisation  

Go & PostgreSQL: FOSDEM 2023 talk

1 min read   ·   February 15, 2023

2023   ·   conference   go   postgresql   presentation   slides   talk   fosdem   video  

Reserve connections for the pg_use_reserved_connections group in PostgreSQL 16

A brand-new patch in PostgreSQL 16 provides a way to reserve connection slots for non-superusers. Find out the news here!

1 min read   ·   February 07, 2023

2023   ·   resources   connection   performance   postgresql 16   what's new  

usql: universal psql?

1 min read   ·   January 17, 2023

2023   ·   psql   usql   postgresql