Creating REST APIs Is Fast, Easy, and Secure with Oracle REST Data Services

Session Number: 8548
Track: Database
Sub-Categorization: DB Dev
Session Type: Solutions
Primary Presenter: Blaine Carter [Oracle Developer Advocate for Open Source - Oracle Corporation]
Time: Jun 26, 2019 (11:45 AM - 12:45 PM)
Room: 618, Level 6

Speaker Bio: Blaine Carter started programming in 1995. For most of his career, he has used Oracle tools to build applications. Blaine has worked with Oracle Forms and Oracle Reports and even created a framework to generate web applications using PL/SQL, which is similar to Oracle Application Express. He has done a little Java, both inside and outside the database, and of course a whole bunch of SQL and PL/SQL.

Several years ago, Blaine got hooked on open source and went exploring. He wrote a tiny bit of Perl, explored using Solr and Elastic Search as a database for small projects, wrote even more Java, built a project with Ruby for a small autism center, and most recently got all excited about JavaScript.

His combined experience with Oracle Database and open source led him to a brand-new position at Oracle Corporation: Oracle Developer Advocate for Open Source. Blaine helps users figure out how to take full advantage of Oracle Database technologies from open-source tools, and he promotes the use of open source inside and outside of Oracle. Blaine is a firm believer in learning by doing, failing, and then sharing at www.learncodeshare.net.

Technologies or Products Used: Oracle REST Data Services, SQL Developer

Session Summary for Attendees:  In this session, Blaine Carter will demonstrate how to REST enable your database using Oracle Rest Data Services (ORDS). He will demonstrate how to use SQL Developer to create and deploy REST services in ORDS. First, Blaine will "Auto REST" enable a table and a PL/SQL package. Then he will secure the API and create an OAuth2 client that can be used to access the service. Next, he will walk through the steps of creating a custom REST API using the REST Data Services wizard. This API will be used to POST image files into a BLOB column in the database, and the GET handler will serve the image directly in a webpage. You will leave this session with an understanding of how to quickly create REST services on your own database.