dolthub / dolt-workbench Goto Github PK

As this repo's Readme points out, I too have found that the modern landscape of SQL workbenches is less than modern and was excited to see Dolt's contribution to this space for MySQL.

I was wondering if you all have considered being able to also use this workbench for SQLite? 🙏

We run a lot of apps in a stateless system (that can restart processes) and doesn't allow mount points. Is there anyway this tool can store its metadata into an external database (like mysql rds or dolt itself)?

Here is how metabase works, It can be provided the database credentials via environment variable which would be ideal:

https://www.metabase.com/docs/latest/installation-and-operation/configuring-application-database#mysql-or-mariadb

When running this docker image locally things work fine. However in our hosting setup we run into the following error:

We have to run two processes, one for the HTTP web server and one for the GraphQL Server. How do we tell the HTTP process the precise GraphQL address to route its requests to?

Could we make both the WebUI and graphql server listen on the same port and route to the same location (https://host:port)?

MySQL file upload uses a LOAD DATA statement to import file data into a table. It lets you specify whether you'd like to ignore or replace on duplicate key.

Postgres file upload uses a COPY FROM statement. It does not let you specify duplicate key behavior. There are workarounds like this, where we can import to a temporary table, and then specify on conflict behavior on upsert

MySQL has show create table statements, which we show in the Schemas tab, and postgres doesn't have an equivalent. Other workbenches generate this statement from the information_schema.columns table. We should eventually implement this as well