Development Environments
Oracle AI Database Free supports the following development environments:
- Java: Develop and deploy modern database-bound Java Web applications (Servlets), modules (Microservices) or standalone Java frameworks using the Oracle JDBC Driver, the Universal Connection Pool (UCP), and the Database-embedded JVM (for in-place, server-side processing).
See https://www.oracle.com/database/technologies/appdev/jdbc.html for more information. - C and C++: Developers can use Oracle Call Interface (OCI) and Oracle C++ Call Interface (OCCI) to create high performance programs accessing Oracle AI Database Free. ODBC and the ODPI-C wrapper over OCI are also usable.
See https://www.oracle.com/database/technologies/appdev/oci.html for more information.
- .NET and Visual Studio: Developers can use Oracle Data Provider for .NET (ODP.NET) for C# and VB.NET data access to any Oracle AI Database. At design-time, they can use Oracle Developer Tools for Visual Studio for full development life cycle support.
See https://www.oracle.com/database/technologies/appdev/dotnet.html for more information
For walk-throughs on creating a .NET application with Oracle AI Database Free:
https://www.oracle.com/tools/technologies/quickstart-dotnet-for-oracle-database.htmlThe walk-throughs cover several development scenarios, including with Visual Studio and command line.
- Oracle SQL Developer: Oracle SQL Developer is a graphical version of SQL*Plus that gives database developers a convenient way to perform basic tasks. You can connect to any target Oracle AI Database Free schema using standard Oracle AI Database authentication. Once connected, you can perform operations on objects in the database.
Download and install Oracle SQL Developer from:
https://www.oracle.com/database/sqldeveloper/ - Oracle SQL Developer Web: Included with Oracle REST Data Services, Oracle SQL Developer Web is the web-based version of Oracle SQL Developer that enables you to run queries and scripts, create database objects, build data models, and monitor database activity.
- Oracle Application Express: Oracle Application Express (APEX) is a rapid web application development tool for the Oracle AI Database.
Download and install Application Express from:
https://www.oracle.com/database/technologies/appdev/rest.html - Oracle REST Data Services (ORDS): ORDS makes it easy to develop modern REST interfaces for relational data in the Oracle AI Database and the Oracle AI Database JSON Document Store.
Download and install ORDS from:
https://www.oracle.com/database/technologies/appdev/rest.html - SODA (Simple Oracle Document Access) APIs that let you develop NoSQL-style applications against collections of JSON documents. Native language SODA drivers are available for common languages.
See https://docs.oracle.com/en/database/oracle/simple-oracle-document-access/ for more information.