Meta engineering migrated a petabyte-scale MySQL data ingestion platform to a centralized, self-managed warehouse service, using reverse shadowing and continuous checksum monitoring to achieve zero do…
A developer scanned Dub's open-source codebase using a CLI tool and discovered it is not a simple link shortener but an affiliate management platform with fraud detection, AI-generated landing pages, …
Brave CMS is an open-source content management system built with Laravel, MySQL, and Bootstrap 5, designed to offer developers a clean, extensible foundation for websites, blogs, and online newspapers…
This article explains how to build a custom database connection framework for ASP.NET minimal APIs using ADO.NET and SQLite, replacing Entity Framework to gain full control over SQL queries. The autho…
The article explains that a data model, which defines what a system remembers, must be designed before creating diagrams like flowcharts, as diagrams without data context are vague. It uses the exampl…
The article describes a team's failed attempt to scale a treasure hunt engine by adding more MySQL instances behind a load balancer within a single AWS availability zone, which led to disk I/O and CPU…
This article provides a tutorial on building a semantic search API in Go using the Fiber web framework and Meilisearch, a typo-tolerant search engine. The architecture includes filter support, configu…
This article, part 14 of a 15-part Apache Iceberg Masterclass, provides a practical walkthrough of using Iceberg with Dremio Cloud, covering table creation, data ingestion, and optimization. It highli…
This article explains that database maintenance should be triggered by workload signals rather than fixed schedules, as scheduled maintenance often misses tables that need it most and leads to product…
The article explains that SQLite is an embedded database engine stored in a single `.db` file, unlike client-server databases like MySQL. It introduces TinySqlite, a 740-line C++23 project that reads …
Bintrail is a new open-source tool that enables time-travel queries and row-history lookups in MySQL by indexing binary logs and routing queries through ProxySQL, without requiring any modifications t…
TiDB SCaiLE Europe 2026 will take place on June 4, 2026, at Epicenter Stockholm, bringing together engineers and technical leaders to address database infrastructure challenges posed by agentic AI. Th…
The article discusses the history and current state of MySQL, noting its decline in popularity after Oracle's acquisition but arguing it may be due for a renaissance. Despite PostgreSQL becoming the d…
Bun 1.3 is a major update that transforms Bun into a full-stack JavaScript runtime with built-in frontend development support, including hot reloading, React Fast Refresh, and a production bundler. Th…
This article provides a step-by-step guide for migrating a Pterodactyl game panel and Wings daemon to a new server. The process involves backing up the `.env` file and database, reinstalling the panel…
This article provides a PowerShell script to repair the MySQL data directory in XAMPP by backing up the existing data folder, creating a new one from a backup, and then selectively copying user databa…