Absolute Database and BDE

[Beast_Power]

I am busy moving legacy apps to XE10, I am converting to Absolute database, I have moved the files that cause lock file grown to large problems first, but even working with absolute database with these files it is still causing the same lock files grown to large problems.

Anybody have advice as moving the files is a lengthy process and need to sort out the lock file problems first.

 

[kindghost]

You should remove any BDE-based components (visual and non-visual) and units from your project

 

[dalx]

I work quite a lot in the database. And my advice to you - forget about such decisions.
If the database implies the work of a large number of users (> 10-20), then you will choose something like MSSQL, MySQL, PostgreSQL. If not, and / or local work is expected - then use ACCESS, SQLite.
It is better to do it right away than to make a mistake in the future.

 

[pupas]

I work quite a lot in the database. And my advice to you - forget about such decisions.
If the database implies the work of a large number of users (> 10-20), then you will choose something like MSSQL, MySQL, PostgreSQL.

Completely agree with you!

If not, and / or local work is expected - then use ACCESS, SQLite.
It is better to do it right away than to make a mistake in the future.

for local work Firebird embedded is better.

 

[DelphiVader]

A performant abstraction layer should also be considered, like ZeosLib.
https://sourceforge.net/projects/zeoslib/

That'll make switching the DB backend later on way less painful!