Feature request: allow connecting over unix sockets

[Vinnl]

I recently adopted devenv.sh, and by default, the Postgres servers that it starts only accept connections over unix sockets. If it's already possible to connect to those using tarug, it's not obvious to me how to 😅

[ppvan]

@Vinnl I don't know much about unix domain socket. From libpq docs (what tarug use to conect), you can put absolute path to the "Host" field

If the host name starts with @, it is taken as a Unix-domain socket in the abstract namespace (currently supported on Linux and Windows). The default behavior when host is not specified, or is empty, is to connect to a Unix-domain socket in /tmp (or whatever socket directory was specified when PostgreSQL was built). On Windows, the default is to connect to localhost.

How would you connect to postgres using unix domain socket with psql tools? That could give some hint.

You can see the code that's build the connection string here:

tarug/src/models/Connection.vala

Lines 90 to 107 in 73c9e8f

	public string connection_string (int connection_timeout, int query_timeout){
	var ssl_mode = use_ssl ? "verify-full" : "disable";
	var options = @"\'-c statement_timeout=$(query_timeout * 1000)\'";
	var res = Resolver.get_default ();
	var adds = res.lookup_by_name (host, null);
	var host_addr = adds.nth_data (0).to_string ();
	var base_str = @"user=$user password=$password port=$port hostaddr=$host_addr dbname=$database application_name=$(Config.APP_NAME) sslmode=$ssl_mode connect_timeout=$connection_timeout options=$options";
	var builder = new StringBuilder(base_str);
	if (use_ssl) {
	builder.append(@" sslrootcert=$(cert_path) ");
	}
	return(builder.free_and_steal());
	}

Feel free to open a PR if you're able to