home
> blog
>> 586
| [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
