ws4sqlite
tuql
ws4sqlite | tuql | |
---|---|---|
7 | 5 | |
390 | 1,035 | |
- | - | |
7.3 | 3.8 | |
2 days ago | almost 3 years ago | |
Go | JavaScript | |
ISC License | MIT 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.
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.
tuql
- Tuql: Automatically create a GraphQL server from a SQLite database
-
postlite: Postgres wire compatible SQLite proxy.
Postlite fakes the pg_catalog but it would probably take some work to get it good enough to work with a GraphQL wrapper. Those also may use SQL that's only supported by Postgres since they usually try to bundle up fetches into a single query. I think you're probably better off using a wrapper specific to SQLite such as tuql.
- Ws4sqlite: Query SQLite via HTTP
What are some alternatives?
dashera - DasherA is a Data General DASHER D200/D210 terminal emulator
sqlite-s3-query - Python functions to query SQLite files stored on S3
Sqinn-Go - Golang SQLite without cgo
aurora - CLI tool that orchestrates prisma files in a way that allows multiple .prisma files with cross-relations
postlite - Postgres wire compatible SQLite proxy.
barrier - Open-source KVM software
sqlite3vfshttp - Go sqlite3 http vfs: query sqlite databases over http with range headers
graphql-sequelize-generator - A Graphql API generator based on Sequelize.
go-sqlite3 - sqlite3 driver for go using database/sql
pluralize - Pluralize or singularize any word based on a count