My next announcement: **Introducing: D1 JDBC Driver! 🎉 ** A JDBC driver connects GUI tools like Je
My next announcement:
Introducing: D1 JDBC Driver! 🎉
A JDBC driver connects GUI tools like Jetbrains IDEs and Datagrip (the dedicated Database IDE) to a database.
The D1 JDBC Driver, available at https://github.com/isaac-mcfadyen/d1-jdbc-driver, allows querying and viewing data in D1 from a GUI tool such as Datagrip.
Supports:
- full schema introspection, to give you insight into your table schemas
- SQL statement execution, including SELECT and modification (DELETE, INSERT, etc) execution.
- IDE abstractions such as table view mode
- FULL autocomplete, including table names, columns, and SQLite-specific datatypes (NUMERIC, TEXT, etc)
Small subset of features currently a work-in-progress:
- table-style editing within Datagrip
Try it out! Fully tested with Datagrip and Jetbrains IDEs, your mileage may vary with other tools.
https://github.com/isaac-mcfadyen/d1-jdbc-driver
Small demo video:
0 Replies