Welcome to the August edition of Monthly Product Pulse, your monthly round-up of the latest technical resources from Oracle product teams. This month’s highlights include AI development tutorials, Oracle APEX community opportunities, new Oracle Spatial capabilities, Oracle MicroTx updates, and the latest MySQL technical content.
Whether you’re building AI-powered applications, modernizing databases, or expanding your Oracle expertise, these resources will help you stay informed and productive.
Oracle APEX & Oracle Dev Gym
* SQL Keyword Search Puzzle
Put your SQL knowledge to the test with the latest Oracle Dev Gym challenge. See if you can find all the SQL keywords hidden in the puzzle. Try the puzzle.
* If you are an Oracle ACE, you can become a speaker for the Oracle APEX Community
The Oracle APEX product team is looking for community members to present during its live technical series:
- APEX Office Hours (Portuguese)
- APEX Office Hours (Spanish)
- APEX ACE Masters (English)
If you’d like to share your experience with Oracle APEX 26.1, APEXlang, or another Oracle APEX topic, email karina.pastor@oracle.com to express your interest.
You can also explore recordings from previous sessions:
APEX Office Hours: Portuguese | Spanish | English
Java & Oracle AI Database
* From Stateless Prompts to Durable AI Conversations with LangChain4J
Discover how to persist chat memory in LangChain4J applications using the OracleChatMemoryStore extension and Oracle AI Database 26ai. This article demonstrates how Java developers can build AI assistants, support bots, coding agents, and troubleshooting applications that maintain conversation history across sessions, restarts, and deployments.
* Build AI Vector Search Applications in Kotlin
Learn how to build a Kotlin-based AI vector search REST application using Micronaut, JetBrains Exposed, Oracle JDBC, Oracle Universal Connection Pool (UCP), and Oracle AI Database 26ai. The tutorial demonstrates semantic search techniques, including cosine similarity, Euclidean distance, and dot-product ranking, providing a practical foundation for building RAG applications, recommendation engines, duplicate detection, and similarity search services.
Oracle Spatial
* Oracle Spatial Adds Spatiotemporal Indexing
Oracle Spatial now supports enhanced CBTREE indexing for spatiotemporal workloads. The enhancement allows a single domain index to combine point geometry with timestamp, date, and other scalar fields, enabling Oracle Database to optimize both spatial and non-spatial predicates together.
This capability benefits applications such as fleet tracking, threat monitoring, wildfire management, and other location-aware analytics.
Learn more: Creating a Composite B-tree Spatial Index on Points (see the Using FILTER BY with CBTREE Spatial Indexes section of the Oracle documentation).
Oracle MicroTx
* Build More Durable Enterprise Workflows
Learn how Oracle MicroTx Workflows enables durable workflow execution for enterprise applications, helping developers build resilient, long-running business processes.
* Oracle MicroTx Free Now Available
Oracle MicroTx Free is now available in the Oracle Cloud Marketplace, making it easy to explore the service and start building cloud-native applications with MicroTx.
MySQL
This month brings new technical content covering query optimization, Kubernetes operations, community activities, and on-demand conference sessions.
* Smarter Join Planning with the Hypergraph Optimizer
Learn how the Hypergraph Optimizer in MySQL 9.7 Community Edition improves join planning and query optimization for complex SQL workloads.
* MySQL on Oracle Kubernetes Engine
Explore how database operations can be managed as Kubernetes state when running MySQL on Oracle Kubernetes Engine (OKE).
* MySQL Community Conversations Across JAPAC
Read about recent MySQL community events across Tokyo, Seoul, and Taipei, highlighting technical sessions and community engagement throughout the JAPAC region.
* Watch the MySQL Contributor Summit On Demand
Missed the May 2026 MySQL Contributor Summit? All sessions are now available to watch on demand.
Stay Connected
We hope these resources help you discover new technologies, sharpen your skills, and stay current with Oracle’s latest technical innovations. Be sure to check back next month for another edition of Monthly Product Pulse featuring fresh tutorials, product updates, and community resources from Oracle product teams.