@suriyasg

PostgreSQL Execution Plans

Feb 8 · 6 min read · Sample Query SELECT * FROM "customer" INNER JOIN "branch" ON ("customer"."branch_id" = "branch"."id") LEFT OUTER JOIN "customer_attribute" ON ("customer"."id" = "customer_attribute"."customer_id") WHERE ("branch"."organization_id" IN ('9ea8d10f-0e9c-...

Vulnerability Scan with Nessus Essential

Aug 30, 2025 · 4 min read · Introduction “Nessus Essentials is a free product from Tenable that provides high-speed, in-depth vulnerability scanning for up to 16 IP addresses per scanner.”- tenable. It helps automate identifying security flaws, misconfigurations, and potential...

The Beginning

Mar 1, 2025 · 1 min read · On 1 March 2025 - I might update as I go on this journey. In my chat application now I have a direct chat with End-To-End-Encryption using Hybrid-encryption. In future let's see how it goes and see what features we can incorporate. and what kind of o...

Postgres Vs MySQL

Dec 1, 2024 · 2 min read · Below these are some commands to start server and login to terminal client in macOS and DDLs Operation PostgreSQL Command MySQL Equivalent Start the server pt_ctl -D /path/to/data start sudo /us

Not A tutorial For Fork

Nov 28, 2024 · 2 min read · fork() is used to create a new process. The child process is almost an exact copy of the parent, inheriting its memory, file descriptors, and more. However, there's more happening beneath the hood than meets the eye. Let’s get started with one simple...