Best Database

Postgres for me, it's my favourite FOSS database and its spatial extension via PostGIS is brilliant. I'm not a python person (yet) but I have successfully installed PostGIS on RPi / Archlinux. I even managed to run a java-gnome client app against it, although I had to import the jar file for that - RPi can't handle the eclipse IDE I developed it on. See java-gnome to the stars on my (RPi hosted) blog. Don't forget to install pgadmin3 as well.

RPi is remarkable, but we shouldn't expect too much of it. Like me, it's not good at multi-tasking, it can only do one thing at a time.

See java-gnome to the stars on my (RPi hosted) blog.

Oops I lost my static IP address. My ISP withdrew RPi's static IP and I can't afford an upgrade to replace it. So I have switched to Dynamic DNS via http://dalriada.hopto.org/rpi , thanks to no-ip.com and my Draytek router.

java-gnome to the stars is now at http://dalriada.hopto.org/rpi/?p=68

What would be a good database to use for:

Application to be written in python
Simple structure (one table) but large, up to several GB
Runs locally on the RPi as part of the application, not on a server

Seems the most important question was not yet asked:
Do you need to find records quickly more than writing new records quickly?
If yes, use a database like bsddb.
If no, just use a file.
No need to use relational databases if you don't need more than one table and hence no relations...