We have a brand new hands-on LiveLab ready for you in a couple of weeks in Las Vegas for Cloud World 2024!
Seats are quickly filling up, so if you’re a developer curious learning more about:
- using SQL to query JSON in the database
- building REST APIs to query said data
- using those REST APIs in a Python Flask web app…with a bit of on-page JavaScript thrown in…
Day: Wednesday, September 11
Time: 3:00 PM – 4:30 PM PDT
REGISTER NOW for HOL2987 : Python, Flask Application w/ REST APIs: 2024 Edition
Don’t worry, it probably won’t take you 90 minutes to get to the part where you’re playing with the app/code – it took me about…7 minutes.
We can even demonstrate tweaking the APIs ‘on the fly’ and see how the app reacts, or adds/improves functionality. WE WANT THIS SESSION TO BE FUN AND INFORMATIVE.
![](https://www.thatjeffsmith.com/wp-content/uploads/2024/08/python-flask-lab-demo.gif)
The apps is quite simple – you pick a genre, a move runtime, and hit ‘go’ – this hits our REST API endpoint, and returns a json object array.
The python app renders this as a nice/simple web page, that you can then paginate through, or hit the ‘+’ button to learn more about the movie.
Every time you click a button, you’re getting data from an Oracle Database. But, if you look at the Python or JavaScript source code, there’s no SQL, no database connections! Just http fetching 🙂
I barked at Chris to comment his code…he understood the task
![](https://www.thatjeffsmith.com/wp-content/uploads/2024/08/image-11-1024x725.png)
Chris, myself, and maybe even Kris will be there in the room to guide you through the process, and we’ll be ready to explain the RESTful API concepts, how the SQL actually works, how the REST APIs all come together to power your Python app.
We’ll provide the environment for you, so no need to create a database or cloud account in advance, you can borrow ours!
Need a better understanding of ORDS and REST APIs, including how to implement security via OAuth2?
Then you’ll also want to add this session to your itinery.
HOL2986 – Hands-On Lab, Oracle Database REST APIs: a Master Class: learn how to AutoREST a table, build your own REST API, and how to secure with an an OAuth2 client.