- https://en.wikipedia.org/wiki/Java_Database_Connectivity
- http://jan-lolling.de
- https://github.com/jlolling/sqlrunner
- https://github.com/JochenHayek/sqlrunner – my fork
I am giving Jan Lolling’s SQLRunner a try to connect to a local PostgreSQL database. SQLRunner is written in Java, and it uses JDBC to connect to the various databases.
Apparently there are 2 ways to connect to a PostgreSQL database:
- hostname + port + database + …
- socket + database + …
The 2nd way is not just a variant of the 1st (I got told).
It appears to me, that JDBC for PostgreSQL only supports the first way. Is there a way to get this assumption confirmed?
- http://stackoverflow.com/questions/25918416/jdbc-mysql-connection-using-unix-socket :
“Java itself doesn’t support unix domain sockets, but since you’re on windows, you can use named pipes, [..]” (I am not sure, this is true) - http://dev.mysql.com/doc/connector-j/5.1/en/connector-j-reference-configuration-properties.html : NamedPipeSocketFactory …