eikek / eikek/docspell

Unix socket for database connection

Open
#2,166 1 comment 2 reactions 0 assignees View on GitHub
Dominant language
Elm
Stars
2.3k
Forks
184
Avg merge
8h 2m
Merged PRs (30d)
4

Description

This is a follow-up of the bug #622, but I cannot reopen it, so I open a new one.

There is a library that allows using an unix socket for connecting to the database, [junixsocket](https://kohlschutter.github.io/junixsocket/). I have used it with keycloak, and you only have to add the dependencies to maven, or [whatever scala uses](https://kohlschutter.github.io/junixsocket/dependency-info.html). Then, the connection URL something like this (in my case with postgresql):

`jdbc:postgresql://localhost/keycloakdb?socketFactory=org.newsclub.net.unix.AFUNIXSocketFactory$FactoryArg&socketFactoryArg=/mnt/postgresql/.s.PGSQL.5432&sslmode=disable`

I would simply add this dependency, it's very easy and faster if the DB and docspell are in the same machine.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.