Database driven applications in the cloud

Now that we have the database running and can connect to it, we need nice sample data to create good demos for more learning to come. Seasoned Oracle developers will remember the SCOTT or HR schemas. Let's use something different. My colleague  Friedhold   created an Oracle version of the Northwind database. First we need to create a new Oracle schema as a home for our sample data: CREATE USER "NORTHWIND" IDENTIFIED BY "password" ; GRANT CREATE SESSION TO northwind ; GRANT CREATE table TO northwind ; GRANT CREATE SEQUENCE TO northwind ; GRANT CREATE PROCEDURE TO northwind ; GRANT CREATE TRIGGER TO northwind ; ALTER USER northwind QUOTA 200 M ON DATA ; BEGIN    ORDS_ADMIN.ENABLE_SCHEMA(      p_enabled => TRUE ,      p_schema => 'northwind' ,      p_url_mapping_type => 'BASE_PATH' ,      p_url_mapping_pattern => 'nor...

Oracle gives its database away for free in the cloud as  Always Free Autonomous Database . In contrast to Amazon's  AWS Free Tier  that ends after 12 months, Oracle's offer does not expire. The creation of an Oracle Cloud account and a free tier database is easily done with a few mouse clicks. Valid payment information, like from a credit card, has to be provided but Oracle promises not to charge without asking to transform the account into a paid version. This is another difference to AWS. Once an Amazon subscriber exceeds free tier limits, he will be automatically charged. We will deal with AWS in this blog soon. When we have created our free Oracle Cloud database, we could instantly develop a web application using APEX. But this is not the route this blog wants to go and there are plenty of sources on the web for that. To make productive use of a database as a developer, we still need a connection on our local computer and a tool. SQL Developer woul...

The serious part of my IT career started when I began working as a technical consultant for Oracle in Germany around 2000. I did a lot of database programming in PL/SQL, Forms, Reports. Then the middleware came into focus with WebLogic, Java. After almost a decade I decided to do the consulting work self-employed. I put much commitment into ADF. Well ... You may know that, you are busy working in projects, you know your technologies well, read articles to keep up with current developments. But one day you look around and realize, many things have changed in IT. Cloud is no longer a buzzword. In IT boards you read about containers and microservices. Javascript is not just a useful little helper on HTML based web sites anymore, it is taking over the front end completely, also some of the server side. At that moment it was time to take a deep breath. How can one approach all this? I think the best idea is to start from the known and approach the unknown from there. No surprise ...