Why not add a possible to use a string to store the database in instead of a path, to avoid any harddrive usage, and possible to do whatever I want with the database.
For example like this:
dim database as string
SQLiteConnection cnn = new SQLiteConnection("Data Source=string:database");
and so on...
This would allow many applications. For example:
Fetching a database from a server, working with it locally in memory, and then sending it to server, without any harddrive involved.
Fetching a encrypted database from a file, and then decrypting it in memory, providing the decrypted string to the database engine to work with. At the end of application, it encrypts the string in memory and then it writes it to disk. No plaintext data does touch the harddrive ever.
base64-encoding the database, sending it thorugh some text-only medium and then decoding it at the receive end.