What if you could turn
thousands of lines of code into
simple queries?


I wrote a book!


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. So I felt I should take some time and report about my experience at those conferences. And of course, some more is on the way, as the PostgreSQL Conference Tour gets busier each year it seems. *And PostgreSQL Conferences get more attendees each year!* PGCON 2013, Ottawa In may was the famous PGCON conference where PostgreSQL contributors are meeting all together, offering the occasion to run the Hackers Meeting.


Tonight I had the pleasure to present a talk at the Dublin PostgreSQL User Group using remote technologies. The talk is about how to make the most ouf of PostgreSQL when using SQL as a developer, and tries to convince you to dive into mastering SQL by showing how to solve an application example all in SQL, using window functions and common table expressions. *PostgreSQL for developer* And using remote technologies, the presentation have been recorded and made available on the internet:



In this article, we want to find the town with the greatest number of inhabitants near a given location. A very localized example We first need to find and import some data, and I found at the following place a CSV listing of french cities with coordinates and population and some numbers of interest for the exercise here. To import the data set, we first need a table, then a COPY command:


Yes it did happen, for real, in London: the Emacs Conference. It was easter week-end. Yet the conference managed to have more than 60 people meet together and spend a full day talking about Emacs. If you weren’t there, a live stream was available and soon enough (wait for about two weeks) the video material will be published, as sacha is working on it. The conference has been packed with awesome really.

Dimitri Fontaine

PostgreSQL Major Contributor

Open Source Software Engineer

France