• How to restore a Drupal website too old for manual upgrades

    Owners of websites that remained frozen for a year or more, because the _projects _they represent also were closed, or greatly slowed down their activity, face a big problem when those projects restart: updating the website without losing all its old content is really, really hard, if not impossible. Here is how I faced this problem with an old Drupal website, with an approach that can work on many other websites running off some database.
  • Dbmail? A great Open Source email system, especially for LAMP/MySql administrators

    A couple of weeks ago, I was thinking about how I may build an advanced search utility for my own email archive. One way to make complex queries on the archive seemed to be to put it all into a relational database. Since the Dbmail system stores email in that way, I asked its developers and Harald Reindl (an email administrator at The Lounge who already uses Dbmail: I found him in the PostFix Mailing list archives) if Dbmail could be used in that way.
  • How to create lists of WordPress posts from the command line

    WordPress is a great online publishing system. One of its strengths, as far as I am concerned, is the administration interface, which I find flexible, efficient and easy to use. However, sometimes even that interface isn’t flexible enough.Recently, for example, I needed a quick way to create and insert into another Web page an HTML list of all and only the posts I had published in a certain date range. If you only have four of five posts to manage it’s OK, but what when, as in my case, there are many tenths of them?
  • Create your Web database applications with DaDaBIK

    Dadabik is Free Software that you can use (writing little or no code by hand!) to create PHP-based Web applications that even users with little previous experience can use to manage several types of (already existing) relational databases. I’m happy to report that, after a quite long stop, development of DaDaBIK recently restarted. The result, which you can see in the screenshots in this page, is version 4.