---

• What is YugabyteDB?
• Get Started
• Build Apps
• What's being worked on?
• Architecture
• Need Help?
• Contribute
• License
• Read More

What is YugabyteDB?

YugabyteDB is a high-performance, cloud-native distributed SQL database that aims to support all PostgreSQL features. It is best to fit for cloud-native OLTP (i.e. real-time, business-critical) applications that need absolute data correctness and require at least one of the following: scalability, high tolerance to failures, or globally-distributed deployments.

The core features of YugabyteDB include:

• Powerful RDBMS capabilities Yugabyte SQL (YSQL for short) reuses the query layer of PostgreSQL (similar to Amazon Aurora PostgreSQL), thereby supporting most of its features (datatypes, queries, expressions, operators and functions, stored procedures, triggers, extensions, etc). Here is a detailed list of features currently supported by YSQL.

• Distributed transactions The transaction design is based on the Google Spanner architecture. Strong consistency of writes is achieved by using Raft consensus for replication and cluster-wide distributed ACID transactions using hybrid logical clocks. Snapshot and serializable isolation levels are supported. Reads (queries) have strong consistency by default, but can be tuned dynamically to read from followers and read-replicas.

• Continuous availability YugabyteDB is extremely resilient to common outages with native failover and repair. YugabyteDB can be configured to tolerate disk, node, zone, region, and cloud failures automatically. For a typical deployment where a YugabyteDB cluster is deployed in one region across multiple zones on a public cloud, the RPO is 0 (meaning no data is lost on failure) and the RTO is 3 seconds (meaning the data being served by the failed node is available in 3 seconds).

• Horizontal scalability Scaling a YugabyteDB cluster to achieve more IOPS or data storage is as simple as adding nodes to the cluster.

• Geo-distributed, multi-cloud YugabyteDB can be deployed in public clouds and natively inside Kubernetes. It supports deployments that span three or more fault domains, such as multi-zone, multi-region, and multi-cloud deployments. It also supports xCluster asynchronous replication with unidirectional master-slave and bidirectional multi-master configurations that can be leveraged in two-region deployments. To serve (stale) data with low latencies, read replicas are also a supported feature.

• Multi API design The query layer of YugabyteDB is built to be extensible. Currently, YugabyteDB supports two distributed SQL APIs: Yugabyte SQL (YSQL), a fully relational API that re-uses query layer of PostgreSQL, and Yugabyte Cloud QL (YCQL), a semi-relational SQL-like API with documents/indexing support with Apache Cassandra QL roots.

• 100% open source YugabyteDB is fully open-source under the Apache 2.0 license. The open-source version has powerful enterprise features such as distributed backups, encryption of data-at-rest, in-flight TLS encryption, change data capture, read replicas, and more.

Read more about YugabyteDB in our Docs.

Get Started

• Install YugabyteDB
• Create a local cluster
• Start with Yugabyte Cloud
• Connect and try out SQL commands
• Build an app using a PostgreSQL-compatible driver or ORM.
• Try running a real-world demo application:
  • Microservices-oriented e-commerce app
  • Streaming IoT app with Kafka and Spark Streaming

Cannot find what you are looking for? Have a question? Please post your questions or comments on our Community Slack or Forum.

Build Apps

YugabyteDB supports several languages and client drivers. Below is a brief list.

Language	ORM	YSQL Drivers	YCQL Drivers
Java	Spring/Hibernate	PostgreSQL JDBC	cassandra-driver-core-yb
Go	Gorm	pq	gocql
NodeJS	Sequelize	pg	cassandra-driver
Python	SQLAlchemy	psycopg2	yb-cassandra-driver
Ruby	ActiveRecord	pg	yugabyte-ycql-driver
C#	EntityFramework	npgsql	CassandraCSharpDriver
C++	Not tested	libpqxx	cassandra-cpp-driver
C	Not tested	libpq	Not tested

What's being worked on?

This section was last updated in December, 2021.

Current roadmap

Here is a list of some of the key features being worked on for the upcoming releases (the YugabyteDB v2.11 latest release has been released in November, 2021, and the v2.8 stable release was released in October 2021).

Feature	Status	Release Target	Progress	Comments
Upgrade to PostgreSQL v13	PROGRESS	v2.13	Track	For latest features, new PostgreSQL extensions, performance, and community fixes
Change Data Capture	PROGRESS	v2.13	Track	Allows multiple downstream apps and services to consume changes from YugabyteDB
Support for in-cluster PITR	PROGRESS	v2.13	Track	Point in time recovery of YSQL databases, to a fixed point in time, across DDL and DML changes
Support for materalized views	PROGRESS	v2.13	Track	Support create, drop, refresh materialized view
Geo-partitioning support for the transaction status table	PROGRESS	v2.13	Track	Allows creating multiple transaction status tables
Automatic tablet splitting enabled by default	PROGRESS	v2.13	Track	Enables changing the number of tablets (which are splits of data) at runtime.
YSQL-table statistics and cost based optimizer(CBO)	PROGRESS	v2.13	Track	Improve YSQL query performance
YSQL-Feature support - ALTER TABLE	PROGRESS	v2.13	Track	Support for various ALTER TABLE variants
YSQL-Online schema migration	PROGRESS	v2.13	Track	Schema migrations(includes DDL operations) to be safely run concurrently with foreground operations
Row-level geo-partitioning	PROGRESS	v2.13	Track	Enhance YSQL language support
Transparently restart transactions	PROGRESS	v2.13	Track	Decrease the incidence of transaction restart errors seen in various scenarios
Pessimistic locking Design	PROGRESS	v2.13	Track
Make COLOCATED tables default for YSQL	PLANNING		Track
Support for transactions in async xCluster replication	PLANNING		Track	Apply transactions atomically on consumer cluster.

Recently released features

Feature	Status	Release Target	Docs / Enhancements	Comments
YSQL-Support GIN indexes	✅ DONE	v2.11	Docs	Support for generalized inverted indexes for container data types like jsonb, tsvector, and array
YSQL-Collation Support	✅ DONE	v2.11	Docs	Allows specifying the sort order and character classification behavior of data per-column, or even per-operation according to language and country-specific rules
YSQL-Savepoint Support	✅ DONE	v2.11	Docs	Useful for implementing complex error recovery in multi-statement transaction
xCluster replication management through Platform	✅ DONE	v2.11
Spring Data YugabyteDB module	✅ DONE	v2.9	Track	Bridges the gap for learning the distributed SQL concepts with familiarity and ease of Spring Data APIs
Support Liquibase, Flyway, ORM schema migrations	✅ DONE	v2.9	Docs
Support ALTER TABLE add primary key	✅ DONE	v2.9	Track
YCQL-LDAP Support	✅ DONE	v2.8	Docs	support LDAP authentication in YCQL API
Platform Alerting and Notification	✅ DONE	v2.8	Docs	To get notified in real time about database alerts, user defined alert policies notify you when a performance metric rises above or falls below a threshold you set.
Platform API	✅ DONE	v2.8	Docs	Securely Deploy YugabyteDB Clusters Using Infrastructure-as-Code
Support Spark 3.x on YCQL API	✅ DONE	v2.6	Track
Identity and access management in YSQL	✅ DONE	v2.5	Track	LDAP and Active Directory support
Follower reads in YSQL	✅ BETA	v2.5	Issue	Ability to perform follower reads for YSQL and transactional tables in YCQL.
YSQL cluster administration features - Node-Level statistics	✅ DONE	v2.5	Issue	Per-node view of currently active queries, find which queries are slow, what active connections are doing, etc.
Support loading large data sets into YSQL using COPY	✅ DONE	v2.5	Issue	Improving transactions which have a very large number of operations, as well as provide various options to batch load data more efficiently
Database runtime activity monitoring	✅ DONE	v2.5	Issue	Activity monitoring, audit logging, inactivity monitoring
Online rebuild of indexes	✅ DONE	v2.2		Docs coming soon. See pending enhancements
DEFERRED constraints in YSQL	✅ DONE	v2.2		Docs coming soon. See pending enhancements.
COLOCATED tables GA	✅ DONE	v2.2		Docs coming soon
Online schema migration framework	✅ DONE	v2.2		Note that this is just the framework implementation. See planned enhancements in this area.
Distributed backups for transactional tables	✅ DONE	v2.2		Docs coming soon. See pending enhancements.
IPV6 support for YugabyteDB	✅ DONE	v2.2		Docs coming soon
Automatic tablet splitting	✅ BETA	v2.2	Docs	See further enhancements
xCluster replication (async cross-cluster replication)	✅ DONE	v2.1	Docs
Encryption of data at rest	✅ DONE	v2.1	Docs

Architecture

Review detailed architecture in our Docs.

Need Help?

• You can ask questions, find answers, and help others on our Community Slack and Forum, as well as Stack Overflow.

• Please use GitHub issues to report issues.

Contribute

As an an open-source project with a strong focus on the user community, we welcome contributions as GitHub pull requests. See our Contributor Guides to get going. Discussions and RFCs for features happen on the design discussions section of our Forum.

License

Source code in this repository is variously licensed under the Apache License 2.0 and the Polyform Free Trial License 1.0.0. A copy of each license can be found in the licenses directory.

The build produces two sets of binaries:

• The entire database with all its features (including the enterprise ones) are licensed under the Apache License 2.0
• The binaries that contain -managed in the artifact and help run a managed service are licensed under the Polyform Free Trial License 1.0.0.

By default, the build options generate only the Apache License 2.0 binaries.

Read More

• To see our updates, go to The Distributed SQL Blog.
• See how YugabyteDB compares with other databases.