Emacs
Regexp performances and Finite Automata
The major reason why I dislike perl so much, and ruby too, and the thing I’d want different in the Emacs Lisp API so far is how they set developers mind into using …
tag
PostgreSQL
207 posts
PostgreSQL
Window Functions example remix
The drawback of hosting a static only website is, obviously, the lack of comments. What happens actually, though, is that I receive very few comments by direct mail. As I …
PostgreSQL
Window Functions example
So, when 8.4 came out there was all those comments about how getting window functions was an awesome addition. Now, it seems that a lot of people seeking for help in …
PostgreSQL
Synchronous Replication
Although the new asynchronous replication facility that ships with 9.0 ain’t released to the wide public yet, our hackers hero are already working on the …
PostgreSQL
Happy Numbers
After discovering the excellent Gwene service, which allows you to subscribe to newsgroups to read RSS content ( blogs, planets, commits, etc), I came to read this nice …
PostgreSQL
Playing with bit strings
The idea of the day ain’t directly from me, I’m just helping with a very thin subpart of the problem. The problem, I can’t say much about, let’s …
PostgreSQL
Editing constants in constraints
We’re using constants in some constraints here, for example in cases where several servers are replicating to the same federating one: each origin server has his …
Projects
debian packaging PostgreSQL extensions
In trying to help an extension debian packaging effort, I’ve once again proposed to handle it. That’s because I now begin to know how to do it, as you can see …
PostgreSQL
Querying the Catalog to plan an upgrade
Some user on IRC was reading the releases notes in order to plan for a minor upgrade of his 8.3.3 installation, and was puzzled about potential needs for rebuilding GIST …
PostgreSQL
Database Virtual Machines
Today I’m being told once again about SQLite as an embedded database software. That one ain’t a database server but a software library that you can use …
PostgreSQL
Partitioning: relation size per “group”
This time, we are trying to figure out where is the bulk of the data on disk. The trick is that we’re using DDL partitioning, but we want a “nice” view of size per …
debian
Emacs and PostgreSQL
Those are my two all times favorite Open Source Software. Or Free Software in the GNU sense of the world, as both the BSD and the GPL are labeled free there. Even if I …