In this workshop, you will build a mobile-friendly Movie Watchlist app that you and your friends can use to search for movies and add them to your own personal movie watchlists.
The app will source data from The Movie Database (TMDB), an online community-based database with metadata for thousands of movies and TV shows, and an extensive API.
The workshop is organized into a total of ten labs, with the last two being optional. First, you will get your APEX environment and set up an API key on TMDB. Then, you will create REST Data Sources in APEX to connect to TMDB, and begin developing!
It will take about two hours to complete the workshop, but your time may vary depending on your experience with APEX. If you get stuck, don't worry! At the end of each lab, you will find an app export that will get you across the finish line.
Upon completing this workshop, you will have your very own simple movies watchlist app that is fun and easy to use! From there, you can continue to enhance this app by applying the concepts and techniques you learned. For example, you can use the Star Rating item to rate a movie once its been watched, or show which streaming providers have the movie using TMDB's rich API. The possibilities are endless, and you'll be fully prepared for your next movie night!
Estimated Workshop Time: 2 hours
Note: This lab assumes you are using Oracle APEX 21.1.
In this lab, you will:
- Obtain a free development environment.
- Learn how to create REST data sources.
- Learn how to create local tables.
- Learn how to use application items and processes.
- Learn how to create a page to view data from a REST source.
- Learn how to create a page to view data from a local table.
- Learn how to search for movies.
- Learn how to manage a list of movies.
| # | Module | Est. Time |
|---|---|---|
| - | Getting Started | 5 min |
| 1 | Create the Application | 5 min |
| 2 | Create REST Data Sources | 15 min |
| 3 | Create the Movie Search Page | 20 min |
| 4 | Create the Movie Details Page | 10 min |
| 5 | Create Local Tables | 10 min |
| 6 | Implement Buttons and Badges | 15 min |
| 7 | Implement the Watchlist Page | 20 min |
| 8 | Improve the Movie Details Page | 10 min |
| 9 | Add Cast List (Optional) | 10 min |
| 10 | Improve the Watchlist Page (Optional) | 5 min |
- Click here or select Getting Started from the menu on the left to start the workshop and set up an Oracle APEX workspace.
- If the menu is not displayed, you can open by clicking the menu button (
) at the top of the page.
- Click here to download the completed application.
- The Movie Database
- The Movie Database API
- APEX on Autonomous
- APEX Service
- APEX Collateral
- Tutorials
- Community
- External Site + Slack
- Author - Paige Hanssen
- Additional Contributors - Kay Jasanya, Shakeeb Rahman, Steve Muench, Monica Godoy, Eli Feuerstein, Carlos Maciel, Dalia Vazquez
- Last Updated By/Date - Paige Hanssen, March 2022