You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
This repository was archived by the owner on Apr 18, 2023. It is now read-only.
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
Context
Currently we are using Heroku's cloud
PostgreSQLdatabase.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 cursorTo-dos
Explore Key-value store/NoSQL database (Google Firestore, MangoDB, etc)