Christof.Meerwald@ blog.www

> blog
>> 586

translate to German (by SYSTRAN)

Weblog RDF feed, Atom feed

[previous] / [up] [overview] [down] / [next]

Sat Jan 31 10:23:16 2009 GMT: (Ab)Using OpenVPN

Sat Jan 31 10:05:03 2009 GMT: Twinkle 1.4 Bug

Sun Jan 04 16:17:39 2009 GMT: Python DB-API Rant

SQLite really is a great database engine, but as it only supports database-wide locks, it's not really suitable if you want to concurrently access the database from different threads/processes. So I though, just switch to PostgreSQL which should be easy in theory as I am already using Python's DB-API 2.0.

Unfortunately, it's not that easy in practise, as the DB-API specification is not strict enough to make it really useful (and implementations have their own bugs on top of that). The main issue is that Python's built-in sqlite3 module uses "?" as the placeholder in prepared statements, whereas all PostgreSQL DB-API implementations use Python format strings (e.g. "%s") as placeholders. To make matters worse, some implementations expect "%d" for integer parameters, while others expect "%s".

So, essentially you can't use plain DB-API to write portable applications, but need another abstraction layer on top of it...

Sat Dec 27 21:24:53 2008 GMT: vAdmin SNMP Service

My new vServer provider apparently uses vAdmin as the management interface for the vServer. But one of the less than ideal side-effects of this is that the initial installation came with a snmp daemon (as part of the vAdmin setup) that was configured with an easily guessable (read/write) community name (and no IP-based filtering).

Needless to say, one of the first things I did was to deactivate that snmp daemon - but if you are also using a vAdmin based vServer, you might want to check if there is a snmp daemon running you don't know about...

Mon Dec 22 10:26:51 2008 GMT: 64-bit vServer

While migrating to the new virtual server, I decided to go with the 64-bit version of Ubuntu hardy heron which means that most packages on my .deb packages page are now available in 32-bit and 64-bit.

Sun Dec 21 10:21:31 2008 GMT: Server Migration

In the past few days I migrated edge.cmeerw.net to a new host - this time it's hosted by INGATE in Munich. By switching to a new hoster I get three times the amount of RAM (768 MB instead of 256 MB) for the same price as before (and I was told to get native IPv6 connectivity next year).

Mon Nov 17 20:29:55 2008 GMT: New Scientist Redesign

Just noticed that New Scientist recently got a new look and they are apparently allowing free access to their content - so well worth a look.

Mon Nov 10 21:22:00 2008 GMT: Seeing telecom data retention as an opportunity

Mon Nov 10 20:00:23 2008 GMT: Webdav Backup Scripts

Sun Nov 02 10:31:00 2008 GMT: mydisk.se

Tue Oct 28 21:05:22 2008 GMT: AOL Shutting Down XDrive and AOL Pictures

Tue Oct 28 20:57:45 2008 GMT: Snow


This Web page is licensed under the Creative Commons Attribution - NonCommercial - Share Alike License. Any use is subject to the Privacy Policy.

Revision: 1.14, cmeerw.org/blog/586.html
Last modified: Mon Sep 03 18:25:50 2018
Christof Meerwald <cmeerw@cmeerw.org>
XMPP: cmeerw@cmeerw.org