Conferences
Nordic PostgreSQL Day 2014
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 …
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
PostgreSQL, Aggregates and Histograms
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 …
PostgreSQL
Aggregating NBA data, PostgreSQL vs MongoDB
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 …
Conferences
PostgreSQL FOSDEM Conference
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 …
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 …
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 …