Conferences
Back from CHAR(13)
Last week was held the CHAR(13) conference in a great venue in the UK countryside. Not only did we discover UK under good weather conditions and some local beers, we also …
Posts
Software Programming
Emacs Muse meets Common Lisp
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 …
PostgreSQL
Archiving data as fast as possible
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. I …
PostgreSQL
Simple Case for Pivoting in SQL
In a recent article Craig Kerstiens from Heroku did demo the really useful crosstab extension. That function allows you to pivot a table so that you can see the data from …
Conferences
Conferences Report
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 …
Conferences
Make the Most ouf of SQL
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 …
Software Programming
from Parsing to Compiling
Last week came with two bank holidays in a row, and I took the opportunity to design a command language for pgloader. While doing that, I unexpectedly stumbled accross a …
PostgreSQL
Nearest Big City
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 …
Conferences
Emacs Conference
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 …
Conferences
The Need For Speed
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. Le thème hier était à la fois clair …
PostgreSQL
Bulk Replication
In the previous article here we talked about how to properly update more than one row at a time, under the title Batch Update. We did consider performances, including …
PostgreSQL
Batch Update
Performance consulting involves some tricks that you have to teach over and over again. One of them is that SQL tends to be so much better at dealing with plenty of rows …