>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