-----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

Reply via email to