ep-engine
ws4sqlite
ep-engine | ws4sqlite | |
---|---|---|
1 | 7 | |
80 | 390 | |
- | - | |
10.0 | 7.3 | |
over 6 years ago | 6 days ago | |
C++ | Go | |
Apache License 2.0 | 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.
ep-engine
-
Ask HN: Have you used SQLite as a primary database?
This isn't a typical use case. FWIW, a decade ago, we used sqlite as the persistence mechanism for an in-memory KV store called membase. (See https://github.com/membase/ep-engine). This was powering 50M+ DAU traffic in production for very intense write-heavy traffic. It did its job well. Around that time we also considered leveldb (and rocksdb a bit later) as alternative to sqlite.
ws4sqlite
-
ws4sqlite v0.12.1 released - connect to sqlite via HTTP/"REST"
If you are interested, feel free to browse the git repo, read the documentation (with a tutorial) or connect to the discord channel.
-
Ask HN: Have you used SQLite as a primary database?
I am using sqlite where a simple persistence layer is needed, both as the sole in the project or along with a full-fledged database. There are many such projects, once you realize that a database is just an abstraction; for example, for caching in a larger project, or to store results for a subsection of the project. But of course also for smaller, standalone projects.
Also, take a look at ws4sqlite (https://germ.gitbook.io/ws4sqlite/) for a middle ground between SQLite (embedded) and rqlite/dqlite: it's "normal" sqlite addressable via web services. May be useful in some scenarios.
-
Hacker News top posts: Mar 11, 2022
Ws4sqlite: Query SQLite via HTTP\ (30 comments)
- Ws4sqlite: Query SQLite via HTTP
-
A remote JSON interface for SQLite, in Go
ws4sqlite is a web service layer on one (or more) SQLite databases. It’s written in Go, over mattn's go-sqlite3, and allows to use HTTP POST requests to submit SQL statements to a database, in a transaction. It can “serve” multiple databases at once, supports authentication, “stored queries”, in-memory databases, maintenance (vacuum/backups), batching and several other security features and configurations.
What are some alternatives?
uptime
tuql - Automatically create a GraphQL server from a SQLite database or a SQL file
Lieutenant
dashera - DasherA is a Data General DASHER D200/D210 terminal emulator
Sqinn-Go - Golang SQLite without cgo
sqlite-s3-query - Python functions to query SQLite files stored on S3
barrier - Open-source KVM software
sqlite3vfshttp - Go sqlite3 http vfs: query sqlite databases over http with range headers
go-sqlite3 - sqlite3 driver for go using database/sql
ExtPay - The JavaScript library for ExtensionPay.com — payments for your browser extensions, no server needed.
nimforum - Lightweight alternative to Discourse written in Nim