PostgreSQL - Julien Danjou

Julien Danjou

PostgreSQL

A collection of 5 posts

The Art of PostgreSQL is out!

The Art of PostgreSQL is out!

If you remember well, a couple of years ago, I wrote about Mastering PostgreSQL, a fantastic book written by my friend Dimitri Fontaine. Dimitri is a long-time PostgreSQL core developer — for example, he wrote the extension support in PostgreSQL — no less. He is featured in my book Serious Python [https:

Why You Should Care That Your SQL DDL is Transactional

Why You Should Care That Your SQL DDL is Transactional

I don't write a lot about database management. How come? I'm a software engineer, and like many of my peers, I leverage databases to store data. I should talk more about this! What made me write this today is that I've discovered that many of my peers wouldn't be able

Mastering PostgreSQL

Mastering PostgreSQL

A few months ago, my friend Dimitri Fontaine [http://tapoueh.org] and I discussed writing books and sharing our knowledge. If you do not know Dimitri yet, he is an old-time PostgreSQL Major Contributor – meaning he writes code for the PostgreSQL software itself! I interviewed Dimitri a few years ago

From decimal to timestamp with MySQL

From decimal to timestamp with MySQL

When working with timestamps, one question that often arises is the precision of those timestamps. Most software is good enough with a precision up to the second, and that's easy. But in some cases, like working on metering, a finer precision is required. I don't know exactly why, and it

Overriding cl-json object encoding

Overriding cl-json object encoding

CL-JSON [http://common-lisp.net/project/cl-json/] provides an encoder for Lisp data structures and objects to JSON format. Unfortunately, in some case, its default encoding mechanism for CLOS objects isn't exactly doing the right thing. I'll show you how Common Lisp makes it easy to change that. Identifying the problem