Start Now

Category: PostgreSQL

Is Your Distributed Database PostgreSQL Compatible, and Why Does This Matter?

Is Your Distributed Database PostgreSQL Compatible, and Why Does This Matter?

Most companies now realize that compatibility with a widely adopted SQL API is essential to ensure the success of their modern distributed SQL databases.

But, there are many SQL database options available and each one takes a different approach to PostgreSQL compatibility. This can have major implications for the developers and applications leveraging these databases.

In this on-demand webinar, Yugabyte CTO and Co-Founder Karthik Ranganathan discusses the key criteria you can use to evaluate PostgreSQL compatibility.

Read more

Connecting to YugabyteDB with Arctype, a Collaborative SQL Client

Connecting to YugabyteDB with Arctype, a Collaborative SQL Client

YugabyteDB is PostgreSQL compatible. It uses the same protocol and SQL layer as PostgreSQL. This makes YugabyteDB compatible with a majority of database tools, because PostgreSQL is the most popular open source database on the planet. Here is an example with Arctype, a user-friendly collaborative SQL client to query and visualize data.

Setting up a database connection

1. I went to https://arctype.com/ and downloaded the client for Windows.

Read more

Using the PostgreSQL Recursive CTE – Part Two

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

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

YugabyteDB Fundamentals Training Q&A – Jan 28, 2021

YugabyteDB Fundamentals Training Q&A – Jan 28, 2021

Yesterday we had almost 200 folks show up for the latest “YugabyteDB Fundamentals and Certification” training session. We had a lot of questions during the session and weren’t able to get to them all! In this blog I have compiled the majority of them and provided answers in a simple Q&A format.

Missed yesterday’s training? You can catch our next training session, “YugabyteDB YSQL Development and Certification and Training” on Feb 25 by registering here.

Read more

Free Copy of SQL Cookbook, 2nd Edition from O’Reilly Media

Free Copy of SQL Cookbook, 2nd Edition from O’Reilly Media

We are excited to have teamed up with O’Reilly Media to offer developers a free copy of the SQL Cookbook, 2nd Edition. SQL remains the lingua franca of the relational database world. But where do you turn when you have questions you need to answer in your day-to-day use of the query language? Let the new SQL Cookbook, 2nd Edition be your new go-to guide for all things SQL. Previously available in a preview version,

Read more

Using PostgreSQL Aggregate Functions in YugabyteDB to Analyze COVID-19 Data

Using PostgreSQL Aggregate Functions in YugabyteDB to Analyze COVID-19 Data

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; and (2) Query Layer.

Read more

Announcing YugabyteDB 2.5

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.

Read more

Distributed SQL Summit Recap: Envoy and Service Meshes for Databases

Distributed SQL Summit Recap: Envoy and Service Meshes for Databases

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,

Read more

Distributed SQL Summit Recap: Mainframe Modernization

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,

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