If you are developing a system and need a database to test your application, be aware that there are several free options on the market, including commercial database editions such as Oracle Database and Microsoft SQL Server.
Before choosing the database for your application, consult the global ranking of popularity of technologies in the link below:
URL: https://db-engines.com/en/ranking
Now, see the list of 5 free database options:
1. Oracle Database Express Edition
Oracle has a free edition of Oracle Database, the Express Edition or better known as Oracle XE. It has the same structure as the other paid editions, but there are limitations for use, as follows:
• Up to 12 GB of user data
• Up to 2 GB of database RAM
• Up to 2 CPU threads
For more information on this edition, visit the website: https://www.oracle.com/br/database/technologies/appdev/xe.html
To download the latest version: https://www.oracle.com/br/database/technologies/xe-downloads.html
2. SQL Server Express Edition
Microsoft also provides a free edition of SQL Server 2019 but with limitations for use, as follows:
• Up to 10 GB of user data
• Up to 2 GB of database RAM
• Up to 1 CPU with a maximum of 4 cores
The Express edition is ideal for learning about and creating desktop applications and applications driven by small server data. It is the best choice for independent software vendors, developers and stakeholders building client applications.
For more information on this edition, visit the website: https://docs.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-version-15?view=sql -server-ver15
To download the latest version: https://go.microsoft.com/fwlink/?linkid=866658
3. PostgreSQL
PostgreSQL is a very popular Open Source database that has been in development for over 30 years. Widely used by companies of different segments and sizes due to its reliability, robustness and, above all, performance.
To learn more about each feature, visit the feature matrix: https://www.postgresql.org/about/featurematrix/
For more information on this edition, visit the website: https://www.postgresql.org/about/
To download the latest version: https://www.postgresql.org/download/
4. MYSQL
MySQL is also an Open Source database and allows you to use it in high performance and scalable online transaction processing (OLTP) applications. Well known for its high performance and industrial strength reliability.
It is worth remembering that Oracle has a commercial version, with a subscription cost, called Oracle MySQL Enterprise Edition. For details on Enterprise features, visit: https://www.mysql.com/products/enterprise/mysql-datasheet.en.pdf
For more information on the Open Source edition, visit the website: https://www.mysql.com/products/standard/
To download the latest version: https://dev.mysql.com/downloads/repo/yum/
5. MongoDB
The Community version of the MongoDB database offers a flexible document data model, along with support for ad-hoc queries, secondary indexing, and real-time aggregations to provide powerful ways to access and analyze your data.
It is worth remembering that there is a paid version, the Enterprise, in addition to options managed in the Cloud (Atlas).
For more information on the Open Source edition, visit the website: https://www.mongodb.com/download-center/community/releases
To download the latest version: https://www.mongodb.com/try/download/community
To learn more, talk to one of our specialists – comercial@datacosmos.com.br or +55 (11) 97099-7434.
