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.
PostgreSQL Contributions
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
As of now, this list only contains my first PostgreSQL patch, implementing Extensions properly. I have an extension tag for articles on this blog related to the feature.
PostgreSQL Extensions
Those are code that you can load into your PostgreSQL instance to extend its feature set.
Prefix
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.
preprepare
The idea behind preprepare is to sort out all the named PREPARE statement
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
to EXECUTE the queries.
debian packaging
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.
PostgreSQL replication
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.
pgloader
pgloader allows you to load a plain data file into PostgreSQL while managing the errors that you might have. See the pgloader tutorial and the articles tagged pgloader here.
pg_staging
How to turn your boring nightly backups into something useful everyday? pg_staging has an answer here.
Emacs Extensions
My working environment of choice is emacs, and is so happens that it's also my preferred text editor.
el-get
This could be labeled as apt-get for emacs. Check out the el-get
description to make your mind about it, and you can also see all the
articles tagged el-get on this blog.
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.
Switch Window
This is a visual replacement for C-x o, check out the switch-window page.
Mailq
You will read here the details of my outgoing email setup, using
postfix sender_dependent_relayhost_maps. The consequence is that I have to
sometime do 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.
rcirc-groups
That's a little add-on to follow IRC notification when using rcirc.