Alternatives
Products that do what SQLYac – Structured SQL files you can run from the terminal does
Inspired by .http files and HTTPYac, SQLYac lets you write executable SQL documentation with variables, safety prompts, and per-query targeting. Instead of scattered .sql files or copy-pasting into clients, write annotated queries once and pipe them to any sql database client. Variables get substituted, destructive queries can prompt for confirmation, and your schema stays documented alongside actual queries. For example, if you have a `queries.sql` file like this: --- -- @name QueryWithVariables SELECT * FROM orders o, users u WHERE u.id=@user_id AND u.active=@active AND o.status=@status…
- 1
- 2DU
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…
Oct 2025 · demo.duckui.com
- 3FS
2017 · github.com
- 4SQ
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
- 5AS
2020 · github.com
- 6WU
2021 · github.com
- 7GA
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
- 8IW
I wrote a relational database management system (RDBMS) (sqlite clone) from scratch in pure Python.
2023 · github.com
- 9
- 10
- 11
- 12SP
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
- 13
- 14SC
2019 · conroy.org
- 15
- 16
- 17SD
My name is Weston Goodwin. I created a tool called SQL Simulator which allows you to do Dry Runs with your SQL Scripts. The reason I created the tool was because I wanted to verify that my SQL scripts did what I thought they would do without executing them against the database. It is similar in concept to Redgate SQL Clone or Windocs. If you are not familiar with these tools they make clones of your database. The key difference with SQL Simulator is, it only makes a clone of the database objects affected by your sql script, not the entire database. Nor does it copy the entire table (if your…
2023 · tribalknowledge.tech
- 18WW
2021 · superintendent.app
- 19SW
2024 · sql-workbench.com
- 20SB
Hey Hacker News! I wanted to share the open source project I have been working on during the last year: SQLPage, a tool to build small web applications entirely in SQL. Building web applications with just SQL isn't as crazy as it seems. Most simple applications can be expressed declaratively as just data queries that fill pre-defined web components. I'd love to hear your feedback and thoughts on it. Would you potentially use it? How can it be improved? Website: https://sql.ophir.dev/ Github: https://github.com/lovasoa/SQLpage Example app:…
2023 · sql.ophir.dev
- 21JG
2016 · github.com
- 22SS
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
- 23IS
2022 · github.com
- 24
Ranked by how close each launch is in meaning, then by votes. Refine with a description →