ralphkb/sentinel-tickets

[FEATURE] MySQL Database external connexion

Closed this issue · 3 comments

OverStyleFR commented

Hi,

I wondering if you can setup a option for using a external database, i just see you using SQLlite for store the ticket and other stuff.
Maybye you can add a option to set the storage local or external, with :

  • SQL
  • Mongo
  • An other database
mrkingtj commented

It would be more suited for multi guild bots but since this bot is designed for single guild, you can just copy the main.sqlite and tickets.sqlite files onto another folder or google drive etc. But that is just my thoughts on it

OverStyleFR commented

It would be more suited for multi guild bots but since this bot is designed for single guild, you can just copy the main.sqlite and tickets.sqlite files onto another folder or google drive etc. But that is just my thoughts on it

Yeah of course, but if there is a external connection you can so just update the bot more easily.

I go too far but, if the config.yml can be saved on a database. You can so update your bot by just delete everything and upload the latest version, once it's down. You can imagine a command like restore and with the login connection to a external database restore the config.yml file and other stuff like main.sqlite & tickets.sqlite.
But it's a very ideal idea... I don't think it's possible or if it is, too many hours for not much.

But there is my vision with a feature "External Database connection"

ralphkb commented

Hey, I understand your point however for the time being I intend to keep the bot as simple as possible for users to setup and enjoy. I also think the NPM package I use for the database would probably allow me to easily add MySQL support at some point in the future so I might consider it later but for now I intend to keep it that way with SQLite.

Thanks for the suggestion though.