[Feature Request] Add Cloudflare D1 database connection about dataflare HOT 5 CLOSED

Thanks @jasongitmail

To connect to the remote D1 database, it seems that only this API is available.

I have added a simple integration that should be available in the next version.

from dataflare.

New version released!
These features are currently unavailable because D1 disables the running of certain SQL.

1. Schema Manager
2. Column input suggestions in SQL editor about
3. More...

from dataflare.

Column type

This is mainly because the API doesn't return the column type and we may need additional SQL query to get it.
Track it here: #57

_cf_KV

This is supposed to be a built-in table for the D1, I suspect it doesn't have anything to do with the Workers KV (I'm not sure), let's leave it here until I figure it out.

It comes from this SQL:

SELECT name FROM sqlite_master WHERE type = 'table' ORDER BY name;

from dataflare.

Very cool! Thanks!

from dataflare.

Thanks! This works great.

• One improvement would be to show the column type (number, blob, etc) next to the col name, like you do for other database types:

  

• Also, I assume this is expected, but FYI in case it's not. Should the _cf_KV table be hidden by default? I enabled Workers KV on my API key, so I assume it's just not possible, but I don't know for sure.

  

from dataflare.