We are using mySQL with tens of millions of rows in a commercial application.
We are in financial services and we have a ton of joins inner joins and other complexities.
We use MySQL Workbench and Navicat And believe it or not PHP myAdmin. (Working on replacing PH my admin with a RS version of the same)
Other than a nasty bug (which Real is fixing) in mySQL plugin things work very well.
(dont set MultiThreaded=true)
For us: The use of an esoteric database like Valentina causes all sorts of grief with IT people from other companies. And quite frankly, you probably could never get it past a audit in the corporate world (Stability of vendor...)
Thank you, JonhV
but Valentina DB have celebrate just only 15 years. mySQL as I know, older may be couple of years...
Where you see issue with stability? Its mySQL already was sold from one hand into another.
Its mySQL have got huge stream of away runners, mostly to SQLite and Postgre.
It is enough to look on REALbasic list to see this process during last 2-4 years. btw mainly because of license. See below.
And no need to say that mySQL can go through audit. mySQL is NOT an Enterprise standard. Many articles exists on this.
As only they have claim they want to touch the Enterprise market, they was bought fast by Oracle ...
mySQL for years on own site have claim something as
"we are very optimized for light-weight queries that are perfect for WEB".
Valentina somehow was targeted to heavy queries ... Than more was our wonder few years ago, when one of our users, on that time yet big-fan-of-RB, have port own ORM from mySQL to Valentina and reported us that his app launches few times faster. Note, app sends a lots of small queries to db on start. We have win mySQL by nature of our net-protocol... We have win even in that area where they claimed they are cool...
NOTE: to be honest, we know one area where we loose yet, but we see algs to implement to become there not worse.
We wish to concentrate on our core business: Not justifying our choice of tools. mySQL is know, solid and FREE.
('Yes but you use real studio" i hear you cry. That is true I choose real studio because it there is an advantage to doing so. With a SQL database No so much. )
Many people of REALbasic list, already few times have discussed that mySQL is not so free as many did think. Especially for applications. This is why they have run to Postgre.
Once I have read dispute where somebody claim this is changed by Oracle ... but only once, and was not proved.
For example it is enough look on this pages on mySQL site: http://www.mysql.com/oem/ http://www.mysql.com/products/
I remember that for deployment of a commercial APP with closed code, you need pay about 450$ per server per year.
And we know from user, that in fact mySQL team just try squeeze from you maximal amount they can... When you call them ...
Anyway all this was discussed very deeply on rb lists and forum. This is why, once again, many RB and Livecode users have run ti Lite and Postgre, which claim to be totally free for any purpose.