Subscribe: Pasha Golub's Blog » PostgreSQL
http://pgolub.wordpress.com/category/postgresql/feed/
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:
http://2.gravatar.com/avatar/5c62509bcb072c7fd0db0e00cf8372ed?s=96&d=wavatar&r=G




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:
http://pgolub.files.wordpress.com/2017/11/image7.png




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:
http://pgolub.files.wordpress.com/2017/11/photo_2017-11-24_15-02-43.jpg




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:
http://pgolub.files.wordpress.com/2017/11/1zjn2a.jpg







Some Warsaw pgconf.eu photosbook-1977235_1280pashagolubCHM IconUnblock CHM

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

  Some more on Twitter: PostgreSQL Conference Europe 2017


Media Files:
http://pgolub.files.wordpress.com/2017/08/unblock.png




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:
http://pgolub.files.wordpress.com/2017/05/postgresql-mysql-oracle-mssql-sotrends.png?w=800