Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Standardize SQL database interface for TS/JS #476

Open
halvardssm opened this issue Mar 16, 2024 · 5 comments
Open

Standardize SQL database interface for TS/JS #476

halvardssm opened this issue Mar 16, 2024 · 5 comments

Comments

@halvardssm
Copy link
Contributor

It's a topic that has been brought up every now and then in the Deno DB community, but as Deno is becoming more stable, supports NPM and Node, and we got JSR, I believe it's time to consolidate and create a db standard SQL interface for TS and JS.

I have created a POC in my repo PR.

Any input and contribution is greatly appreciated and encouraged as it would be best to make this a collaborative effort amongst the database maintainers since they know the pitfalls for the different engines.

The milestones are as follows:

  • Decide on an interface for DB clients that can be implemented by any SQL based db. Wrappers can be created for existing database clients to locate potential issues with the interface and current implementations.
  • Refactor existing databases to implement these interfaces.

The goal for this is to be able to easily transition between databases and have a familiar interface and usage between them.

Consider the PR as a parent issue to have discussions, and where we can finalize the implementation.

@langpavel
Copy link
Contributor

Nice idea but very hard task!

There is @bartlomieju/postgres at JSR
which unfortunately does not look maintained (sorry for that opinion), not connected to this project – no possibility to open discussions nor PRs, feels like closed source 💔
Why @bartlomieju? It may be hard to keep all the responsibility. I know this well, but…

There is great node-postgres (@brianc) (npm:pg) best in town library at that time.
I had the honor to work on it. But time for great new language features ❤️ and simplifications 🚀 may be here.

And that's not the end.
There will be more libraries in time. It's natural.

https://xkcd.com/927/

@langpavel
Copy link
Contributor

BTW @halvardssm some suggestions?

@bartlomieju
Copy link
Collaborator

There is @bartlomieju/postgres at JSR which unfortunately does not look maintained (sorry for that opinion), not connected to this project – no possibility to open discussions nor PRs, feels like closed source 💔 Why @bartlomieju? It may be hard to keep all the responsibility. I know this well, but…

The one published to JSR is literally this library.

@halvardssm
Copy link
Contributor Author

@langpavel jupp, a very hard task indeed,but I think with some collaboration it should be feasible 💪🏻 and yes, feel free do send feedback in the PR.

@halvardssm
Copy link
Contributor Author

RFC has been created: halvardssm/stdext#6

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants