Databases

January 28, 2022

My Yugabyte Journey: From Intern to Full-Time Software Engineer

Hello. My name is Tim Elgersma, and I’m a software engineering intern on the YSQL team at Yugabyte. I have one semester left in my bachelor of Computer Science program at the University of Waterloo. In this blog post, I’d like to talk about my experience interning here over the past several months, and why I’m excited to join the company full time upon graduation.

Adding tablespaces to tablegroups

My onboarding at Yugabyte went pretty smoothly.

…

PostgreSQL Timestamps and Timezones: How to Navigate the Interval Minefield

January 27, 2022

By Bryn Llewellyn

Databases How It Works PostgreSQL YugabyteDB

PostgreSQL Timestamps and Timezones: How to Navigate the Interval Minefield

In the second part of this blog series on PostgreSQL and YSQL date-time data types, the focus shifts to representing durations, or how long things last. Assuming the reader has read the first part and downloaded the companion code kit, this post explores the relevant data types, including interval, timestamp difference, and other related functions.

PostgreSQL Timestamps and Timezones: What You Need to Know—and What You Don’t

January 27, 2022

By Bryn Llewellyn

Databases How It Works PostgreSQL YugabyteDB

PostgreSQL Timestamps and Timezones: What You Need to Know—and What You Don’t

This is the first of a two-part blog post series that deals with the basic business of representing moments using time, date, and timestamp data types. YugabyteDB’s YSQL subsystem provides a similar experience to PostgreSQL, so the topic may still be enlightening for some YSQL users.

YugabyteDB Integrates with Arctype SQL Client

January 25, 2022

By Yugabyte Team

Databases Ecosystem Integrations PostgreSQL YugabyteDB

YugabyteDB Integrates with Arctype SQL Client

PostgreSQL has eaten the world. And so Yugabyte set out to build the most Postgres-compatible, scalable, and resilient database. YugabyteDB is not only wire compatible with PostgreSQL, it is code compatible by reusing the upper half of PostgreSQL. Thanks to this compatibility, YugabyteDB can connect to the vast majority of database tools that integrate with Postgres.

In a previous blog post, Yugabyte Developer Advocate Franck Pachot showed how to connect YugabyteDB in Arctype.

…

YugabyteDB Savepoints: Checkpointing Work in Distributed Transactions

January 21, 2022

By Rob Sami

Databases Distributed SQL PostgreSQL

YugabyteDB Savepoints: Checkpointing Work in Distributed Transactions

Yugabyte brings best-in-class performance, scalability, and availability to YugabyteDB, a fully PostgreSQL-compatible SQL database. Because YugabyteDB’s architecture uses PostgreSQL at the SQL layer, we get a long-tail of PostgreSQL compatibility for free. But implementing savepoints requires deeper integration into YugabyteDB’s distributed persistence and transaction layers.

In this blog post, we’ll discuss why you should care about savepoints. We’ll also examine how we built savepoints into YugabyteDB’s distributed transaction layer,

…

My Yugabyte Journey into Distributed SQL Databases

January 21, 2022

By Brian Foster

Community News Company News Databases Distributed SQL

My Yugabyte Journey into Distributed SQL Databases

This post was written by Nim Wijetunga, a Yugabyte intern during fall 2021. Nim’s currently a software engineering student at the University of Waterloo in Waterloo, Ontario, Canada.

My journey into distributed databases began in early 2021. I was an intern at Snowflake and was part of the core FoundationDB (FDB) team. FDB is an open source distributed key-value store. Snowflake and Apple are currently the largest contributors (and maintainers) of FDB.

…

Tutorial: How to Deploy Multi-Region YugabyteDB on GKE Using Multi-Cluster Services

January 18, 2022

By Srinivasa Vasu

Databases Distributed SQL Docker Google Cloud Platform Kubernetes

Tutorial: How to Deploy Multi-Region YugabyteDB on GKE Using Multi-Cluster Services

The evolution of “build once, run anywhere” containers and Kubernetes—a cloud-agnostic, declarative-driven orchestration API—have made a scalable, self-service platform layer a reality. Even though it is not a one size fits all solution, a majority of business and technical challenges are being addressed. Kubernetes as the common denominator gives scalability, resiliency, and agility to internet-scale applications on various clouds in a predictable, consistent manner. But what good is application layer scalability if the data is still confined to a single vertically scalable server that can’t exceed a predefined limit?

…

Tutorial: Getting Started with YugabyteDB and Docker

January 7, 2022

By Shawn Sherwood

Containers Databases Distributed SQL Docker

Tutorial: Getting Started with YugabyteDB and Docker

When developing modern applications, it is important to maintain dev/prod parity (that is, keep development, staging, and production as similar as possible). This should also extend to the local development environment. However, containerization makes it easy to achieve consistency across all environments, even with more complicated components such as databases.

YugabyteDB is a cloud-native, distributed SQL database that is also PostgreSQL compatible. This interoperability makes it possible for developers to leverage existing tools,

…

Multi-Cloud Distributed SQL: Avoiding Region Failure with YugabyteDB

December 22, 2021

By Franck Pachot

Cloud Providers Databases Distributed SQL Open Source

Multi-Cloud Distributed SQL: Avoiding Region Failure with YugabyteDB

As Amazon CTO Werner Vogels often reminds us: ”Everything fails, all the time”. This means any component of the infrastructure will fail at some point. However, with more and more software being deployed in the cloud, today’s infrastructure must provide redundancy. In addition, the applications that sit on top of it must provide continuity over failures.

This involves database replication when the failure concerns data in motion. But there are different levels of failures and different protection technologies.

…

How Abra Controls Transforms Energy Companies with YugabyteDB Managed

December 20, 2021

By Suda Srinivasan

Customers Databases Distributed SQL YugabyteDB YugabyteDB Aeon

How Abra Controls Transforms Energy Companies with YugabyteDB Managed

In this blog post, we’ll explore why Abra Controls needed a new database. We’ll detail why it chose YugabyteDB. We’ll then discuss how the company used YugabyteDB Managed to implement its IoT application.

Databases

Adding tablespaces to tablegroups

Explore Distributed SQL and YugabyteDB in Depth