In YugabyteDB, a PostgreSQL backend process refers to the individual processes that manage SQL client connections in a PostgreSQL-compatible way. Built on […]
Read More
Tracking Last Login Time in YSQL
The log_connections parameter in YugabyteDB is a logging configuration option that records every connection attempt to the server to the PostgreSQL log file. […]
Read MoreTerminate Idle Sessions in YSQL
In YSQL (Yugabyte Structured Query Language), idle sessions refer to database connections that remain open but are not actively executing queries. These […]
Read MoreKeep Track of Who Created a Table and When…
When a table is created in YSQL, the catalog does not store information about the user who created it or the time […]
Read MoreA Cleaner Way to Extract Nested JSON Data in YSQL (with Postgres15 Support)
YSQL (YugabyteDB Structured Query Language) supports two dedicated data types to store JSON (JavaScript Object Notation) data. JSON Stores JSON data as […]
Read More