Doubt Client-server system migration, Firedac to more than 1 database?

Question

A system was developed using Firebird is dbexpress, for migration of this system so that it was possible to use more than 1 database, what would be the best solution? In Delphi XE we have Firedac with access to multiple databases, more when using (Sqlquery + Datasetprovider + Clientdataset) the fields are field types of the table in question are loaded, but these types are not equal for both databases, In this case, can Firedac handle the types of data within it, or is there any other way to do it? Thanks

Answer 1

Yes, Firedac can do that. We went through the same situation, but in my case, it was decided to use the components of Devart. I suggest that first, you create custom connection components, so you can address the differences between banks.

For example:

Firebird:

Select first 1 ID from Table

Postgresql:

Select ID from Table Limit 1

These and other differences could be addressed in their customized component.

As for the type of field in the table, I believe that most of them would be the same, except for the Blob type in Firebird, where we use Bytea/Text in Postgresql

I also suggest that you mount the SQL command at runtime, so you take advantage of the Drive and it even brings the right type of Field, besides ensuring that the Fields will always be updated, without having to maintain the source code.