[FEATURE] Support/showcase/standardize usage of embedded DBs

[hpvd]

Affected project(s)

• documentation
• examples
• wasmCloud host
• wasmCloud CLI (wash)
• wasmCloud dashboard UI (washboard)
• capability providers
• provider bindgen
• control interface client
• other / not sure

Is your feature request related to a problem? Please describe.

Would be great to also have support for embedded DBs for

• simplicity (its just a file..)
• speed (saving latency by communication to db server and today fast and feature-rich enough for nearly anything see e.g. https://www.golang.dk/articles/benchmarking-sqlite-performance-in-go)
• looks like the only option where databases can also easily scale to zero (e.g. having file on S3)

-> should be the perfect fit for wasmcloud

Describe the solution you'd like

have a standard implementation showcasing best practise in wasm cloud for embedded DBs

• sqlite
• duckdb

both also have a wasm variant if usage is expedient here..
see
https://duckdb.org/2021/10/29/duckdb-wasm.html
https://github.com/duckdb/duckdb-wasm
https://www.sqlite.org/wasm/doc/trunk/index.md

Describe alternatives you've considered

No response

Additional context

No response

[hpvd]

hmm probably related in the field of duckdb:
duckdb/duckdb-wasm#1119 (comment)
https://github.com/WebAssembly/exception-handling/blob/main/proposals/exception-handling/Exceptions.md

but there seem to be some progress in wasmtime:
bytecodealliance/wasmtime#10251

[hpvd]

the case:

e.g. from https://penberg.org/papers/penberg-conext-sw-23-slides.pdf

-> ok.. there is currently a problem with combining server-less (and with this wasm) and embedded databases and achieving really great reliable speed (P99) on read AND write:
they may be blocking each-other because of their current need to keep in sync.
This paper describes the problem and ..the solution.
Pekka Enberg, Sasu Tarkoma, Jon Crowcroft Ashwin Rao (2024). Serverless Runtime / Database Co-Design With Asynchronous I/O. In EdgeSys ‘24.
https://penberg.org/papers/penberg-edgesys24.pdf

=> As it looks to me, the up coming async capabilities of wasi P3 may open the door to a stunning solution
to combine Wasm Components with the new async capable rewrite of sqlite in rust (limbo) https://github.com/tursodatabase/limbo

@brooksmtownsend would this be an opportunity for wasm-cloud to make it easy to have real highspeed access to a persistent sql data (r/w) as a component?