Oracle 23c unleashed: App Development with JSON Duality Views

• Translation between both worlds is tedious
• Middleware: Spring, Express, etc.
• Mapping: manual / ORM
• ORDS: Autorest a nice start but not tailored to frontend
• Allow for Reads and Writes

Source

• A new view type
• Parent and child tables form document
Read → get JSON document
Write → pass changed JSON document
Lost changes detection
Control which columns can be changed
• ORDS REST enable → auto REST support

• Protect your ORDS endpoints
• Backend-for-frontend: customized JDV for every page
• Read: GET
• Write: I - POST | U - PUT | D - DELETE
• (based on parent document)
• Write helper function to communicate with JDVs

• Authorization can't be in database
• (e.g. only authorized people allowed to write)
• → check in app backend before writing to JDV
• Client-side-rendered apps: read-only

• Pagination inside document
• Having to get PKs from child table → duplicate values for n:m
• Orderby bug

• Oracle JDV Documentation
• @flex columns
• @link annotation (self-references)
• @nocheck annotation
• Restrictions for JavaScript Object Notation and JSON-Relational Duality Views
• Oracle Example
• Oracle Base