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.
June 26, 2023
PostgreSQL
June 20, 2023
How to Select the First Row of Each Set of Grouped Rows Using GROUP BY
Discover efficient methods to partition data in your queries. Explore techniques like GROUP BY, window functions, recursive CTE queries, and the DISTINCT ON clause to optimize performance and scalability
June 13, 2023
How to Check Your PostgreSQL Version
Understanding the PostgreSQL version you’re using is crucial for feature availability and informed decision-making, especially with cloud-managed services. Continue reading to learn how to check your PostgreSQL version.
June 5, 2023
Indexing for LIKE Queries in PostgreSQL
Discover how the LIKE operator enables pattern matching with wildcards and indexing for specific access patterns, focusing on scenarios where the wildcard is at the beginning or end of the pattern. The examples and demonstrations are performed on YugabyteDB, a PostgreSQL-compatible database with variations in storage implementation.
May 30, 2023
Indexing JSON in PostgreSQL
When indexing JSON documents in PostgreSQL, you can add indexes for the access patterns just like with relational table columns. We will walk through an example of this using the Pokémon GO Pokédex as a dataset, utilizing YugabyteDB, a distributed SQL database compatible with PostgreSQL.
May 22, 2023
Generate SQL Script in PostgreSQL
DBAs often need to generate SQL statements using SQL queries and then execute them. PostgreSQL has many features that can help. Let’s walk through an example using YugabyteDB, which is Postgres-compatible and provides the same SQL language and catalog views.
May 15, 2023
Generate Random Text Strings in PostgreSQL
The Orafce extension for PostgreSQL can be used to quickly and easily generate random strings to fill in a text column. Let’s look at an example on how to use Orafce, on either your PostgreSQL database or on a PostgreSQL-compatible database, like YugabyteDB.
December 19, 2022
Handling Automatic ID Generation in PostgreSQL with Node.js and Sequelize
There are many ways to handle ID generation in PostgreSQL. In this blog, we’ll demonstrate four ways to do so in Sequelize for PostgreSQL and YugabyteDB.
November 2, 2022
How to Set Up a Mechanism to Capture pg_stat_statements in a Persistent Table
Let’s see how to capture pg_stat_statements from all the nodes in a persistent table to use for analysis. The data can then be stored in YugabyteDB tables, accessible from any node unless purged. Want to see how it can be done?
October 19, 2022
Client-Side vs Server-Side Latencies Demystified in PostgreSQL and YugabyteDB
Every SQL execution in PostgreSQL and therefore in YugabyteDB YSQL takes time to process. A common way to identify how much is time spent on processing is to use the pg_stat_statements view in the database. However, the time visible in pg_stat_statements might differ from the time a database client registers for the execution. Where does this difference come from? Let’s take a look.