andersswanson.dev

Natural Language SQL with Oracle MCP and LangChain4j

December 2, 2025

AI, Java
Spring Cloud Config: JDBC Backend & Oracle AI Database

November 21, 2025

Java, SpringBoot
Spatial Data in Oracle AI Database

November 14, 2025

PL/SQL, Spatial
AI Optimizer & Toolkit: test and generate apps

November 5, 2025

AI
Unlocking Session Visibility with Oracle Client Info

November 3, 2025

Java, Observability, SpringBoot
AI Optimizer & Toolkit: connect LLMs and use your data

October 27, 2025

AI
AI Optimizer & Toolkit: set up a local sandbox

October 21, 2025

AI
How to write a custom tracer for Oracle Database JDBC

October 20, 2025

Java, Observability, SpringBoot
Oracle JDBC Tracing with Spring Boot OpenTelemetry

October 10, 2025

Java, Observability, SpringBoot
Tracing a Spring Boot JMS app with Oracle Database Free

October 7, 2025

Java, Observability, SpringBoot, TxEventQ
Monitor your Oracle Database(s) with OpenTelemetry

October 2, 2025

Observability
Testing Go apps with Oracle Database using Testcontainers

October 1, 2025

Go, Testcontainers
Consumers and message retention in database-driven event streaming

September 25, 2025

PL/SQL, TxEventQ
Pub/Sub with a NodeJS Oracle Database App

September 22, 2025

NodeJS, PL/SQL, TxEventQ, TypeScript
Pub/Sub in your DB? Oracle Database TxEventQ

September 18, 2025

TxEventQ
Test your TypeScript/NodeJS apps with Oracle Database Free

September 17, 2025

NodeJS, oraclefree, Testcontainers, TypeScript
Spring Boot + Oracle Database

September 16, 2025

Java, SpringBoot
Transactional Outbox: Simplified with Oracle Database

September 12, 2025

Java, Kafka, TxEventQ
Learn Testcontainers (Java) with Oracle Database Free

September 11, 2025

Java, oraclefree, Testcontainers
Test Python Applications with Oracle Database Free using Testcontainers

September 11, 2025

oraclefree, python, Testcontainers
Multiple Views, One Schema: Simple RBAC with Duality Views

September 8, 2025

Duality Views, JSON, PL/SQL, security
10 Modern Database Features To Start Using Today

September 5, 2025

Database
Virtual, Materialized, and @generated columns

August 26, 2025

Duality Views, PL/SQL
Using a modern database? You might not need that ORM anymore

August 25, 2025

Duality Views
Lock-Free Writes at Scale: Under the Hood of Duality Views

August 18, 2025

Duality Views, JSON, PL/SQL
GraphQL syntax for JSON Relational Duality Views

August 14, 2025

Duality Views, JSON, PL/SQL
How to run x86 containers on ARM (like Oracle Database adb-free)

July 25, 2025

oraclefree
Let’s talk about Model Context Protocol (MCP)

July 24, 2025

AI
Many-to-many data modelling with JSON Relational Duality Views

July 23, 2025

Duality Views, JSON, PL/SQL
Simple RESTful services with ORDS: Duality Views

July 22, 2025

Duality Views, JSON, ORDS, PL/SQL
Simple RESTful services with ORDS

July 21, 2025

OCI, ORDS, PL/SQL
Column-Level Access Control Made Simple with Duality Views

July 17, 2025

Duality Views, JSON, security
Fixing the N+1 Query Problem (without ORM hacks) Using Duality Views

July 16, 2025

Duality Views, Java, JPA, JSON
7 Reasons to try out JSON Relational Duality Views, with samples

July 14, 2025

Duality Views, JSON
Run SQLcl as a MCP Server with Oracle Database Free

July 11, 2025

AI, oraclefree, PL/SQL
Run Oracle REST Data Services (ORDS) locally with Oracle Database Free

July 10, 2025
Authenticate to your Oracle Database like it’s a Kafka cluster

July 9, 2025

Java, Kafka, TxEventQ
How do I connect to multiple databases with Oracle Net?

July 7, 2025

Database, security
Use JMS Topics for messaging inside the database

June 27, 2025

Java, JMS, TxEventQ
Event-driven CDC, all within the database

June 26, 2025

Java, JMS, SpringBoot, TxEventQ
Why I’m dropping Lombok

June 25, 2025

Java
🔐 What’s an Oracle wallet, anyway?

June 24, 2025

OCI, oraclefree, security
What’s a Vector Database?

June 23, 2025

AI, Vector Search
Use JMS for asynchronous messaging in Spring Boot

June 19, 2025

Java, JMS, SpringBoot, TxEventQ
Fire-and-Forget: The Power of Sessionless Transactions

June 17, 2025

Java, JDBC
Spring Data MongoDB with Oracle Database’s MongoDB API

June 17, 2025

Java, JSON, MongoDB, SpringBoot
Create a “Run in LiveSQL” link for quick and easy sharing

June 12, 2025

livesql, oraclefree, PL/SQL
Spring JPA: Paging, Sorting, and Filtering

June 11, 2025

Java, JPA, SpringBoot
Spring JPA By Example: One-to-One, Many-to-One, and Many-to-Many

June 11, 2025

Java, JPA, SpringBoot
Learn Spring JPA By Example With Oracle Database Free

June 10, 2025

Java, JPA, SpringBoot
Migrate Apache Kafka applications to Oracle Database: Part III

June 9, 2025

Java, Kafka, TxEventQ
Migrate Apache Kafka applications to Oracle Database: Part II

June 6, 2025

Java, JSON, Kafka, TxEventQ
Chat with your database using Oracle Database Select AI

June 2, 2025

AI, OCI, PL/SQL
Dynamically load Spring properties from external repositories

May 29, 2025

Java, SpringBoot
Try Oracle Database for free in the cloud with OCI

May 29, 2025

OCI, oraclefree
Easily test Oracle Database applications with Testcontainers

May 29, 2025

Java, oraclefree, Testcontainers
JSON in Oracle Database: From 19c to 23ai

May 29, 2025

Duality Views, JSON
Migrate Apache Kafka applications to Oracle Database: Part I

May 28, 2025

Java, Kafka, TxEventQ
Database Metrics Exporter 2.0.0

May 28, 2025

Observability
Oracle Database Pub/Sub over REST

May 28, 2025

ORDS, TxEventQ

Subscribe

Enter your email below to receive updates.