Recent

Author Topic: Use MariaDB or MySQL for new project?  (Read 3000 times)

dodgebros

  • Full Member
  • ***
  • Posts: 161
Use MariaDB or MySQL for new project?
« on: November 01, 2021, 05:06:48 pm »
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  :D

Leledumbo

  • Hero Member
  • *****
  • Posts: 8757
  • Programming + Glam Metal + Tae Kwon Do = Me
Re: Use MariaDB or MySQL for new project?
« Reply #1 on: November 02, 2021, 05:47:18 am »
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

  • Hero Member
  • *****
  • Posts: 2327
Re: Use MariaDB or MySQL for new project?
« Reply #2 on: November 02, 2021, 07:48:48 am »
If you decide for MariaDB don't forget to skip version-check
One System to rule them all, One Code to find them,
One IDE to bring them all, and to the Framework bind them,
in the Land of Redmond, where the Windows lie
---------------------------------------------------------------------
Code is like a joke: If you have to explain it, it's bad

mangakissa

  • Hero Member
  • *****
  • Posts: 1131
Re: Use MariaDB or MySQL for new project?
« Reply #3 on: November 02, 2021, 11:39:19 am »
If 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
Lazarus 2.06 (64b) / FPC 3.0.4 / Windows 10
stucked on Delphi 10.3.1

Zvoni

  • Hero Member
  • *****
  • Posts: 2327
Re: Use MariaDB or MySQL for new project?
« Reply #4 on: November 02, 2021, 12:03:55 pm »
If 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
One System to rule them all, One Code to find them,
One IDE to bring them all, and to the Framework bind them,
in the Land of Redmond, where the Windows lie
---------------------------------------------------------------------
Code is like a joke: If you have to explain it, it's bad

 

TinyPortal © 2005-2018