3 ms·

Does CockroachDB Serverless expose an HTTP api? This sounds like a great fit for use with Cloudflare Workers, but that requires an http api.

• andydb 5y ago
  Great question. We recognize how important this is and are actively working on it.
  • webmaven 5y ago
    Is it possible to use PostgREST in front of CRDB to solve this use case?: https://postgrest.org/ https://postgrest.org/
    • andydb 5y ago
      We're working on enabling PostgREST. There is some small-ish functionality that we need do in CockroachDB for it to fully work.
• sharps_xp 5y ago
  Why do you prefer an HTTP API versus a DB connection? Isn't the former going to inherently have the overhead cost of creating the connection + TLS handshakes? My question is similar, which is, is CockroachDB going to have an equivalent RDS proxy so that apps can handle traffic spikes and not have to deal with problems with DB connection pools
  • pistoriusp 5y ago
    I think we won't be getting socket connections in some of the wasm powered JS runtime engines soon. Using http solves that, and a bunch of caching issues.
    • estambar 5y ago
      there are some great projects that present an http api for postgres that you could use with CRDB I think. I'm thinking of something like https://github.com/pramsey/pgsql-http https://github.com/pramsey/pgsql-http
      • pistoriusp 5y ago
        Now it would be awesome if we could use Prisma against an open standard like this.
• zaidf 5y ago
  I kind of assumed this came with an HTTP api, woops :) I've been using Airtable with Workers for tiny side projects. This seemed like a nice alternative to Airtable's lack of support for vanilla SQL.
• sorenbs 5y ago
  Prisma will launch a data proxy, as well as support for cockroachdb and Cloudflare workers early next year.
• password4321 5y ago
  I think Supabase does, 500mb storage + 2gb outbound data transfer for free.