Feature Request: Embedded SQLite prompt

[jimafisk]

This would probably be pretty low priority, but often times I'm deploying PocketBase to an environment that only has the binary and I'd like to avoid installing other dependencies. It would be nice if I could still run SQLite commands since it's already embedded in the binary. I'm picturing being able to run something like ./pocketbase sqlite would open a prompt that I could then use to execute custom sql commands. Thank you!

[eugenepentland]

I made a PR for this request. Let me know if that's what you were looking for. First time contributing to open source code.

[figuerom16]

https://gitlab.com/figuerom16/gosqliteadmin

I implemented a boilerplate inline SQLite interface that does datatables and exports CSVs. Someone can copy/change the bits into a Svelte version.

It's using a few plain JS libraries so it might not be the cleanest to switch over:
htmx - embedding the result.
surreal - JS helper.
code-input w/ (highlightjs) - The SQL editor portion.

The repo has hints in the README for where the important bits are, but the repo was made to be as plain as could be.