Re: [sqlite] auto library function loading

2007-10-10 Thread Ken
.load /home/users/LIB/sqlite3/user_ext.so unable to open shared library [/home/users/LIB/sqlite3/user_ext.so] sqlite> Any ideas as to why the .load pragma is failing? The file exists, built as follows: gcc -rdynamic -fPIC -I../sqliteSrc/sqlite-3.4.1/src

Re: [sqlite] auto library function loading

2007-10-10 Thread Ken
John very eloquently stated. I completely agree with you regarding the ant-bloatware philosophy. OK, I found the answer: http://www.sqlite.org/cvstrac/wiki?p=LoadableExtensions Which I'll be trying shortly! John Stanton <[EMAIL PROTECTED]> wrote: The Sqlite API is set at a low level for v

Re: [sqlite] auto library function loading

2007-10-10 Thread John Stanton
The Sqlite API is set at a low level for very sound reasons. It is suitable for incorporating Sqlite into other software such as TCL, Perl, Javascript etc or to build an API for specific embedded applications. If higher level features are embedded in the core Sqlite it becomes bloated with com

Re: [sqlite] auto library function loading

2007-10-09 Thread Kees Nuyt
On Tue, 9 Oct 2007 07:06:48 -0700 (PDT), you wrote: > Is there a way for SQLITE to automatically load user > defined functions at database instantiation or upon > database connection? You can put a file .sqliterc in the users homedirectory with commands for the command line tool. They will be ex

Re: [sqlite] auto library function loading

2007-10-09 Thread Ken
John, Kind of defeats the point of "automatic". Using a wrapper for application code is perfectly legitimate. However it does not address the sqlite3 command line tool. The ability to automatically load a library of functions via a dll would be a really nice feature and could be used to pro

Re: [sqlite] auto library function loading

2007-10-09 Thread John Stanton
Ken wrote: Is there a way for SQLITE to automatically load user defined functions at database instantiation or upon database connection? Can it test for a .so/.dll and perform a call to load user functions? If the .dll does not exist maybe issue a warning? Just a thought as a way to al