sqlite-xsv
sqlite-xsv copied to clipboard
asg017
the fastest CSV SQLite extension, written in Rust
Or a different option name than `nullstr`. Inspired from https://github.com/duckdb/duckdb/pull/11616 ```sql create virtual table temp."student_grades.csv" using csv( nullstr=['None', 'null', '', 'N/A'] ); ``` ```
[FTS5](https://www.sqlite.org/fts5.html) is an SQLite [virtual table module](https://www.sqlite.org/c3ref/module.html) that provides [full-text search](https://en.wikipedia.org/wiki/Full_text_search) functionality to database applications. Is there a way to use it with sqlite-xsv? I couldn't find a way to...
While in agreement that spaces should never be used in a column name, at times, when dealing with externally sourced csvs, spaces are indeed present. When attempting to create a...
`select * from temp.label_reader('test_labels.csv') limit 10;`
```sql .load xsv0 create virtual table "students.csv" using csv; select * from "students.csv"; ``` Make `filename=` optional - if the table name is a valid file, then read from there....
I was wondering if zip support could be implemented. I am working with [Reddit Data Export](https://www.reddit.com/settings/data-request), which arrives as a zip file with a couple different CSVs, one zip file...
Not all xsv files have all fields represented in every row in XSV files with multiple defined record types. Please consider to not error if there are underruns or overruns...
