Best of Database — June 2025

1. 1
   Article

   Tech World With Milan·48w

   What I learned from the book Designing Data-Intensive Applications

   A comprehensive review of Martin Kleppmann's "Designing Data-Intensive Applications" after two complete readings. The book provides foundational knowledge about distributed systems, covering reliability, scalability, and maintainability principles. Key topics include data models (relational vs document vs graph), storage engines (B-trees vs LSM-trees), replication strategies, partitioning, transactions, and stream processing. The review highlights the book's strengths in explaining trade-offs and connecting theory to practice, while noting limitations like outdated examples and dense theoretical content. Recommended for experienced engineers working with data-intensive systems.

   250

   6
2. 2
   Article

   Community Picks·49w

   Database Multi tenancy

   Multi-tenancy is an architecture where multiple independent application instances operate in a shared environment with logical isolation. The article explores four database multi-tenancy approaches: single database with shared schema (lowest cost, highest tenant density but minimal isolation), single database with separate schemas (better isolation, more complex maintenance), database per tenant (highest isolation, most resource intensive), and multiple databases with shared schemas (balanced approach). Each pattern has distinct trade-offs between cost, isolation, maintenance complexity, and scalability that should guide architectural decisions based on application requirements.

   150

   2
3. 3
   Article

   Medium·47w

   The 5 Most Surprising, Ingenious Data Structures and What They Actually Do

   Explores five advanced data structures that solve complex problems beyond basic arrays and lists: B-Trees for efficient database storage with shallow depth, Radix Trees for fast prefix-based lookups in routing, Ropes for efficient text editing in large documents, Bloom Filters for probabilistic membership testing at scale, and Cuckoo Hashing for constant-time operations using eviction strategies. Each structure addresses specific performance challenges in real-world systems.

   89

   1
4. 4
   Article

   Data Engineer Things·49w

   I Stopped Using SQL for Database Management. Because I use the MCP Server with GitHub Copilot in VS Code

   A developer demonstrates how to replace traditional SQL database management with AI-powered tools by using GitHub Copilot and GibsonAI's MCP server in VS Code. The approach allows creating complete database schemas, deploying serverless databases, and generating CRUD APIs through simple prompts, eliminating manual schema design and boilerplate code. The tutorial shows building a travel agency database schema in under 60 seconds using natural language descriptions.

   85

   6
5. 5
   Video

   Awesome·50w

   I built my own Redis in Go and it was too easy...

   A developer builds a custom in-memory database in Go as an alternative to Redis, implementing core features like TCP server with goroutines, command parsing for basic operations (set, get, delete), data persistence through file logging, pub/sub messaging using Go channels, and key expiration with background cleanup routines. The project demonstrates how Go's concurrency features make building database-like systems surprisingly straightforward.

   85

   3
6. 6
   Video

   Laravel Daily·50w

   3 Tools to Draw/Manage Database Schema

   Three visual database design tools are showcased for Laravel developers: DrawDB for drag-and-drop visual schema creation, DBDiagram.io for code-based DBML syntax with version control benefits, and RunSQL for testing queries on mock data. The workflow demonstrates using AI to generate database schemas, visualizing relationships, and converting designs to Laravel migrations without writing initial code.

   76
7. 7
   Video

   YouTube·49w

   Obsidian Bases Just Changed Everything

   Obsidian introduces Bases, a new core plugin that transforms notes into powerful databases with filtering and organization capabilities. The feature offers three key advantages: exceptional speed when handling thousands of notes, multiple views per base similar to Airtable, and embeddable views that can be inserted into other notes. Users can filter notes by properties, create custom columns, and organize information like quotes, projects, or recently modified files. While promising for data analysis and retrieval, the feature requires comfort with Obsidian properties and may shift focus from organic note-linking to structured database thinking. Currently in early access for Catalyst license holders, Bases represents a significant evolution in Obsidian's note management capabilities.

   68

   3
8. 8
   Article

   habr·48w

   What May Surprise You About UUIDv7

   UUIDv7 is a 128-bit identifier inspired by ULID that combines timestamps with random data, offering superior performance and functionality compared to traditional auto-increment IDs and other identifier types. Key advantages include cryptographically secure generation, monotonicity guarantees, equivalent performance to bigint while eliminating key collision issues, and the ability to hide creation timestamps through offset options. The format supports various implementation strategies across databases like PostgreSQL and ClickHouse, with optimal storage achieved through binary format rather than string representation.

   61

   1
9. 9
   Article

   Baeldung·47w

   Introduction to DiceDB

   DiceDB is an open-source, high-performance in-memory database that offers Redis-like commands with modern features such as reactive queries. The tutorial covers installation via Docker, connecting through the DiceDB CLI, and performing basic operations like SET, GET, DEL, PING, ECHO, TYPE, and EXISTS commands. DiceDB runs on port 7379 by default and provides a developer-friendly experience for real-time applications with familiar key-value operations.

   48

   1
10. 10
    Article

    Community Picks·49w

    The ultimate ORM for Node and Typescript

    Orange ORM is a comprehensive Object Relational Mapper supporting Node.js, Bun, and Deno with TypeScript and JavaScript compatibility. It provides seamless integration with multiple databases including PostgreSQL, MySQL, SQLite, MS SQL, Oracle, and Cloudflare D1. The ORM features a fluent mapping syntax for defining table relationships, powerful filtering capabilities, transaction support, and browser compatibility through Express middleware. Key features include automatic type generation, conflict resolution strategies, cascade operations, and support for complex queries with aggregations and joins.

    45

    8
11. 11
    Article

    Programming Digest·47w

    Everything I know about good system design

    System design is about assembling services using primitives like databases, caches, and queues. Good design looks underwhelming and focuses on minimizing stateful components, using databases effectively with proper indexing, handling slow operations through background jobs, implementing strategic caching, and designing for failure with retries and circuit breakers. The key is using boring, well-tested components correctly rather than clever tricks.

    43
12. 12
    Article

    DuckDB·50w

    Faster Dashboards with Multi-Column Approximate Sorting

    Advanced multi-column sorting techniques using space filling curves (Morton and Hilbert encodings) and truncated timestamps can significantly improve query performance on columnar data formats. These methods enable approximate sorting across multiple columns simultaneously, allowing diverse dashboard queries to benefit from min-max indexes and row group pruning. Experiments on flight data show Hilbert encoding provides the most consistent performance across different query patterns, while sorting by truncated timestamps (year-level granularity) combined with Hilbert encoding works best for time-filtered queries.

    42
13. 13
    Article

    AppSignal·49w

    Using SQL in Node.js with Sequelize

    A comprehensive guide to integrating Sequelize ORM with Node.js applications for PostgreSQL database operations. Covers setting up database connections, defining models, and implementing complete CRUD functionality through a practical blog post management system. Includes Docker setup for PostgreSQL, model synchronization, pagination considerations, and best practices for production environments.

    39

    1
14. 14
    Article

    Community Picks·48w

    Database Schema Design Patterns for Building Scalable E-commerce Applications

    Essential database schema design patterns for e-commerce applications using SQLAlchemy. Covers relational modeling patterns including one-to-many and many-to-many relationships, hierarchical data structures like adjacency lists and path enumeration, temporal data patterns for versioning and audit trails, embedding vs referencing strategies, and polymorphic associations. Emphasizes normalization principles, data integrity constraints, and designing schemas that support both current requirements and future evolution.

    35

    2
15. 15
    Article

    Awesome Go·49w

    Best Database Migration Tools for Golang

    A comprehensive guide comparing five database migration tools for Go applications: Goose (lightweight and SQL-focused), Migrate (CLI-first with broad database support), Gormigrate (GORM-integrated), SQLx (custom migration workflows), and Flyway (enterprise-grade). Each tool is explained with practical code examples, use cases, and a comparison table to help developers choose based on project size, team needs, and database requirements. The guide includes best practices for versioning, testing, and implementing transactional migrations.

    35
16. 16
    Article

    InfoQ·49w

    Rust: A Productive Language for Writing Database Applications

    Carl Lerche argues that Rust can be productive for building higher-level applications like web apps and database-backed services, not just systems programming. He discusses how Rust's quality benefits translate to long-term productivity gains through reduced bugs and maintenance overhead. The talk covers practical tips for using Rust effectively, including preferring enums over traits, leveraging procedural macros, and proper error handling strategies. Lerche also introduces Toasty, his work-in-progress ORM designed for ease of use, and addresses common challenges like the learning curve and ecosystem maturity.

    34

    3
17. 17
    Article

    Go Developers·49w

    Building Real-World Go RESTful APIs with gorest: A Practical Approach for Modern Developers

    gorest is a production-ready Go starter kit that simplifies building secure RESTful APIs by providing multi-database support, flexible authentication (Basic Auth, JWT, 2FA), security features like CORS and rate limiting, and a modular architecture. It addresses common pain points in Go API development by offering comprehensive tooling beyond basic routing frameworks, including auto migrations, graceful shutdown, and practical examples for real-world CRUD operations.

    33
18. 18
    Article

    Collections·49w

    Introducing the PostgreSQL Extension for VS Code

    Microsoft released a comprehensive PostgreSQL extension for Visual Studio Code that brings database management capabilities directly into the IDE. The extension features schema visualization, natural language database queries through GitHub Copilot integration, migration script generation, SQL IntelliSense, local Docker server creation, connection management, and query history tracking. This tool aims to replace traditional database management applications by providing a unified development environment for PostgreSQL workflows.

    32
19. 19
    Article

    Laravel News·47w

    Defining a Dedicated Query Builder in Laravel 12 With PHP Attributes

    Laravel 12.19 introduces the UseEloquentBuilder PHP attribute as a cleaner way to define custom query builders for Eloquent models. Instead of overriding the newEloquentBuilder() method, developers can now use this attribute to specify a custom builder class. Custom query builders help organize model scopes, reduce model bloat, and provide reusable query methods. The custom builder class must extend Laravel's Builder class and can include methods like wherePublished() for common query patterns.

    30

    2
20. 20
    Article

    Redis·48w

    Redis to Manage Storage Replication

    A freelancer shares how Redis transformed their file system replication architecture by replacing a complex SQL-based solution with Redis pub/sub messaging. The new approach eliminated scheduled batch jobs in favor of real-time replication, reduced operational overhead, and leveraged Redis data structures for analytics. The case study demonstrates Redis's versatility beyond caching, showing its effectiveness for messaging, data storage, and system coordination.

    25

    2
21. 21
    Video

    ThePrimeTime·48w

    Programming From Prison

    A software engineer currently incarcerated has been hired full-time by Turso to work on their Limbo database project, a Rust rewrite of SQLite. Through a prison remote work program, he contributed extensively to open source projects, spending 90+ hours per week programming and eventually becoming a top contributor to Limbo. His journey from drug-related charges to landing a dream job demonstrates how dedication, hard work, and rehabilitation programs can create second chances in tech careers.

    24
22. 22
    Article

    Community Picks·50w

    ClickStack: High-Performance Open-Source Observability

    ClickStack is a high-performance, open-source observability solution built on ClickHouse that unifies logs, metrics, traces, and session replays. It offers sub-second query performance on high-cardinality data with 10-100x cost savings through efficient compression. Companies like Sony LIV use it to monitor streaming services in real-time, processing tens of millions of events while optimizing costs and ensuring high availability.

    23
23. 23
    Article

    Make WordPress Core·49w

    Introducing a new SQLite driver for WordPress – WordPress Playground

    WordPress has released a new SQLite driver that provides better MySQL compatibility through advanced query parsing and emulation. The driver features a complete MySQL lexer and grammar parser written in PHP, supports complex SQL operations like subqueries and UNION statements, and includes MySQL information schema emulation. It's currently available as a feature flag in the SQLite Database Integration plugin v2.2.1+ and powers WordPress Playground. The new architecture enables more robust MySQL feature support and lays groundwork for future database engine compatibility within WordPress.

    19
24. 24
    Article

    P99 Conf·50w

    Migrating from Postgres to ScyllaDB, with 349X Faster Query Processing

    Coralogix migrated their metadata store from PostgreSQL to ScyllaDB, achieving a 349x performance improvement by reducing query processing time from 30 seconds to 86 milliseconds. The migration involved redesigning data models for NoSQL, implementing bloom filter chunking strategies, and optimizing partition keys. Despite challenges with data modeling and EBS storage decisions, the team successfully deployed a 3-node ScyllaDB cluster handling 10K writes per second with sub-millisecond P99 latency, processing terabytes of Parquet metadata for their observability platform.

    17

    6
25. 25
    Article

    Community Picks·48w

    Database Schema Visualization & Security

    PandaView is a database tool that transforms SQL schemas into interactive ERD diagrams while providing security vulnerability detection and performance optimization recommendations. It offers one-click exports, identifies SQL injection risks and permission gaps, and uses AI to suggest indexing strategies for improved query performance.

    15