Show HN: Filesql – SQL Driver for CSV, TSV, LTSV, Parquet, Excel
I built a Go SQL driver that lets you query CSV, TSV, LTSV, Parquet, and Excel files directly using SQLite3 SQL syntax. No database setup required – everything runs in-memory.
Key features: - Query multiple file formats simultaneously and JOIN across them - Handles compressed files (.gz, .bz2, .xz, .zst) automatically - Stream processing for large files with configurable chunk sizes - Support for file paths, directories, io.Reader, and embedded files - Auto-save functionality to persist changes back to files - Cross-platform (Linux, macOS, Windows)
This was extracted from my CLI tools sqly and sqluv to avoid code duplication. Instead of maintaining the same functionality in multiple projects, I made it a reusable library.
The library provides all essential functionality, though it hasn't undergone rigorous production-grade testing yet.
Thank you.
No comments yet