sqlite-web
sqlite-zstd
| sqlite-web | sqlite-zstd | |
|---|---|---|
| 5 | 9 | |
| 2,910 | 1,349 | |
| - | - | |
| 7.4 | 2.2 | |
| 12 days ago | 4 months ago | |
| Python | Rust | |
| MIT License | GNU Lesser General Public License v3.0 only |
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.
sqlite-zstd
-
WAL Mode in LiteFS
Have you compared LZ4 to other compression algorithms, zstd for example? ( https://github.com/phiresky/sqlite-zstd )
Given that LiteFS operates at the filesystem layer via FUSE, have you considered it against designs that use built-in features native to some filesystems? For example, I've considered a similar system design based on a single ZFS primary node that streams ZFS snapshots to reader nodes. With some coordination service (e.g. consul) it could still allow for the whole node promotion process.
- zstd
-
Compressed Sqlite database and indexing
There's library to compress sqlite databases with extensions like sqlite-zstd.
- Show HN: 通过透明压缩将SQLite数据库的大小减少到80%。 (Show HN: Reduce SQLite database size by up to 80% with transparent compression)
- Show HN: Reduce SQLite database size by up to 80% with transparent compression
-
SQLite Archive Files
You can also try sqlite-zstd [1], which is an sqlite extension allows transparent compression of individual rows by automatically training dictionaries based on groups of data rows.
Disclaimer: I made it and it's not production ready
[1] https://github.com/phiresky/sqlite-zstd
What are some alternatives?
litexplore - Remote SQLite database explorer
libsqlfs - a library that implements a POSIX style filesystem on top of an SQLite database
Flask-Migrate - SQLAlchemy database migrations for Flask applications using Alembic
compress - Optimized Go Compression Packages
Flask-Tortoise - Adds asynchronous Tortoise ORM(Like Django-ORM) support for flask app.
pocketbase-framework-litestr
pocketbase-framework-litestream - A small example using PocketBase as a Go Framework with replication/restoration of SQLite DB with Litestream
cloudbeaver - Cloud Database Manager
Sending-Data-from-React-to-Flask - A guide on how to send data from a React frontend to a Flask backend.
compress-json - Store JSON data in space efficient manner
postlite - Postgres wire compatible SQLite proxy.