enifsieus / vulndb

Ingesting and modeling tools for NVD (Vulnerabilities and Products) and OSV
Apache License 2.0
1 stars 4 forks source link

psycopg2 fails to install on mac arm64 m1 and misc installation issues #9

Open nettrino opened 6 months ago

nettrino commented 6 months ago

Hello,

Thanks for putting the project together, I tried a poetry install on mac and psycopg2 failed to install, and as a result (?) none of the vulndb admin commands work properly. Moreover the sql command described in the program assumes some program installed for users which might not be there so any additional context would be helpful

enifsieus commented 6 months ago

By the 'the sql command described in the program' are you referring to db/create.sql?

The primary means of database management is intended to be through the 'vulndb admin' command set. That does require psycopg2 to be working, but then so do most features in the code base, so it's something that you'll need to resolve to get much use from it. What is the issue that you're having?

Having said that, about 90% of the work to convert to sqlite3 and eliminate postgresql entirely is done, but it's uncertain right now when the final 10% will be completed.