Using mySQL
-
This is probably a query that comes often... sorry if it is so... Does anybody have any experience of using mySQL? Does it work? Is it reliable? Is there a proper ODBC or ADO encapsulation? Does it compare in terms of performance to SQL server? Any experience with multithreading and Visual C++ 6.0? I do not actually need a monster of a database (something like a couple of hundreds of megabytes probably). The writing would be intensive, the reading much less. Any caveat welcome... well any feedback would! Thanks in advance! BadJerry
-
This is probably a query that comes often... sorry if it is so... Does anybody have any experience of using mySQL? Does it work? Is it reliable? Is there a proper ODBC or ADO encapsulation? Does it compare in terms of performance to SQL server? Any experience with multithreading and Visual C++ 6.0? I do not actually need a monster of a database (something like a couple of hundreds of megabytes probably). The writing would be intensive, the reading much less. Any caveat welcome... well any feedback would! Thanks in advance! BadJerry
I downloaded it to use with ADO and VC++. I found it sucked. I couldn't get it to work, or even figure out how to set it up. I was much happier to spend the money to use SQL Server or MS Access. Apparently, there is a reason MS dominates the market. Turns out free stuff is only free if your time is of no value. Just my limited experience with mySQL.
-
I downloaded it to use with ADO and VC++. I found it sucked. I couldn't get it to work, or even figure out how to set it up. I was much happier to spend the money to use SQL Server or MS Access. Apparently, there is a reason MS dominates the market. Turns out free stuff is only free if your time is of no value. Just my limited experience with mySQL.
-
If you want something free, use MSDE, not MySQL.
"Do unto others as you would have them do unto you." - Jesus
"An eye for an eye only makes the whole world blind." - Mahatma GandhiMySQL is a perfectly viable database. Version 4 even has a mechanism to embed a server within your application. I would agree that using it isn't for the faint of heart, however, just because it doesn't have an Access/Sql Server-like interface doesn't make it suck. What sucks is when people give up and say it sucks without giving it a fair shake doing what it does best--storing data. Once you get past the setup, it is just as easy to use as the others. As far as speed goes, MySql can keep up with the best of them. In my opinion, the only shortfall with MySql is the lack of stored procedures and transactions (though I think transactions have been added in version 4). If you go to the mysql.com website, you'll find programming APIs for different languages including C++. It is called MySql++. I've used it before and it works great. You can get MySQL++ from here: http://www.mysql.com/downloads/api-mysql++.html. Make sure you download the binary for VC++ 6. Good luck. -Matt ------------------------------------------ The 3 great virtues of a programmer: Laziness, Impatience, and Hubris. --Larry Wall
-
This is probably a query that comes often... sorry if it is so... Does anybody have any experience of using mySQL? Does it work? Is it reliable? Is there a proper ODBC or ADO encapsulation? Does it compare in terms of performance to SQL server? Any experience with multithreading and Visual C++ 6.0? I do not actually need a monster of a database (something like a couple of hundreds of megabytes probably). The writing would be intensive, the reading much less. Any caveat welcome... well any feedback would! Thanks in advance! BadJerry
There is a managed MySql data provider at Sourceforge.net. It probably performs better than using odbc. Check it out
-
MySQL is a perfectly viable database. Version 4 even has a mechanism to embed a server within your application. I would agree that using it isn't for the faint of heart, however, just because it doesn't have an Access/Sql Server-like interface doesn't make it suck. What sucks is when people give up and say it sucks without giving it a fair shake doing what it does best--storing data. Once you get past the setup, it is just as easy to use as the others. As far as speed goes, MySql can keep up with the best of them. In my opinion, the only shortfall with MySql is the lack of stored procedures and transactions (though I think transactions have been added in version 4). If you go to the mysql.com website, you'll find programming APIs for different languages including C++. It is called MySql++. I've used it before and it works great. You can get MySQL++ from here: http://www.mysql.com/downloads/api-mysql++.html. Make sure you download the binary for VC++ 6. Good luck. -Matt ------------------------------------------ The 3 great virtues of a programmer: Laziness, Impatience, and Hubris. --Larry Wall
Hi Matt, I totally agree, MySQL is my fav DBMS and it only lacks Triggers and Stored Procedures. It's easy install (download and launch installer, then it runs as a NT service) and powerful. However I wonder if you were able to handle a local database using MySQL++, local database : DB as a file (like MS Access .mdb files...). JM. Molina Web: http://goa.ifrance.com
-
Hi Matt, I totally agree, MySQL is my fav DBMS and it only lacks Triggers and Stored Procedures. It's easy install (download and launch installer, then it runs as a NT service) and powerful. However I wonder if you were able to handle a local database using MySQL++, local database : DB as a file (like MS Access .mdb files...). JM. Molina Web: http://goa.ifrance.com
As far as I know, there is only one way to do this--MySQL 4 supports embedding. You would have to embed the MySQL server in your app. It sounds like a pain to me, but I haven't looked at it except to know that it exists. ;-) -Matt ------------------------------------------ The 3 great virtues of a programmer: Laziness, Impatience, and Hubris. --Larry Wall
-
If you want something free, use MSDE, not MySQL.
"Do unto others as you would have them do unto you." - Jesus
"An eye for an eye only makes the whole world blind." - Mahatma GandhiHi, Thanks for the tip ! So MSDE is a database engine that you can use in your desktop application ? Is it VC++ 6 compliant ? Where can I download it ? I can't find it on MSDN (http://www.microsoft.com/sql/techinfo/development/2000/MSDE2000.asp). Regards, JM. Molina Web: http://goa.ifrance.com