site_archiver@lists.apple.com Delivered-To: darwin-dev@lists.apple.com Hi There,. I am using LibSQLite3.0.dylib in a multi thread app. I am a little stuck here, probably down to my ignorance in 'roll your own'. Can anyone advise ? All I want is a thread safe libsqlite3.0.dylib Thanks Mark Gilbert. -- mark@gallery.co.uk Tel: +44 208 340 5677 fax: +44 870 055 7790 http://www.gallery.co.uk New Product ! - MetaCorder Location Sound Field Recorder http://www.metacorder.info _______________________________________________ Do not post admin requests to the list. They will be ignored. Darwin-dev mailing list (Darwin-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/darwin-dev/site_archiver%40lists.appl... I have encountered problems where access to the database from a second thread is showing the database as locked. After some research it would appear that libsqlite must be compiled with the THREADSAFE flag set to 1 in order to support multithread access. It also implied that UNIX distributions may have this set to 0 by default. So... first - is the library included with Tiger THREADSAFE on or off ? My results suggest not. Also, I have downloaded the sqlite source and piled into an unfamiliar manual rebuild of the library (I am not a Unix hacker...). I have configured and make'd the sqlite stuff, but it doesn't turn out a .dylib file (just lots of other files...). I did find a 'make install' command, but this seemed to be largely interested in creating extensions for TCL (it did make a libsqlitetcl dylib, however). This email sent to site_archiver@lists.apple.com