Change the database from SQLite to postgreSQL

thecodefoundation / Vison-WoC-Backend

Repository for Vison Backened for Winter of Code 2019.

MIT License

9 stars 6 forks source link

Change the database from SQLite to postgreSQL #2

Closed sunitasen closed 4 years ago

sunitasen commented 5 years ago

Create a database named vison.db
A table urls with column names urlId(text) and rank(integer) .
Choose an appropriate connector, you can look for the psycopg2 module.

Nerocodes commented 5 years ago

Can I work on this?

ayulockin commented 5 years ago

Sure go ahead. :) @Nerocodes

Nerocodes commented 5 years ago

Please, I'll like to clarify a few things.

Noticed there's already a Postgres database connection, I'm I to create a new one in a different folder or use the existing and add the column stated above?

ayulockin commented 5 years ago

Surely,

The requirement is have a Postgres database for the crawler. The Postres folder that you found is for the indexer. Create a new one in a different folder and proceed accordingly.

I hope this helps. :D

sunitasen commented 4 years ago

Hey @Nerocodes ! It's been a long time since we have not heard from you! 😞 I am unassigning you this issue as there is already a PR ready. Feel free to contribute to other issues!

Nerocodes commented 4 years ago

Apologies... I couldn't get around to it. Thank you for the opportunity