sql: Driver & ORM List

[BramGruneir]

This is meta issue to serve as a list of known drivers and ORMs that we would like to support. I'll be keeping this top description updated, so if there are any other drivers and ORMs that are not on this list, please comment and I'll add them. Note that these are ordered alphabetically and not by priority. If there is a tracking issue for any of them, it will be linked to from here.

This list is not exhaustive (I just looked for ones we have open issues for), but I would like to keep this as up to date as possible, so it can be somewhat of a source of truth.

C++

• libpqxx
• SOCI

Clojure

• JDBC wrapper

Elixir

• Postgrex
  • sql/pgwire: Elixir Connection Issues - Postgrex Protocol Errors - First Test #5582
  • sql: Ecto compatibility #33441 Ecto

Go

• Go-PG
  • sql: Support Go ORM: go-pg #14379
• GORM
  • sql: Golang GORM not creating the db. #24838
• pq
• XORM
  • sql: grafana support #17161

Java

• Hibernate
  • sql: support features used by Hibernate #16491
• JDBC

.Net

• npgsql
  • sql: npgsql support #25462
• .NET Core 3.x and NPoco
  • User reports working well

Node.js

• pg
• Sequelize
  • sql: update Sequelize Support to 4.x #33192 - Update to v4
• TypeORM
  • sql: TypeORM support for Node.js Apps #22298
• Knex.js
• MeteorJS

Perl

• DBD::Pg

PHP

• Doctrine
  • sql: Compatibility with Doctrine/Symfony #19337
• PostgreSQL
• Yii2
  • sql: PHP Yii2 ORM compatibility #25461
• Laravel

Python

• psycopg2
• SQLAlchemy
• Django
  • sql: Django compatibility #25608
• py-postgresql
  • pgwire: python3 py-postgresql driver error #13191

Ruby

• ActiveRecord
  • sql: ActiveRecord / Rails ORM support #20932
• pg

Rust

• Diesel
  • sql: support diesel-rs #13787
• postgres

Multiplatform

• Prisma.io
  • Magic introspection naming prisma/prisma#1705

[kocoten1992]

Laravel eloquent: https://laravel.com/docs/master/eloquent (it should be similar with ActiveRecord)

[BramGruneir]

Thanks @kocoten1992, added!

[abaumhauer]

Perl DBIx::Class likely via the DBD::Pg driver

[BramGruneir]

Thanks @abaumhauer, added!

[dtrinh100]

Not a true ORM, but I would love to see CockroachDB support for Prisma

[handrus]

Would be great to see Knex

[BramGruneir]

Added both Prisma and Knex to our list. Thanks!

[drewdeally]

Bram, Adding MeteorJS as per customer request.

[BramGruneir]

@drewdeally Added to the list. Thanks.

[irvingpop]

hi @BramGruneir ! Would you consider adding sqitch to the list?

Against cockroachDB, a sqitch deploy fails with an unimplemented error:

$ sqitch --verbose deploy "db:pg://${USER}:${PASS}@${HOST}/$DB"

ERROR:  unimplemented at or near ","
DETAIL:  source SQL:

        SELECT c.change_id
             , c.script_hash
                 , c.change
             , c.project
             , c.note
             , c.committer_name
             , c.committer_email
             , to_char(c.committed_at AT TIME ZONE 'UTC', '"year":YYYY:"month":MM:"day":DD:"hour":HH24:"minute":MI:"second":SS:"time_zone":"UTC"') AS committed_at

[BramGruneir]

Hi @irvingpop,

Of course! But it's a schema change management system, so I've added it to #25469 instead.

I'm pretty sure it's the to_char that we don't support. That's some old postgres syntax that is supposed to be deprecated but is still used all over. See #3781 for that main issue for that one.

[BramGruneir]

@irvingpop I forgot to mention, we offer online schema change, so there might be less of a need for systems like sqitch. They're still useful for testing and dev, but there's now little need for these system in production.

See https://www.cockroachlabs.com/docs/v2.1/online-schema-changes.html.

[irvingpop]

awesome! thank you @BramGruneir !

[tim-o]

We recently received another request about Prisma: http://forum.cockroachlabs.com/t/2575

[tim-o]

Zendesk ticket #3229 has been linked to this issue.

[rkruze]

Received a request recently for goqu - https://github.com/doug-martin/goqu

[meddlin]

It's not on the list, but I recently started working with .NET Core 3.x and NPoco (via npsql, which is on the list). I'm surprised how well this works!

[vy-ton]

Closing this meta issue in favor of issues for individual tools