# pgjdbc/pgjdbc

Postgresql JDBC Driver

Repository: https://github.com/pgjdbc/pgjdbc
Canonical: https://ross.abutalabs.com/products/pgjdbc
Homepage: https://jdbc.postgresql.org/
Language: Java
License: BSD-2-Clause
License Family: permissive
Topics: jdbc, java, postgresql
Last push: 2026-08-23T08:20:17+00:00

## Health v2 (maintenance only)
Score: 93/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 99, release rhythm 80, longevity 100
- inputs: {"age_days": 5322, "days_push": 10, "days_rel": 58, "gap_med": 69.0, "n_releases_24m": 9}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 1731, forks 941 (observed 2026-08-28T04:05:28.670386+00:00)

## What it is
PgJDBC is the official open-source PostgreSQL JDBC driver, written in pure Java (Type 4) and communicating via the PostgreSQL native network protocol. It lets Java programs connect to and query PostgreSQL databases using standard, database-independent JDBC code, with support for SSL, SCRAM authentication, connection pooling, and PostgreSQL-specific extensions.

## Use cases
- connect a Java application to a PostgreSQL database
- run SQL queries and process result sets from Java
- use PostgreSQL with JDBC-based ORMs like Hibernate
- configure SSL and SCRAM channel-binding for secure database connections
- call PostgreSQL stored procedures and functions from Java
- store and retrieve binary data (bytea, large objects) in PostgreSQL
- use PostgreSQL in a servlet or multithreaded Java server environment

## When to choose
- your Java or JVM application needs to talk to PostgreSQL
- you want a pure-Java, platform-independent driver with no native dependencies
- you need full JDBC 4.2 compliance plus PostgreSQL-specific features like jsonb, arrays, and replication
- you need a mature, actively maintained driver with regular security fixes

## When to avoid
- you are connecting to a database other than PostgreSQL
- you need a non-JVM language driver (use libpq, psycopg, node-postgres, etc.)
- you require reactive/R2DBC access instead of blocking JDBC

## Facets
- artifact type: library
- maturity: stable
- function: database-driver, database, auth, security
- domain: databases, developer-tools, backend, apis
- platform: jvm, cross-platform
- tags: jdbc, postgresql, type-4-driver, sql, connection-pooling, ssl, scram-authentication

## Member repositories
- pgjdbc/pgjdbc (main) score 93

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:05:28.670386+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T03:31:43.564148+00:00, confidence not recorded.
  - readme: https://github.com/pgjdbc/pgjdbc (fetched 2026-08-28T04:05:28.670386+00:00, sha 93e854de40c4)
  - homepage: https://jdbc.postgresql.org/ (fetched 2026-08-29T11:08:51.948231+00:00, sha 1a2f4a2d4d82)
  - site_page: https://jdbc.postgresql.org/documentation (fetched 2026-08-29T11:08:51.957405+00:00, sha 1b4810acf3c6)
  - site_page: https://jdbc.postgresql.org/changelogs (fetched 2026-08-29T11:08:51.959295+00:00, sha 9c93deea084d)
  - site_page: https://jdbc.postgresql.org/changelogs/2026-07-06-42.7.13-release (fetched 2026-08-29T11:08:51.961212+00:00, sha 182230abb1af)
  - site_page: https://jdbc.postgresql.org/changelogs/2026-06-29-42.7.12-release (fetched 2026-08-29T11:08:51.964626+00:00, sha 4a9bc4dd3789)
  - site_page: https://jdbc.postgresql.org/changelogs/2026-04-28-42 (fetched 2026-08-29T11:08:51.967139+00:00, sha eaa9db0909fc)
  - site_page: https://jdbc.postgresql.org/changelogs/2026-01-15-42 (fetched 2026-08-29T11:08:51.969302+00:00, sha c87d3b9560da)
  - site_page: https://jdbc.postgresql.org/changelogs/2025-09-18-42 (fetched 2026-08-29T11:08:51.971498+00:00, sha f49349bb6d51)
  - site_page: https://jdbc.postgresql.org/changelogs/2025-06-11-42 (fetched 2026-08-29T11:08:51.973477+00:00, sha 37213e5ebaeb)
- Data as of 2026-08-30T08:39:29.467469+00:00.