Cockroach: 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
  
  
  
  • [x] #5582
  
  
  • [ ] #33441 Ecto
  
  

Go

• Go-PG
  
  
  
  • [x] #14379
  
  
• GORM
  
  
  
  • [x] #24838
  
  
• pq
• XORM
  
  
  
  • [ ] #17161
  
  

Java

• Hibernate
  
  
  
  • [ ] #16491
  
  
• JDBC

.Net

• npgsql
  
  
  
  • [ ] #25462
  
  
• .NET Core 3.x and NPoco
  
  
  
  • User reports working well
  
  

Node.js

• pg
• Sequelize
  
  
  
  • [ ] #33192 - Update to v4
  
  
• TypeORM
  
  
  
  • [x] #22298
  
  
• Knex.js
• MeteorJS

Perl

• DBD::Pg

PHP

• Doctrine
  
  
  
  • [ ] #19337
  
  
• PostgreSQL
• Yii2
  
  
  
  • [ ] #25461
  
  
• Laravel

Python

• psycopg2
• SQLAlchemy
• Django
  
  
  
  • [x] #25608
  
  
• py-postgresql
  
  
  
  • [ ] #13191
  
  

Ruby

• ActiveRecord
  
  
  
  • [ ] #20932
  
  
• pg

Rust

• Diesel
  
  
  
  • [ ] #13787
  
  
• postgres

Multiplatform

• Prisma.io
  
  
  
  • [ ] https://github.com/prisma/prisma/issues/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