On Tue, 27 Aug 2019, Bo Berglund via lazarus wrote:
On Mon, 26 Aug 2019 23:39:47 +0200 (CEST), Michael Van Canneyt via
lazarus <lazarus@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.
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.
Michael.
--
_______________________________________________
lazarus mailing list
lazarus@lists.lazarus-ide.org
https://lists.lazarus-ide.org/listinfo/lazarus
