Implement database support for data that should be persisted - Githubissues

FoxxMD / context-mod

an event-based, reddit moderation bot built on top of snoowrap and written in typescript

https://contextmod.dev

MIT License

49 stars 11 forks source link

Implement database support for data that should be persisted #66

Closed FoxxMD closed 2 years ago

FoxxMD commented 2 years ago

Currently all data generated by CM is either in memory only or stored in the configured cache.

For the majority of data this is fine but there are now a few data structures that really should be persistent but are still stored in cache, only due to the convenience of using that data storage mechanism at the time i was developing it. Data that really should be persistent:

[x] actioned events
[x] statistics
[ ] last known info on client-server connections
[x] bot states (event, queue, bot running/stopped and by whom)
[ ] Image fingerprints

Main goals for database support are:

[x] Support multiple database types via config, interface should be agnostic (should use typeorm for this)
[x] avoid dependencies on db binaries (I'm looking at you sqlite, use sql.js instead)
[x] (optional) db access should be async

FoxxMD commented 2 years ago

Everything is done in 0.11.0 except fingerprints. Will close for now and open a new issue for fingersprint