Hi
Hi,
I need to find a new DB for Delphi XE2 & up, 32 & 64 bits
NOW: using Aidaim's EasyTable and Accuracer, Single User versions
PROBLEMS: lots of bugs, development halted, poor support, charge upgrade price for a simple re-compile each time a new Delphi version is released.
MY NEEDS, NOW:
. Single user, preferably single file embedded database
. basic DB functions: index, filter, BLOB support, ...
. complex (engineering) data but few records, speed isn't critical
. cryptography is fairly important
. compliance with db-aware third-party VCL controls is fairly important
. fair price
NEEDS, NEAR FUTURE:
. Multi-user (local server) with few users
. OSX & mobile
Overall, I am NOT a database programmer, I'm focused on math modeling of engineering problems, my tipical softwares have 3 tables in a "technical" database file and 3 tables in a "materials" file; the DB operations are mainly preprogrammed, there's no user creating new queries.
NexusDB would be free for now, but expensive in the future; Firebase is free and expandable but has a big learning curve... SQLite has free and comercial wrappers, but seems to have problems with file locking for multi-user (if I understood correctly sqlite.org's FAQ) - Please note that by "Multi-user" I'm talking about 5 to 10 concurrent users that make projects locally but will share the same materials database on a local server.
any suggestions?
(and sorry for the size of this post!)
I need to find a new DB for Delphi XE2 & up, 32 & 64 bits
NOW: using Aidaim's EasyTable and Accuracer, Single User versions
PROBLEMS: lots of bugs, development halted, poor support, charge upgrade price for a simple re-compile each time a new Delphi version is released.
MY NEEDS, NOW:
. Single user, preferably single file embedded database
. basic DB functions: index, filter, BLOB support, ...
. complex (engineering) data but few records, speed isn't critical
. cryptography is fairly important
. compliance with db-aware third-party VCL controls is fairly important
. fair price
NEEDS, NEAR FUTURE:
. Multi-user (local server) with few users
. OSX & mobile
Overall, I am NOT a database programmer, I'm focused on math modeling of engineering problems, my tipical softwares have 3 tables in a "technical" database file and 3 tables in a "materials" file; the DB operations are mainly preprogrammed, there's no user creating new queries.
NexusDB would be free for now, but expensive in the future; Firebase is free and expandable but has a big learning curve... SQLite has free and comercial wrappers, but seems to have problems with file locking for multi-user (if I understood correctly sqlite.org's FAQ) - Please note that by "Multi-user" I'm talking about 5 to 10 concurrent users that make projects locally but will share the same materials database on a local server.
any suggestions?
(and sorry for the size of this post!)
Firebird. Free as in free beer
ReplyDeleteYes ... from the firebird website:
ReplyDelete"FREE LIKE FREE BEER. No fees for download, registration, licensing or deployment, even you distribute Firebird as part of your commercial software package."
It is developed and owned by the firebird foundation (http://www.firebirdsql.org/en/firebird-foundation/) to make sure it is not sold to any company that changes this in the future like it happened to some other "free" databases.
Hi, thank you all for the replies, very useful!
ReplyDelete