SSDB
sqlite
Our great sponsors
SSDB | sqlite | |
---|---|---|
14 | 7 | |
8,133 | 552 | |
- | - | |
0.0 | 0.0 | |
over 1 year ago | 9 days ago | |
C++ | C | |
BSD 3-clause "New" or "Revised" License | ISC 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.
SSDB
-
Redis Re-Implemented with SQLite
I've used SSDB[0] in the past for some really stupid large datasets (20TB)_and it worked really well in production
[0] https://github.com/ideawu/ssdb
- The first version of Redis, written in Tcl
-
Building a distributed task queue in Python
> Or wanting to shift the architecture entirely to avoid using memory-bound Redis as a queue with an overflow risk.
I wanted to use SSDB[1] instead of Redis for that reason, but it doesn't support the necessary data structures.
[1] https://github.com/ideawu/ssdb
- I deleted 78% of my Redis container and it still works
-
How to store subscriptions? A practical guide and analysis of 3 selected databases A closer look into PostgreSQL, Redis, and DynamoDB.
There is also ssdb https://github.com/ideawu/ssdb
- SSDB
-
Tell HN: Memcached and Redis Considered Harmful
It's 2021 and we have extremely fast key-value lookups using LevelDB/RocksDB, but we're still using RAM-based caching tools [1] [2] [3]. It's time to consider RAM-based caching harmful, and start caching with SSDs for larger datasets and lower costs. For ex: SSDB [4]
[1] https://redis.io/
[2] https://memcached.org/
[3] https://news.ycombinator.com/item?id=29532552
[4] https://github.com/ideawu/ssdb#ssdb-vs-redis
- Drop-In Replacement for Memcached
-
Using a disk-based Redis clone to reduce AWS S3 bill
Aside from this particular use-case, which is what most people here are talking about -- I had never heard of the SSDB project, but it interests me because I often use Redis for certain things it's able to do, aside from its in-memory storage, and sometimes the fact that the data is not stored on disk is a bit of a drawback for me, something I have to work around.
- SSDB – A fast NoSQL database, an alternative to Redis
sqlite
-
Redis Re-Implemented with SQLite
> You can get substantially better performance out of sqlite by using the lower level https://github.com/crawshaw/sqlite, turning on WAL etc, using a connection per goroutine for reads, and sending batches of writes over a buffered channel / queue to a dedicated writer thread. That way you can turn off SQLite’s built in per-connection mutex but still be thread safe since each connection is only used on a single thread at a time.
Would this protect against a row update in the middle of a read? e.g. would a row at least be internally consistent at the time it was read?
-
SQLite in Go, with and Without Cgo
The default go sqlite driver is https://github.com/mattn/go-sqlite3, which is quite lovely, but I ran into issues with concurrency on read only databases.
I'm now using https://github.com/crawshaw/sqlite and it seems to address those issues (but I haven't gotten around to setting up a proper test to confirm). It may be worth perusing if you do run into performance problems. It does come with the caveat of not being a database/sql driver though.
-
Awesome SQLite
crawshaw/sqlite - Low-level Go interface to SQLite
-
A pure Go embedded SQL database
crawshaw/sqlite actually uses CGo -- it's a wrapper around the C version of SQLite. For example, see https://github.com/crawshaw/sqlite/blob/23d646f8ac00d9dd2390...
zombiezen/go-sqlite uses cznic's pure Go converted version of SQLite, so avoids CGo. It's explicitly stated to be "a fork of crawshaw.io/sqlite that uses modernc.org/sqlite, a CGo-free SQLite package. It aims to be a mostly drop-in replacement for crawshaw.io/sqlite."
-
Are both MySQL and Postgres drivers similar in quality?
The second well known driver is https://github.com/crawshaw/sqlite
What are some alternatives?
KeyDB - A Multithreaded Fork of Redis
sqlite
kvrocks - Apache Kvrocks is a distributed key value NoSQL database that uses RocksDB as storage engine and is compatible with Redis protocol.
go-sqlite-lite - SQLite driver for the Go programming language
Tendis - Tendis is a high-performance distributed storage system fully compatible with the Redis protocol.
go-sqlite - Low-level Go interface to SQLite 3
mini-redis - Incomplete Redis client and server implementation using Tokio - for learning purposes only
go-sqlite3 - sqlite3 driver for go using database/sql
Memcached - memcached development tree
chai - Modern embedded SQL database
dynomite - A generic dynamo implementation for different k-v storage engines
ql