top of page

5 Free Database to Test and Develop

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.

627 views0 comments

Yorumlar


bottom of page