Feature Request: Port database to SQlite

[logicallysynced]

Just a thought while trying to get this up and running for myself..

Could you possible port the database aspect of this bot to SQLite? That way you can store all your database stuff in a single file and include it with your dist. Seems much more efficient than having to rely on MySQL and all the overhead that comes with that.

https://www.sqlite.org/index.html

On that note, could you please provide a template to upload to my MySQL db to populate the tables?

[Citillara]

Can add the scripts for generating the database no problem. Will upload them in the day.

SQL Lite has never been considered because a website is also used for management (exemple : https://www.citillara.fr/citibot/c/elbody/cookies/flavours)

[Citillara]

I added the database creation script and some example data that you'll need to start the bots.

Don't forget that you'll also need the 2 others projects that I made TwitchClient and IrcClient.

You will also need to generate an irc oauth token for twitch which you can do there https://twitchapps.com/tmi/

[Citillara]

With incoming architecture V3, the data access will be decoupled from the current framework. Instead the bot will ask for Interfaces to retrive data

[Citillara]

Still thinking on it