![]() ![]() There've also been additional performance tweaks and added functionality, but this comes at the cost of breaking the original command-line flags and changing the install command. In the time since the initial release of textql, I've made some improvements as well as made the project much more modular. String: replicate, charindex, leftstr, rightstr, ltrim, rtrim, trim, replace, reverse, proper, padl, padr, padc, strfilter.Allows you to easily execute SQL against structured text like CSV or TSV.Math: acos, asin, atan, atn2, atan2, acosh, asinh, atanh, difference, degrees, radians, cos, sin, tan, cot, cosh, sinh, tanh, coth, exp, log, log10, power, sign, sqrt, square, ceil, floor, pi.Just follow the install directions at go-sqlite3-extension-functions and textql will automatically load this library. Print version and exit I want stdev, average, other functions Output delimiter character between fields -output-dlm=tab for tab, -dlm=0x# to specify a character code in hex (default ", ")įilename to write output to, if empty no output is written (default "stdout ") Treat input files as having the first row as a header row Input delimiter character between fields -dlm=tab for tab, -dlm=0x# to specify a character code in hex (default ", ") ![]() Textql Īfter all statements are run, open SQLite3 REPL with this data textql leverages the sqlite in-memory database feature as much as possible and only touches disk if asked.textql supports quote-escaped delimiters, sqlite does not.sqlite import will not accept stdin, breaking unix pipes.Key differences between textql and sqlite importing Writing to a directory no longer fails silently.Removed '-source', any files / paths at the end of the command are used, as well as piped-in data.This makes less sense after the automatic tablename generation based on filename, joins, and shorter SQL syntax changes. Dropped the ability to override table names.The flag '-outputHeader' was renamed to '-output-header'.This means the v1 command textql -sql "select * from tbl" -source some_file.csv can be shortened to textql -sql "*" some_file.csv.For simple selects, the SELECT keyword can be dropped from the query.For the case of a single table, the FROM can be dropped from the query. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |