The best free database… Google is wrong!
If you search on Google for “the best free database” you get the following:
There’s no Oracle on the list?
The reason is Google took the answer from this review. It has been put in red what is wrong with the answer, so in case Google shows images, and people don’t read this blog post, they don’t get the wrong answer;
(Search done 11-NOV-2018 and again on 12-JAN-2019 and 28-JAN-2019).
This seems so wrong as the best free database in the world is Oracle Express Edition (XE). Oracle released XE18c on October 19th, 2018. You get an Enterprise Edition version and almost all options are turned on! The only restrictions you have is on the amount of RAM (2GB) and disk space (12GB). You even have the pluggable database architecture and can create 3 PDBs (pluggable databases).
It is most people’s opinion that there is no other free database in the world that will beat this.
Guess what? Google actually knows the right answer too.
Google says “People also ask”: “What are the top 5 databases available on the market?” and here Oracle is number one. The other question is “What is the best database software for small businesses?” Oracle number one again. If the question would be “What is the best database software for enterprise businesses?” Oracle is number one too, this is common knowledge.
Google’s algorithm to answer the first question just got it wrong. How can Oracle be number one and be the best, but not in the free section, whereas their best database is available for free?
Google allows you to comment on their search results:
Why Oracle XE 18c is preferred!
When we talk about Oracle XE, we really talk about the full Oracle database in general. Yes, there are a couple of limitations, but nevertheless, you get the full feature set of the Oracle database! All the good stuff why Oracle shines is there: to have the best performance you can use partitioning and online index rebuilds (and in the future automatic index creation!), to increase high availability you have the full flashback technology to your disposal, for security Oracle has VPD, Real Application Security, Database Vault… Oracle plans to release a new version of XE every year too, so you have always the latest and greatest.
Getting started with Oracle XE:
If you just want to try Oracle XE, most likely the easiest way without hitting your system, is to go with the Oracle docker container. Here’re the steps to get Oracle XE running in an Oracle docker container.
Open a Terminal or Command Prompt and run following commands:
Copy the oracle-database-xe-18c-1.0-1.x86_64.rpm in the docker-images/OracleDatabase/SingleInstance/dockerfiles/18.4.0 directory
Move on by running following command: ./buildDockerImage.sh -v 18.4.0 -x -i
docker run –name OracleXE -p 1521:1521 -p 8080:8080 -e ORACLE_SID=XE -e ORACLE_PWD=oracle -v /Users/dgielis/git/docker-images/OracleDatabase/SingleInstance/dockerfiles:/opt/oracle/oradata oracle/database:18.4.0-xe
And you are done! (more info on the Oracle Docker images)
To get a view in your database you can use Oracle SQL Developer.
Here’s how you connect to it:
The next thing would be to install Oracle APEX, so you don’t only have the best database in the world, but also the best low code platform in the world, which works extremely well with the Oracle database.
Extracted From: The Dimitri Gielis Blog