Databases Library | Page 12 of 32

March 25, 2021

Creating Standard Patterns to Load Data into YugabyteDB with Apache Airflow

At this year’s Distributed SQL Summit Asia 2021, Viraj Parekh and Pete DeJoy from Astronomer presented the talk, “Creating Standard Patterns to Load Data in YugabyteDB with Apache Airflow.”

Apache Airflow is an open source workflow orchestrator that is used by data teams of all sizes. Airflow is trusted by organizations like Marriott, RBC, Zapier, and Sonos. Given its flexible nature, Airflow is used to interact with everything from legacy on-prem systems to distributed,

…

What’s New in YugabyteDB Docs – March 2021

March 24, 2021

By Alex Ball

Community News Company News Databases Distributed 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.

…

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

March 9, 2021

By Nikhil Chandrappa

Community News Databases Distributed SQL How 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.

…

Yugabyte Secures $48M in Funding and Sets the Stage for Global Growth

March 3, 2021

By Bill Cook

Company News Databases Distributed SQL

Yugabyte Secures $48M in Funding and Sets the Stage for Global Growth

We are excited to announce that Yugabyte has closed a $48M funding round led by Lightspeed Venture Partners with additional participation by Greenspring Associates, Dell Technologies Capital, Wipro Ventures, and 8VC. This comes on the heels of a $30M raise announced in June 2020, bringing the total funding currently raised to $103M. This additional funding will be used to accelerate the launch of the fully managed Yugabyte Cloud offering in addition to growing the R&D,

…

Using the PostgreSQL Recursive CTE – Part Two

March 1, 2021

By Bryn Llewellyn

Databases Distributed SQL How To PostgreSQL

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;

…

Using the PostgreSQL Recursive CTE – Part One

March 1, 2021

By Bryn Llewellyn

Databases Distributed SQL How To PostgreSQL

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;

…

YSQL Development Fundamentals Training Recap – Feb 25, 2021

February 26, 2021

By Jimmy Guerrero

Community News Databases Distributed 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.

…

YugabyteDB: Reimagining the RDBMS for the Cloud

February 25, 2021

By Karthik Ranganathan

Community News Company News Databases Distributed SQL How It Works Open 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,

…

Achieving GDPR Compliance with YugabyteDB

February 23, 2021

By Cyrus Wadia

Community News Databases Distributed SQL How It Works

Achieving GDPR Compliance with YugabyteDB

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

Part 1: Achieving Compliance with YugabyteDB
Part 2: Achieving GDPR Compliance with YugabyteDB (this post)

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),

…

Measuring the Performance Impact of TLS Encryption Using TPC-C

February 22, 2021

By Taylor Mull

Databases Distributed SQL How To Performance 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),

…

Databases

YugabyteDB Core

Computing Bacon Numbers for actors listed in the IMDb

Traversing an employee hierarchy

Course Content

Perspectives from 5 years of building a cloud native database

Explore Distributed SQL and YugabyteDB in Depth