libmariadb.dll vs. libmysql.dll

[Otto]

Dear Mr. Rao,
starting with SQL what should I use.
Can you please tell me where I can find documentation of the libs and is there also source code provided.
Thank you in advance
Otto

[Admpss]

HI, can i use mysql or mariadb like ads local mode, or without install the server, for test pourpose, in local mode using an DLL to simulate the server.

thanks

[nageswaragunupudi]

Dear Mr. Otto

You may use either libmysql.dll or libmariadb.dll with MySql server or MariaDB server without any problems. They are fully compatible with each other.

Documentation
https://dev.mysql.com/doc/refman/5.6/en ... tions.html

FWH provided wrappers to all and it is desirable to use FWH connection methods which are fully documented in the Wiki and also in viewtopic.php?f=3&t=33286

Recently MySql released version 8.0. The present libmysql.dll and libmariadb.dll work with this latest version also. But if you like to use the latest features (very likely not), you may use the latest libmysql.dll (ver 8.0)

[nageswaragunupudi]

HI, can i use mysql or mariadb like ads local mode, or without install the server, for test pourpose, in local mode using an DLL to simulate the server.

thanks

You may download either MySql server or MariaDB server and install on your computer and connect to them locally,
You can also consider MySql embedded
viewtopic.php?f=3&t=33798
but do not advise because MySql officially withdrew support for MySql embedded.

[TimStone]

What about Microsoft SQL ?

[nageswaragunupudi]

libmysql.dll and libmariadb.dll are exclusively meant for mysql/mariadb only.

For Microsoft SQL (MSSQL), we need to use ADO. We can use ADO for other servers also like MySql, Oracle, etc.

FWH provides convenient wrapper functions for ADO and makes it easy to use ADO.

For testing and development on local server, we can download the free SQLEXPRESS and install on our PC.

[TimStone]

I was at the corporate meeting when Ashton Tate first presented SQL and planned to use it in dBase IV. That was a LOT of years ago. DBF's have worked so well for my designs that I just never went over there, although I have used some IDE's with it over the years.

I suppose it's time to explore using it more in depth ...