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

[Bo Berglund]

On Mon, 26 Aug 2019 23:39:47 +0200 (CEST), Michael Van Canneyt via
lazarus <lazarus at lists.lazarus-ide.org> wrote:

>If you have a choice of database, choose something else.
>MariaDB/MySQLDB are the probably the worst choices you can make.
>Postgres, Firebird, SQLIte: all better choices, depending on your use case.
>

Well it so happens that the database I need to access is a MySql one
on our website. So I have created an export of it using phpmyadmin on
the webserver and loaded this into a MariaDB server I have inbstalled
on a RaspberryPi4 box.
Gonna use this while I am making the program to finally be deployed
against the website database.
So the database server is not really a choice I can make.

In my past I worked with Delphi against MSSQLServer for many years
using the ADODB connection in Delphi. Now no longer using Delphi and
no longer at that company either.
So Fpc/Lazarus it is....


-- 
Bo Berglund
Developer in Sweden