proomt

Search

Search posts, papers, and topics

All posts

InfoQSergio De Simone2 min readrelease notesintermediate

MariaDB 13 Expands Oracle Compatibility and Improves Developer Experience and Observability

Read on infoq.com

Summary

MariaDB 13 GA adds Oracle‑compatible REF CURSOR and RECORD types, a RETURNING clause for UPDATE, and richer optimizer hint handling. It also exposes replication role and index options via system tables for better observability.

  • REF CURSOR (weak/strong) and RECORD can now be used in package routine parameters and function returns, easing Oracle PL/SQL migration.
  • UPDATE statements support RETURNING, letting apps fetch old and new values in one round‑trip with OLD_VALUE().
  • Optimizer hint framework auto‑assigns query block names to Views/CTEs/derived tables, and QB_NAME locators target deep nested blocks.
  • init_rpl_role is exposed as a system variable; I_S.STATISTICS and I_S.COLUMNS now include CREATE_OPTIONS; I_S.SYSTEM_VARIABLES shows deprecation flags.

DBAs and developers moving Oracle workloads to MariaDB, or needing tighter observability, will benefit from the new compatibility and admin features.

6/10
observabilityperformancedatabasessqlmariadboracle compatibility

Related reading

  1. pgAssistant 3.8.0 : continuous improvement loop for Postgres

    pgAssistant 3.8.0 expands from a tuning advisor to a continuous PostgreSQL improvement platform, adding a Collector that records historical workload and environment data. It lets teams run an Observe‑Diagnose‑Prioritize‑Plan‑Implement‑Measure loop, compare consecutive snapshots, and measure the impact of applied recommendations.

    PostgreSQLpostgresql.org1 minrelease

  2. JDK 27 has been released

    JDK 27 became GA on 15 Sep 2026 with binaries from Oracle. It ships default G1 GC, post‑quantum TLS key exchange, default compact object headers, and several preview features such as structured concurrency and lazy constants.

    Lobstersopenjdk.org1 minreleaseHN41lobste.rs37

  3. Announcing Native BM25 Ranking in AlloyDB and Cloud SQL

    Google Cloud adds native BM25 ranking to AlloyDB and Cloud SQL (PostgreSQL 17+) via the open‑source pg_textsearch extension, letting you run keyword‑based full‑text search inside the database. This removes the need for a separate search backend and, on AlloyDB, speeds up vector queries up to 10×.

    Google Cloud Bloggoogle.com2 min

  4. "Regex for Rows": Simplifying Pattern Detection in SQL with MATCH_RECOGNIZE

    Databricks announces MATCH_RECOGNIZE, a preview‑only SQL clause that lets you write regex‑style patterns over ordered rows. The post walks through four industry‑level use cases (security login‑failure sequences, V‑shaped stock trends, e‑commerce cart abandonment, IoT sensor‑driven failure prediction) and claims the operator replaces complex CTEs, window functions, and self‑joins. No actual syntax…

    Databricksdatabricks.com5 min

  5. What's new in ClickStack - Aug ’26

    ClickStack August 2026 update adds general‑availability dashboard variables (including cross‑source SQL, Lucene, PromQL macros), chart formulas for derived metrics, a metrics explorer UI, release‑marker overlays, OIDC auth for the collector, and a beta LLM observability dashboard. It also introduces a private‑preview TimeSeries engine with PromQL support, letting ClickStack store and query Promet…

    ClickHouseclickhouse.com16 min

  6. Reflect, Revise, Reuse: Training-Free Skill Evolution for GUI Agents

    EvoSkill‑GUI lets GUI agents revise their procedural skills on‑the‑fly without extra training by using a reflect‑revise‑reuse loop that edits skill packages during execution. The approach yields up to +16.2% improvement on MobileWorld and similar gains on AndroidWorld and OSWorld, and the evolved skills transfer to related tasks.

    Hugging Face Daily Papersarxiv.org1 minpaper