Databases

Distributed SQL Tips and Tricks – April 21, 2021
April 21, 2021
By
DatabasesDistributed SQLHow To

Distributed SQL Tips and Tricks – April 21, 2021

Welcome back to our bi-weekly tips and tricks blog where we recap some distributed SQL questions from around the Internet. We’ll also review upcoming events, new documentation, and blogs that have been published recently. Got questions? Make sure to ask them on our YugabyteDB Slack channel, Forum, GitHub, or Stack Overflow. Let’s get into it:

Importing a Large Table Using Smaller Transactions

When first playing around with YugabyteDB many users import existing data from other databases,

…

Read more

Creating a Centralized Consent Database for 80M Citizens Across 100k+ Companies
April 20, 2021
By
Community NewsDatabasesDistributed SQLHow To

Creating a Centralized Consent Database for 80M Citizens Across 100k+ Companies

At this year’s Distributed SQL Summit Asia 2021, Cetin Yalcin Gulec, Shivam Arora, and Cem Aladogan from Softtech presented the talk, “Creating a Centralized Commercial Consent Database for 80M Citizens Across 100k+ Companies.” In this post you can find a summary of the talk, some of the presentation highlights, as well as links to this talk and others from the event.

A Quick Introduction to Softtech

Cem kicked things off with a quick introduction to Softtech.

…

Read more

Distributed SQL Tips and Tricks – April 7, 2021
April 7, 2021
By
Community NewsDatabasesDistributed SQLHow To

Distributed SQL Tips and Tricks – April 7, 2021

Welcome back to our bi-weekly tips and tricks blog where we recap some distributed SQL questions from around the Internet. We’ll also review upcoming events, new documentation, and blogs that have been published since the last post. Got questions? Make sure to ask them on our YugabyteDB Slack channel, Forum, GitHub, or Stack Overflow. Let’s dive right in:

How to create client certs and propagate those on the yb-nodes using the YSQL API

There was a behavior change for the YSQL API after YugabyteDB version 2.5.2 where client certs are no longer required to authenticate to a TLS enabled cluster.

…

Read more

What’s New in YugabyteDB Docs – March 2021
March 24, 2021
By
Community NewsCompany NewsDatabasesDistributed SQL

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

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

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