search

fbdevelopercircles / open-source-edu-bot

Open Source Education bot, built by the Developer Circles community.
MIT License
59 stars 79 forks source link

Change DB Configuration from sqlite to Postgres #27

Open Awinja-j opened 4 years ago

Awinja-j commented 4 years ago

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

  1. Install psycopg2
  2. Install flask-sqlalchemy
  3. freeze requirements.txt
  4. create models folder and add -> init.py, game_users.py, messages.py
  5. add tests
vj-codes commented 4 years ago

@aboullaite I would like to fix this! psycopg and flask sqlachemy should be done in requirements.txt right?

Awinja-j commented 4 years ago

@vj-codes yes!

vj-codes commented 4 years ago

@elinguiuriel the latest version of psycopg is psycopg2 should that be installed instead?

Awinja-j commented 4 years ago

@vj-codes yes, install the latest version.

prilcool commented 4 years ago

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