Anders Swanson

Oracle JDBC Tracing with Spring Boot OpenTelemetry Oracle's JDBC Driver can export traces to an OpenTelemetry backend - let's walk through how to configure this with Spring Boot and Micrometer! Just looking for the code? Click Here. With OpenTelemetry tracing, you gain visibility into JDBC calls Oracle Database — making it easier to debug, optimize, and monitor your applications. We'll collect traces from JDBC calls, export traces to an OpenTelemetry (Zipkin) backend, and then view the traces online.

Oracle JDBC Tracing with Spring Boot OpenTelemetry

Oracle's JDBC Driver can export traces to an OpenTelemetry backend - let's walk through how to configure this with Spring Boot and Micrometer! Just looking for the code? Click Here. With OpenTelemetry tracing, you gain visibility into JDBC calls…

Tracing a Spring Boot JMS app with Oracle Database Free In this article, we'll use OpenTelemetry tracing to instrument a Spring JMS application with Oracle Database Free. Tracing allows developers to follow a request as it flows through distributed systems — in this case, from the producer to the consumer through Oracle Database Transactional Event Queues (TxEventQ). Tracing helps correlate slow consumers, lost messages, or queue bottlenecks to specific spans.

Tracing a Spring Boot JMS app with Oracle Database Free

In this article, we'll use OpenTelemetry tracing to instrument a Spring JMS application with Oracle Database Free. Tracing allows developers to follow a request as it flows through distributed systems — in this case, from the producer to the…

Monitor your Oracle Database(s) with OpenTelemetry In this article, we'll explore how Oracle Database fits into the modern, open-source, and cloud-native observability stack. What is OpenTelemetry? OpenTelemetry is an open-source observability framework that provides a standardized way to collect and process telemetry data, including traces, metrics, and logs: Standardizes across tools and vendors, allowing you to send data to any backend that supports OpenTelemetry. Supports modern architectures, where cloud-native microservices greatly benefit from consistent telemetry collection.

Monitor your Oracle Database(s) with OpenTelemetry

In this article, we'll explore how Oracle Database fits into the modern, open-source, and cloud-native observability stack. What is OpenTelemetry? OpenTelemetry is an open-source observability framework that provides a standardized way to collect…

Testing Go apps with Oracle Database using Testcontainers In this article, we'll walk through how to configure an Oracle Database Free container for go application tests using testcontainers-go. What is Testcontainers? Testcontainers for Oracle Database (go) Write a test for OracleContainer Run the test References What is Testcontainers? Testcontainers is a popular framework that lets you test applications against real, disposable containers. It helps ensure your tests run against realistic environments without requiring complex infrastructure setup.

Testing Go apps with Oracle Database using Testcontainers

In this article, we'll walk through how to configure an Oracle Database Free container for go application tests using testcontainers-go. What is Testcontainers? Testcontainers for Oracle Database (go) Write a test for OracleContainer Run…

YouTube video by Data Bites Migrate an Apache Kafka application to Oracle Database in 5 minutes

Migrate an Apache Kafka app to Oracle Database in 5 minutes.
youtu.be/LS12tcBNIdM?...

Consumers and message retention in database-driven event streaming

In this article, we’ll walk through the differences between push vs. pull messaging, queues and topics, and describe consumer groups in the context of Oracle Database Transactional Event Queues (TxEventQ). By the end of this…

Pub/Sub with a NodeJS Oracle Database App Did you know you can easily add pub/sub capabilities to your NodeJS/TypeScript app using Oracle Database? In this article, we'll implement a simple pub/sub TypeScript example using Oracle Database Transactional Event Queues (TxEventQ). If you're not familiar with TxEventQ or database-driven messaging, I recommend reading my article Pub/Sub in your DB. You’ll learn patterns you can use in any NodeJS/TypeScript app, making it easy to implement database-driven messaging between one or more distributed services.

Pub/Sub with a NodeJS Oracle Database App

Did you know you can easily add pub/sub capabilities to your NodeJS/TypeScript app using Oracle Database? In this article, we'll implement a simple pub/sub TypeScript example using Oracle Database Transactional Event Queues (TxEventQ). If you're not…

Pub/Sub in your DB? Oracle Database TxEventQ Pub/Sub in the Database? Yes — Here’s Why. In this article, we’ll discuss how to use your database for event streaming with Oracle Database Transactional Event Queues (TxEventQ), a built-in, database-native message broker. TxEventQ supports multiple consumers/producers, exactly-once messaging, partitioned queuing (key based and automatic), and strict ordering per message stream. TxEventQ is included in every Oracle Database version from…

Pub/Sub in your DB? Oracle Database TxEventQ

Pub/Sub in the Database? Yes — Here’s Why. In this article, we’ll discuss how to use your database for event streaming with Oracle Database Transactional Event Queues (TxEventQ), a built-in, database-native message broker. TxEventQ supports multiple…

Test your TypeScript/NodeJS apps with Oracle Database Free Testcontainers is a popular framework that lets you test applications against real, disposable containers. It helps ensure your tests run against realistic environments without requiring complex infrastructure setup. In this article, we'll use the GenericContainer class to implement an Oracle Database Free container for testing, experimentation, and POCs. Our implementation will use the testcontainers-nodejs SDK and the Oracle Database Free container image…

Test your TypeScript/NodeJS apps with Oracle Database Free

Testcontainers is a popular framework that lets you test applications against real, disposable containers. It helps ensure your tests run against realistic environments without requiring complex infrastructure setup. In this article, we'll…

Spring Boot + Oracle Database

In this article, we'll explore several Oracle Database integrations with Spring Boot from the Spring Cloud Oracle project. UCP DataSource over Hikari Oracle Wallet JMS Spring Cloud Stream Binder kafka-clients APIs JSON Collections Testcontainers with Oracle Database…

Transactional Outbox: Simplified with Oracle Database Event streaming is extremely popular in modern application architectures, providing high-throughput, real-time data flow in microservices architectures. However, ensuring data consistency in distributed systems is challenging — Traditional two-phase commit (2PC) implementations can be costly and slow, making them impractical for high-throughput environments. In this article, we’ll solve data consistency challenges in event streaming systems using Oracle Database Transactional Event Queues…

Transactional Outbox: Simplified with Oracle Database

Event streaming is extremely popular in modern application architectures, providing high-throughput, real-time data flow in microservices architectures. However, ensuring data consistency in distributed systems is challenging — Traditional…

Learn Testcontainers (Java) with Oracle Database Free Testcontainers is a popular testing library that enables developers to write tests against disposable, containerized instances of databases, message brokers, and other essential services — anything that can fit in a container. For database testing, Testcontainers integrates with Oracle Database Free, to offer a powerful, developer-focused solution to spin up real, isolated database instances directly within their tests, ensuring reliable and consistent environments.

Learn Testcontainers (Java) with Oracle Database Free

Testcontainers is a popular testing library that enables developers to write tests against disposable, containerized instances of databases, message brokers, and other essential services — anything that can fit in a container. For database…

Test Python Applications with Oracle Database Free using Testcontainers Testcontainers is a wildly popular library that provides developers with on-demand, disposable containers. When you build apps that use databases like Oracle, testing against a real instance instead of mocks or in-memory alternatives improves reliability and confidence in application behavior. In this article, we'll use the Testcontainers Python binding with Oracle Database Free to spin up disposable database containers - containers you can use for…

Test Python Applications with Oracle Database Free using Testcontainers

Testcontainers is a wildly popular library that provides developers with on-demand, disposable containers. When you build apps that use databases like Oracle, testing against a real instance instead of mocks or in-memory…

Multiple Views, One Schema: Simple RBAC with Duality Views In this article, we'll explore how JSON Relational Duality Views can be used to decompose a schema into subdomains - allowing role-based isolation of data to relevant services. If you'd like to follow along with this article, I recommend using Oracle Database Free. Unfamiliar with JSON Relational Duality Views? Read 7 Reasons to try out JSON Relational Duality Views, with samples…

Multiple Views, One Schema: Simple RBAC with Duality Views

In this article, we'll explore how JSON Relational Duality Views can be used to decompose a schema into subdomains - allowing role-based isolation of data to relevant services. If you'd like to follow along with this article, I recommend…

10 Modern Database Features To Start Using Today Relational databases have evolved. Modern multi-model databases go beyond tables, rows, and columns to become full-featured data platforms for application development. In this article, we'll explore 10 modern Oracle Database features that help build simple, robust data-driven applications. Event Streaming JSON Document Data Multitenant Architecture Database as Cache Automatic REST APIs AI Vector Search Geospatial and Graph In-Database JavaScript Observability and Monitoring…

10 Modern Database Features To Start Using Today

Relational databases have evolved. Modern multi-model databases go beyond tables, rows, and columns to become full-featured data platforms for application development. In this article, we'll explore 10 modern Oracle Database features that help build…

Virtual, Materialized, and @generated columns In this article, we'll explore virtual and materialized columns and @generated fields in JSON Relational Duality Views. Why use computed columns at all? Indexing Query simplification Human error Types of computed columns Virtual Columns Materialized Columns And now, @generated When to use each type of computed column? References Why use computed columns at all? I've always computed values in a query, so what's the point?

Virtual, Materialized, and @generated columns

In this article, we'll explore virtual and materialized columns and @generated fields in JSON Relational Duality Views. Why use computed columns at all? Indexing Query simplification Human error Types of computed columns Virtual Columns Materialized…

Using a modern database? You might not need that ORM anymore Object Relational Mapping (ORM) frameworks translate programming objects to SQL statements. ORM implementations are found in most programming languages, and frameworks like Hibernate and Prisma are extremely popular among developers for their ease of use and abstraction of common SQL queries. I've used ORMs in many production-grade systems over the years, and I will likely continue to do so. However, sometimes ORMs won't be my first choice for data access and management.

Using a modern database? You might not need that ORM anymore

Object Relational Mapping (ORM) frameworks translate programming objects to SQL statements. ORM implementations are found in most programming languages, and frameworks like Hibernate and Prisma are extremely popular among developers for…

Lock-Free Writes at Scale: Under the Hood of Duality Views In this article, we'll explore Lock-Free Concurrency, a form of optimistic concurrency control. We'll see how lock-free concurrency control synchronizes document writes with JSON Relational Duality Views, allowing multiple concurrent requests to safely work with the same data. If you're new to duality views, read my article 7 Reasons to try out JSON Relational Duality Views, with samples for a quick primer.

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

In this article, we'll explore Lock-Free Concurrency, a form of optimistic concurrency control. We'll see how lock-free concurrency control synchronizes document writes with JSON Relational Duality Views, allowing multiple concurrent…

GraphQL syntax for JSON Relational Duality Views Working with JSON Relational Duality Views, you can use the SQL or GraphQL DDL syntax. I like the GraphQL format for its simple, expressive syntax: in this article, we'll explore using GraphQL to define for JSON Relational Duality Views through examples. If you'd like to follow along with the article, spin up an instance of Oracle Database Free…

GraphQL syntax for JSON Relational Duality Views

Working with JSON Relational Duality Views, you can use the SQL or GraphQL DDL syntax. I like the GraphQL format for its simple, expressive syntax: in this article, we'll explore using GraphQL to define for JSON Relational Duality Views through…

How to run x86 containers on ARM (like Oracle Database adb-free) Sometimes you have an ARM chip, but the container image you want to use is only runs on x86 processors. I have a MacBook Pro (M-series, ARM architecture), but I also like running the Oracle Database adb-free container image. This is an awesome image for testing Oracle Database, because it includes most features of Oracle Autonomous Databas and bundles…

How to run x86 containers on ARM (like Oracle Database adb-free)

Sometimes you have an ARM chip, but the container image you want to use is only runs on x86 processors. I have a MacBook Pro (M-series, ARM architecture), but I also like running the Oracle Database adb-free container image. This is…

Let’s talk about Model Context Protocol (MCP) First, let's talk about LLVM, the modular and reusable compiler toolchain: With LLVM as a compiler backend, we write code in the language of our choice, and compile it to any number of supported backend architectures. “develop a frontend for any programming language and a backend for any instruction set architecture.” LLVM's extensible architecture lets us compile code (using Clang, Rustc, etc.) from any supported language to…

Let’s talk about Model Context Protocol (MCP)

First, let's talk about LLVM, the modular and reusable compiler toolchain: With LLVM as a compiler backend, we write code in the language of our choice, and compile it to any number of supported backend architectures. “develop a frontend for any…

Many-to-many data modelling with JSON Relational Duality Views Oracle Database JSON Relational Duality Views are a powerful tool that combines the functionality of document databases and relational schemas. With duality views, you model data in normalized tables, and access it as clean, composable JSON documents: perfect for REST APIs, SQL queries, or even wire-compatible MongoDB access. In this article, we'll explore data modelling of many-to-many relationships…

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

Oracle Database JSON Relational Duality Views are a powerful tool that combines the functionality of document databases and relational schemas. With duality views, you model data in normalized tables, and access it as clean, composable…

Simple RESTful services with ORDS: Duality Views In this article, we'll create a RESTful webservice that can GET/POST/PUT/DELETE relational JSON documents. The best part? We'll use just a few lines of PL/SQL and zero lines of backend code to implement our REST API with Oracle REST Data Services (ORDS) "Auto REST". New to creating RESTful services with ORDS? Check out my previous post and learn how to create a CRUD service for an Oracle Database table with a few lines of PL/SQL.

Simple RESTful services with ORDS: Duality Views

In this article, we'll create a RESTful webservice that can GET/POST/PUT/DELETE relational JSON documents. The best part? We'll use just a few lines of PL/SQL and zero lines of backend code to implement our REST API with Oracle REST Data Services…

Simple RESTful services with ORDS Oracle REST Data Services (ORDS) is free-to-use Java EE server that extends that capabilities of Oracle Database with RESTful services. With ORDS, you get out-of-the-box functionality for your database instance: Database management REST APIs SQL Developer (web) Wire-compatible MongoDB API Extensible REST APIs for your data Security features like OAuth 2.0 support for custom IDPs, JWTs, and more. In this article, we'll explore ORDS' "

Simple RESTful services with ORDS

Oracle REST Data Services (ORDS) is free-to-use Java EE server that extends that capabilities of Oracle Database with RESTful services. With ORDS, you get out-of-the-box functionality for your database instance: Database management REST APIs SQL Developer (web)…

One Database. Any Data. Any Workload.

Oracle Database handles relational, JSON, vectors, and more—from a single, converged database engine.

Try it out yourself, with Oracle Database Free:
- container database: lnkd.in/dUtrjpXN
- with Testcontainers: lnkd.in/gCGzufrd
- Demo App: lnkd.in/g5digBVS

Intro to Vector Databases Vector databases provide new ways to store and query unstructured data by enabling powerful, AI-driven search capabilities. Unlike…

Curious about AI Vector search but not sure where to begin? Let’s break it down! Check out my intro article on Vector Databases 🎓

📖 Learn the Basics:
👉 Intro to Vector Databases: lnkd.in/gYMqShaS

YouTube video by TheConvergedDatabase Feature of the Week: Transactional Event Queues Kafka Connectors and Spring Boot Integration

Short video highlighting Kafka Connectors and Spring Integration with Oracle Database Transactional Event Queues (TxEventQ)

If you're not familiar, TxEventQ enables queuing and event streaming with topics in Oracle Database.

www.youtube.com/watch?v=D7A-...

Oracle Database Transactional Event Queues: Spring + Kafka Integrations In this article, we’ll cover three important features of Oracle Database Transactional Event Queues — Kafka Connectors, the Spring Cloud Stream Binder, and Spring JMS. These features enable applicatio...

Oracle Database Feature Highlight: Kafka Connectors, Spring Cloud Stream Binder, and Spring JMS with Transactional Event Queues

medium.com/@anders.swan...

Less-well-known features of Multilingual Engine: Document API Many developers like the simplicity and flexibility provided by specialised document databases. These systems offer a lot of freedom when it comes to writing applications. If you don’t like S…

Modern IT gives developers the freedom to choose their tech. Whether it's SQL, NoSQL, or a document API, modern databases offer flexibility. For instance, JavaScript developers can easily use a document API in Oracle Database 23ai. Check out this guide for more: martincarstenbach.com/2025/02/07/l...

Spring Boot + Oracle Transactional Event Queues (TxEventQ) Producer and Consumer Example

Andy Tael demonstrates how to produce and consume messages with Spring JMS and Oracle Database Transactional Event Queues (TxEventQ) 🚀

TxEventQ integrates with the idiomatic Spring JMS APIan, enabling developers to use Oracle Database as a messaging system.

medium.com/@andytael/sp...