All drivers and client libraries¶

Drivers and adapters for supported programming languages, frameworks, and environments.

PostgreSQL¶

The drivers listed here all use the CrateDB PostgreSQL interface.

Driver/Adapter

Description

Info

PostgreSQL ODBC

The official PostgreSQL ODBC Driver. For connecting to CrateDB from any environment that supports it.

.NET

Npgsql

An open source ADO.NET Data Provider for PostgreSQL, for program written in C#, Visual Basic, and F#.

.NET

CrateDB Npgsql fork

This fork of the official driver was needed prior to CrateDB 4.2.

Golang

pgx

A pure Go driver and toolkit for PostgreSQL.

Java

PostgreSQL JDBC

The official PostgreSQL JDBC Driver. For connecting to CrateDB from any environment that supports it.

Java

CrateDB PgJDBC fork

For connecting to CrateDB with specialized type system support and other tweaks. Ignores the ROLLBACK statement and the hstore and jsonb extensions.

Node.js

node-postgres

A collection of Node.js modules for interfacing with a PostgreSQL database using JavaScript or TypeScript.

Has support for callbacks, promises, async/await, connection pooling, prepared statements, cursors, streaming results, C/C++ bindings, rich type parsing, and more.

PHP

PDO_PGSQL

For connecting to CrateDB from PHP, supporting its PDO interface.

PHP

AMPHP

For connecting to CrateDB using AMPHP, an Async PostgreSQL client for PHP. AMPHP is a collection of high-quality, event-driven libraries for PHP designed with fibers and concurrency in mind.