[peiskos]

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.

[Superfud]

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