Feature request: Implement PgLite db adapter

[KONFeature]

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

For now, the recommendation for the dev env is using SQLite with the better-sqlite3.
It's a mess when running with Bun and it's heavy af.

Describe the solution you'd like

Add a db adapter supporting PGLite.
It would help with:

• Streamline db schema between pg adapter and dev adapter
• Native support of vector and fuzzystrmatch
• Faster dev env (benchmark)
• Prepare for a potential switch to bun runtime for even faster env? 👀 (and better-sqlite is a mess with bun)

Describe alternatives you've considered

No other lib, in my knowledge, is as fast as pglite in term of dev env (specially with the in mem adapter and ultra slim WASM size)

Additional context

None

[github-actions]

Hello @KONFeature! Welcome to the ai16z community. Thank you for opening your first issue; we appreciate your contribution. You are now a ai16z contributor!