Liking cljdoc? Tell your friends :D

wagoe.platform.shell.adapters.database.postgresql.connection

PostgreSQL connection settings and JDBC URL.

PostgreSQL connection settings and JDBC URL.
raw docstring

build-jdbc-urlclj

(build-jdbc-url {:keys [host port name application-name statement-timeout-ms]})

Build the PostgreSQL JDBC URL from db-config.

Session settings ride on the URL so every physical connection in the pool gets them:

  • stringtype=unspecified: let the server infer the type of string literals
  • ApplicationName: identifies the connection in pg_stat_activity
  • options: statement_timeout guard, and a TimeZone that does not take — pgjdbc sends the JVM's timezone in the startup packet after options, so sessions run in local time (BOU-431)
  • reWriteBatchedInserts: batches multi-row INSERTs into single statements
Build the PostgreSQL JDBC URL from `db-config`.

Session settings ride on the URL so every physical connection in the pool
gets them:
- stringtype=unspecified: let the server infer the type of string literals
- ApplicationName: identifies the connection in pg_stat_activity
- options: statement_timeout guard, and a TimeZone that does not take —
  pgjdbc sends the JVM's timezone in the startup packet after `options`,
  so sessions run in local time (BOU-431)
- reWriteBatchedInserts: batches multi-row INSERTs into single statements
sourceraw docstring

pool-defaultsclj

HikariCP defaults for a server database.

HikariCP defaults for a server database.
sourceraw docstring

session-statementsclj

(session-statements _db-config)

A connectivity probe only. The session settings are on the JDBC URL above — a SET here would reach just the one pooled connection that ran it.

A connectivity probe only. The session settings are on the JDBC URL above —
a SET here would reach just the one pooled connection that ran it.
sourceraw docstring

cljdoc builds & hosts documentation for Clojure/Script libraries

Keyboard shortcuts
Ctrl+kJump to recent docs
Move to previous article
Move to next article
Ctrl+/Jump to the search field
× close