Best of Database — February 2025

1. 1
   Video

   ByteGrad·1y

   SQL Tutorial - All 38 Concepts You Need To Know

   SQL is a structured query language used to manage and analyze data in databases. Understanding SQL concepts is valuable for both organizations and individual careers. Key SQL concepts include creating and managing databases, tables, and relationships, as well as performing queries to insert, update, delete, and retrieve data. Proper data structuring, using primary and foreign keys, and employing joins are essential for database efficiency. Indexing can optimize queries, and using transactions ensures data consistency. Tools and certifications like those offered by DataCamp can enhance SQL skills.

   327

   1
2. 2
   Article

   The Polymathic Engineer·1y

   Database sharding case study: PostgreSQL

   Notion's engineering team faced significant challenges in scaling their monolithic PostgreSQL database due to rapid user base growth. They decided to implement database sharding, with the Block table and related tables being sharded using Workspace ID as the key. The migration involved a double-write phase and verification to ensure data integrity. Despite some lessons learned, such as the importance of starting early and aiming for zero downtime, the outcome was a more scalable and faster system for Notion's users.

   199

   1
3. 3
   Article

   Directus·1y

   Stop Overengineering Your Multi-tenant Architecture

   Multi-tenancy is crucial for building SaaS products. Simplified, it can cut infrastructure costs significantly. Three main approaches exist: row-level tenancy, schema-level separation, and database-level isolation. Start simple and scale as needed, with row-level tenancy sufficing for most starting apps. Tools like Flyway or Liquibase for migrations, PostgreSQL for database, and PgBouncer for connection management are recommended.

   118

   7
4. 4
   Article

   System Design Codex·1y

   Your Code is Fast, But Your Database is Slow—Now What?

   If your application is slow despite optimized code, the database might be the bottleneck. This issue often arises because database operations like disk access and network calls are slower than in-memory processes. To address this, you must identify bottlenecks using methods like query profiling and monitoring key performance metrics. Optimize queries by adding indexes, avoiding SELECT *, and using joins instead of nested queries. Also consider architectural optimizations such as caching, connection pooling, materialized views, sharding, and read replicas to improve performance and scalability.

   61

   4
5. 5
   Article

   Vlad Mihalcea·1y

   MySQL Performance Tuning with Releem

   Releem is a tool designed to optimize MySQL performance by monitoring and providing optimization tips. The setup involves creating a database user, configuring the Releem agent, and adjusting MySQL settings for optimal data collection. Users can monitor query response times, throughput, and slow queries through an online dashboard. The tool also offers insights into database schema optimization for better application performance.

   30
6. 6
   Article

   .NET Blog·1y

   Announcing Chroma DB C# SDK

   Chroma, an open-source database for AI applications, now has a C# SDK. It supports embedding storage, metadata filtering, vector search, full-text search, and document storage. You can integrate Chroma into .NET applications using the ChromaDB.Client package. Example operations include creating collections, adding data representations (such as movie descriptions), and performing vector searches. The new SDK simplifies AI solutions implementation in .NET and supports integration with Microsoft's AI and data components.

   22
7. 7
   Video

   Community Picks·1y

   A new Postgres service is here

   Prisma has launched a new managed PostgreSQL service designed to provide an always-on, serverless database with pay-as-you-go pricing. Utilizing bare metal servers and innovative unic kernels and micro VMs, the service aims to eliminate cold starts and offer real-time subscriptions, caching, and query optimization out of the box. Currently in early access, the service targets non-mission-critical projects with plans to improve storage, compute, and connection options in future updates.

   18
8. 8
   Video

   Zoran Horvat·1y

   Master CQRS Queries in EF Core: Optimize for Speed and Efficiency

   Learn how to optimize database queries using the CQRS principle in Entity Framework Core. This involves separating queries from commands, projecting queries to collect only necessary data, and efficiently using resources by minimizing database calls. The post provides a practical guide, including code examples, to illustrate how to implement CQRS in a Minimal API application.

   13
9. 9
   Article

   Community Picks·1y

   goatplatform/goatdb: Lightweight NoDB for Deno & React

   GoatDB is a real-time, version-controlled, client-side database that is highly resilient and works offline. It is optimized for Deno & React, making it ideal for prototyping, self-hosting, and single or ultra-light multi-tenant apps. Minimal server-side infrastructure is required, as most processing occurs in the client. GoatDB's design enables seamless synchronization, real-time collaboration, and automatic state restoration. It employs strong security measures and efficient conflict resolution, ensuring data integrity and consistency.

   12
10. 10
    Article

    Hacker News·1y

    tcdi/plrust: A Rust procedural language handler for PostgreSQL

    PL/Rust is a procedural language for PostgreSQL that allows writing functions in Rust, offering natively compiled functions for optimal performance and safety. It supports various Postgres data types and can be used to write trigger functions. PL/Rust is available as both a 'trusted' and 'untrusted' procedural language depending on the system. The post provides installation instructions, configuration settings, and additional resources for getting started.

    11