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.
December 19, 2022
Databases
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.
September 29, 2022
Make the Most of Query Planner Hints in YSQL
Learn how to best use Query Planner hints in the YugabyteDB database to optimize business queries based on how applications expose them. Walk through a use case that utilizes data sets from two popular TV shows to find total viewership per season, episode, etc.
September 26, 2022
Export and Import Data with Azure Databricks and YugabyteDB
This blog explores how to import and export Avro (a row-based storage format file) and Parquet (a columnar storage format file) and how to process the data with a YugabyteDB database using Azure Databricks.
August 25, 2022
Comparing the Maximum Availability of YugabyteDB and Oracle Database
Finding one-to-one mapping of the differences between monolithic and cloud-native databases is difficult.
In this blog, we compare YugabyteDB and Oracle (RAC, Data Guard) via availability objectives.
This should help you understand how Oracle MAA options map to YugabyteDB’s intrinsic features when considering migration projects.
August 4, 2022
Unlocking Azure Storage Options With YugabyteDB CDC
In this blog, we explore how to transfer and process data from YugabyteDB (YBDB) to Azure Blob Storage or Azure Data Lake Storage using Azure EventHub through YBDB’s Change Data Capture (CDC) feature.
July 22, 2022
Announcing YugabyteDB 2.14: Higher Performance and Security
Our team continues to deliver new innovations, so we are excited to announce our latest stable release—YugabyteDB 2.14, which delivers higher performance, security and YugabyteDB Anywhere enhancements.
YugabyteDB is quickly becoming the cloud native relational database for the world’s most demanding enterprises, driving data-driven innovation in the face of growth, uncertainty, and change.
July 15, 2022
Yugabyte Engineering: Why I Decided to Join a Fast-Growing Startup
Hello. I’m Sahith, a Yugabyte engineering intern. I’m a 2022 Computer Science Engineer graduate from PES University in Bangalore who loves to solve problems with code. I also recently decided to join Yugabyte in a full-time engineering role. And lucky for me, this turned out to be one of the best decisions I’ve made.
However, before joining the company full time, I wanted to share some takeaways from my internship experience.
…
July 13, 2022
Java Development: How Applications Litter Beyond the Heap
In Java development, garbage collection is a routine task. Applications generate garbage all the time. And that garbage is meticulously cleaned out by CMS, G1, Azul C4 and other types of collectors. Basically, our applications are born to bring value to this world, but nothing is perfect—including our applications that leave litter in the Java heap.
However, the story doesn’t end with the Java heap. In fact, it only starts there. Let’s take the example of a basic Java application that uses a relational database—such as PostgreSQL—and solid state drives (SSDs) as a storage device.
…