search

supabase-community / database-build

In-browser Postgres sandbox with AI assistance (formerly postgres.new)
https://database.build
Apache License 2.0
2.49k stars 197 forks source link

is possible add feature for connect with bigquery (struct) compatibility? #102

Closed johnfelipe closed 1 month ago

johnfelipe commented 2 months ago

is possible add feature for connect with bigquery (struct) compatibility?

gregnr commented 2 months ago

Hey @johnfelipe, thanks for the issue. What do you picture this looking like? postgres.new pointing to an actual bigquery backend instead of postgres?

postgres.new works by spinning up small PGlite databases that run directly in the browser, so connecting this with external databases would be a pretty big design shift.

johnfelipe commented 2 months ago

yes is something like ask bigquery, that will be awsome, we review wren-ai:

SNAG-0261

SNAG-0262

but this option with your app is something awsome and pretty big

gregnr commented 1 month ago

It's a cool idea and I agree would be very powerful. Like I mentioned though this would be a major design shift, since we would need to direct queries to an external BigQuery API instead of performing locally.

I'll close this for now as 'not planned' with the intent to revisit this in the future if we ever decide to support external databases (or offer another service that does this 😄). Thanks again for the suggestion!