Database socket connections

[miken32]

There appears to be no way to connect over a database socket. I'm trying to use MariaDB and from what I can see in server/core/db.js there simply aren't any options for this common situation. Assuming the backend driver supports it (mysql2 does, I assume others do as well) it should be a simple matter to accept them in the configuration and pass them on?

[miken32]

Just so there is a workaround for others to find, you can use a connection string. The parameters in the "query string" are not well documented but it seems that mysql2 takes the same options as the connection object, and not the documented ones (e.g. socketPath instead of socket.) As with any URI, special characters are percent encoded.

DATABASE_URL="mysql://wikijs:wikijsrocks@localhost/wiki?socketPath=%2Frun%2Fmariadb%2Fmariadb.sock" node server

This should still be supported in the config file though.

[jjabba]

I just added support for socket connection in this draft PR #7839

I expect to iterate before we can merge, but since the database lib used (knex) supports sockets it's dead simple to implement.