PostgreSQL

November 12, 2020

Community News Company News Databases Distributed SQL PostgreSQL Release Announcements

Announcing YugabyteDB 2.5

Support for Geo-Partitioning and Enterprise-Grade Security Features

Our mission at Yugabyte is to build the default distributed SQL database for cloud native applications in a multi cloud world. To further that mission, this release brings major enhancements to multi-region deployments, performance, and security features offered by the database – while simultaneously improving on high availability, horizontal scalability, and ease of managing the database.

Enhanced multi-region capabilities with geo-partitioning and follower reads: The YugabyteDB 2.5 release adds row-level geo-partitioning capabilities as well as follower reads to the extensive set of multi-region features that YugabyteDB already had.

…

Envoy and Service Meshes for Databases: What the Future Holds

November 11, 2020

By Michelle Brinich

Databases Distributed SQL How It Works PostgreSQL

Envoy and Service Meshes for Databases: What the Future Holds

At the Distributed SQL Summit 2020, Christoph Pakulski, software engineer at Tetrate, and Prasad Radhakrishnan, VP of data engineering at Yugabyte presented the talk “Envoy and Service Meshes for Databases: What the Future Holds”. In the talk, they explored the topics of Envoy, service meshes–specifically Istio, and how they intersect with the database world. Christoph explained the Envoy PostgreSQL network filter extension released earlier in the year,

…

Distributed SQL Summit Recap: Mainframe Modernization

October 20, 2020

By Jimmy Guerrero

Databases Distributed SQL How To PostgreSQL

Distributed SQL Summit Recap: Mainframe Modernization

At the Distributed SQL Summit 2020, Brenesh Stanslas Flower Mary – Senior Architect, Wipro Digital, presented the talk “Monolith to Microservices.” In the talk he demonstrated how it is possible to take a large, intertwined mainframe monolith and break it down into microservices using a practical approach. The end-to-end approach he demonstrated made use of Wipro’s “moderniZ” platform which addresses the modernization (or transformation) of UIs, data, and services.

Challenges with Mainframes Today

Brenesh pointed out that although many organizations are well down the path of moving new (and some legacy applications) to the cloud or cloud-native technologies so they can take advantage of the cost savings,

…

Distributed SQL Tips and Tricks – Oct 16, 2020

October 16, 2020

By Dorian Hoxha

Databases Distributed SQL How To PostgreSQL

Distributed SQL Tips and Tricks – Oct 16, 2020

Welcome to this week’s 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 Stackoverflow. Ok, let’s dive right in:

How to use joins in UPDATE statements

Sometimes,

…

Effortless Database Installation: Unveiling the Compatibility of YugabyteDB and PostgreSQL

October 1, 2020

By Jimmy Guerrero

PostgreSQL YugabyteDB

Effortless Database Installation: Unveiling the Compatibility of YugabyteDB and PostgreSQL

Discover the seamless compatibility between PostgreSQL and YugabyteDB. Learn how the installation commands overlap, including connecting to databases, creating users, schemas, and executing files from the SQL shell.

Getting Started with IntelliJ IDEA and Distributed SQL

September 29, 2020

By Jimmy Guerrero

Databases Distributed SQL How To PostgreSQL

Getting Started with IntelliJ IDEA and Distributed SQL

IntelliJ IDEA is a popular integrated development environment (IDE) written in Java for developing software. It is developed by JetBrains and is available as an ache 2 licensed community edition and in a proprietary commercial edition. IntelliJ supports a variety of datasources within their IDE. Because YugabyteDB is PostgreSQL compatible, most third-party tools and apps will work “out of the box.” IntelliJ is no exception here.

In this blog post we’ll walk you though the following steps:

Install a 3 node YugabyteDB cluster on Google Kubernetes Platform
Install the Northwind sample database
Configure IntelliJ to work with YugabyteDB
Test out some basic IntelliJ database features with YugabyteD

Step 1: Install YugabyteDB on a GKE Cluster using Helm 3

In this section we are going to install YugabyteDB on the cluster.

…

Use Retool to Quickly Build Distributed SQL and React Apps

September 24, 2020

By Jimmy Guerrero

Databases Distributed SQL How To PostgreSQL

Use Retool to Quickly Build Distributed SQL and React Apps

Retool is a next generation WSIWYG SaaS-based tool that enables you to quickly build React applications for internal consumption from your existing data sources using a variety of pre-built “building blocks.” Developers can choose from over 58 drag and drop components and combine them with custom JavaScript to create applications that can be securely deployed on-premise or hosted environments like Heroku. Retool supports over 30 native integrations including PostgreSQL, GraphQL, AWS S3, and Cassandra.

…

What’s New and Improved in YugabyteDB Docs – September 2020

September 22, 2020

By Steve Bang

Community News Databases Distributed SQL How To PostgreSQL

What’s New and Improved in YugabyteDB Docs – September 2020

Welcome to this month’s edition of what’s new and improved in YugabyteDB Docs. We’re continually adding to and updating the documentation to give you the information you need to make the most out of YugabyteDB. This post covers recent content added, and changes made, to the YugabyteDB documentation since the last posting.

YSQL

What is YSQL? Yugabyte Structured Query Language (YSQL) is a fully-relational, PostgreSQL-compatible API.

…

Distributed SQL Tips and Tricks for PostgreSQL and Oracle DBAs – Sep 9, 2020

September 9, 2020

By Jimmy Guerrero

Database Migration Distributed SQL How To PostgreSQL

Distributed SQL Tips and Tricks for PostgreSQL and Oracle DBAs – Sep 9, 2020

Welcome to this week’s tips and tricks blog where we explore both beginner and advanced YugabyteDB topics for PostgreSQL and Oracle DBAs.

Please note that most examples in the post make use of the Northwind sample database. Instructions on how to get it installed are here.

Ok, let’s dive in…

Is there a functional equivalent to Oracle’s NVL in PostgreSQL or YugabyteDB?

In a nutshell,

…

Row Counts of Tables in a SQL Schema and Database: PostgreSQL vs. YugabyteDB

August 27, 2020

By Karthik Ranganathan

Compare and contrast PostgreSQL YugabyteDB

Row Counts of Tables in a SQL Schema and Database: PostgreSQL vs. YugabyteDB

Getting the total row counts of data in tables across various dimensions (per-table, per-schema, and in a given database) is a useful SQL technique to have in your toolkit. This blog post will guide you to obtain per-table row counts of all tables in PostgreSQL and YugabyteDB. This can serve as a first sanity check after migrating an application with pre-existing data from PostgreSQL to YugabyteDB.

This blog post also outlines how to get the following row counts broken down per table in a schema,

…

PostgreSQL

Support for Geo-Partitioning and Enterprise-Grade Security Features

Challenges with Mainframes Today

How to use joins in UPDATE statements

Step 1: Install YugabyteDB on a GKE Cluster using Helm 3

YSQL

Is there a functional equivalent to Oracle’s NVL in PostgreSQL or YugabyteDB?

Explore Distributed SQL and YugabyteDB in Depth