Page 1 of 1
libmariadb.dll vs. libmysql.dll
Posted: Tue May 07, 2019 6:15 am
by 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
Re: libmariadb.dll vs. libmysql.dll
Posted: Tue May 07, 2019 5:08 pm
by 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
Re: libmariadb.dll vs. libmysql.dll
Posted: Tue May 07, 2019 5:49 pm
by 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
http://forums.fivetechsupport.com/viewt ... =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)
Re: libmariadb.dll vs. libmysql.dll
Posted: Tue May 07, 2019 5:54 pm
by nageswaragunupudi
Admpss wrote: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
http://forums.fivetechsupport.com/viewt ... =3&t=33798
but do not advise because MySql officially withdrew support for MySql embedded.
Re: libmariadb.dll vs. libmysql.dll
Posted: Tue May 07, 2019 6:29 pm
by TimStone
What about Microsoft SQL ?
Re: libmariadb.dll vs. libmysql.dll
Posted: Tue May 07, 2019 6:43 pm
by 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.
Re: libmariadb.dll vs. libmysql.dll
Posted: Wed May 08, 2019 6:03 pm
by 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 ...