Presto on YugabyteDB: Interactive OLAP SQL Queries Made Easy
This post describes how you can run Presto queries on YCQL API as well as join data across the YCQL and YSQL APIs.
November 14, 2018
YugabyteDB
November 1, 2018
Are MongoDB’s ACID Transactions Ready for High-Performance Applications?
MongoDB’s “schemaless” JSON data modeling was initially attractive to web app developers looking to escape the constraints of traditional relational databases, but issues with data durability and ACID transactions have been a consistent challenge. While the recent MongoDB 4.0 release includes multi-document transaction support, this post explores where the platform falls short for transactional, high performance apps.
October 25, 2018
YSQL Architecture: Implementing Distributed SQL in YugabyteDB
In this post, we will look at the architecture of YSQL, the PostgreSQL-compatible distributed SQL API in YugabyteDB. We will also touch on the current state of the project and the next steps in progress. Here is a quick overview:
- YugabyteDB has a common distributed storage engine that powers both SQL and NoSQL
- For supporting NoSQL apps, YugabyteDB is designed for low latency, sub-millisecond reads and massive write scalability. It can handle millions of requests and many TBs of data per node with linear scalability and high resilience.
…
October 25, 2018
Introducing YSQL: A PostgreSQL Compatible Distributed SQL API for YugabyteDB
YugaByte has introduced YSQL, a PostgreSQL-compatible distributed SQL API in YugabyteDB’s 1.1 release. This architecture enables developer agility, operational simplicity, and scalability, addressing the needs of fast-growing online services and cloud-native deployments.
October 2, 2018
YugabyteDB 1.1 New Feature: Public IPs to Simplify Multi or Hybrid Cloud Database Deployments
Welcome to another post in our ongoing series that highlights new features from the latest 1.1 release announced last week. Today we are going to look at the importance of public IP addresses and hostnames in simplifying multi-cloud and hybrid cloud deployments.
In modern cloud deployments, servers often have a combination of private IP addresses (used in the private LAN and often the IP address of the network interface on the server),
…
September 26, 2018
YugabyteDB 1.1 New Feature: Document Data Modeling with the JSON Data Type
Welcome to another post in our ongoing series that highlights new features from the latest 1.1 release announced last week. Today we are going to look at document data modeling using the native JSON data type available in YugabyteDB’s Cassandra compatible YCQL API. Note that this data type is specific to YugabyteDB and is not part of the standard Cassandra Query Language (CQL).
With YugabyteDB’s native JSON support,
…
September 25, 2018
YugabyteDB 1.1 New Feature: Speeding Up Queries with Secondary Indexes
Welcome to another post from our ongoing series where we highlight a new feature from the latest 1.1 release! Today we are going to look at secondary indexes.
Defining Secondary Indexes
A database index is a data structure that improves the speed of data retrieval operations on a database table. Typically, databases are very efficient at looking up data by the primary key. A secondary index can be created using one or more columns of a database table,
…
September 19, 2018
Announcing YugabyteDB 1.1 and Company Update
The team at YugaByte is excited to announce that YugabyteDB 1.1 is officially GA! You can download the latest version from our Quick Start page. New in this release:
YugabyteDB Open Source
- Excellent progress on YSQL, our Postgres-compatible Distributed SQL API
- And,
…
March 7, 2018
Overcoming MongoDB Sharding and Replication Limitations
MongoDB’s sharding and replication have improved since it was first an AP database, but it still has limitations for highly scalable and latency-sensitive apps. In this blog, the authors discuss why users switch to YugabyteDB due to distributed ACID transactions and improved scalability.