 Take our Quick Survey and enter a drawing for a chance to win a $100 VISA Gift Card.|
| MySQL - SQL (Structured Query Language) database server.Updated by FastRunner on Tuesday, October 10th 2006.The MySQL database server is the world's most popular open source database. Its architecture makes it extremely fast and easy to customize. Extensive reuse of code within the software and a minimalistic approach to producing functionally-rich features has resulted in a database management system unmatched in speed, compactness, stability and ease of deployment. The unique separation of the core server from the storage engine makes it possible to run with strict transaction control or with ultra-fast transactionless disk access, whichever is most appropriate for the situation. See MySQL 5 for newer version. Licence : GPL
Version : 4.0.27 [Stable]4.1.22 (stable) [Development]
 |
MySQL Contact / Download links :
Displaying 2 of 2 user comments. Transactions - they are in MySQLby Anonymous on Jul 30, 2000Just check for the new versions. MySQL have transactions.
MySQL has one big flaw: no transactions.by Slimer on Jun 13, 2000Yes, yes...I know what you are about to say:
a) transactions slow down the database
b) you can use locking in MySQL
c) you don't really need them anyway.
Inserts are way faster without transactions, true, but what do you do when one insert out of ten fails? Like, the order goes into the invoice table, but not the delivery table, because that insert fails?
Locking, you say. Well, avoiding deadlocks while using locking is easy as long as your system is rather small, and as long as there is only one developer working on it, someone who can keep track of everything in his/her head. With increased complexity the chance of a deadlock situation increases exponentially, and in practise, only having locking means you are restricted to a singleton pattern for database access. Not especially scalable, although a bit easier to implement.
I tend to miss subselects, too, although that is, AFAIK, being implemented.
You do need transactions for anything that grows beyond your pet project, and MySQL doesn't provide it. It is, though, lighting-fast and very durable. | |
