Start Now

Simplify data migration and embrace a cloud native architecture with YugabyteDB Voyager!

Learn More

Author: Jimmy Guerrero

Distributed SQL Change Management with Liquibase and YugabyteDB on GKE

Distributed SQL Change Management with Liquibase and YugabyteDB on GKE

Liquibase is an open source and extensible change management project that supports a variety of databases including Snowflake, MySQL, and PostgreSQL via JDBC. Liquibase allows users to easily define changes in SQL, XML, JSON, and YAML. These changes are then managed in a version control system so the changes can be documented, ordered, and standardized. For more information on the features and benefits of Liquibase, check out their documentation site.

Read more

Getting Started with SQLPad and Distributed SQL on Google Kubernetes Engine

Getting Started with SQLPad and Distributed SQL on Google Kubernetes Engine

SQLPad is an MIT licensed web app written in React and Node.js for writing and running SQL queries and visualizing the results. SQLPad supports PostgreSQL, MySQL, SQL Server, Crate, Vertica, Presto, SAP HANA, Cassandra, Snowflake, Google BigQuery, SQLite, and many more via ODBC. Because YugabyteDB is PostgreSQL compatible, most third-party tools and apps will work “out of the box.” SQLPad is no exception here.

In this blog post we’ll show you how to:

  • Install a 3 node YugabyteDB cluster on Google Kubernetes Engine
  • Build the sample Northwind database
  • Build and configure SQLPad
  • Start the required SQLPad processes
  • Launch the SQLPad UI and issue a test query to validate the deployment

New to distributed SQL or YugabyteDB?

Read more

Distributed SQL Tips and Tricks for PostgreSQL and Oracle DBAs – July 24, 2020

Distributed SQL Tips and Tricks for PostgreSQL and Oracle DBAs – July 24, 2020

Welcome to this week’s tips and tricks blog where we explore both beginner and advanced YugabyteDB topics for PostgreSQL and Oracle DBAs. First things first, for those of you who might be new to either distributed SQL or YugabyteDB.

What is Distributed SQL?

Distributed SQL databases are becoming popular with organizations interested in moving data infrastructure to the cloud or cloud native environments. This is often motivated by the desire to reduce TCO or move away from the horizontal scaling limitations of monolithic RDBMS like Oracle,

Read more

Getting Started with Longhorn Distributed Block Storage and Cloud Native Distributed SQL

Getting Started with Longhorn Distributed Block Storage and Cloud Native Distributed SQL

Editor’s note: This post was originally published on the Rancher blog, and has been cross-posted here and updated as of July 21, 2020 to account for new versions of software available.

Longhorn is cloud native distributed block storage for Kubernetes that is easy to deploy and upgrade, 100 percent open source, and persistent. Longhorn’s built-in incremental snapshot and backup features keep volume data safe, while its intuitive UI makes scheduling backups of persistent volumes easy to manage.

Read more

GraphQL & Distributed SQL Tips and Tricks – July 10, 2020

GraphQL & Distributed SQL Tips and Tricks – July 10, 2020

Welcome to this week’s tips and tricks blog where we explore topics related to combining GraphQL and YugabyteDB to develop scalable APIs and services. We’ll also review upcoming events, new documentation, and blogs that have been published since the last tips and tricks post.

This next section is for those of you who might be new to either GraphQL or distributed SQL.

What’s GraphQL?

GraphQL is a query language (more specifically a specification) for your API,

Read more

INSERT INTO Yugabyte (We’re Hiring Developer Advocates)

INSERT INTO Yugabyte (We’re Hiring Developer Advocates)

It has been an exciting last few weeks here at Yugabyte! We closed our Series B funding round, Bill Cook (formerly of Pivotal and Greenplum) joined as our new CEO, we reaffirmed our commitment to open source, and achieved a bunch of cool community adoption milestones. We are hiring for several roles across engineering, customer success, and marketing. Particularly, with a new round of funding and exploding interest in Distributed SQL,

Read more

Part 2: Airflow DAGs for Migrating PostgreSQL Data to Distributed SQL

Part 2: Airflow DAGs for Migrating PostgreSQL Data to Distributed SQL

Welcome to part two of our series on how to integrate Apache Airflow and YugabyeDB. In part one we showed you how to get Airflow configured to use YuagbyteDB as a backend. In this second post we’ll show you how to build an Airflow workflow that will migrate data between PostgreSQL and YugabyteDB.

What’s YugabyteDB? It is an open source, high-performance distributed SQL database built on a scalable and fault-tolerant design inspired by Google Spanner.

Read more

Part 1: Deploying a Distributed SQL Backend for Apache Airflow on Google Cloud

Part 1: Deploying a Distributed SQL Backend for Apache Airflow on Google Cloud

Apache Airflow is a popular platform for programmatically authoring, scheduling, and monitoring workflows. Airflow has been deployed by companies like Adobe, Airbnb, Etsy, Instacart, and Square. The advantage of defining workflows as code is that they become more maintainable, versionable, testable, and collaborative. Airflow is used to author these workflows as directed acyclic graphs (DAGs) of tasks. Airflow’s scheduler executes your tasks on an array of workers while following the specified dependencies.

Read more

Oracle vs PostgreSQL: First Glance – Testing YugabyteDB’s Compatibility

Oracle vs PostgreSQL: First Glance – Testing YugabyteDB’s Compatibility

Roland Takacs wrote an interesting blog post titled Oracle vs PostgreSQL: First Glance earlier this month. The genesis for his blog post was that he was in the middle of migrating his current Oracle tech stack to Python, parquet files, and PostgreSQL. As such, Roland thought it might be a good exercise to document the various Oracle features he was accustomed to and figure out what the equivalent functionality was in PostgreSQL. In his post,

Read more

Getting Started with Distributed SQL on Azure Kubernetes Service

Getting Started with Distributed SQL on Azure Kubernetes Service

Microsoft’s Azure Kubernetes Service (AKS) offers a highly available, secure, and fully managed Kubernetes service for developers looking to host their applications on containers in the cloud. AKS features elastic provisioning, an integrated developer experience for rapid application development, enterprise security features, and the most available regions of any cloud provider.

YugabyteDB is a natural fit for AKS because it was designed to support cloud native environments since its initial design.

Read more

Learn More to Accelerate Your Retail Business

Ready to dive deeper into distributed SQL, YugabyteDB, and Yugabyte Cloud?
Learn at Yugabyte University
Learn More
Browse Yugabyte Docs
Read More
Join the Yugabyte Community
Join Now