Very interesting writeup OP!! This sounds like something definitely worth trying!!

Very interesting writeup OP!! This sounds like something definitely worth giving a try.

If anyone has other interesting link blogs, do share them here

A bit off topic, can someone suggest how I can learn more about using databases(postgres specifically) in real world applications? I am familiar with SQL and common ORMs, but I feel the internet is full of beginner level tutorials which lack this depth.

For PostgreSQL, the manual is extremely well written, and is warmly recommended reading. That should give you a robust foundation.