Database integration

[Happy-Ferret]

Group configuration, filters, stickers, Welcome/Goodbye messages and other persistent data need to be stored in a database.

Viable options are PickleDB and MongoDB, with a preference for the latter.

[Happy-Ferret]

• Evaluate PickleDB and MongoDB
  • Is key-value storage enough, or is a full fledged document database the better option?
    • consider the bot being used by a number of supergroups. Scalability.

TODO: Simple example of getting a value out of either DB (Welcome message).

PickleDB

Upsides

• Doesn't require a complex setup or external driver.

Downsides

• Less flexible. Key-value only (does have lists/dicts, alas).
  • Will require lots of parsing and sanitizing.
• Limited migration options.
• No active development.
  • Most recent version (0.9) is more than 2 years old.

MongoDB

Upsides

• Flexible (full fledged document database)
• Well documented
• Actively developed
• Drivers for most mainstream programming languages.
• Simplified migration

Downsides

• Requires a database cluster.

• Pick a MongoDB Atlas cluster
  • Location? Maybe outside of Europe due to impending Telegram crackdown in Germany?