One click free browser based Oracle Database environment with Gitpod

Lucas Jellema
0 0
Read Time:1 Minute, 19 Second

This article describes how you can run your very own Oracle Database from your browser using Gitpod. With a free account (50 hours Gitpod use per month), you can open this URL to launch a workspace that contains Oracle Database 21c XE along with VS Code, Oracle Developer Tools extension in VS Code, SQLcl running in a Linux Ubuntu 20.04 OS. When you first start the workspace, it may take up to 90 seconds before it is fully available. Every subsequent restart of the same workspace will last for less than 10 seconds.

This next picture visualizes the process: click on the button and the Gitpod workspace is launched. After some 30 seconds you will enter the workspace environment where SQLcl, SQL*Plus and VS Code provide access to three user accounts (APP, DEV and SYS) in the XE database.

image

The Gitpod workspace looks like this:

image

Running this environment only requires a browser. Nothing happens locally – and still you get your own database. I can think of no other way to get this environment up and running so very rapidly and effortlessly. It is seems very well suited for workshops and tutorials where you want to ensure that participants all have the proper environment.

You can take the .gitpod.yml file from the GitHub repo (https://github.com/lucasjellema/gitpod-oracle-database) and further customize it. For example to install additional tools, add APEX to the database, use a different Oracle Database container image (Gerald has created a whole library of Oracle Database XE images to choose from) or perform other initialization steps.

About Post Author

Lucas Jellema

Lucas Jellema, active in IT (and with Oracle) since 1994. Oracle ACE Director and Oracle Developer Champion. Solution architect and developer on diverse areas including SQL, JavaScript, Kubernetes & Docker, Machine Learning, Java, SOA and microservices, events in various shapes and forms and many other things. Author of the Oracle Press book Oracle SOA Suite 12c Handbook. Frequent presenter on user groups and community events and conferences such as JavaOne, Oracle Code, CodeOne, NLJUG JFall and Oracle OpenWorld.
Happy
Happy
100 %
Sad
Sad
0 %
Excited
Excited
0 %
Sleepy
Sleepy
0 %
Angry
Angry
0 %
Surprise
Surprise
0 %

Average Rating

5 Star
0%
4 Star
0%
3 Star
0%
2 Star
0%
1 Star
0%

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Next Post

Reflections from Devoxx 2022–on software engineering today

End of day two. So many topics already were presented, demonstrated, discussed, tried out to and by me. This article is just a very brief overview of what caught my attention. And what I will have to look into in more detail – or not in some cases. Containers and […]
%d bloggers like this: