Free or open source databases with commercial-quality features
Microsoft, Oracle offer impressive free versions of their commercial offerings, but MariaDB wins our test
By Susan Perschke | Network World US | Published: 14:41, 03 December 2012
We tested six popular free or open source relational database management systems (RDBMS): Microsoft SQL Server Express, PostgreSQL, Oracle’s MySQL, MariaDB, Apache Derby, and Firebird SQL. We tested each product on ease of installation, documentation, features, management tools and performance using a log file containing more than one million records. Here are the individual results.
Microsoft SQL Server Express 2012
A free version of Microsoft’s popular SQL Server, SQL Server Express is targeted at smaller-scale applications, but it’s a feature-rich product that delivers many of the core functionality of the commercial version. It might not have high availability and clustering, but it does have an excellent management interface and performance was top notch. Inserting one-million-plus records took just over a minute, while the commercial version took 45 seconds. Retrieving 100,000 records took 10 seconds, compared to three seconds for the commercial version.