Dimitri Fontaine

Recently I’ve been to some more conferences and didn’t take the time to blog about them, even though I really did have great fun over there.

Tonight I had the pleasure to present a talk at the Dublin PostgreSQL User Group using remote technologies.

Une conférence qui s’attache aux usages de PostgreSQL avec de très gros volumes de données, intitulée Vers le PetaByte avec PostgreSQL.

Last week came with two bank holidays in a row, and I took the opportunity to design a command language for pgloader.

In this article, we want to find the town with the greatest number of inhabitants near a given location.

Yes it did happen, for real, in London: the Emacs Conference.

An history of el-get, the Emacs library that helps you to manage the external elisp bits and pieces upon which you depend!

Hier se tenait la cinquième édition de la conférence organisée par dalibo, où des intervenants extérieurs sont régulièrement invités.

Une présentation en français qui traite des performances avec PostgreSQL, er rappelle la loi d’Amdahl dans le contexte des performances de requêtes SQL.

In the previous article here we talked about how to properly update more than one row at a time, under the title Batch Update.

Performance consulting involves some tricks that you have to teach over and over again.

The Emacs Conference is happening, it’s real, and it will take place at the end of this month in London.

In the article from yesterday we talked about PostgreSQL HyperLogLog with some details.

If you’ve been following along at home the newer statistics developments, you might have heard about this new State of The Art Cardinality Estimation Algorithm called HyperLogLog.

While making progress with both Event Triggers and Extension Templates, I needed to make a little break.

I’ve discovered recently another Emacs facility that I since then use several times a day, and I wonder how I did without it before: C-M-SPC runs the command mark-sexp.

Some skytools related new today, it’s been a while.

This year’s FOSDEM has been a great edition, in particular the FOSDEM PGDAY 2013 was a great way to begin a 3 days marathon of talking about PostgreSQL with people not only from our community but also from plenty other Open Source communities too: users!

The first talk is a presentation of PostgreSQL High-Availability solutions, with different Architectures presented in their context.

The previous article FOSDEM 2013 said to be careful with the PostgreSQL devroom schedule because one of my talks there might get swapped with a slot on the FOSDEM PGDay 2013 which happens this Friday and has been sold out anyway.

This year again I’m going to FOSDEM, and to the extra special PostgreSQL FOSDEM day.

pgloader is a tool to help loading data into PostgreSQL, adding some error management to the COPY command.

Another day, another migration from MySQL to PostgreSQL… or at least that’s how it feels sometimes.

Thanks to Mickael on twitter I got to read an article about loosing scope with some common programming languages.

In a recent article titled Inline Extensions we detailed the problem of how to distribute an extension’s package to a remote server without having access to its file system at all.

We’ve been having the CREATE EXTENSION feature in PostgreSQL for a couple of releases now, so let’s talk about how to go from here.

I’ve been asked about how to integrate the ack tool (you know, the one that is better than grep) into Emacs today.

A while ago I stumbled upon Happy Numbers as explained in programming praxis, and offered an implementation of them in SQL and in Emacs Lisp.

Following some tweet I found myself desultory watching an episode of the awesome VimGolf in Emacs video series by Tim Visher.

It’s hard to read my blog yet not know I’m using Emacs.

Thanks to Mickael on twitter I ran into that article about implementing a very basic Hello World!

As Guillaume says, we’ve been enjoying a great evening conference in Lyon 2 days ago, presenting PostgreSQL to developers.

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

Last week was PostgreSQL Conference Europe 2012 in Prague, and it’s been awesome.

The first talk is about a PostgreSQL Migration (from MySQL) of the Fotolog web site with 32 millions of users, 1 billion photos and 10 billion comments on those photos.

It’s been a long time since I last had some time to spend on the prefix PostgreSQL extension and its prefix_range data type.

I’ve been given a nice puzzle that I think is a good blog article opportunity, as it involves some thinking and window functions.

The talk is about a PostgreSQL Migration (from MySQL) of the Fotolog web site with 32 millions of users, 1 billion photos and 10 billion comments on those photos.

PostgreSQL 9.2 is released!

Please welcome the new stable version of El-Get, the much awaited version 4.1 has now been branched for your pleasure.

I stumbled onto an interesting article about performance when using python, called Python performance the easy(ish) way, where the author tries to get the bet available performances out of the dumbiest possible python code, trying to solve a very simple a…

The PostgreSQL community host a number of conferences all over the year, and the next ones I’m lucky enough to get to are approaching fast now.

Peter Norvig published a while ago a very nice article titled Solving Every Sudoku Puzzle wherein he presents a programmatic approach to solving that puzzle game.

The french PostgreSQL Conference, pgday.fr, was yesterday in Lyon.

A friend of mine just asked me for advice to tweak some Emacs features, and I think that’s really typical of using Emacs: rather than getting used to the way things are shipped to you, when using Emacs, you start wanting to adapt the tools to the way you…

Last week was the annual PostgreSQL Hackers gathering in Canada, thanks to the awesome pgcon conference.

The talk is about a PostgreSQL Migration (from MySQL) of a the Fotolog web site with 32 millions of users, 1 billion photos and 10 billion comments on those photos.

Now that you’re all using the wonders of Cooperative Consumers to help you efficiently and reliably implement your business constraints and offload them from the main user transactions, you’re reaching a point where you have to clean up your development e…

While working a new PostgreSQL architecture for an high scale project that used to be in the top 10 of internet popular web sites (in terms of visitors), I needed to be able to off load some processing from the main path: that’s called a batch job.

PostgreSQL 9.1 includes proper extension support, as you might well know if you ever read this very blog here.