sqlite-utils insert --sniff
option for detecting the delimiter and quote character used by a CSV file, see Alternative delimiters and quote characters. (#230)- The
table.rows_where()
,table.search()
andtable.search_sql()
methods all now take optionaloffset=
andlimit=
arguments. (#231) - New
--no-headers
option forsqlite-utils insert --csv
to handle CSV files that are missing the header row, see CSV files without a header row. (#228) - Fixed bug where inserting data with extra columns in subsequent chunks would throw an error. Thanks @nieuwenhoven for the fix. (#234)
- Fixed bug importing CSV files with columns containing more than 128KB of data. (#229)
- Test suite now runs in CI against Ubuntu, macOS and Windows. Thanks @nieuwenhoven for the Windows test fixes. (#232)