Database

Explore the Topic

AI-Powered Database Tools

Evaluations of AI systems that diagnose database issues, with patterns for testing and deployment.

Vector Databases

Comparisons of vector database systems and guides to choosing them for AI projects.

Data Warehouse Design

Approaches to building data warehouses, dimensional modeling, and handling slowly changing dimensions.

StarRocks and Apache Doris

Technical guides to deploying and optimizing StarRocks and Apache Doris for real-time analytics workloads.

Databases on Kubernetes

Debates and guides on running stateful databases in Kubernetes and cloud-native environments.

Sharding and Replication

Explanations of database sharding, partitioning strategies, and replication mechanisms for distributed systems.

Redis and In-Memory Stores

Guides to Redis data structures, implementation patterns, and building in-memory databases.

Database Configuration

Guides to deploying databases on various platforms, from containers to cloud services.

Entity Framework Core

Patterns for migrations, unit of work, and performance optimization in Entity Framework Core.

Laravel and Eloquent

Techniques for optimizing Laravel Eloquent queries, seeding, and database interactions.

Python Database Tools

Guides to working with databases in Python using DuckDB, ORMs, and built-in libraries.

DynamoDB and AWS Services

Architecture patterns, scaling strategies, and design practices for DynamoDB and related AWS databases.

MongoDB Practices

Guides to data modeling, query optimization, and security patterns in MongoDB.

PostgreSQL Use Cases

Debates over when PostgreSQL fits as a default choice and when to consider alternatives.

Indexing Strategies

Explanations of B-trees, hash indexes, and other indexing structures that improve query performance.

Query Optimization

Guides to analyzing slow queries, reading execution plans, and tuning database performance.

Getting Started with Databases

Introductions to database concepts, SQL basics, and choosing database systems.

SQL Query Techniques

Examples of common SQL statements and patterns for data analysis tasks.

Streaming Databases

Architectures for processing real-time data with RisingWave, Kafka, and materialized views.

Latest stories

Jayani Basnayake

1h ago

SQL Table Joins

SQL JOINs combine data from two or more tables based on a related column. The join type determines which matching and unmatched rows appear…

Skill Stuff

TechByRahmat

2h ago

10 Database Migration Mistakes That Can Turn a Small Change Into an Incident

One missing default, an unexpected table lock, or a migration that cannot be rolled back can turn a routine deployment into hours of…

JIN System Architect

JIN

2h ago

What a Retail Company’s Architecture Diagram Is Actually Hiding

System Architecture

JavaScript in Plain English

TechByRahmat

2h ago

PostgreSQL vs MongoDB: 9 Questions That Should Decide Your Database

The right database depends on your data, query patterns, and consistency requirements, not which technology is trending.

Muneezabilal

2h ago

47. I Built My Personal Portfolio with React, Oracle Database & CMS……….

When I started building my personal portfolio, I wanted to create more than just a website to display my skills and projects.

See more stories

Database

Explore the Topic

AI and Vector SearchSpecialized databases for machine learning and semantic search applications.

AI-Powered Database Tools

Vector Databases

Data Warehouse PlatformsGuides to specific data warehouse systems and their performance characteristics.

Data Warehouse Design

StarRocks and Apache Doris

Distributed Database PatternsTechniques for scaling databases across multiple nodes and regions.

Databases on Kubernetes

Sharding and Replication

In-Memory and CachingUsing in-memory data stores for performance and caching use cases.

Redis and In-Memory Stores

Infrastructure and DeploymentSetting up database environments and managing infrastructure.

Database Configuration

Language-Specific ToolsDatabase libraries and ORMs for specific programming languages.

Entity Framework Core

Laravel and Eloquent

Python Database Tools

NoSQL and Document StoresWorking with non-relational database systems and their specific patterns.

DynamoDB and AWS Services

MongoDB Practices

PostgreSQLPerspectives on PostgreSQL adoption, migration strategies, and when to use it.

PostgreSQL Use Cases

Query PerformanceTechniques for optimizing database queries and understanding execution behavior.

Indexing Strategies

Query Optimization

SQL FundamentalsLearning SQL syntax, query patterns, and introductory database concepts.

Getting Started with Databases

SQL Query Techniques

Streaming and Real-Time DataDatabases designed for continuous data ingestion and real-time analytics.

Streaming Databases

Latest stories

SQL Table Joins

SQL JOINs combine data from two or more tables based on a related column. The join type determines which matching and unmatched rows appear…

10 Database Migration Mistakes That Can Turn a Small Change Into an Incident

One missing default, an unexpected table lock, or a migration that cannot be rolled back can turn a routine deployment into hours of…

What a Retail Company’s Architecture Diagram Is Actually Hiding

System Architecture

PostgreSQL vs MongoDB: 9 Questions That Should Decide Your Database

The right database depends on your data, query patterns, and consistency requirements, not which technology is trending.

47. I Built My Personal Portfolio with React, Oracle Database & CMS……….

When I started building my personal portfolio, I wanted to create more than just a website to display my skills and projects.

Why PostgreSQL Became 50% Slower on Linux 7.0

How to Scale PostgreSQL to 100,000 Writes Per Second Without Sharding

How I Design Database Schemas as a Senior Developer for Better Results

Change Data Capture (CDC) for Data Engineers

7 Database Scaling Techniques Every Backend Developer Should Know

I Built My Head Out of Lego. Inside SQL Server 2025.

When to Use Optimistic vs Pessimistic Locking

SQL Server 2025, an RTX 5090, and the slow death of “Will the hon. Gentleman give way?”

Change Data Capture (CDC) for Data Engineers

Partition Finalization in Pinterest’s Next-Generation DB Ingestion Framework