> I've also read Richard Hipp's > advice about potential issues if multiple threads of the same process access > the same DB so I figured I'd be safer if I have just one SQLITE module
I guess you refer to this Richard's advice: http://www.mail-archive.com/sqlite-users@sqlite.org/msg69579.html. Note that it's related only to Linux and its POSIX advisory file locks. Windows works differently and on Windows SQLite uses different locks (in fact Windows doesn't have POSIX locks at all). And I believe Windows doesn't have such multi-threading vs locking problem Linux has. Pavel On Mon, Apr 23, 2012 at 9:45 PM, Mircea Neacsu <mir...@neacsu.net> wrote: > Thanks everyone for your answers. Man, this list is one of the most helpful > places to hang out in the whole wide web; full of friendly and knowledgeable > advice - reminds me of the Usenet of the 80-es. > > @Michel: > >> Is there a reason you can't just compile it into your program instead of >> using it as a DLL? > > This is part of the reason and also I have a program and a couple of it's > DLL-es each using SQLITE on the same DB. I've also read Richard Hipp's > advice about potential issues if multiple threads of the same process access > the same DB so I figured I'd be safer if I have just one SQLITE module (yes, > each DLL and the main exe run separate threads). > > Please correct me if I'm wrong. > > Mircea > > > On 23/04/2012 4:20 PM, Black, Michael (IS) wrote: >> >> Is there a reason you can't just compile it into your program instead of >> using it as a DLL? >> >> Are you distributing multiple executables that would actually take >> advantage of that? >> >> It's under 1Meg as it's not much by today's standards. >> >> >> >> Seems to me we've heard more than one person with DLL problems on this >> list. >> >> >> >> Michael D. Black >> >> Senior Scientist >> >> Advanced Analytics Directorate >> >> Advanced GEOINT Solutions Operating Unit >> >> Northrop Grumman Information Systems >> >> ________________________________ >> From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on >> behalf of Mircea Neacsu [mir...@neacsu.net] >> Sent: Monday, April 23, 2012 3:12 PM >> To: sqlite-users@sqlite.org >> Subject: EXT :Re: [sqlite] SQLITE3 64-bit version >> >> Thanks everyone, >> >> @Roger: >>> >>> Is there anything that lead you to believe it wouldn't work or there may >>> be issues? >> >> No, I just haven't seen any pre-compiled binaries and wanted to save >> myself some trouble in case there are any known issues. I'll just go >> ahead and make myself one. >> >> One more thing if I may: if I need to distribute both 64 and 32 bit DLL >> versions is there a "canonical" file name I should use? >> >> >> Mircea >> >> >> On 23/04/2012 3:56 PM, Roger Binns wrote: >>> >>> -----BEGIN PGP SIGNED MESSAGE----- >>> Hash: SHA1 >>> >>> On 23/04/12 11:12, Mircea Neacsu wrote: >>>> >>>> Would you know if SQLITE3 can be compiled (and if it will work) as a >>>> 64-bit DLL? >>> >>> Yes - I use it as both 32 bit and 64 bit on non-Windows platforms. On >>> Windows I also do 32 and 64 bit. I've only done the Windows 64 bit with >>> Microsoft compilers, but 32 bit with both MinGW and Microsoft. >>> >>> Is there anything that lead you to believe it wouldn't work or there may >>> be issues? >>> >>> Roger >>> -----BEGIN PGP SIGNATURE----- >>> Version: GnuPG v1.4.11 (GNU/Linux) >>> >>> iEYEARECAAYFAk+Vs/UACgkQmOOfHg372QRtEwCfUgy2NIJeYTf0g7EM3Ky3htgW >>> KxgAn0PyretJwKptHigMHMgNqFR0jUMb >>> =2DhR >>> -----END PGP SIGNATURE----- >>> _______________________________________________ >>> sqlite-users mailing list >>> sqlite-users@sqlite.org >>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
