search

sudogroup / SudoBot

A Bot that will do everything for the server, from playing songs to pouring coffee and making you تقدع
https://sudo.group
GNU General Public License v3.0
2 stars 0 forks source link

Implementing Database #35

Open ma7dev opened 3 years ago

ma7dev commented 3 years ago

Is your feature request related to a problem? Please describe. We don't have a database to store needed values for a continuous integration of bot features. Describe the solution you'd like We will set up an SQLite database to store streamers, projects, and mute_list for the first release.

ma7dev commented 3 years ago

I have implemented the sqlite3 database, however, I haven't tested it and implemented into other components. Will do this later.

ma7dev commented 3 years ago

I couldn't setup sqlite3-offline on raspberry pi. I have tried with multiple nodejs versions "{12,10,9,8}.0.0", but couldn't make it to work. I think using sqlite3 might be an issue to deploy it on raspberry pi. It might be because raspberry pi arch. doesn't support this type of stuff (although sqlite3 as a program works, the nodejs package doesn't work).

Next step, try to use mongodb or something similar. Maybe try to use an external service for database management or use a different server to deploy the bot.

ma7dev commented 3 years ago

It seems that issue that I have was sqlite3 was taking too long to compile on the edge-devices (Jetson Nano and Raspberry Pi 3b). However, it works right now!

I will need to implement the other functionalities of the databases to test this behavior.

ma7dev commented 3 years ago

I have added streamers to the streamer table. I will modify the notification and check the streamers' status later this weekend. In addition, I will do the same for the project table.