Sqlite3-dump - a fast SQLite to CSV and parquet
a fast zero-copy sqlite implementation only for dumping the contents of a sqlite3 file
Sqlite3-dump - a fast SQLite to CSV and parquet launched on October 24, 2025 with 19 votes, #584 of 8,178 launches that month and more than 90% of that year's launches.
In plain words
Sqlite3-dump is a specialized tool designed to export SQLite database contents to CSV and Parquet formats. It uses a zero-copy approach to optimize performance for this specific task. The tool is built for users who need to quickly extract and convert SQLite data into other file formats, rather than providing full database functionality. It is available on GitHub.
written from the facts on this page · September 2026
From the sources
"fast" sqlite to parquet and csv converter. Contribute to i64/sqlite3-dump development by creating an account on GitHub.
Fast SQLite3 database file parser and dumper written in Rust. export RUSTFLAGS="-C target-cpu=native" CSV Export cargo run --bin csv --release -- database.db -t table_name output.csv cargo run --bin csv --release -- database.db -t table_name > output.csv Parquet Export cargo run --bin parquet --release -- database.db table_name -o output.parquet quick comprasion generated database of 100m rows . $ du -sh basic_batched.db 1.5G basic_batched.db sqlite3 -- 23 seconds: time sqlite3 -header -csv ./basic_batched.db "SELECT * FROM user;" > test.csv real 0m23.757s user 0m22.033s sys 0m1.691s sqlite3-dump csv -- 6.4 seconds $ time target/release/csv basic_batched.db -t user > test2.csv real 0m6.403s…from github.com
Does a similar job
all alternatives →
Reduce SQLite database size by up to 80% with transparent compression2022 · github.com · ▲420Transparent dictionary-based row-level compression for SQLite - phiresky/sqlite-zstd
Turbolite – a SQLite VFS serving sub-250ms cold JOIN queries from S3Mar 2026 · github.com · ▲185I 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…
I wrote a RDBMS (SQLite clone) from scratch in pure Python2023 · github.com · ▲371I wrote a relational database management system (RDBMS) (sqlite clone) from scratch in pure Python.
- SQSQLite query inside a Bash function2021 · ▲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/_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…
SQLxport – Export SQL Query Results to Parquet, CSV, and S32025 · github.com · ▲5Introducing sqlxport: export SQL query results to Parquet/CSV in seconds — and optionally upload to S3 or MinIO. Works with PostgreSQL & Redshift CLI-first, cloud-friendly Great for data pipelines and engineers
More life & fun this month
the category →
A free city-building game in your browser. You are the mayor. You know what the city needs. Now get it past the zoning board, the neighbors, the appeals court and the next election.
Life & fun · 2d ago · permit.petercai.com
- IV
Life & fun · 14d ago · tanzaniaeducationproject.org
Turn a phone, tablet or TV into a sign. Type a message and it fills the screen: welcome signs, timers, Wi-Fi passwords and more. No app, no account, free.
Life & fun · 15d ago · bigwords.page
Play a free virtual guitar online with your keyboard or by touch. Slow songs down and see every chord, string and strum. Acoustic, classic, electric and bass.
Life & fun · 9d ago · guitoro.com
Carrier settings from iPhone, Pixel and Galaxy firmware, decoded and compared: APNs, VoLTE, 5G and Wi-Fi Calling per carrier, and what each build changed.
Life & fun · 13d ago · carrierexplode.com
Life & fun · 23d ago · space.bl2.net
Source: Show HN post ↗
Launched alongside, October 2025
the whole month →
I went down the rabbit hole on a side project and ended up building this: Strange Attractors(https://blog.shashanktomar.com/posts/strange-attractors). It’s built with three.js. Working on it reminded me of the little "maths for fun" exercises I used to do while learning programming in early days. Just trying things out, getting fascinated and geeky, and being surprised by the results. I spent way too much time on this, but it was extreme fun. My favorite part: someone pointed me to the Simone Attractor on Threads. It is a 2D attractor and I asked GPT to extrapolate it to…
AI · Oct 2025 · blog.shashanktomar.com
Autism Simulator▲779Hey all, I built this. It’s not trying to capture every autistic experience (that’d be impossible). It’s based on my own lived experience as well as that of friends on the spectrum. I'm trying to give people a feel for what masking, decision fatigue, and burnout can look like day-to-day. That’s hard to explain in words, but easier to show through choices and stats. I'm not trying to "define autism". I’ve gotten good feedback here about resilience, meds, and difficulty tuning. I’ll keep tweaking it. If even a few people walk away thinking, "ah, maybe that’s why my coworker struggles in those…
Life & fun · 2025 · autism-simulator.vercel.app
