The Distributed SQL Blog

Thoughts on distributed databases, open source and cloud native

Using PostgreSQL Aggregate Functions in YugabyteDB to Analyze COVID-19 Data

YugabyteDB is an open source, high-performance distributed SQL database built on a scalable and fault-tolerant design inspired by Google Spanner. YugabyteDB uses its own special distributed document store called DocDB. But it provides SQL and stored procedure functionality by re-using the “upper half” of the standard PostgreSQL source code. This is explained in the two part blog post “Distributed PostgreSQL on a Google Spanner Architecture”: (1) Storage Layer;

Read More

Announcing YugabyteDB 2.5

Support for Geo-Partitioning and Enterprise-Grade Security Features

YugabyteDB Adds Support for Geo-Partitioning and Enterprise-Grade Security Features Announcement

Our mission at Yugabyte is to build the default distributed SQL database for cloud native applications in a multi cloud world. To further that mission, this release brings major enhancements to multi-region deployments, performance, and security features offered by the database – while simultaneously improving on high availability,

Read More

Distributed SQL Summit Recap: Envoy and Service Meshes for Databases

At the Distributed SQL Summit 2020, Christoph Pakulski, software engineer at Tetrate, and Prasad Radhakrishnan, VP of data engineering at Yugabyte presented the talk “Envoy and Service Meshes for Databases: What the Future Holds”. In the talk, they explored the topics of Envoy, service meshes–specifically Istio, and how they intersect with the database world.

Read More

Distributed SQL Summit Recap: Mainframe Modernization

At the Distributed SQL Summit 2020, Brenesh Stanslas Flower Mary – Senior Architect, Wipro Digital, presented the talk “Monolith to Microservices.” In the talk he demonstrated how it is possible to take a large, intertwined mainframe monolith and break it down into microservices using a practical approach. The end-to-end approach he demonstrated made use of Wipro’s “moderniZ” platform which addresses the modernization (or transformation) of UIs,

Read More

A PostgreSQL-Compatible, Distributed SQL Cheat Sheet: The Basics

In this blog post, we’ll highlight how all the basic commands you end up using in the first few minutes after installing PostgreSQL are identical in YugabyteDB. We’ll cover connecting to the database, creating users, databases, schemas, and calling external files from the SQL shell. In the next blog post in this series we’ll tackle querying data to demonstrate that if you know how to query data in PostgreSQL,

Read More

Getting Started with IntelliJ IDEA and Distributed SQL

IntelliJ IDEA is a popular integrated development environment (IDE) written in Java for developing software. It is developed by JetBrains and is available as an Apache 2 licensed community edition and in a proprietary commercial edition. IntelliJ supports a variety of datasources within their IDE. Because YugabyteDB is PostgreSQL compatible, most third-party tools and apps will work “out of the box.” IntelliJ is no exception here.

Read More

Use Retool to Quickly Build Distributed SQL and React Apps

Retool is a next generation WSIWYG SaaS-based tool that enables you to quickly build React applications for internal consumption from your existing data sources using a variety of pre-built “building blocks.” Developers can choose from over 58 drag and drop components and combine them with custom JavaScript to create applications that can be securely deployed on-premise or hosted environments like Heroku.

Read More

What’s New and Improved in YugabyteDB Docs – September 2020

Welcome to this month’s edition of what’s new and improved in YugabyteDB Docs. We’re continually adding to and updating the documentation to give you the information you need to make the most out of YugabyteDB. This post covers recent content added, and changes made, to the YugabyteDB documentation since the last posting.

YSQL

What is YSQL?

Read More