Compact flash is a pain in the neck.
Some disks have built-in wear leveling. Interesting - the Emphase disk-on-modules have up to 4,000,000 writes. How many writes does a database make?
Related Links:
http://www.filipdewaard.com/php/SQLite-in-memory-databases/ http://www.sqlite.org/cvstrac/wiki?p=InMemoryDatabase