Introducing a standard interface for database drivers

[halvardssm]

In the JS ecosystem for database drivers, this package is one of the more widely used. Together with the Deno Standard Library team, we have been working on creating a standard interface for JS that database drivers can adopt to provide consistency in how to interact with sql based databases, similar to what exists for the Go ecosystem.

In the JS community, we are quite wary of any breaking changes, or alterations of existing signatures, which is why this would not require a rewrite of existing code, but can live alongside the existing implementations. If the interface is adopted into the project, it is possible and also encouraged to provide both the existing exports alongside the new exports to allow for gradual adoption.

I am opening this issue to introduce the project, and to hopefully spark interest from the maintainer team to engage, contribute and potentially adopt the interfaces into this package. The current implementation of the standard interface is more or less stable, but if any overlooked issues or concerns surface, the implementation is open for amendments. I am also happy to provide implementation support if it helps adoption.

If this project is of interest to you, feel free to read the full specifications in the RFC PR, and comment here or in the RFC. And feel free to reach out if a further discussion is wanted.

Issues has been created for other popular db driver packages, and existing implementations can be found for the following drivers:

• Deno SQLite: Implemented stdext/sql interfaces denodrivers/sqlite3#135
• Deno MySQL: Implement SQLx interface denodrivers/mysql#170

[alexgleason]

There already is one, it's called Kysely. Just use that.

[samwillis]

I'm closing this issue here for now. I'm excited about this standardisation process, and keen to take part, but I don't this we need to explicitly track its progress here.

I have a few concerns/comments, you can see my reply here: halvardssm/stdext#6 (comment)