FoggyKitchen TODO App

Containerized Next.js TODO application used by FoggyKitchen OCI DevOps OKE examples.

The application stores TODO items in the APPUSER.FK_TODO_ITEM database table in Oracle Autonomous Database. Database schema changes are versioned with this repository under functions/fnadbupdater/changelog/changes and are applied by the landing-zone DevOps pipeline before the application rollout.

This repository is used as the external application source for the OCI DevOps OKE blue-green ADB scenario.

The Liquibase changelog intentionally contains multiple SQL changesets:

• 001-create-fk-todo-item.sql creates the base TODO table and status index.
• 002-add-priority-to-fk-todo-item.sql evolves the table with a PRIORITY column and index.

The updater function uses includeAll from db.changelog-master.yaml, so future database changes can be added as additional files in the same changes directory and applied incrementally.

The OCI DevOps build spec produces two release artifacts from the same commit:

• APPLICATION_DOCKER_IMAGE - the Next.js TODO application container
• MIGRATION_FUNCTION_DOCKER_IMAGE - the Liquibase update function container

During deployment, OCI DevOps first updates and invokes the update function, then deploys the matching application image through the OKE blue-green pipeline.

Configuration

Required runtime environment variables:

• ADB_USER
• ADB_PASSWORD
• ADB_CONNECT_STRING

Optional:

• TNS_ADMIN - wallet directory, for example /app/wallet

Local Development

npm install
npm run dev

Container

docker build -t foggykitchen-todo-app:local .
docker run --rm -p 3000:3000 foggykitchen-todo-app:local

License

Licensed under the Universal Permissive License (UPL), Version 1.0. See LICENSE for details.

© 2026 FoggyKitchen.com - Cloud. Code. Clarity.