Is MySQL database supported or only SQLite and MongoDB? I looked in the documentation but didn’t find an answer. If yes then please also mention how to configure it.

Thanks for the reply. I’ll file a feature request as I think MySQL support is very important for adoption. MySQL allows connecting to the database directly and executing complex queries that are not supported via the api. I believe it shouldn’t be too hard since it’s not too different from SQLite. …

Cockpit needs as JSON based db (Document storage). So the recommended db is mongodb here. Sqlite is used as an alternative because you can register custom sql functions to simulate a document storage. this is not possible with mysql.

Thanks. I understand better now. So the structure is not relational to start with which would not make it very useful for making direct sql queries.

Actually with mysql 5.7 there is a JSON data type which I use all the time for document storage - it shouldn’t be such a big deal to convert.

[image] artcote: it shouldn’t be such a big deal to convert. This was already done. Have a look at: [image] GitHub - piotr-cz/cockpit-sql-driver: SQL Driver for Cockpit CMS SQL Driver for Cockpit CMS. Contribute to piotr-cz/cockpit-sql-driver development by creating an account on…

Is it still working in v2? I tried to use it, but failed :wink:

Is MySQL database supported

Support

raffaelj September 28, 2020, 8:58am 7

This was already done. Have a look at:

Topic		Replies	Views
New Addon: SQL Driver for Cockpit Addons	16	6892	July 15, 2020
I need help to understand Cockpit, database concepts and query system Support	4	3832	May 10, 2019
SQLite performance (indexing) and Discussion to Switch to MongoDB Support	3	1748	February 24, 2020
Hello everyone. What can I do for cockpit? General	3	772	November 2, 2021
NoSQL speed ? It's MongoDB available? Support	2	584	December 18, 2018

Is MySQL database supported

Related topics