Skip to content
This repository has been archived by the owner on Jun 12, 2024. It is now read-only.

Mariadb? #3

Open
CallumDowling opened this issue Nov 8, 2023 · 6 comments
Open

Mariadb? #3

CallumDowling opened this issue Nov 8, 2023 · 6 comments
Assignees
Labels
enhancement New feature or request

Comments

@CallumDowling
Copy link

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

@proofrock proofrock self-assigned this Nov 9, 2023
@proofrock proofrock added the enhancement New feature or request label Nov 9, 2023
@proofrock
Copy link
Owner

proofrock commented Nov 9, 2023

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

@CallumDowling
Copy link
Author

CallumDowling commented Nov 9, 2023

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
Copy link
Author

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

@proofrock
Copy link
Owner

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.

@CallumDowling
Copy link
Author

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

@proofrock
Copy link
Owner

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

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

2 participants