how to

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

Pointer in C – All Mysteries Revealed Now

Cary Huang
January 1, 2024January 1, 2024
C Programming

Explore the fundamentals of a C pointer and learn how to use this unique C feature safely and confidently by real examples

Beware of Type Casting in C – How to do it Right

Cary Huang
November 29, 2023December 23, 2023
C Programming

Explore the principles of type casting in C programming to avoid misuse and loss of data precisions problems

Create Custom Data Types With the C Struct

Cary Huang
November 28, 2023December 23, 2023
C Programming

A C struct is one of the most common construct used in C programming. Learn to define, declare and use a C struct

Is The Goto in C still a Harmful Practice?

Cary Huang
November 23, 2023December 22, 2023
C Programming

Using the goto in C is often considered as a bad practice, but it is not always bad, let me show you one best use case with it

How Not To Exploit The C Loops

Cary Huang
November 20, 2023December 22, 2023
C Programming

Learn different types of C loops types in C programming and the best practices of using them with real examples

Common Usages of The C Switch Statement

Cary Huang
November 18, 2023December 22, 2023
C Programming

Learn the basic use cases with C switch statement, understand its advantages over if statements and avoid common mistakes with examples

A Deeper Look At The If Statement In C

Cary Huang
November 17, 2023December 22, 2023
C Programming

Learn the basics of if statement in C and its syntax to control to execution flow within your c program with examples

Unlock Your Arsenals: GDB Debugging Essentials with PostgreSQL

Cary Huang
October 30, 2023October 30, 2023
C Programming, postgresql

GDB is a powerful tool for any seasoned C developer. Explore the essentials of GDB debugging with PostgreSQL database as practical examples

Explore Practical PostgreSQL Substring Use Cases with Examples

Cary Huang
October 8, 2023October 12, 2023
postgresql

Explore the versatility of PostgreSQL substring function and learn how it can help with your string manipulation tasks.

All PostgreSQL Replication Explained – How to Do Them Right.

Cary Huang
September 20, 2023September 21, 2023
postgresql

Dive into the principles of PostgreSQL streaming replication and logical replication. Learn how to set them up properly

Achieve ISNULL Function in PostgreSQL 16 with Right Examples

Cary Huang
September 16, 2023December 20, 2023
postgresql

Explore the alternatives to achieve ISNULL PostgreSQL example. Learn to create your own ISNULL function in PostgreSQL 16