Thanks.
I appreciate very much, the way I can add my own loadable extension 
myExtension.dll by simply calling on SQL-level
select load_extension("myExtension.dll") without changing anything in C.
I wish that I could do this for vfs too. 
select load_vfs("myVFS.dll") 
without changing anything in C.

Best Martin



________________________________
Von: Roger Binns <rog...@rogerbinns.com>
An: General Discussion of SQLite Database <sqlite-users@sqlite.org>
Gesendet: Donnerstag, den 26. März 2009, 18:36:50 Uhr
Betreff: Re: [sqlite] virtual file system

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Martin Pfeifle wrote:
> I have a question regarding virtual file systems.
> I assume I can load my own virtual file system by calling
> the  c-function sqlite3_vfs_register(...).

That function passes the vfs name and a series of callbacks that
implement the vfs to SQLite.  To actually use a vfs, you need to pass
the appropriate name to sqlite3_vfs_open_v2.

> Am I right that I cannot load a virtual file system by a pragma command

You couldn't register one that way since it needs C level callbacks.
You can set the default vfs when calling sqlite3_vfs_register(...)

> or a core function similar to load_extension?

sqlite3_vfs_register is a core function in exactly the same way as
sqlite3_load_extension

What exactly is it you are trying to achieve?

Roger
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)

iEYEARECAAYFAknLvS4ACgkQmOOfHg372QRtlgCeI5UjLAFzGM6eMiPlxGH2NxmH
qZ4AniOKkZBrYuYCSjw3Cm8GoXiAREc+
=FvJH
-----END PGP SIGNATURE-----
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users



      
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to