Conversational Queries with YugabyteDB Using The LangChain Framework
In this blog post, we’ll walk through how application’s data stored in YugabyteDB can be queried through natural language by using the Langchain Model.
October 17, 2023
Query
September 12, 2023
Dream Big, Go Bigger: Turbocharging PostgreSQL
At the 5th annual Distributed SQL Summit, Yugabyte CTO, Karthik Ranganathan unveiled product enhancements for YugabyteDB, supercharging PostgreSQL performance and addressing its traditional weak points with innovative features in YugabyteDB 2.19 and Voyager 1.5.
June 26, 2023
How to Create a Conditional WHERE Clause in PostgreSQL
Let’s walk through some examples to see the importance of the conditional WHERE clause in PostgreSQL, especially when dealing with data that requires extensive filtering.
May 23, 2023
Unlock Kubernetes and Simplify Operations: Introducing YugabyteDB 2.18
Introducing YugabyteDB 2.18! Accelerate data modernization with new cloud-native features, multi-region Kubernetes support, and simplified operations through YugabyteDB Anywhere’s enhanced automation and intelligence.
March 15, 2023
Fuzzy Matching in YugabyteDB
This blog discusses the performance issues with wildcard lookups in YugabyteDB and showcases alternative methods to find specific data in a large dataset, including several varieties of phonetic matching and trigrams. A test plan is provided to demonstrate basic query timings.
March 7, 2023
How To Design Distributed Indexes for Optimal Query Performance
In a distributed database, data is split into multiple tablets which reside on different nodes. So it is not just tables, but indexes, that are distributed across nodes. So let’s examine how to optimally design distributed indexes to get the best query performance.
April 24, 2020
Why We Built YugabyteDB by Reusing the PostgreSQL Query Layer
Opting for PostgreSQL’s native query layer in YugabyteDB, instead of building a new one from scratch, proved to be a key decision. Our initial attempt at creating a PostgreSQL-compatible layer showed that this approach was essential for developing a top-tier cloud-native RDBMS efficiently.
March 4, 2020
5 Query Pushdowns for Distributed SQL and How They Differ from a Traditional RDBMS
A pushdown is an optimization to improve the performance of a SQL query by moving its processing as close to the data as possible. Pushdowns can drastically reduce SQL statement processing time by filtering data before transferring it over the network, filtering data before loading it into memory, or pruning out entire files or blocks that do not need to be read. PostgreSQL is a highly optimized single-node RDBMS when it comes to pushdowns. Because Yugabyte’s YSQL API reuses the upper half of PostgreSQL,
…
August 1, 2019
Getting Started with SQL Workbench/J on a Distributed SQL Database
Although most databases ship with a command line utility to administer the instance, these utilities often come with a steep learning curve. If using the command line and learning sometimes arcane syntax makes you uncomfortable, there are graphical tools that can help you speed up many daily DBA tasks. In fact, you can find a comprehensive list of tools on the PostgreSQL wiki here. In a previous blog we explored the DBeaver database management tool,
…