February 2024

Modernize PostgreSQL Certificate Revocation List with OCSP Stapling

David Zhang
February 28, 2024February 28, 2024
external, security

The Online Certificate Status Protocol (OCSP) serves to real-time validate the status of a certificate, offering a much better alternative to the Certificate Revocation List (CRL). OCSP Stapling, utilized in SSL/TLS protocols, involves the server proactively transmitting a recent OCSP response alongside its certificate during the handshake. This enables the client to verify the certificate’s status without direct communication with the OCSP responder

Easy JSON Parsing with libjansson Tutorial in C

Cary Huang
February 20, 2024February 20, 2024
C Programming

libjansson is one of the C libraries to work with JSON files. Learn how to use this library to parse and create JSON data

A Guide to Set up TLS Security in PostgreSQL

David Zhang
February 9, 2024February 28, 2024
external, security

PostgreSQL is a robust open-source database management system, earning the distinction of DBMS of the Year 2023. Users choose PostgreSQL due to various reasons, such as SQL support, Query Optimization, and Reliability, etc. In this blog, I will guide you through the process of setting up a TLS connection between a PostgreSQL server and the psql client using self-signed certificates

PostgreSQL Query Processing – A Comprehensive Overview

Cary Huang
February 9, 2024February 28, 2024
external

PostgreSQL performs several stages of processing to turn a query into results in shortest amount of time. Learn the sophisticated internal processing of PostgreSQL as a database developer

Easy Config File Management with libconfig Tutorial in C

Cary Huang
February 7, 2024February 11, 2024
C Programming

Libconfig is a easy to use C library to manage configuration files for C applications. Learn the basics to intermedia use cases with examples