Add per-driver connection information

[ericharmeling]

Eric Harmeling (ericharmeling) commented:

For each supported driver and ORM framework, we currently have download and installation information and example applications.

We do not have a dedicated page for connection information for each driver/ORM. I think users would find this information super helpful to have in one place (alla Install a Driver or ORM Framework), especially if we somehow linked to this page from the Connect page of the CC console (and possibly in the welcome page of the relevant cockroach commands).

All of the relevant connection information should be available on either the tool's example app tutorial page, or on the tool's third-party website.

Jira Issue: DOC-1745

[vy-ton]

@ericharmeling @ianjevans @awoods187

In discussion with @emily-horing and @kannanlakshmi on connection questions from Serverless users, we should prioritize this as a Q4 OKR action/docs projects. It will greatly improve the onboarding journey

[awoods187]

cc @kernfeld-cockroach

[ericharmeling]

we should prioritize this as a Q4 OKR action/docs projects.

+1

[jordanlewis]

A user had a question about connecting with Ecto. The way to connect to Ecto is here:

config :myapp, MyApp.repo,
  username: "username",
  password: "xxxx",
  database: "defaultdb",
  hostname: "free-tier.gcp-us-central1.cockroachlabs.cloud",
  port: 26257,
  ssl: true,
  ssl_opts: [
    cert_pem: "foo.pem",
    key_pem:  "bar.pem"
  ],
  show_sensitive_data_on_connection_error: true,
  pool_size: 10,
  parameters: [
    options: "--cluster=cluster-name-1234"
  ]

[vy-ton]

@ericharmeling we should try and set up this page to make it easy for community contributions for things like Ecto in the future

[jordanlewis]

I've written up instructions for JetBrains if they don't already exist here: https://stackoverflow.com/questions/69747102/how-do-i-connect-jetbrains-datagrip-to-cockroachdb-serverless/69747103#69747103

(And added the answer for Ecto here: https://stackoverflow.com/questions/69747033/how-do-i-connect-ecto-to-cockroachdb-serverless)

I do think that adding all of these to StackOverflow would be great too, as we move toward a product that's a lot more "consumer web facing" I think we'll see a lot more traffic in googleable places like StackOverflow. I'm happy to help write some of these things up there over time.

[jordanlewis]

DBeaver instructions: https://stackoverflow.com/questions/69757289/how-do-i-connect-dbeaver-to-cockroachdb-serverless/69757290#69757290

[exalate-issue-sync]

Jesse Seldess (jseldess) commented:
Eric Harmeling, flagging this as Dev Experience. Please change it to the appropriate SQL area, if necessary.

[exalate-issue-sync]

Vy Ton (vy-ton) commented:
fyi Paul Kernfeld I wanted to make sure you were aware of this issue so you and Eric Harmeling can prioritize accordingly. It was earmarked as a Q4 actions.