Releases: jokedst/CsvQuery
v1.2.9 Work with Npp 8.3
v1.2.8 Better SQL errors
Now shows actual SQL error messages in the error popup.
Dark mode icon added (for Npp v8.0+)
v1.2.7 Streaming readers
Now all CSV parsing uses streams to read the text in notepad, using less memory. This should allow much larger CSV files to be parsed.
This also fixes a bug in parsing files in ANSI-encoding for non-standard-ASCII characters (like ÅÄÖ)
v1.2.6 Quoted string analysis
This release does two parallell analysis of the file, one with strings in quotes (") and one without, and selects the best separator. Should solve some situations where it selects the wrong separator due to e.g. commas inside strings.
Still sucks at quoted quotes though :P
This release should also be able to handle larger files before getting an "OutOfMemoryException", but probably not by much (and it will take a long time to get there). It's half done.
v1.2.5 Preserve headers when generating CSV files
CSV headers are cleaned from "unsafe" characters when creating DB column names.
This version adds a new setting (default: on) that uses the original header names when generating a new CSV
Better type system
Type system rewritten which should make header detection much better (and the same for sqlite and mssql).
New setting (default disabled) to use the types when creating DB tables.
v1.2.3b
v1.2.3
v1.2.2
SQL Server bugfix
Made delete table more backwards compatible for SQL Server.
(if you don't use SQL Server as backend this update is unnecessary)