Veesker Oracle Platform
Blog

Notes from the Oracle + AI workshop.

Two posts per week. Mondays are deep-dives — code, EXPLAIN PLAN, architectural decisions. Thursdays are short manifestos — opinions, takes, calls to action.

Topics:
  1. 2026-09-07 Deep dive 7 min read

    Oracle statistics and histograms: why the CBO's plan changes when you gather stats

    A precise look at how Oracle's cost-based optimizer uses statistics and histograms to estimate cardinality, and why gathering — or mis-gathering — stats changes every plan downstream.

    #oracle#cbo#statistics#histograms#performance
  2. 2026-08-10 Deep dive 6 min read

    CDB and PDB in practice: how Veesker navigates pluggable database hierarchies

    Oracle's Multitenant architecture splits databases into containers and pluggables. Here's how to work it daily, and how Veesker keeps the hierarchy visible.

    #oracle#multitenant#cdb#pdb#developer-tools
  3. 2026-07-23 Manifesto 2 min read

    Dead software and open licenses: what you owe the people who built workflows on your tool

    When a developer tool dies, an open license is not charity — it is the minimum you owe every developer who built workflows on your promise of longevity.

    #open-source#developer-tools#licensing#sustainability
  4. 2026-07-20 Deep dive 7 min read

    Oracle 23ai JSON Relational Duality Views: what they are and how to query them

    JSON Relational Duality Views let you read and write relational data as JSON documents without maintaining a separate document store.

    #oracle#23ai#json#duality-views#sql
  5. 2026-07-13 Deep dive 6 min read

    Writing a schema-aware PL/SQL formatter: rules you can't get from a generic linter

    Generic SQL formatters work on syntax. PL/SQL formatting decisions are often semantic — and the right answer lives in the database, not in the source text.

    #oracle#plsql#formatter#developer-tools#linter
  6. 2026-07-06 Deep dive 7 min read

    How Veesker handles Oracle wallet files: OCI, mTLS, and the cloud connection story

    A practical look at Oracle wallet authentication — cwallet.sso, ewallet.p12, mTLS, and how Veesker stores and uses wallet credentials without touching a plaintext config file.

    #oracle#wallet#oci#mtls#security
  7. 2026-06-29 Deep dive 7 min read

    Bind variables vs string concatenation: still relevant in the LLM era

    LLMs trained on web code tend to generate string-concatenated SQL. Here is why that is an Oracle performance problem, and how schema-aware AI avoids it.

    #oracle#performance#sql#ai#plsql
  8. 2026-06-25 Manifesto 2 min read

    The pricing transparency test: why 'contact sales' is the wrong answer for a developer tool

    If a developer can't see the price of your tool on your marketing page, you've already failed the first trust test.

    #developer-tools#pricing#trust#open-source
  9. 2026-06-22 Deep dive 7 min read

    Auto-documenting 1000 PL/SQL Packages Overnight — Design Notes

    How Veesker's schema-aware pipeline extracts context from the data dictionary, resolves dependencies, and generates reviewable PL/SQL documentation at scale.

    #oracle#plsql#documentation#ai#developer-tools
  10. 2026-06-18 Manifesto 2 min read

    What 'good' looks like for a database IDE in 2026

    Good is not a feature list. A database IDE is good when it knows the database it is connected to — version, schema, constraints — and adapts.

    #developer-tools#oracle#database#local-first
  11. 2026-06-15 Deep dive 7 min read

    Per-connection safety in Veesker: env tags, read-only mode, statement timeouts, and DML guards

    How Veesker's per-connection safety controls — env tags, read-only mode, statement timeouts, and unsafe-DML guards — make the wrong connection feel different before you execute.

    #oracle#safety#developer-tools#dml#connection-management
  12. 2026-06-11 Manifesto 2 min read

    You don't have a query problem, you have a context problem

    When AI-assisted SQL fails, the model is rarely wrong about SQL — it's wrong about your database. The fix is context, not a bigger model.

    #oracle#ai#sql#developer-tools#context
  13. 2026-06-08 Deep dive 7 min read

    Why we picked Tauri 2 over Electron for an Oracle IDE

    Tauri 2 cut Veesker's installer to 12 MB, uses native OS WebViews instead of bundled Chromium, and hands security-sensitive work to a Rust backend that owns Oracle credentials properly.

    #oracle#tauri#electron#desktop-apps#developer-tools
  14. 2026-06-04 Manifesto 2 min read

    Open-source as a hiring filter: build the tool the senior dev would download

    Open-source developer tools are the most honest job posting you will ever write — the senior dev who downloads yours has passed a filter most hiring processes can't replicate.

    #open-source#hiring#developer-tools#oracle#apache
  15. 2026-06-01 Deep dive 7 min read

    Building Oracle 23ai vector RAG: from embeddings to ORDS endpoints

    A practical walkthrough of Oracle 23ai's VECTOR type, VECTOR_DISTANCE queries, HNSW indexes, and ORDS REST endpoints — the full RAG pipeline without leaving the database.

    #oracle#vector-search#rag#ords#23ai
  16. 2026-05-28 Manifesto 2 min read

    The Case Against Subscription-Only IDEs in 2026

    Subscription gates on developer tools are a pricing decision dressed up as product philosophy — and Oracle developers are the ones paying the cost.

    #developer-tools#oracle#open-source#pricing
  17. 2026-05-25 Deep dive 7 min read

    EXPLAIN PLAN as a feedback loop for AI query tuning

    Most AI query suggestions are evaluated in a vacuum. Grounding AI output against Oracle's cost-based optimizer changes the economics of AI-assisted tuning.

    #oracle#explain-plan#ai#query-tuning#performance
  18. 2026-05-21 Manifesto 2 min read

    Why "AI for SQL" is mostly a UX problem, not a model problem

    The LLM can write correct Oracle SQL — it just needs the schema, the version, and the execution plan. Giving it those three things is a UX job, not a model job.

    #oracle#ai#developer-tools#ux
  19. 2026-05-18 Deep dive 7 min read

    Migrating legacy PL/SQL packages to APEX 24.x — a field guide

    A practical approach to surfacing legacy PL/SQL business logic through APEX 24.x: what to lift as-is, what to rewrite, and where AI helps and where it doesn't.

    #oracle#plsql#apex#migration#developer-tools
  20. 2026-05-14 Manifesto 2 min read

    The Oracle DBA is not going extinct

    The Oracle DBA is not going extinct — the problem was never the expertise, it was the tooling that failed to match it.

    #oracle#dba#ai#developer-tools
  21. 2026-05-13 Manifesto 4 min read

    Going fully open: one repo, one binary, all source public

    The private Cloud Edition repository has been archived. All Veesker code — including premium features — is now in the public Apache 2.0 repository. A subscription still unlocks premium capabilities at runtime, but the source for every feature is public.

    #open-source#architecture#transparency
  22. 2026-05-11 Deep dive 7 min read

    Sharing production data without leaking it: VeeskerDB Sandbox encryption design

    How VeeskerDB Sandbox uses X25519 key exchange and ChaCha20-Poly1305 AEAD to share Oracle result sets between teammates without exposing plaintext to the relay.

    #oracle#security#encryption#sandbox
  23. 2026-05-07 Manifesto 2 min read

    Local-first developer tools: a manifesto for Oracle teams

    SaaS tooling that routes credentials through a remote server isn't just inconvenient for Oracle teams — it fails the first question any serious compliance audit asks.

    #oracle#local-first#security#developer-tools
  24. 2026-05-07 Manifesto 3 min read

    Stop asking your LLM to invent schemas. Ground it.

    A grounded model writing against your real schema beats a frontier model guessing. The bottleneck for AI on databases is context, not intelligence.

    #ai#oracle#schema#context
  25. 2026-05-04 Deep dive 7 min read

    Schema-aware AI: why generic LLMs fail at PL/SQL

    Generic LLMs know just enough Oracle to be dangerous — wrong CONNECT BY rewrites, broken MERGE syntax, stripped hints, and bind variables replaced with concatenation.

    #oracle#plsql#ai#schema-aware#developer-tools
  26. 2026-05-04 Deep dive 7 min read

    Why we built another Oracle IDE in 2026

    The Oracle developer toolbox is full of names — SQL Developer, PL/SQL Developer, DBeaver, Toad. So why ship another one? Because none of them treat 9i through 26ai as one job, and none of them ship AI that understands PL/SQL.

    #oracle#developer-tools#positioning#ai
  27. 2026-05-02 Deep dive 7 min read

    Oracle 9i to 26ai in one binary — Thick mode auto-discovery explained

    How Veesker bundles Oracle Instant Client, auto-detects Thick mode, and connects to every Oracle version from 9.2 to 26ai without driver gymnastics.

    #oracle#thick-mode#instant-client#connectivity#developer-tools