I am not even sure myself this is the right path. I have table with file names and need operations to be performed on columns (i.e. on files). Results, numeric or new file names, are to be recorded in a column. I see two ways:
From bash script, make list of rows, run commands, load results to sqlite. Or From sqlite, use extension to run commands for each row. Both have issues. Roman -------- Original message -------- From: Richard Hipp <[email protected]> Date: 1/11/17 7:23 PM (GMT-05:00) To: SQLite mailing list <[email protected]> Subject: Re: [sqlite] extension to run bash On 1/11/17, Bob Friesenhahn <[email protected]> wrote: > > For anyone thinking that it is a good idea to embed shell > functionality in the SQL interpreter, it makes the SQL interpreter > much less secure for untrusted inputs. Nobody is suggesting that this become a standard feature of the language. Roman wants a "loadable extension", a separate shared library that will only be used by Roman himself, and then under carefully controlled circumstances. -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
