Hi all,
I need an embedded/In Memory Database which support multithread access.
Thanks!
Leo
+13
A:
You can use SQlite3 with the DISQLite3 library.
For proof that they are thread-safe check the links provided by Mohammed Nasman
jitter
2009-06-28 14:45:45
Hey, You are faster in few seconds ;-), but Firebird 1.5 is thread-safe too, refer to to the link I posted to see that.
Mohammed Nasman
2009-06-28 14:51:02
I know that it is. That's why I proposed these two. Didn't say it wasn't threadsave. But thanks anyway for the links
jitter
2009-06-28 14:53:12
I had completely forgotten the SQlite could use memory as a store. There goes MY afternoon!!!
Brad Bruce
2009-06-28 15:11:56
Just a small warning ... FB Embedded works great as a threasafe internal database - except when you're connecting to the database. We were getting infrequent crashes in GDS32.DLL during the connect until we put a lock around the connection code.
gabr
2009-06-29 07:00:06
if you use gds32.dll with Firebird : you probably don't use the right component to connect because Firebird client dll is fbclient.dll
Hugues Van Landeghem
2009-06-29 19:47:08
Gds32.dll is just renamed fbclient.dll so that TIBDB can work with it. FB Embedded DLL supports both access modes - older gds32 and newer fbclient. But as the error occurs deep inside the connection code in the dll, I don't think the gds32 wrapper causes the problem.
gabr
2009-06-30 06:45:30
+4
A:
Components4Developers has one that's been around a long time kbmMemTable
Darian Miller
2009-06-28 15:47:30
+1
A:
ComponentAce offers AbsoluteDatabase with in memory option AbsoluteDatabase
Darian Miller
2009-06-28 15:48:35
+4
A:
NexusDB can be both embedded and use memory tables. For a multithreaded application you just give each thread it's own Session and Database components.
There is a free embedded version with no souce code or you can purchase the full client server version with source code.
LachlanG
2009-06-28 23:54:31
I heard good things about NexusDB. About kbmmemtable too, but nexusdb seems more focused on performance.
Marco van de Voort
2009-06-29 10:39:45
+1
A:
eXtremeDB, from my company (McObject), is increasingly popular.The standard edition is an embedded in-memory database.