This repository was archived by the owner on Apr 1, 2022. It is now read-only.
Repository navigation
This repository was archived by the owner on Apr 1, 2022. It is now read-only.
Change DB Configuration from sqlite to Postgres #27
Description
Describe the bug
Currently, the code has SQLite configuration, this should be changed to Postgres as it is supported by Heroku
What is the DB being used for?
The DB will store user information and the user's current stage in the bot.
The stages are in reference to gamification which will happen in the future.
The DB will also store all the messages that will be used in the bot.
Model structure
Messages
Index| Message| response_id| gif_id
Users
index| Full_name| game_stage|
Steps to take
- Install psycopg2
- Install flask-sqlalchemy
- freeze requirements.txt
- create models folder and add -> init.py, game_users.py, messages.py
- add tests
Activity
vj-codes commentedon Jul 28, 2020
@aboullaite I would like to fix this!
psycopg and flask sqlachemy should be done in requirements.txt right?
Awinja-j commentedon Jul 28, 2020
@vj-codes yes!
vj-codes commentedon Jul 30, 2020
@elinguiuriel the latest version of psycopg is psycopg2 should that be installed instead?
Awinja-j commentedon Jul 30, 2020
@vj-codes yes, install the latest version.
prilcool commentedon Aug 2, 2020
Yes I agree we should use MySQL or PostgreSQL .
Sqlite should not be used if this is going to be a large scale application since sqlite handles read/write operations in a serialized way this will create bottle necks