feat: add `nuxt-pglite`

[sandros94]

🔗 Linked issue

Resolves #1125

❓ Type of change

• [ ] 📖 Documentation (updates to the documentation or readme)
• [ ] 🐞 Bug fix (a non-breaking change that fixes an issue)
• [ ] 👌 Enhancement (improving an existing functionality)
• [x] ✨ New feature (a non-breaking change that adds functionality)
• [ ] 🧹 Chore (updates to the build process or auxiliary tools and libraries)
• [ ] ⚠️ Breaking change (fix or feature that would cause existing functionality to change)

📚 Description

A Nuxt module aimed to simplify the use of PGlite.

PGlite, an Embeddable Postgres Run a full Postgres database locally in WASM with reactivity and live sync.

It probides a series of composables, plugins and server utils to support PGlite both in the browser and on the server.

Key features:

• RLS support
• Web Workers by default in browser env
• Full type support for a better DX

Automatic extensions installation with support for things like:

• live: to subscribe reactively to a particular query.
• Sync: to sync a subset of a remove Postgres database for offline-first implementations.
• vector: for vector similarity searches

[pi0]

Nice work! One important point is that for server-side, you can actually leverage built-in db layer ~> https://github.com/sandros94/nuxt-pglite/issues/7