-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 10/03/2010 09:31 AM, Pierre Krieger wrote: > Anyway I don't think about using this code in a real program for the > moment, I just made it because of my love for modularity and because it > looked like a nice idea
It is a good idea and the use cases you gave (networked data, compression etc) are good matches for using VFS. The problem side is the io::stream API is not a particularly good match for what SQLite needs from a VFS. You'd likely be ok if the data only ever needs to be read, but if that is the case then presenting the data as a web service would be better in the long term. For writable data you do have to implement locking, changing file size, disk sync etc which io:stream provides no help for. (Incidentally your implementation of xSync bears no resemblance with actually getting the data onto disk platters :-) You should also ideally make sure that if the data source is a local file then the same file being opened by regular SQLite will be ok and not cause corruption. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAkyowuUACgkQmOOfHg372QQQZACcCPsW9EqoJXXoXPrJqB5iCgkb N0gAoJHcVAdVkLgfDuTTcIxO1nv3mlR5 =zq2l -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users