I'm about to start developing a product (in .NET), and I'm evaluating open source database engines in order to avoid adding licensing costs to the overall cost of my product.
Which ones do you know that are potent? Is MySQL a good alternative? What kind of website load can it support?
Do you have any experience using an open source database in real life projects?
Or do I just need to use Oracle or SQL Server to develop a robust product?
Much like open source solutions such as WordPress, an open source database will offer you flexibility, scalability, and security at a core level. Even better, tools such as MySQL, MariaDB, PostgreSQL, and Redis are all open source, popular, and supported by many web hosts.
Is MySQL OpenSource? MySQL Software is an Open-source RDBMS software. The source code of MySQL OpenSources is available under the terms of GNU General Public License, as well as under a variety of proprietary agreements. For Proprietary use, several paid versions are available that offer additional functionalities.
You can always download the free version of MySQL that many companies and individuals use for their databases. It is called the MySQL Community edition, the most widely used open-source database in the World. Most web hosting plans don’t even require you to download it, because it is usually included in their package as a bonus.
If performance is one of the main aspects you need in a database, then MySQL is the perfect choice for you. It is designed in a way to provide high-speed usage, especially for those that run their websites on a shared web hosting plan. After all, you don’t want to wait for those load times when the stakes are high.
MySQL is good enough for Flickr, Facebook, Wikipedia, Google, and YouTube to use it (says Wiki) - I'd say they each serve more load than you're likely to reach. I believe WordPress.com - four million+ blogs (stats), including CNN, Time, etc. blogs - also uses MySQL.
Oracle/MSSQL are definitely not required to develop a robust product.
This wikipedia link should help, it compares most of the big relational databases. http://en.wikipedia.org/wiki/Comparison_of_relational_database_management_systems Mysql should work fine assuming you write your code properly, it's what wikipedia runs on so should support almost all applications if configured properly and run on good enough hardware/clustering setups.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With