PostgreSQL
Getting out of SQL_ASCII, part 2
So, if you followed the previous blog entry, now you have a new database containing all the static tables encoded in UTF-8 rather than SQL_ASCII. Because if it was not …
Posts
PostgreSQL
Getting out of SQL_ASCII, part 1
It happens that you have to manage databases designed by your predecessor, and it even happens that the team used to not have a DBA. Those histerical raisins can lead to …
PostgreSQL
Resetting sequences. All of them, please!
So, after restoring a production dump with intermediate filtering, none of our sequences were set to the right value. I could have tried to review the process of …
Projects
pg_staging's bird view
One of the most important feedback I got about the presentation of pgstaging were the lack of pictures, something like a bird-view of how you operate it. Well, thanks to …
Conferences
PGday.eu feedback
At pgday there was this form you could fill to give speakers some feedback about their talks. And that’s a really nice way as a speaker to know what to improve. And …
Projects
prefix 1.1.0
So I had two bug reports about prefix in less than a week. It means several things, one of them is that my code is getting used in the wild, which is nice. The other side …
Projects
Yet Another PostgreSQL tool hits debian
So there it is, this newer contribution of mine that I presented at PGDay is now in debian NEW queue. pg_staging will empower you with respect to what you do about those …
Conferences
PGDay.eu, Paris: it was awesome!
moment. Lots of attendees, lots of quality talks ( slides are online), good food, great party: all the ingredients were there! It also was for me the occasion to first …
Software Programming
Emacs Muse based publishing
As you might have noticed, this little blog of mine is not compromising much and entirely maintained from Emacs. Until today, I had to resort to term to upload my …
Projects
prefix 1.0.0
So there it is, at long last, the final 1.0.0 release of prefix! It’s on its way into the debian repository (targetting sid, in testing in 10 days) and available on …
Emacs
Emacs is Twinkling here
So you have a rolodex like database in your Emacs, or you have this phone number in a mail and you want to call it. It happens you have VoIP setup and you’re using …
Emacs
Escreen integration
After having used elscreen for a long time, I’m now a very happy user of escreen, which feels much better integrated and allows to have one ring of recently visited …