Your Next Dev Adventure Starts Here

AI blog Database docker Duality Views Go Graph Java JDBC JMS JPA JSON Kafka livesql microservices MongoDB NodeJS Observability OCI oraclefree Oracle Text ORDS PDB performance PL/SQL python security Spatial SpringBoot Testcontainers TxEventQ TypeScript Vector Search

  • Oracle AI Database for Free?

    Oracle AI Database for Free?

    Wait — Oracle? For devs? Yeah. Let me show you. docker pull gvenzl/oracle-free:23.26.0-slim-faststart Oracle now gives you a modern, free-to-try database with some surprisingly cool features: You don’t need to be a DBA. You don’t need a license key. You just spin it up and go. In this article, we’ll explore the different ways you… Read More

  • Agent Memory Techniques for Oracle AI Database

    Agent Memory Techniques for Oracle AI Database

    Key Takeaways If you build agent memory off a vector table, it’s probably not going to give you the full picture. It may work for a demo, but falls apart when the system needs to remember a preference from last month, ignore a one-off session detail, distinguish two users, explain why a memory was retrieved, and avoid stuffing weak… Read More

  • Is Oracle the best database for small to mid size shops?

    Is Oracle the best database for small to mid size shops?

    Key Takeaways Oracle AI Database isn’t an automatic “best database” choice for every app, side project, or business system. If you need the absolute simplest embedded database, use SQLite. If your team already knows Postgres, that might be the shortest path. However, if your team needs one database that can cover normal relational data, JSON documents, search, spatial data, graph relationships, events, REST endpoints, APEX apps, local testing, and a… Read More

  • Polyglot, automated ORDS tests with Testcontainers

    Polyglot, automated ORDS tests with Testcontainers

    Did you know you can locally test Oracle REST Data Services (ORDS) with free Oracle AI Database resources? If you rely on mock servers (or don’t run automated tests at all!), you’re dealing with a thin layer of comfort. Using container-driven ORDS tests can prove your app starts, connects to ORDS, and uses database APIs… Read More

  • An Agent Skill that uses Kafka Java APIs for Oracle AI Database

    An Agent Skill that uses Kafka Java APIs for Oracle AI Database

    In my own work, I found most coding agents weren’t generating high-quality code for Oracle AI Database’s Kafka Java API (OKafka). You can get results, but they’re not idiomatic, and miss subtleties. This is why I created the okafka-java-code oracle agent skill, based off my hand-written Kafka Java API examples. Agent skills can greatly enhance… Read More

  • An app that keeps its data in one place : multi-model database pattern

    An app that keeps its data in one place : multi-model database pattern

    The code for this article on multi-model database patterns lives in the oracle-database-code-samples repo, under the support-ticket-intelligence sample.  When I add a graph database to an application, I’m not just adding a query feature. I need to understand how the database is set up, how its schema works, how to operate it, how to monitor it, and how to move data across service boundaries. The… Read More

  • MongoDB Over Relational Data: JSON Relational Duality Views

    MongoDB Over Relational Data: JSON Relational Duality Views

    Can your MongoDB client be used against a document-shaped contract while the system of record stays relational? You can do exactly this with the MongoDB API for duality views. JSON Relational Duality Views expose document APIs over relational data. Those same document APIs accessed through Oracle REST Data Services’ (ORDS) MongoDB-compatible API allow any MongoDB… Read More

  • 5 Free Oracle AI Database Dev Tools I’d Put in a Starter Kit

    5 Free Oracle AI Database Dev Tools I’d Put in a Starter Kit

    Developers need the shortest path from claim to proof. Can I start a database locally? Can I connect from my app? Can I run my tests against it? Can I inspect the schema without guessing? Can I use it with scripts, agents, and CI? Can I easily move from a laptop to a managed cloud database? This is all possible with free Oracle… Read More

  • SQLcl MCP for Oracle AI Database using LangChain

    SQLcl MCP for Oracle AI Database using LangChain

    Want to ask to use Model Context Protocol (MCP) to orchestrate Oracle AI Database from Python apps? In this article, we’ll build a small agent using Python, LangChain, SQLcl MCP, and Oracle AI Database Free. The app takes a user prompt and then uses SQLcl’s MCP server to inspect the schema, generate a read-only query and return a concise answer. This… Read More

  • The Exploit Window is Shrinking. Converged Databases Shrink the Attack Surface

    The Exploit Window is Shrinking. Converged Databases Shrink the Attack Surface

    I often talk about converged, multi-model databases from the perspective of developer productivity. Owning one platform that handles many data types like relational, JSON, graph, vector yields fewer moving parts when building and operating apps. Recently, another reason is more and more compelling: security. AI-assisted vulnerability discovery is moving incredibly fast. Anthropic’s Project Glasswing describes frontier models finding and exploiting… Read More

  • Database Per Service with Oracle AI Database PDBs

    Database Per Service with Oracle AI Database PDBs

    Using Oracle AI Database Pluggable Databases (PDBs) to give each Spring Boot service its own clear data boundary. Key Takeaways PDBs are a natural fit for microservices that need hard data ownership without turning every service into a separate database install. In Why You Should Use Pluggable Databases (PDBs), I walked through the basic mechanics of creating… Read More

  • Using Agent Skills to develop with Oracle AI Database

    Using Agent Skills to develop with Oracle AI Database

    Skills are reusable, task-specific workflows for your agents: each skill is a directory centered on a SKILL.md file, with optional scripts,references, and assets packaged together. Skills bring context efficient capabilities to agents in a reliable, repeatable manner. In this article, we’ll look at what skills are, how to install them, and how the open source… Read More

AI blog Database docker Duality Views Go Graph Java JDBC JMS JPA JSON Kafka livesql microservices MongoDB NodeJS Observability OCI oraclefree Oracle Text ORDS PDB performance PL/SQL python security Spatial SpringBoot Testcontainers TxEventQ TypeScript Vector Search

Hi! Thanks for stopping by.

I’m Anders — A Developer Advocate for Oracle Database, and the writer behind andersswanson.dev.

This space is dedicated to empowering developers and making Oracle Database more approachable. I focus on helping you get the most out of powerful features like AI Vector Search, JSON Relational Duality Views, and Transactional Event Queues with clear, practical examples and real-world use cases.

Broken Top

Questions? Message me.

← Back

Thank you for your response. ✨

Lauren wearing a white dress, standing in front of kinbane castle on northern ireland's causeway coast.
Broken Top and no name lake with paintbrush flowers blooming in the foreground
Lauren in Japan, with Mt. Fuji and a red pagoda in the background.
North rim trail facing south in Grand Canyon National Park.