Dimitri Fontaine

Earlier this year we did compare compare Aggregating NBA data, PostgreSQL vs MongoDB then talked about PostgreSQL, Aggregates and histograms where we even produced a nice Histogram chart directly within the awesome psql console.

A lightning talk about pgLoader and the wide range of input formats it accepts, from CSV to advanced database migration from MS SQL or MySQL to PostgreSQL.

En début de semaine se tenait le PHP Tour 2014 à Lyon, et j’ai eu le privilège d’y être invité afin de présenter comment Utiliser PostgreSQL en 2014.

Une présentation des particularités de PostgreSQL, et pourquoi ce système de gestion de bases de données relationnelles reste d’actualité quand on fait du PHP et de la programmation moderne !

Ce mois-ci est particulièrement actif en terme de conférences françaises, puisqu’après un détour à Toulon pour les PGDay.fr nous avons un Meetup à Paris puis une conférence PHP Tour 2014 à Lyon.

Une présentation de pgloader, utilitaire de chargement de données qui prend égalemment en charge des migrations complètes depuis MySQL ou encore MS SQL Server™.

pgloader loads data into PostgreSQL.

A lightning talk about pgloader and why I chose to rewrite it enterily, switching from Python to Common Lisp.

A couple of week ago I had the chance to participate into the PGConf NYC 2014 Conference, one of the biggest conferences about PostgreSQL worldwide.

Hier soir se déroulait le troisième Meetup PostgreSQL à Paris, et je crois pouvoir dire que tous les participants étaient ravis de cette édition.

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

Last week some PostgreSQL users, contributors and advocates have organized a really great conference in Stockholm, Sweden, where I had the please to give the following talk: *PostgreSQL is YeSQL!

PostgreSQL is YeSQL!

In our previous article Aggregating NBA data, PostgreSQL vs MongoDB we spent time comparing the pretty new MongoDB Aggregation Framework with the decades old SQL aggregates.

When reading the article Crunching 30 Years of NBA Data with MongoDB Aggregation I coulnd’t help but think that we’ve been enjoying aggregates in SQL for 3 or 4 decades already.

Back from the FODESM 2014 Conference, here’s the slides I’ve been using for the Advanced Extension Use Cases talk I gave, based on the ongoing work to be found under the Tour of Extensions index in this web site.

This talk is about Advanced Uses Cases for PostgreSQL Extensions.

This year again the PostgreSQL community is organising a FOSDEM PGDay rigth before the main event.

Notre première rencontre des utilisateurs Parisiens de PostgreSQL avait eu lieue le 28 novembre 2013 et a fait l’objet d’un billet de présentation ici-même : l’article Groupe d’Utilisateurs PostgreSQL à Paris annonce la création du groupe !

The code of El-Get has been pretty stable for a long time now.

Comme annoncé dans un mail sur la liste de diffusion pgsql-fr-generale j’ai le plaisir de démarrer un groupe de rencontres PostgreSQL à Paris !

A long time ago we talked about how to Import fixed width data with pgloader, following up on other stories still online at Postgres OnLine Journal and on David Fetter’s blog.

As presented at the PostgreSQL Conference Europe the new version of pgloader is now able to fully migrate a MySQL database, including discovering the schema, casting data types, transforming data and default values.

Last week I had the pleasure to present two talks at the awesome PostgreSQL Conference Europe.

The first talk covers migrating from MySQL to PostgreSQL in a single command line thanks to pgloader, your migration companion.

In our Tour of Extensions today’s article is about advanced tag indexing.

At the Open World Forum two weeks ago I had the pleasure to meet with Colin Charles.

PostgreSQL is an all round impressive Relational DataBase Management System which implements the SQL standard (see the very useful reference page Comparison of different SQL implementations for details).

Last Friday I had the chance to be speaking at the Open World Forum in the NewSQL track, where we had lots of interest and excitement around the NoSQL offerings.

Une présentation qui montre que PostgreSQL est déjà web-scale, avec un rappel de l’histoire du projet et quelques exemples pratiques montrant des cas d’usages modernes de PostgreSQL.

In our previous article about Loading Geolocation Data, we did load some data into PostgreSQL and saw the quite noticable impact of a user transformation.

As I’ve been mentionning in the past already, I’m currently rewriting pgloader from scratch in Common Lisp.

Have you heard about the Open World Forum conference that takes place in Paris, October 3-5, 2013?

The following story is only interesting to read if you like it when bad things happen, or if you don’t have a trustworthy backup policy in place.

In our ongoing Tour of Extensions we played with earth distance in How far is the nearest pub?

In a previous article about Trigger Parameters we have been using the extension hstore in order to compute some extra field in our records, where the fields used both for the computation and for storing the results were passed in as dynamic parameters.

Sometimes you want to compute values automatically at INSERT time, like for example a duration column out of a start and an end column, both timestamptz.

There was SQL before window functions and SQL after window functions: that’s how powerful this tool is.

About the only time when I will accept to work with MySQL is when you need help to migrate away from it because you decided to move to PostgreSQL instead.

In our recent article about The Most Popular Pub Names we did have a look at how to find the pubs nearby, but didn’t compute the distance in between that pub and us.

In his article titled The Most Popular Pub Names Ross Lawley did show us how to perform some quite interesting geographic queries against MongoDB, using some nice Open Data found at the Open Street Map project.

After spending an awesome week in San Francisco, CA I’m lucky enough to be spending another week in the USA, in Portand, OR.

The migration of a complex system and architecture from MySQL and Java to PostgreSQL and PHP, with plenty details about the context and the trade-offs that were made in the process.

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

Those days feel really lucky to me.

A presentation of Skytools version 3, the replication toolset from Skype that includes Londiste and PGQ.

Last week was held the CHAR(13) conference in a great venue in the UK countryside.

This blog of mine is written in the very good Emacs Muse format, that I find much more friendly to writing articles than both org-mode and markdown-mode that I both use in a regular basis too.

In a recent article here we’ve been talking about how do do Batch Updates in a very efficient way, using the Writable CTE features available in PostgreSQL 9.1.

In a recent article Craig Kerstiens from Heroku did demo the really useful crosstab extension.