sqlite-zstd
zstd-proxy
| sqlite-zstd | zstd-proxy | |
|---|---|---|
| 9 | 1 | |
| 1,358 | 73 | |
| - | - | |
| 3.0 | 10.0 | |
| 15 days ago | over 1 year ago | |
| Rust | C | |
| 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
zstd-proxy
-
zstd
I needed to compress a TCP stream [0] for a block-storage project and I've been very impressed with zstd. Combined with io_uring, I'm getting less CPU usage and higher throughput to send and compress data than using socat to send uncompressed data.
[0]: https://github.com/fathyb/zstd-proxy
What are some alternatives?
libsqlfs - a library that implements a POSIX style filesystem on top of an SQLite database
compress - Optimized Go Compression Packages
pocketbase-framework-litestr
cloudbeaver - Cloud Database Manager
compress-json - Store JSON data in space efficient manner
postlite - Postgres wire compatible SQLite proxy.
pocketbase-framework-litestream - A small example using PocketBase as a Go Framework with replication/restoration of SQLite DB with Litestream
sqlite-web - Web-based SQLite database browser written in Python
LZ4 - Extremely Fast Compression algorithm
litexplore - Remote SQLite database explorer
litefs - FUSE-based file system for replicating SQLite databases across a cluster of machines
zstd - Zstandard - Fast real-time compression algorithm