A recent interview question that I had to review was spelled like this:

Find missing int element into array 1..100

Of course at first read I got it wrong, you have only one integer to look for into the array. So while the obvious idea was to apply classic sorting techniques and minimize array traversal to handle complexity (time and space), it turns out there’s a much simpler way to do it if you remember your math lessons from younger. But is it that much simpler?

PostgreSQL Conference US took place in New York City and I had the pleasure to be a speaker there. I presented there a talk about why You’d Better Have Tested Backups. The important bit is that backups are not interesting, recoveries are. Also the only way to make sure a backup is successful is to be able to use it for recovery.

Le 21 avril prochain se tient le premier pgDay Paris: une conférence PostgreSQL d’une journée complète. Il s’agit de 8 conférences sur votre base de données préférée par des conférencers internationaux, incluant des retours d’expérience et une analyse de l’utilisation des derniers développements en cours dans notre projet de base de données préféré.

PostgreSQL comes with an awesome bulk copy protocol and tooling best known as the COPY and \copy commands. Being a transactional system, PostgreSQL COPY implementation will ROLLBACK any work done if a single error is found in the data set you’re importing. That’s the reason why pgloader got started: it provides with error handling for the COPY protocol.

Dimitri Fontaine

PostgreSQL Major Contributor

Open Source Software Engineer