d1-jdbc-driver issues

Select anything but * seems to fail

1

where `mytable` has a primary key of `mykey` the follow queries error: `select distinct field from mytable` `select field from mytable` They succeed in the CF D1 console. I tested...

kingmesal

Implement foreign key constraints.

Hi @isaac-mcfadyen, Love your work! Correct me if I'm wrong, but it seems like the database driver has no conception of foreign keys in the databases, right? For example, the...

kinda-raffy

Does this work with D1 created via wrangler CLI?

4

aimproxy

Columns not showing up

1

I added this driver to my WebStorm to be able to look inside my D1 database as I started to develop. When I got to my second table, no columns...

Yrlish

:tada: Some major changes coming to d1-jdbc-driver! **TLDR:** `d1-jdbc-driver` now reports itself as the official `sqlite` driver to improve compatibility. You may need to recreate your Data Source in Datagrip...

isaac-mcfadyen

Updating records inline is not working

2

First, thanks a lot for this project, whatever is available is already amazing to have and is an extreme productivity booster when working with D1 ❤️. Maybe enable GitHub sponsorships?...

steebchen