-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Florian v. Savigny wrote: > I was completely aware it is not intended as > the standard way for programs to access an SQLite database,
Yes, this isn't documented as such but DRH does mention it now and then. However if you look at the SQLite web site you will notice there is no documentation about the shell at all - just the C and Tcl interfaces. You'll also notice that the requirements also don't cover the shell - http://sqlite.org/requirements.html About the only place the shell is mentioned is as a subsystem when creating a new ticket. Of course it is rather hard for people new to SQLite to realize this :-) BTW the shell is documented at http://www.sqlite.org/sqlite.html but I couldn't find any other part of the site that actually links to that page! > but I had > actually assumed this was exclusively a performance issue (which is > BTW unnoticeable in my modest application - commands which call the > sqlite interface seem extremely fast). So, is this a dead end? The shell will work just fine providing nothing goes horribly wrong. There are little things here and there that may bite or surprise you. Here are some random sample tickets: http://www.sqlite.org/cvstrac/tktview?tn=1312 http://www.sqlite.org/cvstrac/tktview?tn=3353 http://www.sqlite.org/cvstrac/tktview?tn=3450 http://www.sqlite.org/cvstrac/tktview?tn=2231 http://www.sqlite.org/cvstrac/tktview?tn=1298 http://www.sqlite.org/cvstrac/tktview?tn=3638 > FFI apparently being a general term, can anyone tell me the > proper name of this interface? I am an Xemacs person myself :-) It appears that FFI will never be part of FSF emacs due to claims that Stallman feels it would allow a backdoor and violation of the GPL (at least in spirit). However no one ever points to anything that shows he actually has this position, just make the claim on his behalf. Google searches do show random combinations of FFI, Lisp and Elisp mentioned although nothing that helps you immediately. However it looks like Emacs can already be compiled with SQLite support if this bug report is anything to go by: http://groups.google.com/group/gnu.emacs.bug/browse_thread/thread/90098e724c379c1e/50b0dd9199eab304 There is also a libferris project that exposes data such as SQLite databases as part of the filesystem (using FUSE). Here is a tutorial/example of usage: http://linux.com/news/software/developer/6803-libferris-and-sqlite-a-powerful-combination-part-1 Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAko18TsACgkQmOOfHg372QR4UgCcCC9OQTEPZcLaHdsc01lxHSNW CMEAnR5ra3dAzrVQrWNbPp8oWGBG83so =7KCT -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
