Dimitri Fontaine

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!

Current trend in software deployments is to rely on open source software for entire production stacks.

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 more a hindrance to data manipulation than an efficient tool.

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.

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 with you too.

You might have read it in the news already in Citus’ blog post by Sumedh Pathak: PostgreSQL Expert Dimitri Fontaine joins Citus Data.

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.

pgDay Paris 4th edition happens March 15, 2018!

PostgreSQL ships with an interactive console with the command line tool named psql.

Florent Fourcot has read Mastering PostgreSQL in Application Development and has seen tremendous inprovements in his production setup from reading the first chapters and applying the book advices to his use case.

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 database, the one that’s used throughout the book examples, and also with a Jupyter Network…

The PostgreSQL community made the explicit choice some times ago that they would not use the infamous master and slave terminology.

Today I am very pleased to announce the release of the book Scaling Python from my good friend Julien Danjou!

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, :'variable', and :"identifier").

In our article Exploring a Data Set in SQL we discovered a data set related to music: the Chinook sample database.

Now that my book Mastering PostgreSQL in Application Development is released (and selling well, thanks guys!)

Today is the day my book Mastering PostgreSQL in Application Development launches!

pgloader, your migration companion Migrating data from another RDBMS to PostgreSQL should be really easy.

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 changes.

PostgreSQL has had proper json support for a while now.

Mastering PostgreSQL in Application Development is the full title of the book I am currently writing.

There’s a very rich set of PostgreSQL functions to process text, you can find them all at the String Functions and Operators documentation chapter, with functions such as overlay, substring, position or trim.

In a previous article here we saw How to Write SQL in your application code.

Today pgloader v3.4.1 is released and available!

The reason why I like Unicode a lot is because it allows me to code in text based environments and still have nice output.

The modern calendar is a trap for the young engineer’s mind.

Business logic is supposed to be the part of the application where you deal with customer or user facing decisions and computations.

Sometimes you need to dive in an existing data set that you know very little about.

Kris Jenkins cooked up a very nice way to embed SQL in your code: YeSQL for Clojure.

A recent interview question that I had to review was spelled like this: Find missing int element into array 1..100 Of course at first read I got it wrong, you have only one integer to look for into the array.

I am writing a book to share my knowledge about how to best use PostgreSQL as an application developer.

PostgreSQL Conference US took place in New York City and I had the pleasure to be a speaker there.

You’d better have tested backups explains why you must implement an automated recovery solution rather than merely backup scripts.

I had the pleasure to be invited to speak at All Your Base Conference 2015 about PostgreSQL (of course).

The database landscape has changed a lot in the recent years.

J’ai eu le plaisir de présenter PostgreSQL au Java User Group de Montpellier le 20 mai dernier dans le cadre d’une soirée PostgreSQL is YeSQL.

PostgreSQL Extensions is a tutorial that shows how to solve some real use cases with a practical use of Extension.

Common Lisp users are very happy to use Quicklisp when it comes to downloading and maintaining dependencies between their own code and the librairies it is using.

Le 21 avril prochain se tient le premier pgDay Paris: une conférence PostgreSQL d’une journée complète.

The PostgreSQL for Developers talk begins with a simple use case for developers to solve entirely in SQL.

I was lucky to participate as a speaker to the Nordic PostgreSQL Day 2015 and it’s been another awesome edition of the conference.

The FOSDEM 2015 edition has been awesome this year, the usual mix of meeting with old friends, talking about interesting topics, seeing tremendous activity in all Open Source domains, and having Belgium beers in the evenings.

Backups are not interesting.

Thanks to the Postgres Weekly issue #89 and a post to Hacker News front page (see Pgloader: A High-speed PostgreSQL Swiss Army Knife, Written in Lisp it well seems that I just had my first Slashdot effect…

PostgreSQL comes with an awesome bulk copy protocol and tooling best known as the COPY and \copy commands.

You’d better have tested backups explains why you must implement an automated recovery solution rather than merely backup scripts.

Mercredi 8 octobre se tiendra le prochain Meetup PostgreSQL à Paris dans les locaux de Mozilla Europe, dont la capacité est de 90 personnes !

A ligthning talk about pgcharts, a tool to turn your SQL queries into charts, and share the result.

En juin dernier se tenait le PHP Tour 2014 à Lyon, où j’ai eu le plaisir de présenter une conférence sur PostgreSQL en 2014.

Next month, Postgres Open 2014 is happening in Chicago, and I’ll have the pleasure to host a tutorial about PostgreSQL Extensions Writing & Using Postgres Extensions, and a talk aimed at developers wanting to make the best out of PostgreSQL, PostgreSQL for