Solved

MySQL Description

Posted on 2004-04-27
4
1,939 Views
Last Modified: 2008-03-06
Hello there,

Can anyone give me a quick rundown of what MySQL does, and what its main benefits and drawbacks are? I'm comparing databases for a project, and MySQL is one area I've chosen to start research.

(I'm not asking for anything comprehensive, just a few links would do so I can follow them up!!)

Thanks,

MT
0
Comment
Question by:tigermoth
4 Comments
 
LVL 7

Accepted Solution

by:
madwax earned 40 total points
ID: 10933556
MySQL  4.x:
+ free, one of the most used, good support, many apis, guides and examples, a lot of implemented functions, simplicity
- no transactions, no foreign key constraints, subqueries from 4.1, no views, no stored procedures or triggers

The functions differ from version to version, but as I pointer - for big transactional and business critical applications where the data accessing is going to be more than just from webpages I would go for either Oracle or MS SQL-server and maybe Postgre. But this is a very subjective opinion.

To summarize, MySQL is fine for > 99% of what anybody uses a database for.  Most people don't use transactions or any other of the more advanced features in their apps anyway.

//madwax
0
 
LVL 2

Assisted Solution

by:RichardAllsebrook
RichardAllsebrook earned 40 total points
ID: 10936747
For:

1. It's effectivly free

2. Widely used AND supported

3. Its quick

4. Easy to remotely administer

5. Plugs into PHP seemlessly

6. Runs on non-micro%soft platforms

7. Most web-hosts have it pre-installed as standard.

Against:

1. Non-standard SQL syntax

2. Very little information (that I could find) that indicates its scalability


In short - you have to have a very distinct need (such as transactions) to want to pay for your database back end.
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
RDBMS and No sql database 4 63
mysql joining from the same table 6 47
PHP & MySql - Turn Select Query Results into a Glyphicon 3 39
mysql between clause 2 32
Foreword This is an old article.  Instead of using the MySQL extension that was used in the original code examples, please choose one of the currently supported database extensions instead.  More information is available here: MySQLi / PDO (http://…
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question