Yes, that's the one.
Hmm, so you say that I'm safe if I statically link SQLITE in each of my
modules... goes a bit against my reflexes (paraphrasing an old saying: 1
MB here 1 MB there; soon you start talking real memory bloating) but
I'll give it a thought.
Thanks again,
Mircea
On 23/04/2012 10:01 PM, Pavel Ivanov wrote:
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
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
