Work · alternatives · 2026

24 alternatives to SQLite query inside a Bash function

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…

This is a Bash scripting technique for automating data processing workflows. It demonstrates how to embed SQLite queries within a Bash function to join multiple tab-separated value files and generate a consolidated… Below are 24 products that do a similar job, ranked by how close each is in meaning and then by launch-day votes. SQLite query inside a Bash function launched in 2021; newer entries below may have overtaken it.

1
SQLite Plugin for Jekyll▲227
I love Jekyll, especially the Datafiles[0] feature, which lets you use CSV/JSON/YAML files and iterate through them. Mixed with the Jekyll Data Pages generator[1], which lets you create a page for every row in your dataset, it is a very powerful combination. However, Liquid is a terrible language for data-mangling, and simple filtering/sorting/merging can become very annoying. So I wrote a Jekyll SQLite plugin that lets you use the same data interface in Jekyll/Liquid, but backed by a SQLite file(s). It gives you the simplicity of the Baked Data pattern[2], and the…
2024 · github.com · its alternatives →
2
TextQuery – Query CSV, JSON, XLSX Files with SQL▲163
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 →
3
OctoSQL – Query and join multiple databases and files, written in Go▲310
OctoSQL is a query tool that allows you to join, analyse and transform data from multiple databases and file formats using SQL. - cube2222/octosql
2019 · github.com · its alternatives →
4
SQLite JavaScript - extend your database with JavaScript▲199
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 →
5DU
Duck-UI – Browser-Based SQL IDE for DuckDB▲213
I built Duck-UI, a web-based SQL editor that runs DuckDB entirely in your browser via WebAssembly. No backend required. The Problem: Every time I needed to query csv, parquet, or even to play with SQL, I had to either: (a) spin up a Jupyter notebook (b) use the CLI (c) upload to a hosted service. Friction at every step (TOO MUCH to load a csv or even to test some sql (study)... The Solution: DuckDB's WASM runtime lets us run SQL analysis client-side. Load CSV/JSON/Parquet files from disk or URL, write SQL, get results instantly. Data stays on your machine. What It Does: SQL editor…
2025 · demo.duckui.com · its alternatives →
6
Base, an SQLite database editor for macOS▲693
I recently released v3 of Base, my SQLite editor for macOS. The goal of this app is to provide a comfortable native GUI for SQLite, without it turning into a massive IDE-style app. The coolest features are - That it can handle full altering of tables, which is quite finicky to do manually with SQLite. - It has a more detailed display of column constraints than most editors. Each constraint is shown as an icon if active, with full details available on clicking the icon. This update also adds support for attaching databases, which is a bit fiddly with macOS sandboxing. I'd love to hear any…
2025 · menial.co.uk · its alternatives →
7
SQL workbench in the browser▲117
Free browser-based SQL editor powered by DuckDB. Query and visualize CSV, JSON, Parquet and Arrow files locally or from remote URLs. No installation required.
2024 · sql-workbench.com · its alternatives →
8
A SQL database implemented purely in TypeScript type annotations▲426
A SQL database implemented purely in TypeScript type annotations. - codemix/ts-sql
2020 · github.com · its alternatives →
9
SQL Workbench▲186
In-browser SQL Workbench for data querying & visualization
2024 · sql-workbench.com · its alternatives →
10
Equals Import Scripts▲339
A spreadsheet with SQL, JavaScript, and Python built in
2022 · equals.com · its alternatives →
11
I built jq-like scriptable tool to query CSV and JSON with SQLite▲11
Convert and query JSON, JSONL, CSV, and SQLite with ease! - chand1012/sq
2024 · github.com · its alternatives →
12
FSQL – Search through your file system with SQL-esque queries▲341
Search for files using a fun query language. Contribute to kashav/fsql development by creating an account on GitHub.
2017 · github.com · its alternatives →
13
Private, in-browser, CSV-SQL query runner using SQLite-WASM▲41
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 →
14
I wrote a RDBMS (SQLite clone) from scratch in pure Python▲371
I wrote a relational database management system (RDBMS) (sqlite clone) from scratch in pure Python.
2023 · github.com · its alternatives →
15
SPyQL – SQL with Python in the middle▲105
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 →
16
Google Drive to SQLite▲305
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 →
17
ClangQL – Query C++ codebases using SQLite▲73
Query C++ codebases using SQLite. Contribute to frabert/ClangQL development by creating an account on GitHub.
2021 · github.com · its alternatives →
18
ClaySQL▲141
Run SQL queries directly in Google Sheets
2021 · chromewebstore.google.com · its alternatives →
19CQ
CSVFiddle – Query CSV files with DuckDB in the browser▲64
Import CSVs, write SQL, and instantly share it with anyone. Runs 100% in-browser, so you're in control of your data.
2022 · csvfiddle.io · its alternatives →
20
SQL-tString a t-string SQL builder in Python▲85
SQL-tString is a SQL builder that utilises the recently accepted PEP-750, https://peps.python.org/pep-0750/, t-strings to build SQL queries, for example, from sql_tstring import sql val = 2 query, values = sql(t"SELECT x FROM y WHERE x = {val}") assert query == "SELECT x FROM y WHERE x = ?" assert values == [2] db.execute(query, values) # Most DB engines support this The placeholder ? protects against SQL injection, but cannot be used everywhere. For example, a column name cannot be a placeholder. If you try this SQL-tString will raise an error, col = "x" sql(t"SELECT…
2025 · github.com · its alternatives →
21
TABLUM.IO▲159
Turn CSV, XML & JSON into a live analysis-ready SQL database
2023 · tablum.io · its alternatives →
22
Embed an SQLite database in your PostgreSQL table▲180
pglite-fusion is a PostgreSQL extension that allows you to embed SQLite databases into your PostgreSQL tables by enabling the creation of columns with the `SQLITE` type. This means every row in the table can have an embedded SQLite database. In addition to the PostgreSQL `SQLITE` type, pglite-fusion provides the `query_sqlite`` function for querying SQLite databases and the `execute_sqlite` function for updating them. Additional functions are listed in the project’s README. The pglite-fusion extension is written in Rust using the pgrx framework [1]. ---- Implementation Details The PostgreSQL…
2024 · github.com · its alternatives →
23
JinjaSQL – Generate SQL Queries using a Jinja Template▲77
Template Language for SQL with Automatic Bind Parameter Extraction - sripathikrishnan/jinjasql
2016 · github.com · its alternatives →
24
Query SQLite files stored in S3▲160
Query SQLite files in S3 using s3fs. Contribute to litements/s3sqlite development by creating an account on GitHub.
2022 · github.com · its alternatives →

Also compare

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 →