Yugabyte Db

YugabyteDB - the cloud native distributed SQL database for mission-critical applications.
Alternatives To Yugabyte Db
Project NameStarsDownloadsRepos Using ThisPackages Using ThisMost Recent CommitTotal ReleasesLatest ReleaseOpen IssuesLicenseLanguage
Superset54,3751612 hours ago6April 18, 20231,521apache-2.0TypeScript
Apache Superset is a Data Visualization and Data Exploration Platform
Tidb34,91768137a day ago1,289April 07, 20224,365apache-2.0Go
TiDB is an open-source, cloud-native, distributed, MySQL-Compatible database for elastic scale and real-time analytics. Try AI-powered Chat2Query free at : https://tidbcloud.com/free-trial
Metabase34,403
15 hours ago1June 08, 20223,257otherClojure
The simplest, fastest way to get business intelligence and analytics to everyone in your company :yum:
Dbeaver33,933
2 days ago1,813apache-2.0Java
Free universal database tool and SQL client
Sqlmap28,261
3 days ago1February 27, 201857otherPython
Automatic SQL injection and database takeover tool
Cockroach27,866502411 hours ago249August 06, 20215,810otherGo
CockroachDB - the open source, cloud-native distributed SQL database.
Directus23,2701852 days ago86July 25, 2023290otherTypeScript
The Modern Data Stack 🐰 — Directus is an instant REST+GraphQL API and intuitive no-code data collaboration app for any SQL database.
Surrealdb22,6491610 hours ago10April 02, 2023331otherRust
A scalable, distributed, collaborative, document-graph database, for the realtime web
Tdengine21,77422 days ago12April 14, 20221,195agpl-3.0C
TDengine is an open source, high-performance, cloud native time-series database optimized for Internet of Things (IoT), Connected Cars, Industrial IoT and DevOps.
Postgrest21,155
42 days ago37July 12, 2022215mitHaskell
REST API for any Postgres database
Alternatives To Yugabyte Db
Select To Compare


Alternative Project Comparisons
Readme
YugabyteDB

License Documentation Status Ask in forum Slack chat Analytics

What is YugabyteDB?

YugabyteDB is a high-performance, cloud-native, distributed SQL database that aims to support all PostgreSQL features. It is best suited 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.

Core Features

  • 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, serializable and read committed 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 FAQ.

Get Started

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 many languages and client drivers, including Java, Go, NodeJS, Python, and more. For a complete list, including examples, see Drivers and ORMs.

What's being worked on?

This section was last updated in May, 2023.

Current roadmap

Here is a list of some of the key features being worked on for the upcoming releases (the YugabyteDB v2.17 preview release has been released in Jan, 2023, and the v2.16 stable release was released in Jan 2023).

Feature Status Release Target Progress Comments
Automatic tablet splitting enabled by default PROGRESS v2.18 Track Enables changing the number of tablets (which are splits of data) at runtime.
Upgrade to PostgreSQL v15 PROGRESS v2.21 Track For latest features, new PostgreSQL extensions, performance, and community fixes
Database live migration using YugabyteDB Voyager PROGRESS Track Database live migration using YugabyteDB Voyager
Support wait-on-conflict concurrency control PROGRESS v2.19 Track Support wait-on-conflict concurrency control
Support for transactions in async xCluster replication PROGRESS v2.19 Track Apply transactions atomically on target cluster.
YSQL-table statistics and cost based optimizer(CBO) PROGRESS v2.21 Track Improve YSQL query performance
YSQL-Feature support - ALTER TABLE PROGRESS v2.21 Track Support for various ALTER TABLE variants
Support for GiST indexes PLANNING Track Support for GiST (Generalized Search Tree) based index
Connection Management PROGRESS Track Server side connection management

Recently released features

Feature Status Release Target Docs / Enhancements Comments
Faster Bulk-Data Loading in YugabyteDB DONE v2.15 Track Faster Bulk-Data Loading in YugabyteDB
Change Data Capture DONE v2.13 Change data capture (CDC) allows multiple downstream apps and services to consume the continuous and never-ending stream(s) of changes to Yugabyte databases
Support for materalized views DONE v2.13 Docs A materialized view is a pre-computed data set derived from a query specification and stored for later use
Geo-partitioning support for the transaction status table DONE v2.13 Docs Instead of central remote transaction execution metatda, it is now optimized for access from different regions. Since the transaction metadata is also geo partitioned, it eliminates the need for round-trip to remote regions to update transaction statuses.
Transparently restart transactions DONE v2.13 Decrease the incidence of transaction restart errors seen in various scenarios
Row-level geo-partitioning DONE v2.13 Docs Row-level geo-partitioning allows fine-grained control over pinning data in a user table (at a per-row level) to geographic locations, thereby allowing the data residency to be managed at the table-row level.
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 Docs
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

Architecture

YugabyteDB Architecture

Review detailed architecture in our Docs.

Need Help?

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

Popular Database Projects
Popular Sql Projects
Popular Data Storage Categories
Related Searches

Get A Weekly Email With Trending Projects For These Categories
No Spam. Unsubscribe easily at any time.
Cpp
C
Database
Cloud
Postgresql
Kubernetes
Sql
Driver
Progress
Cassandra
Cloud Native
Distributed Database