ORDS - GET PUT POST DELETE your Oracle Database

Have you heard? We now offer support for GraphQL queries! Docs: social.ora.cl/6016R6bNG

@OracleREST TIP: print all config name/values including defaults >> config list --include-defaults

Join @chrishoina @thatjeffsmith on 14 November @ 12 PM ET ! We'll be teaching you how to make sure your Oracle Database REST APIs are FAST. Topics will include tuning tips, ORDS features to minimize response times, and free testing tools. Register TODAY social.ora.cl/6016ugy5C

Our product manager talks about how to debug/fix pool issues when starting ORDS social.ora.cl/6019PUiD7 Is the account locked? Is the password correct, needs updating?

@OracleREST tip. When there is an "All connections in use" , the numbers in the brackets are the pool stats > #shortForm__" target="_blank" rel="nofollow noopener">docs.oracle.com/en/database/or…

New post! We've added support for PATCH requests on your JSON-Relational Duality Views in @OracleDatabase 23c via @OracleREST release 23.2 thatjeffsmith.com/archive/2023/0…

Have you seen our new default landing page? 23.2 will make it easy for you to get started with SQL Developer Web and/or APEX for any of the databases you have enabled with #Oracle REST Data Services (ORDS) Learn more and/or download the latest here! social.ora.cl/6017PRqAf

Can't start @OracleREST in standalone mode because port 8080 is already in use? Fix it... peterobrien.blog/2023/07/17/808…

New post! More on @OracleREST 23.2 - nicer looking, more functional HTML error response pages. thatjeffsmith.com/archive/2023/0… #oracle #database #developers

Recommended reading: Best Practices for developing REST APIs for Oracle Database (with ORDS) social.ora.cl/6013OAiox #oracle #developers #advice #database #restapis

Great post from one of our Oracle Database web developer enthusiasts, @JonDixonUS A must-read if you plan on deploying apps in @OracleCloud blog.cloudnueva.com/oci-api-gatewa…

Effective use of eTags - one of many tools for speedier, more responsive apps. ORDS can help! Here are 3 takes: cdivilly.wordpress.com/2014/10/31/ora… krisrice.io/2020-09-22-ORD… blog.cloudnueva.com/ords-etags

Exporting your REST APIs, Clients, objects for an entire schema OR Exporting a single module OR Generating OpenAPI client/doc for a module - using SQL Developer Web's REST interface! #oracle #restapis #database #developer

A look at running ORDS locally in your dev env running against your Oracle #Database in #Podman from our own @chrishoina followthecoffee.com/user-guide-ora…

From the archives: REST APIs and TABLE INSERTs: the Definitive Guide for Oracle thatjeffsmith.com/archive/2022/0…

Build best REST APIs for your Oracle Database with help from these experts - blog.cdivilly.com/tags/ords/ krisrice.io/archive/ peterobrien.blog followthecoffee.com/tag/ords/ thatjeffsmith.com/oracle-databas…

Great post where @chrishoina shows how to drag-and-drop CSV files on your Mac, and have the data automatically loaded to a table in your @OracleDatabase using REST APIs followthecoffee.com/ords-post-requ…

Calling REST APIs that do 'work' against your @OracleDatabase boils down to HTTP -> SQL/PLSQL -> HTTP with JSON being the data data-interchange format So issuing a POST, results in a PL/SQL block being executed, The response format/data is also defined here.

Need a 'Hello, World!' REST API to see if you've deployed ORDS correctly? Here's a single block of PL/SQL to do that for one of your REST Enabled Schemas - see the image ALT text. PL/SQL API Docs: #GUID-2ABE5D9C-8C80-4422-922E-DBF3A37F4B21" target="_blank" rel="nofollow noopener">docs.oracle.com/en/database/or… #oracle #developer #restapi #database

Test with AutoREST table from my ADW @OracleREST with @axios - it works.