Echo without Aurelius

BIZ TMS Aurelius
1

There is no Echo forum that I can find so I guessed this would be the next most appropriate place to post.


I have a existing client/server VCL application connecting to a Firebird 3 database. This client/server VCL application uses conventional Delphi queries and datasets for data access.

I now need to build an FMX companion mobile application for this system. I am considering using Aurelius with a local SQLite backend and using Echo to replicate data between the master Firebird and mobile SQLite databases.

According to the Echo documentation I would need to convert the client/server VCL application to use Echo also however this is not feasible.

Instead I am considering the feasibility of writing Firebird triggers that simulate Echo though only in the logging of changes made by the VCL client application.

If I understand the Echo architecture correctly, I would also be running an Echo Server alongside the Firebird database server. This will accept the changes made by the FMX mobile clients and apply them to the Firebird database. 

What about changes made to the Firebird database and logged by my triggers. Assuming I correctly log the changes to the Echo tables will that be sufficient for the Echo Server to send the changes to the mobile clients?

Thanks very much,

Lachlan
2

Yes, all you assumptions are correct. But creating the triggers and making it save the data according to Echo specifications might be not be trivial, since Echo uses all Aurelius mapping to know the properties to save, the data format, associations, etc.. It's also not documented so you would have to dig in and learn how to do it.