Support for UNIX sockets

[nabilfreeman]

Hey there, Knex has support for UNIX sockets when socketPath is supplied to the connection: {} object.

The logic behind it is pretty straightforward, when socketPath is detected it ignores the host and port.

As this uses Knex I think it would be useful to add it. There are a lot of performance benefits to using sockets instead of TCP.

Happy to do this myself if you are accepting PRs.

Thoughts appreciated

[elhigu]

Probably not a really easy thing to make work. If you can pull it of nicely with tests it is welcome though.

As this uses Knex I think it would be useful to add it. There are a lot of performance benefits to using sockets instead of TCP.

For performance reasons, usually database runs in a separate computer than node backend. But it could be that some cloud platforms exposes the DB server through unix sockets instead of TCP.