Knowledge Base

Blog

Technical write-ups focused on cybersecurity, software engineering, architecture, and practical tooling.

4 articles visible

Overview of data types in PostgreSQL banner

04/12/2024 · 5 min

Overview of data types in PostgreSQL

PostgreSQL is a powerful and extensible relational database management system (RDBMS). It supports a wide range of data types that allow precise modeling of diverse information. Below is a detailed overview of PostgreSQL

#postgresql
open >
Querying JSON in PostgreSQL banner

25/11/2024 · 4 min

Querying JSON in PostgreSQL

PostgreSQL is a powerful open-source relational database system that supports advanced data types, including **JSON** and **JSONB**. These types allow you to store and query semi-structured data efficiently, combining the

#postgresql
open >
Encryption with pgcrypto in PostgreSQL banner

21/11/2024 · 3 min

Encryption with pgcrypto in PostgreSQL

The `pgcrypto` module in PostgreSQL provides cryptographic functions for encrypting and decrypting data. It supports both symmetric encryption (using a single key) and public-key encryption (using a pair of keys). It's pa

#postgresql
open >