Use MariaDB or MySQL for new project?
lazarus / 16-Databases

----------------------------------------------------------------------
dodgebros · 2021-11-01 16:06

Hi guys/gals.  I might be starting a new desktop project on Windows
and I would like to use MariaDB or MySQL, free versions, as my
database.  I have not used either of these databases with
Lazarus/FreePascal before so I am hoping you guys might share any
issues that I might encounter using them?

Thanks,
TD

----------------------------------------------------------------------
Leledumbo · 2021-11-02 04:47

MariaDB/MySQL is one of the most popular SQL based RDBMS that's well
known NOT to adhere to the standard. You can see the details here.
If you don't mind that, then it should normally work just fine.

----------------------------------------------------------------------
Zvoni · 2021-11-02 06:48

If you decide for MariaDB don't forget to skip version-check

----------------------------------------------------------------------
mangakissa · 2021-11-02 10:39

Quote from: Zvoni on November 02, 2021, 07:48:48 amIf you decide for
MariaDB don't forget to skip version-check
What do you mean by that?
SQLdb is always checking the right version of the library.
I never could that skipped

----------------------------------------------------------------------
Zvoni · 2021-11-02 11:03

Quote from: mangakissa on November 02, 2021, 11:39:19 amQuote from:
Zvoni on November 02, 2021, 07:48:48 amIf you decide for MariaDB don't
forget to skip version-check
What do you mean by that?
SQLdb is always checking the right version of the library.
I never could that skipped
https://forum.lazarus.freepascal.org/index.php/topic,55168.0.html