I wish the RAM could be a bit more, at least 1G or 2G, so I can have a database on there without having to ship my data to the cloud. Then the system can really run isolated as much as possible, for security and privacy.
SQLite would still be a good option. It's incredibly lightweight, and if you set the database to WAL mode it also works well for a database file accessed by multiple applications on the same device.
This. Back in the day when we lacked RAM, especially on *nix based systems, it's absolutely normal to use the disk/flash as pseudo-RAM. This was just...a normal part of computing at the time, heh.
Of course, applications would respond shit slow this way, but in the case of a DB it'd be more than fine, no?
Yes, I understand the content of the database is supposed to be on disk. But for the database to function and do its thing, it needs space in RAM. Like page swap and cache.