1 Topic by teco049 (edited by teco049 2019-01-03 15:23:02)

  • Registered: 2017-02-01
  • Posts: 106

Topic: Question MySQL, MariaDB

Hi,


Maybe somebody has some experience with MySQL and Maria DB. I need some help for the following questions:


- Is MySQL Community 5.6 supported by MyVisualDatabase 5 or does I need to use Version8? Some other applications requesting Version 5.6. Would be perfect if I don't need to do a separate installation.
- Is MariaDB compatible to MyVisualDatabase 5?


Question about MariaDB is only because some internet sources are writing that the performance is better with MariaDB as with MySQL.


Thank you.
teco049

  • From: Нефтеюганск
  • Registered: 2018-04-11
  • Posts: 1,775

Re: Question MySQL, MariaDB

нет, но их можно переключать
settings.ini:
[Options]
DBMS=sqlite or mysql

  • Registered: 2014-06-25
  • Posts: 863

Re: Question MySQL, MariaDB

MariaDB is a fork from the creators of MySQL and is fully open source so it might be compatible as long as you can connect to MariaDB.

  • Registered: 2017-02-01
  • Posts: 106

Re: Question MySQL, MariaDB

tcoton wrote:

MariaDB is a fork from the creators of MySQL and is fully open source so it might be compatible as long as you can connect to MariaDB.


Since Version MariaDB 10, MariaDB works not really identical to MySQL8 or earlier.


So I would need to know which libray version of libmysql.dll from MySql is used by MyVisualDatabase. Thank I can select a suitable MySQL Version and MariaDB.

  • Registered: 2014-02-14
  • Posts: 10,294

Re: Question MySQL, MariaDB

MVD use MyDac library to access to MySQL
https://www.devart.com/mydac/


Used direct mode without involving MySQL client library.
Supports MySQL servers up to 8.0, MariaDB servers versions up to 10.x.

Dmitry.
  • Registered: 2017-02-01
  • Posts: 106

Re: Question MySQL, MariaDB

Thank you for the information.