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

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

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

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

[sqlite] auto library function loading

2007-10-09 Thread Ken
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 allow users