Support for external database server

[pierrehenrymuller]

Hi,
Is it possible to use a database server like MySQL or PostgreSQL instead of SQLite file?
Thanks

[cbrocas]

Hello Pierre Henry,
Yes, it is possible ... if the support for it is developed and merge into CertStreamMonitor ;-)
More seriously, we don't have the usage for the moment, so, we don't have developed it until now. Please, want to code it and submit it through a PR? We can provide assistance :)

[pierrehenrymuller]

Ok ;)
I'll try to make this but maybe I didn't do everything I needed to properly manage the sqlite.
Typically, I don't think I've seen a prune in the sqlite database that would remove entries older than N months. As a result, the sqlite base is constantly growing.
How do you manage the sqlite file when it gets bigger?

[cbrocas]

Currently, our dataset does not represent more than several megabytes, so cleanup the database has not been a priority for the moment. Another part of the problem is that removing entries in a Threat Intel context may not be the good solution in any context.
Btw I will code soon a script that is going to be able to remove entries that are no longer checked - see commit 0cbd5ad . Hope it will help.