random pg scribbles

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  

Re: Creating 1 million users in PostgreSQL

Hans-Jürgen Schönig wrote a great post “Creating 1 million users in PostgreSQL”. I just love such things! Well done! Thanks. But since there is no possibility to leave comments under original post (BTW why?), I’ll create my own post. When testing such tricks always create temp database. Because I accidentally used… no, no, not the … Continue reading Re: Creating 1 million users in PostgreSQL →

2 min read   ·   December 19, 2017   ·   wordpress

2017

Code Quality Comparison of Firebird, MySQL, and PostgreSQL

I have read very interesting post “Code Quality Comparison of Firebird, MySQL, and PostgreSQL” today about static analysis of three open-source RDBMS. And I wonder, should we use static code analyzers on an ongoing basis, e.g. PVS Studio? tl;dr: So, the code-quality rankings are as follows: 1 place – Firebird and PostgreSQL. 2 place – … Continue reading Code Quality Comparison of Firebird, MySQL, and PostgreSQL →

1 min read   ·   November 29, 2017   ·   wordpress

2017

PostgreSQL on Android?

Yes, it’s possible! Recently I found great Android application Termux. Termux is an Android terminal emulator and Linux environment app that works directly with no rooting or setup required. A minimal base system is installed automatically – additional packages are available using the APT package manager. I installed it and my first command was pkg … Continue reading PostgreSQL on Android? →

1 min read   ·   November 24, 2017   ·   wordpress

2017