PostgreSQL
Database Normalization and Primary Keys
In our previous article we saw three classic Database Modelization Anti-Patterns. The article also contains a reference to a Primary Key section of my book The Art of …
Getting more out of PostgreSQL
Notes on SQL technique, data modeling, and PostgreSQL internals — from the author of The Art of PostgreSQL. New articles are built on the free Lab so you can run every query yourself.
PostgreSQL
Database Modelization Anti-Patterns
Next week we see two awesome PostgreSQL conferences in Europe, back to back, with a day in between just so that people may attend both! In chronological order we have …
PostgreSQL
Sustainable Open Source Development
Current trend in software deployments is to rely on open source software for entire production stacks. You can find open source software in the core technical stacks of …
PostgreSQL
Find the number of the longest continuously rising days for a stock
Today I want to react to an article that claims that Relational Algebra Is the Root of SQL Problems in which the author hand-waves the following position: SQL becomes …
PostgreSQL
Exporting a Hierarchy in JSON: with recursive queries
In another article here, entitled on JSON and SQL, we saw in great details how to import a data set only available as a giant JSON file. Then we normalized the data set, …
PostgreSQL
A Year in Review: Most Read Articles in 2017
It seems to be usual nowadays to review the previous year, and readers apparently like Top-N Lists — that’s you now, so let’s hope that my understanding works …
PostgreSQL
Working at Citus Data
You might have read it in the news already in Citus’ blog post by Sumedh Pathak: PostgreSQL Expert Dimitri Fontaine joins Citus Data. I am very happy to join a …
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 …
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 …