Start Polyglot Development with Autonomous Database

Developers often choose their preferred language and development environment for developing applications.

◉ Developing artificial intelligence and machine learning applications: use Python

◉ Does your application need a lot of concurrent connections, or is it collecting data from multiple sources: use Node.js

◉ Corporate standards may dictate the Microsoft environment: use .NET

◉ Want to use the most popular language on the internet: use Java

A common afterthought in modern application development is where and how to persist the data in the cloud. The data is the most valuable part of most applications. Persisting the data in the most functional and robust database in the cloud, the Oracle Autonomous Database should be your first choice.

Very often, Various teams within an enterprise often develop applications using different technologies. Some might be legacy applications as well, understanding how various technologies and polyglot programming access the underlying database is essential for application developers.

Most new cloud based applications consist of front-end customer-facing web applications written in Node.js, Python, or PHP scripts, reading data from a database. A Java-based back-end application provides real-time data management.

Customers can use free low-code Oracle APEX-based web or mobile applications to develop and interact with the same database when they persist their data in the Oracle Autonomous Database. Data scientists can use Jupyter notebooks to test and develop machine learning algorithms with the data persisted in the database. Businesses are guaranteed 99.995% availability of their data. 

Ready to learn hands-on how to use the Oracle Autonomous Database with your development language of choice? Then run the Start Polyglot application development with Oracle Autonomous Database on our LiveLabs hands-on workshop platform. Our new LiveLabs workshop provides examples of connecting to the Autonomous Database and executing SQL queries using multiple programming languages like Python, Java, .NET and Node.js.

 

Experience how easy it is to establish a wallet-less database connection using Python. Just install the required python-oracledb driver, for example, using pip. Then use the connection string and replace the database username and password. You are all set to view the result of your SQL query.

# Sample python code to establish wallet-less connection with Oracle Autonomous Database

import oracledb

# database username and password

username = "<db_user>"

user_pwd = "<password>"

# connection string  

tlsconnstr = "<database connection string>"

connection = oracledb.connect(user=username, password=user_pwd, dsn=tlsconnstr)

with connection.cursor() as cursor:

       sql = "select * from customers where rownum < 10"

       for r in cursor.execute(sql):

               print(r) 

Similarly, you will see how we set up database connectivity & run SQL query from Java, Node.js and ODP.NET core

Why should you consider Oracle Autonomous Database?

As a developer, there are many reasons to use Oracle Autonomous Database:

- You can create in instance in a couple of minutes.

- It eliminates the complexity of operating and securing the Oracle Database.

- It gives you the highest levels of performance, scalability and availability.

- It is available on Oracle Cloud Infrastructure for shared or dedicated deployments and on-premises.

- It detects and automatically protects from system failures or user errors and provides failover to standby databases with zero data loss.

Start your workshop Polyglot application development with Oracle Autonomous Database here.

Source: oracle.com