PostgreSQL
Migrating to PostgreSQL, the White Paper
After having been involved in many migration projects over the last 10 years, I decided to publish the following White Paper in order to share my learnings. The paper is …
category
PostgreSQL
141 posts
PostgreSQL
Submit a Talk to pgDay Paris Today!
pgDay Paris 4th edition happens March 15, 2018! And the Call for Papers is still open, as it closes with the year: the submission deadline is December 31st, 2017. As …
PostgreSQL
Setting up psql, the PostgreSQL CLI
PostgreSQL ships with an interactive console with the command line tool named psql. It can be used both for scripting and interactive usage and is moreover quite a …
PostgreSQL
Mastering PostgreSQL: a reader's interview
Florent Fourcot has read Mastering PostgreSQL in Application Development and has seen tremendous inprovements in his production setup from reading the first chapters and …
PostgreSQL
Mastering PostgreSQL: more about the docker image
The Enterprise Edition of Mastering PostgreSQL in Application Development ships with a docker image that hosts both a PostgreSQL server instance with a pre-loaded …
PostgreSQL
Queen, Princesses, and Workers
The PostgreSQL community made the explicit choice some times ago that they would not use the infamous master and slave terminology. Instead, the documentation introduces …
PostgreSQL
Scaling Python released
Today I am very pleased to announce the release of the book Scaling Python from my good friend Julien Danjou! As Julien says, Python applications can handle millions of …
PostgreSQL
Simple Data Modeling with a Test Data Set
In How to Write SQL we saw how to write SQL queries as separate .sql files, and we learnt about using query parameters with the psql syntax for that (:variable, …
PostgreSQL
The Mode Ordered-Set Aggregate Function
In our article Exploring a Data Set in SQL we discovered a data set related to music: the Chinook sample database. Our discovery led us to find albums containing tracks …
PostgreSQL
What's in a name: “Mastering”
Now that my book Mastering PostgreSQL in Application Development is released (and selling well, thanks guys!), I’ve had some questions about the title. The idea is …
PostgreSQL
Mastering PostgreSQL in Application Development launches!
Today is the day my book Mastering PostgreSQL in Application Development launches! I’m all excited that everybody interested is now able to actually read my book! …
PostgreSQL
Set Returning Functions and PostgreSQL 10
PostgreSQL 10 is now available for everyone to use, and hinted by David Fetter I had to review my previous article on Json and SQL to adapt to Set Returning Functions …