Add MySQL support

[Alberto Lara]

I need mysql support to have a database and use to create scripts. linking ts3, mnecraft and sinusbot.

 

[mtrex]

+1 I was about to write the same.
Is there any way to use a database by now?

I'd like to save a lot of data and make queries on it. A key/value storage isn't suitable for that.

Methods I'm aware of:

• Sinusbots setVar()and getVar() methods
• AJAX-Requests to a webapp that can access a database

 

[Multivitamin]

Why dont use a Web API?

 

[kanalumaddela]

MySQL support would be nice to store lists of users/groups, playlists, music (youtube links), and whatever else is possible. And it would definitely be easier imo for scripts to use this instead. A database under the name of "sinusbot" for example could have tables for each script prefixed with a unique name for the script.

Take ZT Support Channel for ex (zent_supporter, zent_channels) and other info that could be needed. Private Channels can keep track of users and what not (privchan_groups, privchan_channels)

 

[Xuxe]

I don't think that the Bot Core gets MySQL Support you could write a Web API for example with PHP or Nodejs and use the Bot Http Calls

http://blog.modulus.io/build-your-first-http-server-in-nodejs
https://github.com/felixge/node-mysql
- very simple

 

[Lala Sabathil]

I don't think that the Bot Core gets MySQL Support you could write a Web API for example with PHP or Nodejs and use the Bot Http Calls

http://blog.modulus.io/build-your-first-http-server-in-nodejs
https://github.com/felixge/node-mysql
- very simple

jop, ist ganz leihct

 

[Alberto Lara]

better add MariaDB

 

[mtrex]

Yeah it's "easy" to use HTTP-calls, but they add an additional layer to the bot that needs to be maintained.
It wouldn't be as easy as it is to share plugins, if they require a specific webserver, configuration or other dependencies to access a database.

In my eyses the easiest solution regarding dependancies/installation for beginners would be if sinusbot would feature a database-wrapper and a built-in SQLite-database. Most plugins could just use the database like kanalumaddela outlined and sophisticated users could later on use other databases like MariaDB or MySQL if the plugin or amount of data really requires that.

But I see that this is a rather complex feature request

 

[sync667]

MySQL support could fix my script problems, but don't think that @flyth have time to add that. Of course if sinusbot use sqllite now is not hard thing. I have an idea because I need that much now and this would help a lot in my panel development I will give it a try. I will do it too ways for beginners so they could just type mysql auth data and connect to it by php framework on my servers in ssl and second way that users could download framework and put it on own server. Second possibility is that we could do database too so users don't need own server at all and store data on our secure servers. We have a lot of resources so it won't be a problem.

I will start diging into this topic but you could help me about with data should be stored. About scripts they could use mysql support script as am API to store data instead of servar etc.