• andrew gothard (10/3/2016)


    To me, they're not really the same thing. MySQL is more of a replacement for xBase than a proper enterprise product, it's certainly nowhere like Oracle or SQL Server in terms of support for critical systems where your data "matters". Obviously though, the price points are also worlds apart.

    MySQL is simpler and regarded as faster due to less overhead for smaller projects. For a Mom n' Pop's corner shop online presence where if the site dies you can rebuild it without breaking into a sweat and no great demands on it, MySQL fits the bill. You wouldn't want them to be storing your medical records in it though (at least I would be horrified at the idea). Certainly a paid license version of Oracle would be colossal overkill and as mentioned above would add both cost and complexity to a small project.

    If your data is "important", frequently updated with minimal dataloss requirements and transactional and referential consistency, that's where Oracle would come in.

    Or you could start with SQL Server Express (free) and do an easy upgrade to Standard or Enterprise.

    Here's a link (a bit obsolete) that compares different implementations of SQL database systems. http://troels.arvin.dk/db/rdbms/

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2