threatnote icon indicating copy to clipboard operation
threatnote copied to clipboard

Using Postgres over SQLite

Open krish203 opened this issue 4 years ago • 1 comments

From here: https://github.com/brianwarehime/threatnote/blob/master/threatnote/config.py#L21 looks like sqlite is the default db. Since this project seems to be using SQLAlchemy can we just customize https://github.com/brianwarehime/threatnote/blob/master/threatnote/config.py#L20 to use Postgres or MySQL ?

krish203 avatar Nov 22 '21 23:11 krish203

Looks like I was able to modify env file to point to a Postgres database. However, there seems to be no SQL Schema, and the SQLAlchemy backend keeps throwing all kinds of errors if I try and convert the base SQLite schema to postgres.

krish203 avatar Feb 14 '22 17:02 krish203