Skip to content

Remote SQLite management #2831

Description

@doroved

Problem

Now it's really cool to use SQLite for your backend, but you need a quality UI to be able to read and write data.

Proposed solution

Create your own local server that, after installation, will connect to the database, after which TablePro can create an SSH tunnel

ssh -f -N -L 9000:127.0.0.1:8080 root@IP

(or HTTPS, For example, through Caddy)

db.example.com {
    reverse_proxy 127.0.0.1:8080
}

and display our database data in its UI. Database editing support is also needed.

No desktop client has this feature; if you implement it, it will be a killer feature.

See WEB UI example:
https://github.com/coleifer/sqlite-web
https://github.com/YinMo19/sql-web (rust port)
https://gateway.drizzle.team/docs/binary

Alternatives considered

No response

Related database type

SQLite

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or request

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions