sqliterg icon indicating copy to clipboard operation
sqliterg copied to clipboard

Mariadb?

Open CallumDowling opened this issue 2 years ago • 6 comments

Any chance of supporting more dbs like mariadb? Great repos!

CallumDowling avatar Nov 08 '23 23:11 CallumDowling

Hi and thanks! What is your use case? Actually I was thinking about it (for postgres, truth to be told), but I am afraid of fragmentation, and it's difficult to group different dbs in the same tool - especially embedded vs server-based. Also, the use case may be already covered by existing tools.

Kind regards,

G.

PS: there is a duckdb version, as you may know

proofrock avatar Nov 09 '23 10:11 proofrock

I didn't know, I will check it out. My use case sending sending http queries to maria using a workflow automation tool, I have tried the sqlite go repo it works really well, simple, nice to use - I just would like to set it up a more featured dbms because it is the kind of thing that would eventually need to be migrated from sqlite. Postgres would be fine too - I understand about the fragmentation. What are the existing tools you mentioned?

CallumDowling avatar Nov 09 '23 12:11 CallumDowling

I gave this a go https://github.com/CallumDowling/sqlxrg. I added tags and used rust tests instead of the go ones you had.

CallumDowling avatar Dec 01 '23 03:12 CallumDowling

Very cool! Kudos! I am away now so I will look into it more in the future, but there are some cool concepts - I like being able to specify the connection in the headers, even if it means some overhead each time you call it; but maybe some delayed termination could be put in place to reuse the connection... at this point I wouldn't mind thinking about a multi-db tool, we have sqlite, duckdb and mysql and the concept seems "extensible" so postgres could be added too, I think... if you would care to work on it together, it could be nice.

proofrock avatar Dec 01 '23 13:12 proofrock

Yes happy to work on it together. I have dropped you an email.

CallumDowling avatar Dec 04 '23 02:12 CallumDowling

Great! I'll keep this ticket open for the reference to https://github.com/CallumDowling/sqlxrg

proofrock avatar Dec 04 '23 08:12 proofrock