Resource guide

Learn more about YugabyteDB with blogs, videos, and more

Find resources for getting started, migrating existing databases, using your database, and architecting for scalability, reliability, and security.

Introducing YugabyteDB

Distributed SQL 101: Learn how a distributed SQL architecture achieves higher availability, scalability, and replication.
How to Scale a Single-Server Database: A Guide to Distributed PostgreSQL: Enable seamless scalability, high availability, and global data distribution while preserving PostgreSQL compatibility
Distributed SQL vs Sharded Postgres: Learn the differences between distributed SQL and sharded Postgres.
Distributed SQL vs NoSQL vs NewSQL: Learn the differences between distributed SQL and other distributed database implementations.
How 7 Real-World Customers are Using YugabyteDB Aeon: Real-world use cases for moving to a distributed database.
Unlocking the Power of Event Streaming with YugabyteDB: Real world use cases for streaming data with YugabyteDB.
Architecting a Highly Available and Resilient Systems of Record: Learn how YugabyteDB can be deployed as a system of record and integrates into the broader data ecosystem.

Reimagining the RDBMS for the Cloud: Learn how YugabyteDB's distributed SQL architecture adapts traditional RDBMS for cloud environments.
Data Replication in YugabyteDB: YugabyteDB's data replication ensures high availability and consistency across distributed nodes with tunable replication strategies.
Distributed PostgreSQL on a Google Spanner Architecture – Storage Layer: Learn about YugabyteDB's distributed Google Spanner-inspired storage layer DocDB.
Distributed PostgreSQL on a Google Spanner Architecture – Query Layer: Learn about YugabyteDB's distributed, highly resilient, PostgreSQL-compatible SQL API layer.
6 Technical Challenges Developing a Distributed SQL Database: Learn how YugabyteDB addresses six key challenges in building a distributed SQL database, including consistency, scalability, and fault tolerance.

How to Start YugabyteDB on Your Laptop: Try YugabyteDB out by running it on your laptop in five minutes.
Get started using Docker: Use Docker compose to start YugabyteDB with yugabyted.
Create Global Applications: Test YugabyteDB features using a demo application in real time.
Start a multi-node cluster with Yugabyted: Create a multi-node cluster on your laptop.

Improving PostgreSQL: How to Overcome the Tough Challenges with YugabyteDB: Problem areas in PostgreSQL and how to resolve them in YugabyteDB.
Database Migration using YugabyteDB Voyager: Learn how you can migrate databases to YugabyteDB quickly and securely.
Simplify Database Migration with New YugabyteDB Voyager: Use YugabyteDB Voyager to migrate from legacy and single-cloud databases.

Seven Multi-Region Deployment Best Practices: Best practices for reducing latencies and improving performance in a multi-region deployment.
Rapid Data Recovery: Learn how YugabyteDB performs swift data recovery.

Global Applications with YugabyteDB: Explore how to design and build global applications with YugabyteDB.
Hello world: Use your favorite programming language to build an application that uses YSQL or YCQL APIs.
Distributed PostgreSQL Essentials for Developers: Hands-on Course: Build a scalable and fault-tolerant movie recommendation service.
Best practices: Tips and tricks to build applications for high performance and availability.
Drivers and ORMs: Connect applications with your database.

How to Avoid Hotspots: Avoid hotspots in distributed databases by using application-level sharding to distribute writes across multiple nodes.
Scalable Range Indexes To Avoid Hotspots on Indexes (For range queries and Top-n queries): Learn how to avoid hotspots on range-based indexes in distributed databases.

Built-in Connection Manager Turns Key PostgreSQL Weakness into a Strength: Use YugabyteDB's built-in Connection Manager to improve performance and simplify application architecture.
Database Connection Management: Exploring Pools and Performance: Manage database connections effectively, using connection pooling and tuning parameters to reduce latency and handle high concurrency.
Understanding Client Connections and How Connection Pooling Works in YugabyteDB YSQL: Learn about client connections and how you can use third-party connection poolers in YugabyteDB.

EXPLAIN (ANALYZE, DIST) YugabyteDB distributed execution plan: Use EXPLAIN (ANALYZE, DIST) in YugabyteDB to analyze distributed execution plans.
Query Tuning How To: Optimize query performance in YugabyteDB, using indexing, query tuning, and tools like EXPLAIN to analyze and improve distributed query execution.
YugabyteDB Memory Tuning for YSQL: Optimize YugabyteDB memory for YSQL by tuning TServer and Master processes to prevent out-of-memory issues.

Distributed Indexes for Optimal Query Performance: Design indexes to get the best query performance from a distributed database.
Boost Queries with Index Only Scan: Learn how Index Only Scan can boost secondary index queries in a distributed SQL database.
Covering Indexes: Optimize index creation by covering the right columns.
Secondary Indexes in YugabyteDB: Explore secondary indexes in YugabyteDB using YSQL.
Range indexes for LIKE queries in YugabyteDB: Techniques for performing LIKE queries in YugabyteDB.

Optimize Pagination in a Distributed Database: Design queries to return data with pagination while maintaining global ordering.
Efficient Pagination in YugabyteDB: Learn about the best indexing pattern for PostgreSQL and YugabyteDB.
Pagination with an OFFSET is better without OFFSET: Learn why you shouldn't use OFFSET for pagination.

Engineering Around the Physics of Latency: Learn about the geo-distributed deployment topologies offered by YugabyteDB.
Local Reads in Geo-Distributed YugabyteDB: Perform local reads in geo-distributed YugabyteDB databases.
Multi-Region Best Practices: Techniques to reduce latencies and improve performance in a multi-region deployment.