SQLite
SQLite files are found in container volumes by their first bytes, and on the host with the host scan. You can also add a file by its path.
| Plan | Community (every plan) |
| Default ports | none (a file) |
What you can do
Section titled “What you can do”Files inside containers open as a snapshot (a read-only copy, taken through the socket-guard). Files on the host open live when Wharfbase can see them (host scan). Browse, edit (live files) and the SQL editor.
A least-privilege user
Section titled “A least-privilege user”Wharfbase works with any user; give it only what you want it to do.
Read only
Section titled “Read only”SQLite has no users. A snapshot is always read-only. For a live host file, Wharfbase needs read access to the file; it opens it read-only unless the connection allows writes.
Read and write
Section titled “Read and write”Writes to a live file need write access to the file and its directory (SQLite writes a journal or WAL next to it).
Wharfbase refuses ATTACH, DETACH and VACUUM INTO in the editor, so SQL can’t reach other files.