Skip to main content
← All Tags

Database Engineering

6 articles in this category

AI NewsDatabase EngineeringSoftware Architecture

Round-Trip Database Engineering: Reverse Engineering Schemas into Editable Diagrams

SchemaCrawler enables a full round-trip workflow by exporting JDBC databases into DBML, PlantUML, Mermaid, and QuickDBD for iterative design.

Read more
AI NewsWeb DevelopmentDatabase Engineering

Resolving the Supabase Dual-DB Conflict in Lovable AI Workflows

Prevent production data loss by navigating the invisible boundary between test and live database environments in Lovable and Supabase integrations.

Read more
AI NewsDatabase EngineeringData Science

Advanced SQL Techniques: Mastering Window Functions and Common Table Expressions

Learn how to perform complex row-level calculations and improve query readability using SQL window functions and CTEs for data analytics.

Read more
AI NewsDatabase EngineeringSoftware Architecture

Legacy Application Audit Reveals Manual ID Generation and Zero Database Indexes

An investigation into a failing legacy application uncovered a 9,000-line function and a database with zero indexes, necessitating a total system rewrite.

Read more
AI NewsSystem DesignDatabase Engineering

Mastering Database Sharding: Architecting Scalable Distributed Systems for Billions of Records

Database sharding enables distributed systems to handle billions of records by partitioning data across independent nodes for horizontal scalability.

Read more
AI NewsPostgreSQLDatabase Engineering

PostgreSQL Merge Into Equivalent for Conditional Updates

PostgreSQL's MERGE INTO equivalent updates invoice data via subquery join, avoiding full table scans.

Read more