search

neilotoole / sq

sq data wrangler
https://sq.io
MIT License
2.15k stars 31 forks source link

Add support for rqlite #444

Open wchiquito opened 1 month ago

wchiquito commented 1 month ago

Additional context Could use this Go driver: gorqlite (https://github.com/rqlite/gorqlite).

neilotoole commented 1 month ago

@wchiquito: I've been tracking rqlite for several years, I'd love to add support. (Shout out to my fellow O'Toole in databases, @otoolep... apparently databases run in the family).

The way sq is currently built, only DBs that support the Go stdlib database/sql driver mechanism can be added. (Although that could be fixed with an appropriate level of abstraction). I see that there is indeed such a driver for rqlite, so rqlite support seems doable.

I need to write up a "How to write a sq driver" document. At this time, if anybody is interested in starting on rqlite support, please reach out.

otoolep commented 1 month ago

Thanks @neilotoole -- yes, amusing coincidence. Happy to answer any questions on rqlite if it helps.

Yeah, that driver was added in the last year. As long as you can accept a driver that doesn't support traditional transaction support, it should work I believe (rqlite supports a different type of transaction than what most relational databases support, due to the nature of the HTTP API).