[Lazarus] How to connect to MariaDB/mySql database from fpc/Lazarus?

[AB]

You can use the open source zeoslib ( http://zeoslib.sourceforge.net/ ).

It can access many databases, including mysql and mariadb since many 
many years.

There is nothing wrong with using mysql or mariadb for websites, it is 
not an accident that they are popular.


AB

On 8/27/19 12:36 AM, Bo Berglund via lazarus wrote:
> On Tue, 27 Aug 2019 07:51:16 +0200 (CEST), Michael Van Canneyt via
> lazarus <lazarus at 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).
> 
>