>I am told that SQLite compiles and runs out-of-the-box on Integrity  
>OS.  No porting necessary.  But not having a license for Integrity OS  
>nor hardware to run it on, I've never actually tried this myself.

Thanks for a quick response.  I will try and be more precise.

I get a number of unresolved symbols with the stock files.  I have
downloaded 3.6.13 and am compiling with the sqlite3.c and sqlite3.h files
into a library.  There are several pthread related symbols and dlopen,
dlerror, dlclose, and dlsym.

The pthreads look to have something to do with this not being a unix based
os which it is defaulting to.  I set threadsafe to 0 to resolve this.  I am
putting all db code within one library with its own mutex and do not feel
the threading will be an issue.

The dl symbols are for loading libraries.  I have defined
SQLITE_OMIT_LOAD_EXTENSION.  This removed those unresolved symbols.

As for my code, the log table is queried once a second with a max of 200
records returned and a min of 0.  A timer is putting one new record in the
table every 5 seconds.  A trigger after the insert is making sure that the
table does not exceed 5000 records.

Prior to this I had a circular file with 1000 records.  This never exhibited
any problems running the same test.



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

Reply via email to