Dear SQLites, I am using exclusively sqlite3 shell for all the processing and may need ability to run bash commands and assign result to a column. For example:
UPDATE result SET nRows =` wc -l fileNames` ; Here I used `` as would be in bash for command substitution. This would run wc command (word count), count number of lines in each file listed in column fileNames and update the row correspondingly. As far as I understand I should be able to write loadable extension to accomplish this. My questions are: 1. Given that I use sqlite3 shell exclusively, does this path makes sense? If path should be different, what is it? 2. If loadable extension is good way to go, is there an example that I could use given that I have zero knowledge of sqlite's internals? 3. Maybe mixing SQL and shell commands (different syntaxes) is linguistically inappropriate and thus difficult? Thank you, Roman _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
