Skip to content
This repository has been archived by the owner on Jul 29, 2021. It is now read-only.

Implementing Database #35

Open
ma7dev opened this issue Jan 31, 2021 · 4 comments
Open

Implementing Database #35

ma7dev opened this issue Jan 31, 2021 · 4 comments
Assignees
Labels
enhancement New feature or request urgent

Comments

@ma7dev
Copy link
Contributor

ma7dev commented Jan 31, 2021

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 ma7dev added enhancement New feature or request urgent labels Jan 31, 2021
@ma7dev ma7dev self-assigned this Jan 31, 2021
@ma7dev
Copy link
Contributor Author

ma7dev commented Jan 31, 2021

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

@ma7dev
Copy link
Contributor Author

ma7dev commented Feb 1, 2021

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 ma7dev linked a pull request Feb 3, 2021 that will close this issue
@ma7dev
Copy link
Contributor Author

ma7dev commented Feb 4, 2021

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
Copy link
Contributor Author

ma7dev commented Feb 5, 2021

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.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
enhancement New feature or request urgent
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant