sqlite-zstd
pocketbase-framework-litestr
sqlite-zstd | pocketbase-framework-litestr | |
---|---|---|
9 | 1 | |
1,349 | - | |
- | - | |
2.2 | - | |
4 months ago | - | |
Rust | ||
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-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
pocketbase-framework-litestr
-
WAL Mode in LiteFS
For posterity: https://github.com/TylerSustare/pocketbase-framework-litestr...
What are some alternatives?
libsqlfs - a library that implements a POSIX style filesystem on top of an SQLite database
cloudbeaver - Cloud Database Manager
compress - Optimized Go Compression Packages
litexplore - Remote SQLite database explorer
sqlite-web - Web-based SQLite database browser written in Python
compress-json - Store JSON data in space efficient manner
pocketbase-framework-litestream - A small example using PocketBase as a Go Framework with replication/restoration of SQLite DB with Litestream
postlite - Postgres wire compatible SQLite proxy.
datasette - An open source multi-tool for exploring and publishing data
litefs - FUSE-based file system for replicating SQLite databases across a cluster of machines