Dev tools · alternatives · 2026
24 alternatives to SQLite-S3-query – Python function to query a SQLite database on S3
Python functions to query SQLite files stored on S3 - michalc/sqlite-s3-query
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… Below are 24 products that do a similar job, ranked by how close each is in meaning and then by launch-day votes. SQLite-S3-query – Python function to query a SQLite database on S3 launched in 2021; newer entries below may have overtaken it.
- 1
Query SQLite files in S3 using s3fs. Contribute to litements/s3sqlite development by creating an account on GitHub.
2022 · github.com · its alternatives →
- 2SQ
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/_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…
2021 · its alternatives →
- 3
Lambda functions over S3 objects with concurrency control (each, map, reduce, filter) - littlstar/s3-lambda
2017 · github.com · its alternatives →
- 4
I wrote a relational database management system (RDBMS) (sqlite clone) from scratch in pure Python.
2023 · github.com · its alternatives →
- 5
SPyQL (https://github.com/dcmoura/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…
2022 · github.com · its alternatives →
- 6
Search for files using a fun query language. Contribute to kashav/fsql development by creating an account on GitHub.
2017 · github.com · its alternatives →
- 7
PugSQL is a Python library for interacting with your database the way the gods intended.
2019 · pugsql.org · its alternatives →
- 8
Hiya HN! TextQuery is my sabbatical project that I have been working on for the past six months. It was born out of a personal pain point. Anytime I wanted to analyze raw CSV data, I had to create a schema first before I could import it for querying. And to create charts, I had to use yet another tool. I also disliked how bad charts from popular tools like Excel, Google Sheets looked like. I wanted an easier way to do this and TextQuery was my solution: an all-in-one tool to query CSV files using SQL and create beautiful visualizations as well. Currently, it's a macOS app and focused on CSV…
2025 · textquery.app · its alternatives →
- 9
Contribute to akdor1154/python-csql development by creating an account on GitHub.
2020 · github.com · its alternatives →
- 10
Here's the repo: https://github.com/simonw/google-drive-to-sqlite The README is using a trick I'm increasingly leaning on: parts of that document - the --help output and the example database schema - are automatically generated using Cog: https://nedbatchelder.com/code/cog and https://til.simonwillison.net/python/cog-to-update-help-in-r...
2022 · simonwillison.net · its alternatives →
- 11
Upload CSV, and start querying, all locally without any data leaving your browser. Can handle large CSV's easily. Download query results once done. Uses sqlite-wasm binary.
2024 · csvsqltool.com · its alternatives →
- 12HA
Hi all, we recently open sourced the first version of Hashquery, a Python library which lets you model analytics, DRY up common logic, and execute it against a database or warehouse. We were originally rendering SQL directly for all our queries, but that spiraled out of control with more complex analysis; the SQL needed to be changed sporadically for each new database dialect (BigQuery, Redshift, Aethena, Postgres, etc etc) and the SQL fragments were very challenging to reuse (and so fragments were copy-pasted all over). ~~~ Advantages we think it has over writing SQL by hand: - Queries are…
2024 · hashquery.dev · its alternatives →
- 13
Anyquery▲110Query anything with SQL (e.g. Notion, GitHub, JSON)
2024 · anyquery.dev · its alternatives →
- 14SS
2020 · app.swaggerhub.com · its alternatives →
- 15
Interactive SQL database exploration in Python. Contribute to boydgreenfield/query development by creating an account on GitHub.
2014 · github.com · its alternatives →
- 16
https://github.com/ncruces/go-sqlite3 was doing poorly on this benchmark that was posted yesterday to HackerNews [1]. With the help of some pprof, I was able to trace it to a serious performance regression introduced two weeks ago, and come up with the fix (happy to field questions, if you're interested in the nitty gritty). It's not the fastest driver around, but it's no longer the slowest: comfortably middle of the pack. It's based on a WASM build of SQLite, and thanks to https://wazero.io doesn't need CGO. [1]:…
2023 · github.com · its alternatives →
- 17
I built a SQLite VFS in Rust that serves cold queries directly from S3 with sub-second performance, and often much faster. It’s called turbolite. It is experimental, buggy, and may corrupt data. I would not trust it with anything important yet. I wanted to explore whether object storage has gotten fast enough to support embedded databases over cloud storage. Filesystems reward tiny random reads and in-place mutation. S3 rewards fewer requests, bigger transfers, immutable objects, and aggressively parallel operations where bandwidth is often the real constraint. This was explicitly inspired…
Mar 2026 · github.com · its alternatives →
- 18
Sqlime is an online SQLite playground for debugging and sharing SQL snippets.
2021 · sqlime.org · its alternatives →
- 19
Query C++ codebases using SQLite. Contribute to frabert/ClangQL development by creating an account on GitHub.
2021 · github.com · its alternatives →
- 20
Create custom SQLite functions in JavaScript. Extend your database with scalars, aggregates, window functions, and collations directly in JavaScript. - sqliteai/sqlite-js
2025 · github.com · its alternatives →
- 21
A Go SQL query builder and struct mapper. Contribute to samonzeweb/godb development by creating an account on GitHub.
2016 · github.com · its alternatives →
- 22
I've always been curious about how SQL engines actually work. So I built a minimum viable SQL engine in Go. - Supports CSV files as tables - Supports SELECT, FROM, WHERE, LIMIT It's very simple: 1. Parses query string 2. Converts it into an AST representation 3. Executes the query against the CSV 4. Returns the results
2024 · github.com · its alternatives →
- 23
SQL micro-dialect implementation for querying JSON objects. Written purely in Scala. - mmalek06/JsonSql
2020 · github.com · its alternatives →
- 24
a fast zero-copy sqlite implementation only for dumping the contents of a sqlite3 file
Oct 2025 · github.com · its alternatives →
Also compare
- Query SQLite files stored in S3 alternatives
- SQLite query inside a Bash function alternatives
- s3-lambda – Lambda functions over S3 objects: each, map, reduce, filter alternatives
- I wrote a RDBMS (SQLite clone) from scratch in pure Python alternatives
- SPyQL – SQL with Python in the middle alternatives
- FSQL – Search through your file system with SQL-esque queries alternatives
Ranked by how close each launch is in meaning, then by votes. Prices were read from each product’s own site when checked and can change. Refine with your own description →