The Distributed SQL Blog

Thoughts on distributed databases, open source, and cloud native

Announcing YugabyteDB 2.9: Pushing the Boundaries of Relational Databases

This morning we announced the latest release of the YugabyteDB open source database, YugabyteDB 2.9! This release introduces new capabilities that push the boundaries of relational databases further than ever before. Yugabyte pioneered distributed SQL databases that combine advanced RDBMS capabilities with the resilience, scale, and geo-distribution that cloud native applications demand. Over the years, we have continued to innovate with capabilities such as distributed transactional backups,

Read More

Distributed SQL Tips and Tricks – August 18th, 2021

Welcome back to our bi-weekly tips and tricks blog where I have the pleasure of recapping some distributed SQL questions from around the Internet. I had a month long hiatus this summer, so we are making it up by adding an extra entry into this week’s edition. As always, this blog series would not be possible without all of the behind the scenes work done by Yugabeings such as Dorian Hoxha and Frits Hoogland.

Read More

Announcing DSS ’21: Third Annual Distributed SQL Summit

We are delighted to announce that registration is now open for the third annual Distributed SQL Summit! DSS 2021 will happen on September 21-23, bringing together the YugabyteDB open source user community, customers, partners and industry thought leaders to explore opportunities and experiences of embracing modern cloud native data architectures. We are planning sessions and workshops that will dive into use cases,

Read More

Using Sequelize with YugabyteDB

Sequelize is a promise-based Node.js ORM tool that allows us to interact with databases using javascript instead of SQL. In simple terms, Object Relational Mapping is a process for accessing a relational database using object-oriented languages like javascript. For more information on the features in Sequelize, you can check out their documentation site.

Sequelize Node.js package already has support for databases like Postgres,

Read More

Announcing YugabyteDB 2.6

Yugabyte is on a mission to build the default database for cloud native applications and simplify operational data infrastructure. Our latest release, YugabyteDB 2.6, is a big step forward towards that goal. YugabyteDB 2.6 includes significant enhancements to the open source database and our self-managed DBaaS offering, Yugabyte Platform. These enhancements, including point in time recovery (PITR), default encryption in transit,

Read More

Geo-Distribution in YugabyteDB: Engineering Around the Physics of Latency

Customers today expect always-on, highly responsive access to services wherever they are in the world. This is driving businesses to deploy globally distributed applications that deliver better customer experiences. Moving to a geo-distributed database is a key part of this. Moving data closer to where the end-users are enables lower latency access. Geo-distribution can make the data service resilient to zone and region failures in the cloud.

Read More

Connecting to YugabyteDB with Arctype, a Collaborative SQL Client

YugabyteDB is PostgreSQL compatible. It uses the same protocol and SQL layer as PostgreSQL. This makes YugabyteDB compatible with a majority of database tools, because PostgreSQL is the most popular open source database on the planet. Here is an example with Arctype, a user-friendly collaborative SQL client to query and visualize data.

Setting up a database connection

1.

Read More

Getting Started with the Kafka Connect for YugabyteDB (beta)

Kafka Connect is a popular tool for scaling and reliably streaming data between Apache Kafka and other data systems. It ships with a JDBC Sink which is used to insert data from Kafka to a database. Although the default JDBC Sink is good for many popular RDBMS it isn’t optimized for distributed SQL databases that provide linear scalability and high availability like YugabyteDB.

Read More