sqlite-web
litexplore
| sqlite-web | litexplore | |
|---|---|---|
| 5 | 2 | |
| 2,910 | 38 | |
| - | - | |
| 7.4 | 4.4 | |
| 12 days ago | almost 2 years ago | |
| Python | JavaScript | |
| MIT License | MIT License |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
sqlite-web
-
This Week In Python
sqlite-web – Web-based SQLite database browser written in Python
- SQLite-Web: Web-based SQLite database browser written in Python
- WAL Mode in LiteFS
-
how to view a .dB file when on a server ?
I did this yesterday actually. I used sqlite-web and just pointed it to my .db file. Worked great!
-
Volunteer, non-programmer with a question :)
I use a docker (coleifer/sqlite-web) to run sqlite-web (I find it easier than installing it) to view data and try out queries.
litexplore
-
WAL Mode in LiteFS
Currently, you need to SSH in and use the sqlite3 CLI on the server. There has been some work in this area but it's all still rough around the edges. I wrote a server called Postlite[1] that exposes remote SQLite databases over the Postgres wire protocol but it's very alpha. :)
I'd love to see more work in this area. Ricardo Ander-Egg wrote a remote management tool called litexplore[2] that connects over SSH to the SQLite CLI behind the scenes. I haven't used it but I think there's a lot of potential with that approach.
[1]: https://github.com/benbjohnson/postlite
[2]: https://github.com/litements/litexplore
-
Show HN: Explore remote SQLite databases over SSH
Hi! As a big fan of SQLite, I always found the tooling to explore remote databases a bit lacking. Current solutions involve running an extra service in the remote host and exposing a port to access it. I built a small web app that can explore remote SQLite databases without having to run any service on the remote, you just need SSH.
It works by sending sqlite3 CLI commands over a multiplexed SSH connection. The commands use the "-json" flag from the sqlite3 CLI. This basically turns the SSH connection into an JSON API for the remote SQLite database. The project is hosted on GitHub[0] and I wrote a blog post with more details about the project and how it works[1].
I'm still exploring multiple ideas and implementations details, but feedback is more than welcome.
[0]: https://ricardoanderegg.com/posts/sqlite-remote-explorer-gui/
[1]: https://github.com/litements/litexplore
What are some alternatives?
Flask-Migrate - SQLAlchemy database migrations for Flask applications using Alembic
pocketbase-framework-litestr
Flask-Tortoise - Adds asynchronous Tortoise ORM(Like Django-ORM) support for flask app.
sqlite-zstd - Transparent dictionary-based row-level compression for SQLite
pocketbase-framework-litestream - A small example using PocketBase as a Go Framework with replication/restoration of SQLite DB with Litestream
datasette - An open source multi-tool for exploring and publishing data
Sending-Data-from-React-to-Flask - A guide on how to send data from a React frontend to a Flask backend.
cloudbeaver - Cloud Database Manager
litefs - FUSE-based file system for replicating SQLite databases across a cluster of machines