[Database] Trade-off study between SQL vs non-relational databases

[Chilly712]

Context

Currently we are using Heroku's cloud PostgreSQL database.

Cost of hosting PostgreSQL on Heroku: Free, with 1GB size limit and 20k row limit

The benefit of using a SQL database is unclear. Do we really need to perform complex database queries? The cost of using SQL database is the tedious and error-prone process of build custom SQL query string in Python, and sending query through Psycopg3 - a low level library where the program need to maintain configuration, connection and cursor

To-dos

Explore Key-value store/NoSQL database (Google Firestore, MangoDB, etc)