Distributed SQL

Fortune 500 Financial Services Company Chooses YugabyteDB to Support Microservices and Mainframe Migration Initiatives
March 23, 2021
By
CustomersDatabase MigrationDistributed SQL

Fortune 500 Financial Services Company Chooses YugabyteDB to Support Microservices and Mainframe Migration Initiatives

A large, global financial services company is pursuing digital transformation initiatives across the board, with its biggest priorities focused around application modernization. Their goals were to untether from the mainframe, consolidate its numerous database technologies, and migrate to a modern microservices-oriented, cloud native architecture. Learn how they did it and the benefits they achieved.

Read more

Getting Started with DBeaver EE and YugabyteDB Cloud Query Language (YCQL)
March 9, 2021
By
Community NewsDatabasesDistributed SQLHow To

Getting Started with DBeaver EE and YugabyteDB Cloud Query Language (YCQL)

Developers and DBAs widely use SQL editors to design database schemas, write ad hoc queries, troubleshoot, and manage the security policies and database users. For these reasons, it is essential for us as builders of YugabyteDB to bring native integration with popular database tools like DBeaver.

If you are following the YugabyteDB project and our blog posts, you’ll know YugabyteDB currently supports two APIs – YSQL and YCQL (NoSQL) – for querying the database.

…

Read more

Using the PostgreSQL Recursive CTE – Part Two
March 1, 2021
By
DatabasesDistributed SQLHow ToPostgreSQL

Using the PostgreSQL Recursive CTE – Part Two

Computing Bacon Numbers for actors listed in the IMDb

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

Using the PostgreSQL Recursive CTE – Part One
March 1, 2021
By
DatabasesDistributed SQLHow ToPostgreSQL

Using the PostgreSQL Recursive CTE – Part One

Traversing an employee hierarchy

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

YSQL Development Fundamentals Training Recap – Feb 25, 2021
February 26, 2021
By
Community NewsDatabasesDistributed SQL

YSQL Development Fundamentals Training Recap – Feb 25, 2021

Yesterday we delivered our free “YSQL Development Fundamentals” community training and certification class. A special thanks to Karen Tamrazyan and a variety of Meetup groups for hosting and helping promote the event! If you weren’t able to make it, here’s what you missed…

Course Content

In this 90 min training aimed at beginner and intermediate SQL developers, we’ll covered the following topics:

  • YugabyteDB Architecture Review
  • Local 3-Node Installation
  • Basic Administration
  • Installing a Sample Database
  • Configuring Graphical SQL Development Tools
  • Working with the YSQL Shell
  • Schemas and Databases
  • Table Management
  • Data Types
  • Data Manipulation
  • Queries
  • Joins

We worked through almost 80 exercises that showed how developers can immediately leverage their PostgreSQL knowledge and apply it to YugabyteDB.

…

Read more

YugabyteDB: Reimagining the RDBMS for the Cloud
February 25, 2021
By
Community NewsCompany NewsDatabasesDistributed SQLHow It WorksOpen Source

YugabyteDB: Reimagining the RDBMS for the Cloud

Perspectives from 5 years of building a cloud native database

YugabyteDB just turned 5 years old, and I cannot help but reminisce about our journey in building this database over the last half-decade. I vividly remember the genesis of the YugabyteDB project, which started with Kannan, Mikhail, and myself meeting for lunch at a restaurant to discuss the future of cloud native databases. After iterating on the idea over a number of such discussions,

…

Read more

Achieving GDPR Compliance with YugabyteDB
February 23, 2021
By
Community NewsDatabasesDistributed SQLHow It Works

Achieving GDPR Compliance with YugabyteDB

Editor’s note, this is the second post in the series:

This is the second in a series of posts about how different compliance and regulatory frameworks work and how YugabyteDB can be an essential part of a company’s compliance efforts. This installment focuses on the EU’s General Data Protection Regulation (GDPR),

…

Read more

Measuring the Performance Impact of TLS Encryption Using TPC-C
February 22, 2021
By
DatabasesDistributed SQLHow ToPerformance Benchmarks

Measuring the Performance Impact of TLS Encryption Using TPC-C

Organizations need to protect their data, especially the personal data entrusted to them from their users and customers. In order to do so, the data transferred by a database over the network needs to be secure. This is often accomplished using TLS encryption, an encryption protocol that secures communication across a network. When secured by TLS, a communication between a client and a server can enable the two parties to identify one another (preventing any impersonation),

…

Read more

The Average Dreamer
February 19, 2021
By
Community NewsCompany NewsDatabasesDistributed SQL

The Average Dreamer

Editor’s note: Yugabyte is hiring! See all the job openings and consider applying.

Intro

Does any of this ring familiar to you:

“I don’t think that I am making any contribution to the overall growth of the organization.”

“It’s not only about the growth of the organization, it’s about your growth. Both go hand in hand. These tasks might seem trivial to you but they are very important so that you get comfortable.”

Ever heard these words from your manager?

…

Read more

Announcing YugabyteDB 2.4
February 10, 2021
By
Community NewsCompany NewsDatabasesDistributed SQLRelease Announcements

Announcing YugabyteDB 2.4

Run mission-critical applications at scale with enterprise-grade SLAs and security

Our mission at Yugabyte is to build the default distributed SQL database for cloud native applications in a multi-cloud world. We have been accelerating on this mission by bringing new features, growing our user base, and making our software as robust as possible. Today we are excited to announce the general availability of YugabyteDB 2.4 which includes major enhancements and provides enterprise-grade stability allowing you to deploy YugabyteDB in production environments.

…

Read more

Explore Distributed SQL and YugabyteDB in Depth

Discover the future of data management.
Learn at Yugabyte University
Get Started
Browse Yugabyte Docs
Explore docs
PostgreSQL For Cloud Native World
Read for Free