SQLite-S3-query – Python function to query a SQLite database on S3

In plain words

SQLite-S3-query is a Python function that enables users to query SQLite databases stored on Amazon S3 without downloading the entire file locally. It's designed for developers who need to work with SQLite databases in cloud storage environments. The tool streamlines workflows by allowing direct querying of remote databases, reducing storage requirements and improving efficiency for applications that rely on cloud-based data access.

written from the facts on this page · September 2026

• 
  Query SQLite files stored in S32022 · github.com · ▲160

  Query SQLite files in S3 using s3fs. Contribute to litements/s3sqlite development by creating an account on GitHub.

• SQ
  SQLite query inside a Bash function2021 · ▲134

  Part of the workflow for building my website is the generation of a table in tab-separated column format (.tsv). The source data is found in four other .tsv files. I use an SQLite query to perform a 4-way join and write out the new table. For convenience, I wrote a script that encapsulates the query inside a Bash function. The example below illustrates this technique. repertoire() { pushd $CMM_SOURCES&#x2F;_data sqlite3 <<EOS .headers on .mode tabs .import category.tsv category .import composition.tsv composition .import concert.tsv concert .import program.tsv program .once repertoire.tsv…

• 
  s3-lambda – Lambda functions over S3 objects: each, map, reduce, filter2017 · github.com · ▲177

  Lambda functions over S3 objects with concurrency control (each, map, reduce, filter) - littlstar/s3-lambda

• 
  I wrote a RDBMS (SQLite clone) from scratch in pure Python2023 · github.com · ▲371

  I wrote a relational database management system (RDBMS) (sqlite clone) from scratch in pure Python.

• 
  SPyQL – SQL with Python in the middle2022 · github.com · ▲105

  SPyQL (https:&#x2F;&#x2F;github.com&#x2F;dcmoura&#x2F;spyql) is SQL with Python in the middle, an open-source project fully written in Python for making command-line data processing more intuitive, readable and powerful. Try mixing in the same pot: a SQL SELECT for providing the structure, Python expressions for defining transformations and conditions, the essence of awk as a data-processing language, and the JSON handling capabilities of jq. How does a SPyQL query looks like? $ spyql “ IMPORT pendulum AS p SELECT (p.now() - p.from_timestamp(purchase_ts)).in_days() AS days_ago, sum_agg(price…

• 
  PugSQL, a Python Port of HugSQL2019 · pugsql.org · ▲155

  PugSQL is a Python library for interacting with your database the way the gods intended.

• 
  /dev/null▲481

  a social network for devs

  Dev tools · 2d ago · dev-null.sh

• 
  Whiteboard (YC W26) – an open-source IDE for thoughtful software design▲423

  open-source IDE for thoughtful software design. Contribute to devdotfast/whiteboard development by creating an account on GitHub.

  Dev tools · 27d ago · github.com

• 
  Reladraw – A diagram language where you decide where to place things▲411

  Contribute to reladraw/reladraw development by creating an account on GitHub.

  Dev tools · 25d ago · github.com

• 
  OpenBot▲362

  Grok Bot alternative: free, local, open-source, multiplayer

  Dev tools · 22d ago · openbot.run

• 
  Talanoa▲341

  Hi HN, I’m a fullstack developer, and honestly, I’ve lost count of how many side projects I’ve worked on over the years. But one idea kept coming back to me: a different kind of email client. It first came to me in 2014: “What if we could handle emails more like conversations?” Every year, I’d revisit this concept in my “Build Notes.” Ten years later, no one had built exactly what I had in mind — so I finally decided to do it myself. That’s how Talanoa was born. I wanted something focused on people, not timelines. I was tired of marking messages as unread just to remember to reply later, or…

  Dev tools · 20d ago · talanoa.email

• 
  CoreSpeed▲332

  One MCP for everything your agents need: apps, memory, tools

  Dev tools · 28d ago · corespeed.io

• II
  Imba – I have spent 7 years creating a programming language for the web▲1,216

  Hey all My name is Sindre, and I am the CTO of Scrimba (YC S20). For the last 7 years, I have written all my web apps in a full-stack programming language called Imba. It compiles to JavaScript and its main goal is to make web developers more productive. I just launched a major overhaul of Imba, so I wanted to share it here on HN, in case anyone are interested in learning more about it. It is very opinionated, so some of you might not like it, but I would love to hear anyones feedback regardless. Constructive criticism appreciated! The backstory: Imba initially started in 2012 as an effort…

  Life & fun · 2021

• WB
  We built an end-to-end encrypted alternative to Google Photos▲1,180

  Hello HN, Over the last year we've been building ente[1], a privacy-friendly, easy-to-use alternative to Google Photos. We've so far built Android[2][3], iOS[4], web[5] apps that encrypt your files and back them up in the background. You can access these across your devices, and share them with other ente users, end-to-end encrypted. You can also use our electron app[6] to maintain a local copy of your backed up files. We've built a fault-tolerant data replication layer that replicates your data to two different storage providers in the EU. We will be providing additional replicas as an…

  Life & fun · 2021

• 
  SigmaOS▲1,026

  The browser that makes YOU fast

  Work · 2021 · sigmaos.com

• 
  Codex by OpenAI▲954

  OpenAI's smartest and most intuitive to use model yet

  AI · 2021 · openai.com

• 
  Bootstrappers▲788

  Publication dedicated to bootstrapping founders

  Growth · 2021 · bootstrappers.com

• 
  Poet.so▲767

  Capture and share Twitter posts as beautiful images

  Growth · 2021 · poet.so