Luke Boswell (Aug 01 2024 at 23:03): Luke Boswell (Aug 01 2024 at 23:03):@Brendan Hansknecht has a super awesome PR which upgrades our SQLite3 API in basic-webserver
I've been playing with this and exploring the API a bit to help me provide better feedback and design ideas.
One of the things I thought of is maybe we could think about having a cross-platform package for database primities, similar to golang database/sql.
In a world with builtin-task, even before we have module params, we could have an API that would support SQL servers.
One consideration with this -- is that I think it's at odds with the vision @Agus Zubiaga has for roc-pg, in that his hypothesis is about tailoring the experience to each individual sql server and really unlocking the capabilities of that system and not trying to expose a minimal/generic API.
Just an idea I thought I might share if anyone has any ideas or is interested.
Agus Zubiaga (Aug 05 2024 at 02:10):I do think we can benefit from engine-specific libraries instead of the usual agnostic ones.
However, there might be enough overlap to warrant some sharing. I’d suggest waiting until we have more examples to compare or specifics areas that could benefit from this.
Brendan Hansknecht (Aug 05 2024 at 02:40):As a note, I think it would take more complex orchestration to make these share an API. Their primitives are totally different. So it would not only be a shared API, but also a shared set of intermediates that would be required to be built and then translated to each database.
Brendan Hansknecht (Aug 05 2024 at 02:40):Like, how sqlite does decoding will never match postgres.
Brendan Hansknecht (Aug 05 2024 at 02:41):Of course MySQL and postgres are much closer
Last updated: Jun 16 2026 at 16:19 UTC