On Tue, 27 Aug 2019 07:51:16 +0200 (CEST), Michael Van Canneyt via lazarus <lazarus@lists.lazarus-ide.org> wrote:
>> So the database server is not really a choice I can make. > >That's why I started with 'if you have a choice'. > >MySQL by itself is not a very good database, but connecting to it from >FPC/Lazarus is even worse. > >Unfortunately, the ease of use of the LAMP stack made it very popular, >and many are in your situation. I would not recommend it for new projects. > Thanks, I should maybe drop the idea of keeping a mirrored database in MySql format and instead use an MSSQLServer db as the mirror. I know for a fact that accessing that from Lazarus is pretty simple. I will look into the possibility of importing the MySql dump into MSSQLServer, after all it is in SQL format and our tables are not really very complex either. If that works I could add to the website php some kind handling of an operations log file where I save the SQL statements that are adding the data to the website db. Then I could retrieve these regularly and run against the backup database using a Lazarus/Fpc program on Windows (where the main database is hosted). -- Bo Berglund Developer in Sweden -- _______________________________________________ lazarus mailing list lazarus@lists.lazarus-ide.org https://lists.lazarus-ide.org/listinfo/lazarus