Distributed SQL

What’s New in YugabyteDB Docs – March 2021

What’s New in YugabyteDB Docs – March 2021

Welcome to the latest edition of what’s new and improved in Yugabyte Docs. We’re always adding new and updating existing documentation to provide you with the most up-to-date information on YugabyteDB, Yugabyte Platform, and our database ecosystem.

YugabyteDB Core

We had previously launched the Explore section to help users get started with YugabyteDB. YugabyteDB is an open source distributed SQL database that uniquely combines enterprise-grade RDBMS capabilities with the horizontal scalability and resilience of cloud native architectures.

Read more

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

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)

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

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

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

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

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

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

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

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

Explore Distributed SQL and YugabyteDB in Depth

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