The Art of PostgreSQL

Want to share your recipes?

Tuesday 31 Aug 2010 2 mins read Software Programming, Emacs Lisp

Yes, that’s another el-get related entry. It seems to take a lot of my attention these days. After having setup the git repository so that you can update el-get from within itself (so that it’s self-contained), the next logical step is providing recipes. By that I mean that el-get-sources entries will certainly look a lot alike between a user and another. Let’s take the el-get entry itself: (:name el-get :type git :url "git://github.

I wrote a book!

welcome el-get scratch installer

Friday 27 Aug 2010 1 mins read Emacs, el-get

Emacs el-get

A very good remark from some users: installing and managing el-get should be simpler. They wanted both an easy install of the thing, and a way to be able to manage it afterwards (like, update the local copy against the authoritative source). So I decided it was high time for getting the code out of my ~/.emacs.d git repository and up to a public place: http://github.com/dimitri/el-get. Then, I added some documentation (a README), and then, a *scratch* installer, following great ideas from ELPA.

Playing with bit strings

Thursday 26 Aug 2010 2 mins read PostgreSQL, YeSQL

Tricks

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 just assume you want to reduce the storage of MD5 in your database, so you want to abuse bit strings. A solution to use them works fine, but the datatype is still missing some facilities, for example going from and to hexadecimal representation in text.

el-get news

Thursday 26 Aug 2010 2 mins read Emacs, el-get

Emacs el-get

I’ve been receiving some requests for el-get, some of them even included a patch. So now there’s support for bzr, CSV and http-tar, augmenting the existing support for git, git-svn, apt-get, fink and ELPA formats. Also, as the install and even the build are completely asynchronous — there’s a pending bugfix for the building, which is now using start-process-shell-command. The advantage of doing so is that you’re free to use Emacs as usual while el-get is having your piece of elisp code compiled, which can take time.

el-get and dim-switch-window status update

Monday 09 Aug 2010 2 mins read Projects, switch-window

Emacs el-get release switch-window rcirc

Thanks to you readers of Planet Emacsen taking the time to try those pieces of emacs lisp found in my blog, and also the time to comment on them, some bugs have been fixed, and new releases appeared. el-get had some typo kind of bug in its support for apt-get and fink packages, and I managed to break the elpa and http support when going all asynchronous by forgetting to update the call convention I’m using.

Editing constants in constraints

Monday 09 Aug 2010 2 mins read PostgreSQL, Catalogs

plpgsql Catalogs

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 own schema, and all is replicated nicely on the central host, thanks to Londiste, as you might have guessed already.