# Basque - execute shell commands from SQLite ## Pitch `xargs`/`parallel` are all fun and games until you need to include or escape quotes. What if you could use the full power of SQLite to generate, query, and store the results of shell commands? ## Anti-pitch Anything you could do by running shell commands from SQLite, you could do by piping the output of those commands to SQLite using the incredible [q](http://harelba.github.io/q/) tool. You probably want that instead. ## Example usage ```bash $ cargo build $ sqlite3 ``` ```sql Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. sqlite> .load ./target/debug/libbasque sqlite> create table websites(url text, body text); sqlite> insert into websites(url) values('https://www.sqlite.org/'); sqlite> insert into websites(url) values('https://www.rust-lang.org/'); sqlite> update websites set body = basque_cmd("curl", "-L", url); sqlite> select url, substr(body, 1, 20) from websites; https://www.sqlite.org/| * * * * * *