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

[Michael Van Canneyt]

On Tue, 27 Aug 2019, AB via lazarus wrote:

> You can use the open source zeoslib ( http://zeoslib.sourceforge.net/ ).
>
> It can access many databases, including mysql and mariadb since many 
> many years.

So can SQLDB. The point is that it's a bad idea to use it.

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

Depends on what you expect from a database.

MySQL is not really ACID. 
It is also not really typesafe (you can store 0 in a date field), 
has no referential integrity by default and does not use transactions by default.
You can add these but at the cost of performance.

So by default you can store any junk in it that you want:
It just manages more or less structured files with an SQL syntax.

But if that is enough for you (and it is for most PHP programmers) then go
right ahead, but my demands are a little higher...

Michael.