Oracle Database 23ai Adds Native JSON Schema Validation for Enterprises

·6 views

Oracle Database 23ai introduces native support for JSON Schema (draft 2020-12), enabling organizations to define, register, and enforce structural rules on JSON data directly at the database layer. The feature uses a new PL/SQL package, DBMS_JSON_SCHEMA, which allows developers to register schema definitions and link them to specific JSON columns or tables. Any JSON data that violates a registered schema is automatically rejected by the database, eliminating the need for custom validation logic in application code. This capability is available on Oracle Database 23ai running on AWS RDS, provided the appropriate role privileges and the JSON_SCHEMA package are configured. The addition is expected to benefit data-intensive industries such as financial services, where consistent data governance and regulatory compliance are critical requirements.

Read the full story at DEV Community

This is an AI-generated summary. ShortSingh links to the original source for the complete article.

Discussion (0)

Vendor's 200x Speed Claim Shrinks to 3–12x Under Real Workload Testing

A software team tested TypeSafe AI's model 'Jev' against their existing open model using a real production task: classifying email accounts on an admin dashboard. End-to-end, the new model proved 12x faster at the median, narrowing to roughly 3x once accounting for unnecessary output from the old model, and 7x cheaper — primarily because outbound tokens are free on the new platform. The team admits they produced two confident but incorrect benchmark figures before arriving at valid results, including repeating the very measurement error they had previously criticized the vendor for. The most meaningful finding was not speed but consistency: the new model showed just 38ms of latency variance compared to 2,353ms on the old one, eliminating parse failures that had been causing error pages. The team concludes that benchmarks are only useful when run on your own workload, close to production, with a reliable correctness check that does not rely on another model's judgment.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Why yfinance Fails at Scale and How to Build Reliable Options Data Pipelines

Fetching stock prices in Python is straightforward, but retrieving full options chain data — including strikes, implied volatility, open interest, and volume — reliably across hundreds of tickers is a significantly harder engineering challenge. Libraries like yfinance work well for small-scale exploration but are prone to rate-limit errors, empty responses, and silent failures when used in production environments. These tools act as convenience wrappers rather than true data pipelines, leaving developers to handle retries, schema normalization, and monitoring themselves. A structured approach involves defining a consistent per-contract data schema and building a dedicated data layer that handles throttling, scheduling, and error recovery. Separating the data infrastructure from the trading or analytics logic allows developers to focus on strategy rather than repeatedly fixing broken data feeds.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Read Replicas Boost Database Speed but Can Serve Stale Data to Users

Adding a read replica to a database offloads traffic from the primary server and improves read performance, but introduces replication lag that can range from milliseconds to minutes. During this lag window, users may see outdated information — such as a profile update not reflecting immediately or an order status showing as pending after payment. This occurs because replicas apply changes only after they have committed on the primary, a behavior known as a read-after-write violation. Replication lag is not a fixed, predictable value; it varies based on write load, long-running queries, large transactions, and maintenance activity. Engineers are advised to route consistency-sensitive reads — such as balance checks, order status, and post-write fetches — directly to the primary rather than treating all reads as safe to serve from a replica.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Joxo Syncs AI Coding Agents Across Laptops to Share Decisions in Real Time

Joxo is a tool designed to solve a common problem in multi-developer teams where different AI coding agents — such as Claude Code, Codex, and Cursor — repeatedly make the same architectural decisions because they lack shared context. The platform works by writing configuration files directly into each agent's own hook system, so decisions, handoffs, blockers, and task updates are delivered to an agent exactly when needed rather than requiring manual pulls. Each machine runs a local MCP server that connects to a shared relay storing only coordination data — not prompts, transcripts, or the repository itself. When a new teammate joins mid-session, their agent receives all prior decisions at the start of their first turn, and handoff packages include branch and commit references that the receiving agent verifies before proceeding. Joxo supports 28 agents, requires no API keys, runs on users' existing subscriptions, and is priced at $15 per person per month after a free trial.

0 comments Read more at DEV Community