All case studies Data · Analytics

Analytics on Oracle 23ai + APEX 24.

A Dockerized deployment of Oracle Database 23ai Free with APEX 24, running on a Contabo free-tier VPS — proof that modern Oracle no longer means Oracle-license pricing. The stack now serves internal analytics dashboards with vector search and Select AI (natural-language queries).

Engagement
Internal analytics deployment
Stack
Oracle 23ai Free + APEX 24
Host
oracle.thinkstacks.io
Tier
Free — 2 CPU / 2 GB / 12 GB DB
The problem

Modern Oracle without a Big-4 contract.

Oracle 23ai brings AI vector search and GenAI directly into the database engine — but most teams still think "Oracle" means a six-figure procurement cycle. We wanted to prove that a small ops team can run 23ai productively on a modest cloud budget.

The internal analytics use case was straightforward: dashboards over group-wide operational data, plus a "ask a question in English" surface built on Oracle's Select AI.

Approach

Containerised, resource-bounded, upgrade-friendly.

  • Oracle Database 23ai Free in a container, memory-capped to fit the tier.
  • APEX 24 as the app-server layer — no PHP / Node middleware needed.
  • Nginx reverse proxy (CloudPanel) fronting APEX with a Let's Encrypt cert.
  • Docker-compose for lifecycle management and clean upgrades.
  • Automated nightly RMAN-style backup to off-server storage.
What ships

Capabilities enabled by 23ai.

Vector search

Native VECTOR datatype and similarity search functions. No external Pinecone/Milvus needed — vectors live in the same DB as your operational data.

Select AI

Natural-language querying: analysts type "top 10 SKUs by margin last quarter" and Oracle synthesises the SQL, runs it, and returns results.

JSON Duality Views

Model data relationally, expose it as JSON — no ORM layer needed for API endpoints.

APEX 24 dashboards

Low-code visual dashboards drawn directly on DB views. Interactive Reports, charts, and drilldowns without a JS framework.

Free-tier friendly

Bounded memory, tuned SGA/PGA sizing, and workload throttling to keep the whole thing inside 2 CPU / 2 GB RAM.

Docker-managed lifecycle

docker-compose up brings the whole stack — DB, APEX, ORDS, nginx-proxy — with named volumes for data durability across container rebuilds.

Outcomes

Enterprise-class DB tech on a startup budget.

$0Oracle licence cost (Free tier)
12 GBDB size limit (well within needs)
Nativevector search + GenAI
Low-codeAPEX for internal apps
Built on

Tech stack.

Oracle Database 23ai Free Oracle APEX 24 ORDS Docker docker-compose CloudPanel + nginx Let's Encrypt RMAN-style backup
Oracle-shy?

23ai Free is a genuine option for internal apps.

We'll help you evaluate whether Oracle 23ai fits your use case, and stand up a working proof-of-concept on your infrastructure in under a week.

Book a discovery call→