{"repo":"nao1215/filesql","free":true,"listed":false,"github":"https://github.com/nao1215/filesql","clone":"git clone https://github.com/nao1215/filesql.git","description":"loads CSV, TSV, LTSV, JSON, JSONL, Parquet, XLSX, ACH, and Fedwire files into SQLite; includes prep and frame for cleanup and in-memory transforms","language":"Go","stars":377,"topics":["csv","go","golang","ltsv","sql","tsv","parquet","excel","sqlite3","ach"],"license":"MIT","category":"databases-storage","readme_excerpt":"filesql filesql loads files into an in-memory SQLite database. Open CSV, TSV, LTSV, JSON, JSONL, Parquet, XLSX, ACH, or Fedwire inputs, then query them with normal SQLite syntax. The same module also includes two companion packages for work that usually happens before or after SQL: - prep cleans and validates rows before they become tables. - frame handles small in-memory transforms in plain Go. sqly is the shell built on the same core. Why filesql? filesql is for cases where the data is already in a file and the fastest useful tool is SQL. - Open files as tables without setting up a server. - Join across CSV, TSV, LTSV, JSON, JSONL, Parquet, XLSX, ACH, and Fedwire. - Keep edits in memory until you decide to save them. - Clean inputs with prep before loading them. - Reshape small datasets with frame when SQL is not the right fit. Features - Query file data with standard SQLite syntax, including joins, CTEs, and json extract() . - Optionally query with MySQL, PostgreSQL, or GoogleSQL syntax via WithDialect (translated to SQLite). - Read from file paths, directories, io.Reader , and embed.FS . - Handle compressed CSV, TSV, LTSV, JSON, JSONL, Parquet, and XLSX files transparently. - Write csv, tsv, and ltsv output in Shift-JIS, EUC-JP, ISO-2022-JP, or UTF-16 as well as UTF-8. - Load into a new in-memory database or into a sql.DB you already manage. - Save changes with DumpDatabase , EnableAutoSave , or EnableAutoSaveOnCommit . - Stay in one module for loading ( filesql ), cleanu","default_branch":null,"files":null,"tree":[],"storefront":"/r/nao1215","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/nao1215/filesql/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}