ORDS Advanced API Development

An endpoint is built quickly, an API that stays stable for years needs design and discipline. The workshop covers everything between the first handler and a production-grade, versioned API.

Audience

Developers and architects with ORDS basics.

Modules

The modules are building blocks. You choose and weight them, and we agree on the agenda together beforehand.

• API design: resources, verbs, status codes, error formats, conventions
• OpenAPI: generating the specification, contract first or code first, documentation for consumers
• Versioning: parallel versions, deprecation, compatibility
• Large data volumes: pagination, streaming, uploads and downloads, BLOBs
• PL/SQL architecture: layers between handler and business logic, reuse with REST-Lib
• Performance: pools, caching, execution plans, measurement
• Deployment: ORDS definitions in Git, SQLcl and Liquibase, CI/CD
• Integration: ORDS behind API gateways (OCI API Gateway, Azure APIM), load balancing, geo redundancy

REST-Lib

Every ORDS workshop includes my REST-Lib: a PL/SQL library that standardizes recurring tasks such as response formats, error handling and parameter validation. It is handed over to your team together with the materials.

Outcome

A guideline for API design and deployment in your team and a sample API that implements it.

Preview

For a first look: the talks on this topic give you an overview, and the talk pages include the slides.

• Advanced API Development with ORDS SOUG Day Zurich 2025