Life & fun · alternatives · 2026

24 alternatives to SQLite Plugin for Jekyll

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…

SQLite Plugin for Jekyll lets users query SQLite databases directly within Jekyll's static site generator using Liquid templating. Designed for Jekyll users who work with data files, it replaces the limitations of… Below are 24 products that do a similar job, ranked by how close each is in meaning and then by launch-day votes. SQLite Plugin for Jekyll launched in 2024; newer entries below may have overtaken it.

1. 1SQ
   SQLite query inside a Bash function▲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…

   2021 · its alternatives →

2. 2
   I've built a C# IDE, Runtime, and AppStore inside Excel▲670

   The project is called QueryStorm. It uses Roslyn to offer C# (and VB.NET) support in Excel, as an alternative to VBA. I've posted about it before, but a lot has changed since then so figured I'd share an update. The current version includes a host of new features, namely a C# debugger, support for NuGet packages, and the ability to publish Excel extensions to an "AppStore" (which is essentially a NuGet repository). The AppStore can be used by anyone with the (free) runtime component. Another great addition is the community license, which is a free license for individuals and small companies…

   2023 · querystorm.com · its alternatives →

3. 3
   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 →

4. 4
   TABLUM.IO▲159

   Turn CSV, XML & JSON into a live analysis-ready SQL database

   2023 · tablum.io · its alternatives →

5. 5
   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 →

6. 6
   JAQT – JavaScript Queries and Transformations▲100

   Hi all, I've made a javascript library to simplify searching&#x2F;sorting&#x2F;filtering in arrays of objects. Its inspired by both GraphQL and SQL, but implemented using javascript Proxies. Instead of creating a new language, its all just javascript. I've made it as part of an experimental database, which uses javascript as the query engine. The normal javascript map&#x2F;reduce&#x2F;sort functions are quite difficult to master for junior developers. JAQT is easier to explain, and can still be used in combination with any existing array functions. Please let me know what you think of the…

   2024 · github.com · its alternatives →

7. 7
   jql – Easier jq Alternative with a Lispy Syntax Written in Go▲217

   Easy JSON Query Processor with a Lispy syntax in Go - cube2222/jql

   2020 · github.com · its alternatives →

8. 8
   Jspreadsheet▲199

   JavaScript Data Grid with Advanced Spreadsheet Controls

   2024 · jspreadsheet.com · its alternatives →

9. 9
   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 →

10. 10
    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 →

11. 11
    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 →

12. 12
    SQL Workbench▲186

    In-browser SQL Workbench for data querying & visualization

    2024 · sql-workbench.com · its alternatives →

13. 13
    Sherloq▲303

    Create one place for all your SQL, directly on your editor

    2025 · its alternatives →

14. 14
    SPyQL – SQL with Python in the middle▲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…

    2022 · github.com · its alternatives →

15. 15DU
    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&#x2F;JSON&#x2F;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 →

16. 16
    Querying JSON documents using SQL-like language in Scala▲70

    SQL micro-dialect implementation for querying JSON objects. Written purely in Scala. - mmalek06/JsonSql

    2020 · github.com · its alternatives →

17. 17
    Jqview, a simple native GUI for inspecting JSON with jq▲208

    simplest possible native GUI for inspecting JSON objects with jq - fiatjaf/jqview

    2020 · github.com · its alternatives →

18. 18
    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 →

19. 19
    Sqlify▲191

    JSON, CSV and SQL converter

    2017 · its alternatives →

20. 20
    Work with CSV files using SQL. For data scientists and engineers▲99

    A SQL spreadsheet desktop app that queries and visualizes CSV files using SQL.

    2021 · superintendent.app · its alternatives →

21. 21
    ClaySQL▲141

    Run SQL queries directly in Google Sheets

    2021 · chromewebstore.google.com · its alternatives →

22. 22
    JQL – A JSON Query Language CLI Tool Built with Rust▲25

    crates.io serves as a central registry for sharing crates, which are packages or libraries written in Rust that you can use to enhance your projects

    2020 · crates.io · its alternatives →

23. 23DP
    Datasette Publish – Turn CSVs into a SQLite-Backed JSON API▲101

    2018 · publish.datasettes.com · its alternatives →

24. 24
    UseSQL for Web Scraping▲78

    Extract information from websites using SQL

    2022 · usesql.com · its 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 →