Notes

A collection of technical notes and tutorials where I document experiments, share coding practices, and provide structured insights for developers.

Installing PostgreSQL on MacOS Article Image

Installing PostgreSQL on MacOS

Install PostgreSQL on macOS step by step, covering Homebrew setup, configuration, and service manage...

Advanced Oracle SQL Query Examples Article Image

Advanced Oracle SQL Query Examples

Explore advanced Oracle SQL query examples, including analytic functions, hierarchical queries, and ...

2.4GHz vs 5GHz Wi-Fi: Performance, Interference and Manual Control Explained Article Image

2.4GHz vs 5GHz Wi-Fi: Performance, Interference and Manual Control Explained

Compare WiFi 2.4GHz vs 5GHz bands, highlighting speed, range, interference, and best use cases to he...

PostgreSQL Advanced Query Examples Article Image

PostgreSQL Advanced Query Examples

Explore advanced PostgreSQL query examples, including window functions, recursive queries, CTEs, and...

Backing Up and Restoring PostgreSQL Databases Article Image

Backing Up and Restoring PostgreSQL Databases

Learn PostgreSQL backup and restore techniques, covering pg_dump, pg_restore, custom formats, and be...

Backing Up and Restoring MongoDB Article Image

Backing Up and Restoring MongoDB

Learn MongoDB backup and restore techniques, covering mongodump, mongorestore, BSON formats, and bes...