Subscribe: Pasha Golub's Blog » PostgreSQL
Preview: Pasha Golub's Blog » PostgreSQL

PostgreSQL – Pasha Golub's Blog

Nullus est in vitae sensus, ipsa vera est sensus

Last Build Date: Wed, 25 Apr 2018 10:08:09 +0000


Re: Creating 1 million users in PostgreSQLdhammakaya-pagoda-472496_1920pashagolub

Tue, 19 Dec 2017 11:36:45 +0000

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

Media Files:

Code Quality Comparison of Firebird, MySQL, and PostgreSQLimage1pashagolubimage7

Wed, 29 Nov 2017 08:14:39 +0000

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

Media Files:

PostgreSQL on Android?pc-1571963pashagolub$ pkg search postgres

Fri, 24 Nov 2017 13:07:34 +0000

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?

Media Files:

psql on bash on Windows2a6031c9d53d48fda501d84bac7089ffpashagolub1zjn2a

Fri, 17 Nov 2017 12:59:28 +0000

1. Windows 10 supports Subsystem for Linux. 2. psql has some issues with non-English locales under Windows, see Notes for Windows Users. So I installed WSL, then choose Ubuntu, started Bash and executed: pasha_golub@PASHA:~$ sudo apt install postgresql-client Cool. Now I have native Linux psql and, of course, I want to try Pavel Stehule’s Postgres … Continue reading psql on bash on Windows

Media Files:

Some Warsaw photosbook-1977235_1280pashagolubCHM IconUnblock CHM

Tue, 14 Nov 2017 15:15:47 +0000

  Some more on Twitter: PostgreSQL Conference Europe 2017

Media Files:

RDBMS on Stack Overflow trendspashagolubpostgresql-mysql-oracle-mssql-sotrends

Wed, 10 May 2017 09:04:01 +0000

Stack Overflow provided a great tool for creating charts. This is mine for “PostgreSQL vs MySQL vs Oracle vs MSSQL”. PS Oracle and MSSQL have some additional tags depending on version. However, I’m sure we may not include them into statistics because the main tag is always used IMO.

Media Files: