Use standard nitro/db0 layer

[pi0]

Nitro has built-in database layer with pglite support in db0.

While the idea of this module is nice as a full-stack solution, I think this change would really help to avoid fragmenting the ecosystem with several database solutions especially forthe server-side of it.

[sandros94]

Ah true, I forgot it got merged!

I'll experiment with this, and probably open one or two PRs to db0 since I see it lacks type support for extensions. I do agree about avoiding fragmenting the ecosystem as much as possible

[sandros94]

@pi0 after opening the PR I just realized that the the clients for each connector isn't exported and I see that is not possible to provide an external instance unjs/db0#19.
This greatly limits functionality like Sync, are there any plans? I don't see a related issue/discussion, would you like me to open an issue if it is something that you do plan to support?

EDIT: I'm going to open up a related issue about this, IMO is something that could be easily done and I can work on it

[pi0]

Similar to unstorage, we can expose API to raw client for sure.

[sandros94]

Similar to unstorage, we can expose API to raw client for sure.

New issue submitted unjs/db0#131, might draft a PR on it later