Database
19 articles tagged with Database.
What are Different Types of SQL Indexes?
Unlock database performance with our guide to SQL index types. Learn how B-Tree, clustered, non-clustered, and hash indexes speed up your queries.
Normalized vs Denormalized Database?
Choosing between a normalized vs denormalized database? This guide breaks down the performance trade-offs to help you make the right architectural choice.
What Happens During a Database Migration?
Discover what happens during a database migration. This practical guide covers planning, execution, validation, and strategies for a smooth transition.
Acid vs Base: Which Database Consistency Model Should You Use?
Discover whether acid vs base: which database consistency model should you use? Find out which approach suits your needs with real-world examples.
What Are Vector Databases? The Secret Sauce Behind AI Search Engines
A vector database stores complex data, such as text, images, and audio, as high-dimensional numerical representations called vector embeddings.
Write-Through, Write-Back & Write-Around in Cache: A Practical Guide
Your app writes data every second but how it writes can change everything. Write-Through, Write-Back & Write-Around hide big trade-offs.
CDN vs Edge Cache: What You Need to Know
When people discuss CDN vs edge cache, they're often setting up a false comparison. The reality is simpler: edge caching is the core process that makes a modern Content Delivery Network (CDN) work.
Redis vs Memcached: When to Use What?
Redis: complex data, persistence & pub/sub. Memcached: simple, ultra-fast, volatile key-value caching.
What is Memcached?
Memcached is a high-performance, open-source caching system that stores frequently accessed data in RAM.
Object vs File vs Block Storage Explained
File storage uses folders, object storage flattens data with metadata for scale, and block storage is a simpler form for raw binary data.
What is NoSQL? A Clear Guide to NoSQL Databases
Running an online store? Products vary by size, color, reviews, ratings & sellers fitting all that into rigid tables quickly gets messy...
What is Read/Write Splitting? Boost Database Performance
When apps scale, one database handling both reads and writes becomes a bottleneck. Read/write splitting fixes this by separating the two.
Data Management in Applications
Whether you’re building a simple note-taking app, a social media platform, or a large-scale e-commerce system, your application’s success depends on how well...
EP 63: How Quora Optimized their Databases?
Quora optimized databases with caching, MyRocks for storage efficiency, and MySQL sharding to boost performance, cut costs, and handle scale.
EP 61: How Stripe achieved 99.999% uptime with DocDB (Document Database)
Stripe achieved 99.999% uptime by building DocDB, a custom solution on MongoDB, enabling efficient data migration, scaling, and high availability.
What is MongoDB?
MongoDB is a NoSQL database that stores data in flexible, JSON-like documents.
What is PostgreSQL?
PostgreSQL is a robust, open-source object-relational database system known for advanced features, scalability, and support for complex queries.
EP 29: What is Cassandra?
Cassandra is a scalable, distributed NoSQL database for handling large data with high availability.
What is an ORM?
Ever thought of skipping database languages? ORM is for you!