docs/content/v2025.1/reference/get-started-guide.md
Find resources for getting started, migrating existing databases, using your database, and architecting for scalability, reliability, and security.
<!-- <ul class="nav yb-pills"> <li> <a href="https://cloud.yugabyte.com/signup" class="orange"> </i> Sign Up </a> </li> <li> <a href="https://download.yugabyte.com/" class="orange"> </i> Download Now </a> </li> <li> <a href="https://inviter.co/yugabytedb" class="orange"> </i> Join Us on Slack </a> </li> </ul> -->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.