axt43 alexvelin
dannguyen
/ sqlmd.sh
Last active
June 13, 2022 20:05
A command-line function that runs a SQLite query and gets a Markdown-ready table; See console demo at https://asciinema.org/a/89573
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ### sqlmd | |
| # Bash function for outputting SQLite results in Markdown-friendly table | |
| ### Dependency: | |
| # csvlook can be found here: http://csvkit.readthedocs.io/en/540/scripts/csvlook.html | |
| ### USAGE | |
| # $ sqlmd "SELECT name, age FROM people;" optional_db_name_argument.sqlite | |
| ### OUTPUT |