Show HN: Query SQLite files stored in S3

• s3sqlite

  5 427 6.9 Python

  Query SQLite files in S3 using s3fs

  

• verneuil

  4 316 0.0 C

  Verneuil is a VFS extension for SQLite that asynchronously replicates databases to S3-compatible blob stores.

  

• Sonar

  www.sonarsource.com

  sponsored

  Write Clean Python Code. Always.. Sonar helps you commit clean code every time. With over 225 unique rules to find Python bugs, code smells & vulnerabilities, Sonar finds the issues while you focus on the work.

  

• litestream

  63 8,277 6.2 Go

  Streaming replication for SQLite.

• mvsqlite

  24 1,049 8.9 Rust

  Distributed, MVCC SQLite that runs on FoundationDB.

  That DynamoDB VFS looks cool! I agree that the VFS api makes one think about plenty of crazy ideas. Someone is working on a VFS based on Foundation DB[0] that looks very promising. It was recently discussed here[1]

  [0]: https://github.com/losfair/mvsqlite

  [1]: https://news.ycombinator.com/item?id=32269287

• s3fs

  4 658 8.7 Python

  S3 Filesystem

  

• filesystem_spec

  1 560 8.5 Python

  A specification that python filesystems should adhere to.

  

• operations

  9 87 1.6

  OSMF Operations Working Group issue tracking

  

• InfluxDB

  www.influxdata.com

  sponsored

  Access the most powerful time series database as a service. Ingest, store, & analyze all types of time series data in a fully-managed, purpose-built database. Keep data forever with low-cost storage and superior data compression.

  

• papers-we-love

  20 70,624 5.8 Shell

  Papers from the computer science community to read and discuss.

  

  Ever since I read the "Out of the Tar Pit" paper[1], I've been designing my data structures in a more relational form.

  [1]: https://github.com/papers-we-love/papers-we-love/blob/master...

• mbtiles-s3-server

  6 124 9.3 Python

  Python server to on-the-fly extract and serve vector tiles from an mbtiles file on 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)

• sqlite-s3-query

  2 195 6.8 Python

  Python functions to query SQLite files stored on 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)

Suggest a related project