Application development with Oracle Database

Java

Java is the #1 programming language and development platform. It reduces costs, shortens development timeframes, drives innovation, and improves application services. With millions of developers running more than 51 billion Java Virtual Machines worldwide, Java continues to be the development platform of choice for enterprises and developers.

• Oracle JDBC
• Oracle Database Java Developer’s Guide
• Java downloads
• Oracle JDBC Maven Central Guide

Python

The Python programming language is actively used across all domains of contemporary computer science. Since Python development is more efficient than most other languages, it is a popular choice for startups where changes to the codebase must be made quickly and cheaply. It's also used by scientists and mathematicians and in a number of powerful, in-house libraries for statistics and complex math. Explore the features of the Python python-oracledb driver for Oracle Database. python-oracledb is a Python extension module that enables access to Oracle Database. It conforms to the Python database API 2.0 specification with a considerable number of additions and a couple of exclusions.

• What is Python?
• Getting Started with Python and Oracle Database
• Python on Oracle Linux
• python-oracledb home page
• python-oracledb GitHub repository

Oracle C and C++ Call Interface APIs

The Oracle Call Interface C and C++ APIs let you create applications that use function calls to access Oracle Database and control all phases of the SQL statement execution and data access.

• Oracle Call Interface Programmer's Guide
• Oracle C++ Call Interface Programmer's Guide
• Oracle ODBC Driver
• ODPI-C Driver

Node.js

Node.js allows developers to build fast, scalable network applications using easy-to-understand code. It runs on Windows OS, macOS, Linux, Unix, and other operating systems. It has support for ARM processors, such as Raspberry Pi or BeagleBone Black. Node.js is an ideal choice for developers who need to build fast, scalable network applications, such as web servers and other back-end systems powering mobile apps, using simple code.

The node-oracledb add-on for Node.js powers high-performance Oracle Database applications. Applications can be written in TypeScript, or directly in JavaScript.

• Quick Start: Developing Node.js Applications for Oracle Database
• Quick Start: Developing Node.js Applications for Oracle Autonomous Database
• node-oracledb home page
• node-oracledb GitHub repository
• node-oracledb API reference and user guide

.NET

Oracle's .NET development community numbers more than 800,000 members. Popular products include Oracle Data Provider for .NET (ODP.NET), which is optimized to use Oracle Database’s high availability, performance, and security features while giving developers complete access to .NET and .NET Framework. Oracle Developer Tools for Visual Studio Code (VS Code) and Visual Studio are add-ins for editing, executing, and debugging of SQL and PL/SQL for Oracle Database on-premises or in the cloud.

• Oracle .NET Developer Center
• Developing .NET Apps for Oracle Database (On-Premises) quick start
• Developing .NET Apps for Oracle Autonomous Database quick start
• Oracle .NET, VS Code, and Visual Studio downloads
• Oracle .NET sample code

PL/SQL

PL/SQL is an embedded language designed to work efficiently with Oracle Database. PL/SQL adds procedural constructs to SQL and provides a more comprehensive programming language solution for building mission-critical applications on Oracle Databases.

• PL/SQL Language Reference
• PL/SQL for developers

React.js

React is a JavaScript library for web and native user interfaces that lets you build user interfaces out of individual components, such as Thumbnail, Like Button, and Video. These can then be combined into entire screens, pages, and apps. You don’t have to build your whole page in React —you can add React to existing HTML pages and render interactive React components anywhere on them.

The backend of the applications can be written in either Java or Node.js to complete a full-stack development for modern web/mobile applications. Oracle Database provides the backend for both a Java (also with Spring Boot) and JavaScript (with Node.js and Parse platform) full-stack development with React.js.

• Full-Stack Development with Oracle Database 23ai
• React.js on Oracle Mobile Backend as a Service (MBaaS)
• React + Helidon + Autonomous Database = Cloud Native App
• Push Notifications with Oracle's MERN Stack
• Using GraphQL with Oracle’s MERN stack

What are microservices?

Microservices are an architectural approach to developing modern software. Each core function, or service, represents a related business context that is built and deployed independently. Microservices provide agility in building and maintaining applications. Application modernization today is synonymous with microservices.

• Microservices overview
• What are microservices?
• Design a microservices application

Microservices with Spring Boot

Building small, self-contained, ready-to-run applications can bring great flexibility and added resilience to your code. Spring Boot’s purpose-built features make it easy to build and run your microservices in production at scale. The distributed nature of microservices brings challenges, and Spring Boot helps you mitigate them. Spring Cloud Stream makes it easy to consume and produce events, no matter which messaging platform you choose. Oracle offers Oracle Backend for Spring Boot and Microservices.

• Learn Spring Boot
• Spring Data JDBC
• Spring Data JPA
• Spring Cloud Stream
• Oracle Backend for Spring Boot and Microservices

Mobile Application Development

Oracle Mobile Backend as a Service (MBaaS) helps developers build modern mobile applications using the Parse platform APIs, using a variety of developer SDKs – Javascript, Flutter, Unity, etc. An Oracle Database adapter is available to take advantage of the rich application and data services in Oracle's converged database. MongoDB and PostgreSQL adapters are already available as part of the Parse platform, and the platform emulates Google Firebase APIs in a proof-of-concept demo, with a sample application that can run on the Google Firebase service, and with minimal change to include a parsef emulator library run on the Oracle MBaaS platform.

Enterprise application development combines web-first microservices with mobile-first features in application, and the ability to run microservices in application containers and Parse containers managed by Kubernetes makes it easy to converge these two application styles, one in Java and another in JavaScript.

• Oracle MBaaS on Oracle Marketplace (Developer Preview)
• Oracle MBaaS Documentation

Microservices in Java with Helidon

Helidon is a collection of Java libraries for writing microservices that run on a fast web core powered by Netty.

• Helidon overview
• Community
• Helidon SE Quickstart
• Helidon MP Quickstart

Microservices in Java with Micronaut

A modern, JVM-based, full-stack framework for building modular, easily testable microservice and serverless applications. With this framework, application startup time and memory consumption aren't bound to the size of your codebase, resulting in a reduced startup time, fast throughput, and minimal memory footprint.

• User’s Guide
• Micronaut Quickstart

Transaction Manager for Microservices (MicroTx)

Oracle Transaction Manager for Microservices simplifies application development and operations by enabling distributed transactions to ensure consistency across polyglot microservices deployed in Kubernetes and/or other environments. This transaction manager runs outside the database and is suited for running across heterogeneous databases. In addition MicroTX supports Long Running Actions (LRA) and Try-confirm-cancel (TCC) consistency protocols.

• MicroTx Overview
• Developer’s Guide

Data-centric modern AppDev

Reference architectures use design principles to satisfy core modern app development requirements for web/mobile apps that integrate AI/ML, data-driven analytics, and messaging platforms. Architectures are event-driven to react to events in real time. These architectures help accelerate custom AppDev in finance, retail, healthcare, energy, manufacturing and also help extend packaged Oracle Applications. Most enterprise applications are data-centric, with a variety of data that is best handled by a converged database. Low-code AppDev compresses the number of technology tiers needed and is an option, along with polyglot programming, that uses popular languages, such as Java, Python, JavaScript, and more. Apps and database containers managed by Kubernetes can be deployed on OCI, standalone environments, and other major public clouds.

Opinionated choices with recommended technologies cover the following, although we realize there may be an overlap of design choices and best practices among these categories, such as a mobile app that is event-driven, built with low code, and crunches big data. We’ve got you covered with the recommendations below as the main categories of architecture patterns:

• Web/mobile applications
• Messaging and event-driven applications
• Low-code applications
• Big data, analytics, and AI/ML applications
• Converged Data Architecture for App Development
• Modern AppDev design principles and core requirements

Low-code with Oracle APEX

Low-code platforms enable you to build enterprise apps faster than with traditional hand coding. These platforms are well suited for building data reporting and analysis apps and opportunistic applications in collaboration with business stakeholders, extending SaaS apps and modernizing legacy applications.

Oracle APEX uses a simple, database-encapsulated, metadata-driven architecture that provides fast data access, GenAI-powered code generation, top performance, and scalability.

• Low code reference architecture
• Oracle APEX

Blockchain App Builder

Blockchain App Builder provides a low-code development and test environment to support the scaffolding, local testing, and automated deployment of smart contracts. It can automatically generate smart contracts from declarative specs and aids in development, testing, and deployment. It also provides tokenization support with autogeneration of chain codes for the full token lifecycle.

• Using Blockchain App Builder for Smart Contract Development

Oracle Transactional Event Queues

Oracle Transactional Event Queues (TxEventQs) are high-performance partitioned implementation queues with multiple event streams per queue. A TxEventQ is the partitioned and in-memory implementation of Oracle Advanced Queuing. TxEventQ queues support the JMS spec and can be accessed in Java, Python, Node.js, PL/SQL, C/C++, .NET, and Go.

• Use Advanced Queuing with Autonomous Database
• Transactional Event Queues and Advanced Queuing
• Oracle Database Transactional Event Queues Java API reference
• DBMS_AQ PL/SQL packages
• Advanced Queuing: Kafka Java Client for Transactional Event Queues

Oracle XML Developer’s Kit

XML is a scripting language similar to HTML and is mainly used to store and transport data. Oracle XML Developer’s Kit (XDK) is a versatile set of components that enables you to build and deploy C, C++, and Java software programs that process XML. You can assemble these components into an XML application that serves your business needs.

• Introduction to Oracle XML Developer's Kit
• XML C API reference
• XML C++ API reference

Machine learning

Oracle Database accelerates machine learning with powerful algorithms that run inside the database. This allows you to build and run ML models without having to move or reformat data. Data scientists leverage Python, R, SQL, and other tools to integrate ML capabilities into database applications and deliver analytics results in easy-to-use dashboards.

• Oracle Machine Learning overview
• Oracle Machine Learning notebooks
• View an interactive product tour

Oracle REST Data Services API

The Oracle REST Data Services API allows Oracle REST Data Services users to perform Oracle Database management and monitoring operations through a user-friendly REST API. ORDS database APIs provide services, such as pluggable database management, data export, and database performance review.

• Oracle REST Data Services API documentation
• REST APIs for Oracle Database documentation
• Oracle Database REST APIs documentation

Oracle SQL

Oracle SQL provides an easy, elegant, and performant architecture for accessing, defining, and maintaining data. Use SQL with Oracle and PHP, Java, Python, .NET, Hadoop, Node.js, and Oracle APEX.

• Learn SQL for free
• Blog: All things SQL
• Oracle Live SQL: Try it out for free in your browser

SQL*Plus

SQL*Plus is an interactive and batch query tool provided with every Oracle Database server or client installation. It provides a command-line user interface that allows you to enter and execute SQL, PL/SQL, SQL*Plus, and operating system commands.

• SQL*Plus User's Guide

SQL Developer

Oracle SQL Developer is a free graphical tool that simplifies database development tasks. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, edit and debug PL/SQL statements, manipulate and export data, and view and create reports. You can connect to both Oracle Databases and selected third-party (non-Oracle) databases, view metadata and data, and migrate these databases to Oracle. SQL Developer also integrates interfaces into several related technologies, including Oracle Data Miner, Oracle OLAP, Oracle TimesTen In-Memory Database, and SQL Developer Data Modeler (read-only).

• SQL developer documentation
• SQL developer download
• That Jeff Smith blog
• Tutorial: Connecting SQL Developer to Autonomous Database and loading data

SQL Developer Data Modeler

Oracle SQL Developer Data Modeler is a data modeling and database design tool that provides an environment to capture, model, manage, and exploit metadata.

• SQL Developer Data Modeler documentation
• SQL Developer Data Modeler download
• That Jeff Smith blog post on data modeling

SQLcl

Oracle SQLcl (SQL developer command line) is a Java-based command line interface for Oracle Database. Using SQLcl, you can execute SQL and PL/SQL statements in interactive or batch mode. SQLcl provides inline editing, statement completion, command recall, and supports your existing SQL*Plus scripts.

• SQLcl documentation
• SQLcl download
• Oracle SQLcl 5th year anniversary video on That Jeff Smith blog

LiveSQL

Learn and share SQL while getting better at writing code. This includes tutorials, sample macros, explanation of query plans. Run code in the browser in seconds.

• Learn more about LiveSQL

Oracle Database Actions

Oracle Database Actions (formerly SQL Developer Web) is a web-based interface that provides development, data tools, administration, and monitoring features for Oracle Database. It is available with Oracle Autonomous Database and included with the Oracle REST Data Services (ORDS) download for on-premises use.

• Get started with Database Actions
• Oracle Database Actions documentation (on-premises)
• Oracle Database Actions download with ORDS
• That Jeff Smith blog post on SQL Developer Web

JSON data/documents

Oracle Database provides APIs for the manipulation of JSON data and support for native storage of JSON data. These allow you to analyze, secure, and perform other operations on JSON data.

• JSON Developer's Guide
• Oracle JSON Document Database
• Autonomous JSON Database
• Oracle Database API for MongoDB
• Simple Oracle Document Access

Oracle’s spatial database

Oracle's spatial database is available in Oracle Database. It allows developers and analysts to get started easily with location intelligence analytics and mapping services. It enables geographic information system (GIS) professionals to successfully deploy advanced geospatial applications. Organizations can manage different types of geospatial data, perform hundreds of spatial analytic operations, and use interactive map visualization tools with the spatial features in Oracle Autonomous Database and Oracle Database.

• Oracle’s spatial database
• LiveLabs workshop
• Oracle Spatial and Graph blogs
• Oracle Database spatial documentation

Graph database and graph analytics

Oracle’s graph database is available in Oracle's converged database. It allows graph users to use two popular graph models: property graphs and RDF graphs. Developers, analysts, and data scientists can explore data relationships using graph queries and perform graph analytics using prebuilt graph algorithms to gather business insights, such as making recommendations, finding communities, pattern matching, identifying fraud, and other anomalies. Graph Studio in Oracle Autonomous Database provides a fully managed, automated graph data interface that makes it easier to create and query graphs. It delivers extensive graph analytics and graph query support with advanced notebooks and interactive visualizations.

• Oracle’s graph database
• Oracle Spatial and Graph blogs
• Oracle Database graph documentation
• Using Graph Studio in Oracle Autonomous Database
• LiveLabs workshop for Graph Studio
• LiveLabs workshop for exploring graphs in Oracle Database

Oracle XML Database

Oracle XML Database (XML DB) allows you to store and manipulate XML data natively. It provides complex data analysis and reporting, high performance and scalability, data protection, and access control..

• Oracle XML DB
• Oracle XML DB Developer's Guide

Kubernetes Operator

Oracle Database Operator for Kubernetes (also called. OraOperator) extends the Kubernetes API with custom resource definitions and controllers for automating Oracle Databases operations. Kubernetes has become the most popular and ubiquitous open source framework for automating continuous integration and continuous delivery (CI/CD) pipelines.

• Blog: Making Oracle Database Kubernetes-native
• Operator code
• Oracle container registry

Unified observability

End-to-end observability of application development, including app-tier, mid-tier, and data-tier. Metrics, logs, and traces are collected and analyzed with Prometheus, using Grafana as the monitoring dashboard.

• LiveLab: Unified Observability in Grafana with converged Oracle Database
• Blog: Unified observability: metrics, logs, and tracing of app and database tiers in a single Grafana console

Real Application Security

Oracle Database Real Application Security Administration (RASADM) lets you create Real Application Security data security policies using a graphical user interface.

Real Application Security manages application security for application users, rather than database users. It enables application user identity to be known during security enforcement. With Real Application Security, developers can manage security for application-level tasks and return security to the database layer, either incrementally, or all at once.

• Real Application Security Administration Console (RASADM) User’s Guide
• Real Application Security Administrator's and Developer's Guide

Java Database Connectivity

Java Database Connectivity (JDBC) is a Java standard that provides the interface to connect Java applications to relational databases. In addition to supporting the standard JDBC application programming interfaces (APIs), Oracle JDBC also provides extensions to support Oracle-specific data types and enhance performance of Java applications that connect to Oracle Database.

• Oracle Database JDBC Developer's Guide and Reference