We are excited to have teamed up with O'Reilly Media to offer developers a free copy of the SQL Cookbook, 2nd Edition. SQL remains the lingua franca of the relational database world. But where do you … Read More >
Getting Started with PostgreSQL Triggers in a Distributed SQL Database
Triggers are a basic feature that all monolithic SQL systems like Oracle, SQL Server and PostgreSQL have supported for many years. They are very useful in a variety of scenarios ranging from simple au… Read More >
Rise of Globally Distributed SQL Databases – Redefining Transactional Stores for Cloud Native Era
At last month’s KubeCon + CloudNativeCon in Seattle, the single biggest change from previous container-related conferences was the excitement among the end user companies around their adoption of Ku… Read More >
Data Modeling Basics – PostgreSQL vs. Cassandra vs. MongoDB
Application developers usually spend considerable time evaluating multiple operational databases to find that one database that’s best fit for their workload needs. These needs include simplified da… Read More >
Distributed Backups in Multi-Region YugaByte DB Clusters
Our post Getting Started with Distributed Backups in YugaByte DB details the core architecture powering distributed backups in YugaByte DB. It also highlights a few backup/restore operations in a sing… Read More >
Getting Started with Distributed Backups in YugaByte DB
YugaByte DB is a distributed database with a Google Spanner-inspired strongly consistent replication architecture that is purpose-built for high availability and high performance. This architecture al… Read More >
Presto on YugaByte DB: Interactive OLAP SQL Queries Made Easy
Presto is a distributed SQL query engine optimized for OLAP queries at interactive speed. It was created by Facebook and open-sourced in 2012. Since then, it has gained widespread adoption and become … Read More >
Are MongoDB’s ACID Transactions Ready for High Performance Applications?
Web app developers initially adopted MongoDB for its ability to model data as “schemaless” JSON documents. This was a welcome relief to many who were previously bitten by the rigid structure and s… Read More >
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 progre… Read More >
Introducing YSQL: A PostgreSQL Compatible Distributed SQL API for YugaByte DB
YugaByte’s mission from day one has been to simplify operational database infrastructure. We are doing so by bringing together the best aspects of SQL and NoSQL into a single transactional, high-per… Read More >