verneuil
sqlite-s3-query
Our great sponsors
verneuil | sqlite-s3-query | |
---|---|---|
5 | 5 | |
388 | 234 | |
1.8% | - | |
6.7 | 7.5 | |
about 1 month ago | 12 days ago | |
C | Python | |
MIT 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.
verneuil
- Show HN: Query SQLite files stored in S3
- LiteFS a FUSE-based file system for replicating SQLite
-
Ask HN: P2P Databases?
https://github.com/backtrace-labs/verneuil/ is one way to address the diffing / read replica part of the problem. I believe it's compatible with gossipping: most of the data is in small content-addressed chunks, with small manifests that tell clients what chunks to fetch and how to reassemble them to recreate a sqlite database. There's already client-side caching to persistent storage, and chunks can be fetched on demand.
Sharing replication data P2P, while retaining the simplicity of a single authoritative writer per database, is explicitly part of the project's long-term goals!
sqlite-s3-query
-
Using Lidar to map tree shadows
Awesome project!
What about hosting the data in an S3 bucket with "Requestor Pays"? You'd only have the storage cost.
Disables anonymous access (so would a Dropbox share) but reduces your cost massively.
https://docs.aws.amazon.com/AmazonS3/latest/userguide/Reques...
You wouldn't necessarily need an SQL frontend as it's readonly anyway, and there are multiple ways of letting SQLite access databases in S3 buckets, e.g. https://github.com/michalc/sqlite-s3-query
-
Show HN: Query SQLite files stored in S3
Aha! This is done in https://github.com/uktrade/mbtiles-s3-server, but using an alternative library to query SQLite on S3, https://github.com/michalc/sqlite-s3-query
(Full disclosure: I wrote most of both of these)
-
Show HN: Mbtiles-S3-server – serve vector map tiles directly from mbtiles on S3
I was wondering how this ran queries against SQLite files in an S3 bucket. Here's the answer - it's using some very clever Python ctypes code to implement that HTTP Range header trick from last year:
https://github.com/michalc/sqlite-s3-query/blob/main/sqlite_...
Here's the inspiration for that: https://github.com/phiresky/sql.js-httpvfs
- Ws4sqlite: Query SQLite via HTTP
- Show HN: SQLite-S3-query – Python function to query a SQLite database on S3
What are some alternatives?
sqlite3vfshttp - Go sqlite3 http vfs: query sqlite databases over http with range headers
athena-sqlite - A SQLite driver for S3 and Amazon Athena 😳
tuql - Automatically create a GraphQL server from a SQLite database or a SQL file
litefs - FUSE-based file system for replicating SQLite databases across a cluster of machines
go-ds-crdt - A distributed go-datastore implementation using Merkle-CRDTs.
dqlite - Embeddable, replicated and fault-tolerant SQL engine.
WCDB - WCDB is a cross-platform database framework developed by WeChat.
bb-remote-execution - Tools for Buildbarn to allow remote execution of build actions
s3fs - S3 Filesystem
s3sqlite - Query SQLite files in S3 using s3fs
Apache Ignite - Apache Ignite
sql.js-httpvfs - Hosting read-only SQLite databases on static file hosters like Github Pages