Delphi x64 embedded database
Googled for a long time but cant seem to find an answer. Is there any x64 embedded database to use with Delphi ? Cant see开发者_运维问答m to find any
Delphi XE 2 supports FireBird 2.5 using dbExpress, So try the Firebird x64 Embedded version.
Check AnyDAC 5.0.3 with XE2 and 64-bit support. SQLite is already included into library installer.
Embedded:
- SQLite Database
- Firebird Embedded
- MySQL Embedded
- Berkeley DB
- Advantage Local
Devart have a dbExpress driver for sqlite that supports XE2 64 bit targets.
Among free embedded engines there is also Nexus DB to be listed.
http://www.nexusdb.com/support/index.php?q=node/509
People worked with v2 told that the choice is dubious:
- only works good with their own Heap Manager
- In client-server mode high chance of DB corruption when Windows terminates program
- On large (hundreds thousand of rows) table queries, all the data is pulled to memory and only filtered later, if not dieing for not enough memory, cache never shrinks back then. This also makes it work rather slow.
People worked with v3 mostly tell that is hollywar and totally outdated claims.
Up to me, if to need on disk persistence, then go to Firebird Embedded + Unified Interbase library. If to need relatively small in-memory tables with little latency - then NexusDB Embedded would be free and natively-integrating suite.
精彩评论