RFC: CouchDB on FreeBSD

Thanks to Wesley, we recently managed to update CouchDB’s FreeBSD port to the official 0.9.0 release. My current TODO for the port includes: a super-cool rc-script (currently, there is none) automatic user setup/creation (couchdb) patching of the install/source to use BSD-style directories for the database (e.g. /var/db/couchdb). In regard to the the rc-script, I continued on a work in progress and committed an idea on Github. This work in process (couchdb) works out of the box....

May 15, 2009 · 1 min

Great success!

Even though I didn’t like the Borat movie very much, I still like to use his line, Great success!. But on to more important things! ;-) Last weekend, we — the Berlin PHP UserGroup (and Christian Weiske from Leipzig) — took part in what some people labeled the European PHP TestFest 2009. In a nutshell, we were writing tests to cover different PHP extensions. Here’s the outcome (numbers courtesy of Falko Menge):...

May 11, 2009 · 1 min

BEPHPUG: Testen mit PHP -- Eine Einfuehrung in phpt

German content ahead: An invite to the local PHP usergroup meeting, today/tomorrow 6th May, 2009. It’s all free and the venue is located at Z-Bar on Bergstr. 2, Berlin-Mitte! Wir laden heute (6. Mai, 2009) zu einem kleinen Vortrag in der BEPHPUG ein. Was: Testen mit PHP, eine Einfuehrung in phpt Wann: 20:30 Uhr, 6. Mai, 2009 Wo: Z-Bar, Bergstr. 2, Berlin-Mitte Eintritt: frei … und weiter geht’s am Samstag (9....

May 5, 2009 · 1 min

MySQL: Using indices correctly

The objective was to select sessions from a table, that are older than two days. Table setup This is the definition: CREATE TABLE `session` ( `id` varchar(32) NOT NULL DEFAULT '', `data` text NOT NULL, `user` int(11) DEFAULT NULL, `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`id`), KEY `user_id` (`user`), KEY `rec_datemod` (`updated`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; Right and wrong Wrong query:...

May 5, 2009 · 2 min

Magento: Error: Please check for sufficient write file permissions

Moving a store from one server to another server, you’re bound to have small issues. While 99% of the configuration is stored in app/etc/local, there are other bits and pieces that are more spread out. For example, I noticed that there’s no central ‘Are all file permissions OK?’ screen in Magento Commerce and at times the system is pretty secretive when it comes to error messages. For example, after moving a store from a linux to a BSD (essentially a different WWW user id), Magento Connect just died with “Error: Please check for sufficient write file permissions”....

April 30, 2009 · 1 min