Dev tools · alternatives · 2026
24 alternatives to The Canada census data in a SQLite file; advice appreciated
This is niche, I'll admit. I needed to look through the latest census data, but it was exported as multiple multi-gigabyte bespoke latin1-encoded CSV files. Pandas, Polars, and SQLite's CSV import tool weren't much help, so I shelved the project until recently, when I started taking a SQLite course online. I picked it up again, normalized the data, and now there's a database that can be queried through a SQL view that matches the headings in the original CSVs. I'm proud of the script I created to export the data, as well as automatically compress the artifact, make the diagrams and…
Below are 24 products that do a similar job, ranked by how close each is in meaning and then by launch-day votes. The Canada census data in a SQLite file; advice appreciated launched in 2024; newer entries below may have overtaken it.
- 1
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
I wrote a relational database management system (RDBMS) (sqlite clone) from scratch in pure Python.
2023 · github.com · its alternatives →
- 3
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
2024 · crates.io · its alternatives →
- 4
We have been using graph DBs more and more at work. I found them painful to work with locally and decided to try and build something better.
Aug 2026 · github.com · its alternatives →
- 5
Drop a production-ready CSV, Excel, and PDF importer into your SaaS in minutes. Handle up to 2 million rows per import, with column mapping, validation, webhooks, and clean data delivered to your API.
2021 · csvbox.io · its alternatives →
- 6SQ
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 →
- 7
WarcDB: Web crawl data as SQLite databases. Contribute to Florents-Tselai/WarcDB development by creating an account on GitHub.
2022 · github.com · its alternatives →
- 8
OpenSheet▲86Hi folks. I've been doing some experiments on how LLMs could get more handy in the day to day of working with files (CSV, Parquet, etc). Earlier last year, I built https://datakit.page and evolved it over and over into an all in-browser experience with help of duckdb-wasm. Got loads of feedbacks and I think it turned into a good shape with being an adhoc local data studio, but I kept hearing two main things/issues: Why can't the AI also change cells in the file we give to it? Why can't we modify this grid ourselves? So besides the whole READ and text-to-SQL flows, what seemed…
Feb 2026 · opensheet.app · its alternatives →
- 9CE
Hello Hacker News! We're a team of YC founders (Meldium W13, Draft S11, TapEngage S11) launching something new (https://www.getcensus.com). How many times has your business team asked you to generate yet another CSV file, write a ”quick report” in SQL, or send some custom data to a terrible API (looking at you Marketo)? We’ve built a product that connects directly to your data warehouse and syncs into apps like Salesforce, Customer.io and even Google Sheets. In fact, your business teams won’t even need to rely on engineering to manage all these pipelines. The tech stack for…
2020 · its alternatives →
- 10
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 →
- 11
- 12
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 →
- 13
2023 · github.com · its alternatives →
- 14
Today I'm open sourcing "Grid studio", a web-based spreadsheet application with full integration of the Python programming language.
2019 · hackernoon.com · its alternatives →
- 15
EasyStats▲79Easily slice & dice U.S. Census data; Download into Excel.
2014 · census.gov · its alternatives →
- 16
I built CSV GB+ by Data.olllo, a local data tool that lets you open, clean, and export gigabyte-sized CSVs (even billions of rows) without writing code. Most spreadsheet apps choke on big files. Coding in pandas or Polars works—but not everyone wants to write scripts just to filter or merge CSVs. CSV GB+ gives you a fast, point-and-click interface built on dual backends (memory-optimized or disk-backed) so you can process huge datasets offline. Key Features: Handles massive CSVs with ease — merge, split, dedup, filter, batch export Smart engine switch: disk-based "V Core" or RAM-based "P…
2025 · apps.microsoft.com · its alternatives →
- 17CQ
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 →
- 18
Python tool to convert CSVs to SQLite Databases
Nov 2025 · kransfeld.gumroad.com · its alternatives →
- 19
Last year, I wanted to learn a bit about how easy it would be to deploy a python app via web assembly to the browser and decided to make a wrapper around the amazing sqlglot by Toby Mao and the rest of the team. The tool lets you paste in Sql queries and translate them between the available sql dialects in sqlglot. It also gives you parse diagnostics and the ability to easily share queries via storing all the state in the url. The stack that was used is typescript for the UI and pyodide to integrate with Sqlglot, which does the heavy lifting. It's more of a toy app but I've found some use…
2025 · sqlscope.netlify.app · its alternatives →
- 20
Hello HN, I'm excited to share a project I've been working on: A simple, fast way to process huge CSV and XLSX files directly in your browser and export them as clean JSON or XML Here's a few things that makes this converter different: - runs in the browser - all parsing and conversion is client side can handle data any size data - automatically detects delimiters, encodings, and data types as it parses - Live preview with column renaming, search/replace, and data cleanup - Export to JSON or XML — clean, structured output that can be used for API or Databases backstory: I built this…
2025 · csvforge.com · its alternatives →
- 21
- 22
a fast zero-copy sqlite implementation only for dumping the contents of a sqlite3 file
Oct 2025 · github.com · its alternatives →
- 23CC
2014 · database-import-scriptor.appspot.com · its alternatives →
- 24
Datakit▲10DataKit started as my solution to Excel crashing on large files, but it's grown into a full browser-based data platform that handles CSV/Parquet/XLSXL/JSON files up to 20GB+ entirely client-side. What it does: Drag files → instant SQL querying (joins, aggregations, everything) Automatic data profiling (quality issues, null values, duplicates) Smart visualizations for every column type Export transformed/filtered results Now self-hostable: After requests from teams needing this behind firewalls, the entire platform can run on your infrastructure via…
2025 · datakit.page · its alternatives →
Also compare
- SQLite Plugin for Jekyll alternatives
- I wrote a RDBMS (SQLite clone) from scratch in pure Python alternatives
- Comma Separated Values (CSV) to Unicode Separated Values (USV) alternatives
- LatticeDB – Like SQLite but for graph databases alternatives
- Csvbox.io – CSV import button for a web app, SaaS or API alternatives
- SQLite query inside a Bash function 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 →