Knowledge & Insights

Blogs & Insights

Latest articles from HexaCluster on PostgreSQL, database migration, performance tuning, and database modernization.

Recent Articles

Connecting to PostgreSQL with Go using PGX

PostgreSQL has emerged as a reliable, feature-rich database used extensively across various industries. On the other hand, Go (Golang), known for its simplicity, efficiency, and strong standard libraries, has become increasingly preferred for modern

PostgreSQL has emerged as a reliable, feature-rich database used extensively across various industries. On the...

Aditya Surishetti

•Mar 20, 2024

Vector Indexing in Vector Databases

Database

A vector database stores data in the form of high-dimensional vectors. These vectors are embeddings of the original text, Images, audio or video files we want to store. In traditional databases, we store information in the form of relations where we

A vector database stores data in the form of high-dimensional vectors. These vectors are embeddings of the ori...

Surya Sree Bathini

•Mar 12, 2024

Data Navigation with PostgreSQL Cursors – Part III

postgresqlCursors

Welcome back to our series on PostgreSQL Cursors. As we continue exploring PostgreSQL Cursors, including Scrollable and Non-Scrollable Cursors, we’re now focusing on With-Hold Cursors in this article.

Welcome back to our series on PostgreSQL Cursors. As we continue exploring PostgreSQL Cursors, including Scrol...

Jagadeesh Panuganti

•Mar 11, 2024

IN, OUT and INOUT parameters in Oracle vs PostgreSQL

postgresqlDatabase

When migrating Oracle routines to PostgreSQL, handling OUT and INOUT parameters can be tricky. Understanding the distinctions between Oracle and PostgreSQL in how they manage these parameters is essential for a successful migration.

When migrating Oracle routines to PostgreSQL, handling OUT and INOUT parameters can be tricky. Understanding t...

Akhil Reddy Banappagari

•Mar 08, 2024

Exploring JSONB in PostgreSQL

postgresqlJSONB

PostgreSQL is a powerful Open-Source database management system and a migration target for Unstructured databases like MongoDB. as well as Relational databases like Oracle and SQL Server.

PostgreSQL is a powerful Open-Source database management system and a migration target for Unstructured databa...

Goutham Banala

•Mar 06, 2024

PostgreSQL Security - Password Reuse Policy

postgresqlpostgres_extensionsDatabase

A database password reuse policy is a set of rules that govern the use of passwords within a database system. The policy is designed to ensure that users create strong and unique passwords, and that they do not reuse the same password.

A database password reuse policy is a set of rules that govern the use of passwords within a database system. ...

Surya Sree Bathini

•Feb 29, 2024

Start your migration journey 🚀

start your migration journey with our expert team

Blogs & Insights

Recent Articles

Connecting to PostgreSQL with Go using PGX

Vector Indexing in Vector Databases

Data Navigation with PostgreSQL Cursors – Part III

IN, OUT and INOUT parameters in Oracle vs PostgreSQL

Exploring JSONB in PostgreSQL

PostgreSQL Security - Password Reuse Policy

Products

HexaRocket 🚀

Migration Services

PostgreSQL Consulting