Hacker GitHub

← All repos

michalc/sqlite-s3-query

View on GitHub ↗ ★ 258 Python

Python functions to query SQLite files stored on S3

6 mentions on Hacker News by 4 people: 1 story, 5 comments · first 2021-08-14 · latest 2023-07-10

Mentions per year 6 mentions · busiest year 2022 (4)
20082026
AllStoriesComments NewestTopOldest
  1. …readonly anyway, and there are multiple ways of letting SQLite access databases in S3 buckets, e.g. https://github.com/michalc/sqlite-s3-query
    comment by berlincount · 2023-07-10 · in Using Lidar to map tree shadows
  2. Another way to do sqlite over S3 is: - https://github.com/uktrade/sqlite-s3vfs (Read/Write) - https://github.com/michalc/sqlite-s3-query ( Read Only)
    comment by azebazenestor · 2022-09-15 · in Show HN: WunderBase – Serverless OSS database on top of SQLite, Firecracker
  3. …ttps://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)
    comment by michalc · 2022-09-14 · in Show HN: Query SQLite files stored in S3
  4. …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
    comment by simonw · 2022-07-10 · in Show HN: mbtiles-s3-server – serve vector map tiles directly from mbtiles on S3
  5. And Python - https://github.com/michalc/sqlite-s3-query (although this is specific to S3 rather than generic HTTP) (shameless plug - made mostly by me)
    comment by michalc · 2022-03-11 · in Ws4sqlite: Query SQLite via HTTP
  6. ▲ 38
    Show HN: SQLite-S3-query – Python function to query a SQLite database on S3
    story by michalc · 2021-08-14 · 15 comments