Conferences
FOSDEM 2014
This year again the PostgreSQL community is organising a FOSDEM PGDay rigth before the main event. Have a look at the PostgreSQL FOSDEM Schedule, it’s packed with …
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.
Conferences
PostgreSQL User Group Paris
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 : …
Emacs
El-Get is now Rolling Releases
The code of El-Get has been pretty stable for a long time now. About the whole set of patches against the 4.x series has been about bug fixing corner cases (sometimes …
Conferences
Groupe d'Utilisateurs PostgreSQL à Paris
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 ! Les détails …
Projects
Import fixed width data with pgloader
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 …
Projects
Migrating Sakila from MySQL to PostgreSQL
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 …
Conferences
Back From Dublin
Last week I had the pleasure to present two talks at the awesome PostgreSQL Conference Europe. The first one was actually a tutorial about Writing & using Postgres …
PostgreSQL
Denormalizing Tags
In our Tour of Extensions today’s article is about advanced tag indexing. We have a great data collection to play with and our goal today is to be able to quickly …
Conferences
An Interview about MariaDB and PostgreSQL
At the Open World Forum two weeks ago I had the pleasure to meet with Colin Charles. We had a nice talk about the current state of both MariaDB and PostgreSQL, and even …
PostgreSQL
PostgreSQL Autonomous Transaction
PostgreSQL is an all round impressive Relational DataBase Management System which implements the SQL standard (see the very useful reference page Comparison of different …
Conferences
Open World Forum Conference
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. Of …
Projects
A Worthwile Micro Optimisation
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 it happens, …