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 has been 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
The text was updated successfully, but these errors were encountered:
Chilly712
changed the title
[Database] Trade-off study between NoSQL vs SQL
[Database] Trade-off study between SQL vs non-relational databases
Jun 8, 2022
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 cursorTo-dos
Explore Key-value store/NoSQL database (Google Firestore, MangoDB, etc)
The text was updated successfully, but these errors were encountered: