You'll need to move away from the BDE, which will mean some
conversion effort, but it shouldn't be too bad. However, for
performance, it means moving away from using tTable to using tQuery
using SQL, so if your SQL needs brushing up, time to do so.
There is a choice of DBMS interface component. dbExpress comes with
Delphi, or I'm using AnyDAC for some reason back in the distant pass
which I don't recall. :-) There are also several others.
Once an interface component is chosen, the actual DBMS can be swapped
out fairly easily, so there's a wide choice. Right now, I'm using
SQLite for standalone DBMS, and PostgreSQL for shared user DBMS, and
have been pleased with the performance and reliability of both.
But there are others I've used and am comfortable with. MySQL (or
its new fork, MariaDB) is pretty much a standard. Then there are the
commercial DBMS, like DB2, Oracle, Microsoft SQL, Sybase, etc. All
do a good job and should be chosen based on the requirements of the
project, cost, etc.
At 09:04 AM 6/3/2014, Rainer von Saleski wrote:
What database are people using today? I need to port a D7
application (written with BDE Paradox, of course) to XE2 or later. I
would like to avoid completely redesigning all the database
operations, but mostly I need a more robust database.
Suggestions please?
Thanks,
Rainer
_______________________________________________
Delphi-DB mailing list
Delphi-DB@lists.elists.org
http://lists.elists.org/cgi-bin/mailman/listinfo/delphi-db
_______________________________________________
Delphi-DB mailing list
Delphi-DB@lists.elists.org
http://lists.elists.org/cgi-bin/mailman/listinfo/delphi-db
