AI Briefing#database
The latest AI and developer news about #database, with the original source and a short summary.
The latest AI and developer news about #database, with the original source and a short summary.
Benchmarks illustrate where file-based storage alone is enough and where the line for actually needing a DB gets drawn.
A benchmark comparison of read performance across files, memory, SQLite, and indexes.
Shows the working directory and DB path of currently running Datasette instances.
A Datomic-compatible Clojure Datalog DB that lets you freely query past states.
The story of building a custom linter that catches DB calls escaping Go transaction boundaries.
Query and edit Marketplace Postgres DBs with SQL directly in the Vercel dashboard.
QA directly cut off DB, cache, and queue connections to verify customer experience and post-recovery data consistency.
A developer's journey of growth from DB and security to AI, built on reasonable choices rather than right answers.
Ilhaera Kim Bangsael maintained consistency with optimistic locking based on update_version.
Yogiyo built a DDL review bot with Amazon Bedrock, improving review speed by about 20%.
A roundup of Amazon Science's 10 most-viewed blog posts of 2025, organized by topic.
Write throughput improved by up to 47%, support period extended to 5 years, and minor release support introduced for on-premises environments.
In Aurora, DELETE alone doesn't reduce storage, so Snapshot & Restore was needed.
This analyzes the differences and characteristics between MySQL's DATETIME and TIMESTAMP data types.
Kakao has established an Orchestrator-based HA standard to replace MHA through R&D efforts since 2023.
When storing identical JSON data, the TEXT type uses 25 bytes, while the JSON type uses 35 bytes including metadata.
There are conditions where it cannot be used, such as the maximum limit of 64 for ROW_VERSION and the presence of FTS indexes.
This document analyzes the lifecycle of MTR (Mini-Transaction) creation and commit within the InnoDB Redo Log of MySQL 5.7, as well as the concurrency control mechanism via Mutex when recording to the Redo Log Buffer.
It covers TTL settings, Big Key prevention, and how to use data types for memory management and performance optimization when operating Redis.
Replit separates development and production databases to provide a safer app development and deployment environment.
Support for mysql_native_password is discontinued in MySQL 9.0, making the transition to caching_sha2_password and preparation for SSL/RSA connections essential.
This analysis compares the operational principles of MySQL's Copy, In-Place, and Instant ALTER DDL algorithms and their Metadata Lock acquisition patterns.
At AWS re:Invent 2024, Aurora DSQL with unlimited scalability and Apache Iceberg-based S3 Tables were unveiled.
The OMS team built a nationwide building DB of about 10.78 million records using the Ministry of the Interior and Safety's navigation DB and improved the delivery cache structure.