Please find here a listing of recent of maintained contributions I did to Open Source software. Most of them are available from my GitHub page.
The more I work with PostgreSQL (and that's a lot already), the more I like depending on this software. Years passing by, I've been working on more and more features, extensions and client tools for it.
Core PostgreSQL Feature
Those are code that you can load into your PostgreSQL instance to extend its feature set.
This is the
prefix_range datatype and its optimized GiST indexing (which led
me to write most of the documentation page linked here). See the prefix
page here and the articles tagged prefix on this blog.
The idea behind preprepare is to sort out all the named
that your application needs to issue on the server-side, early when
accepting your connection, so that all the application has to care about is
EXECUTE the queries.
I've been contributing to other extensions too, mainly on the debian packaging of them, as you can see the debian packages by Dimitri Fontaine page at debian.
I enjoy using skytools for lots of my replication needs, either Londiste (I wrote the londiste tutorial, send me questions and improvement ideas) or walmgr. I also reworked the whole packaging of Skytools 3.0 and contributes to the project as much as I can (packaging, documentation, bug reports, conferences, etc).
PostgreSQL client tools
I began contributing to PostgreSQL by doing some client side tools. It all began, really, with having to rewrite pgloader because we couldn't extend it anymore: at the time it was written in TCL, which is a fine programming language but one that is not on my portfolio.
How to turn your boring nightly backups into something useful everyday? pg_staging has an answer here.
My working environment of choice is emacs, and is so happens that it's also my preferred text editor.
ClusterSSH for Emacs
After having used some earlier version cssh, I couldn't bear to wait that much for its interface that I didn't like. That's how I decided to learn enough of Emacs Lisp so that I could depend some more on emacs. That led to cssh.el which I still use daily and maintain.
This is a visual replacement for
C-x o, check out the switch-window page.
You will read here the details of my outgoing email setup, using
postfix sender_dependent_relayhost_maps. The consequence is that I have to
M-! mailq to check that I don't have mails kept locally Then
what, open a local terminal so that you can flush the mail queue?
M-x mailq is an answer to that. Not only it displays if you have to worry,
but it also allows to flush your mail queue directly from emacs with a
single keystroke. Much better.
That's a little add-on to follow
IRC notification when using rcirc.