shameless plug for the adventurous duckdb users: s...
# randomb
bulky-autumn-5299
05/09/2023, 1:41 PMshameless plug for the adventurous duckdb users: since some of you might be using duckdb with evidence, I recently posted more info about our duckdb pro tools in duckdb repo discussions you might find handy/worth exploring. It has some really cool new features and shortcut db metadata commands are coming this week too. That duckdb pro and prql tools exts are private and are about 2 ☕ if you want to try them ... https://github.com/duckdb/duckdb/discussions/7388
bulky-autumn-5299
05/09/2023, 2:48 PMnow that I got evidence template app up and running, here is the view of ddb instance it uses. handy to run those queries from pages in evidence app mds too. I might add
Run Querysqlbulky-autumn-5299
05/09/2023, 3:00 PMwould be similar to the PRQL Run Query code lens I shared in another thread, so evidence, observable and other sql md code block users can run queries against duckdb instances from md docs.
bulky-autumn-5299
05/09/2023, 3:03 PMfor the basic tabular data query views that is. I like what evidence does for the visuals and the rest.
bulky-autumn-5299
05/10/2023, 12:44 PMmost likely will call that new vscode ext. SQLCodeLens. twitter tag for future refs and our public dev log for those interested in such new sql query run tool to use in vscode with various markdown formats, emd included, but also qmd, omd, etc. https://twitter.com/TarasNovak/status/1656278232058982402
bulky-autumn-5299
05/14/2023, 1:12 PMmeanwhile, these shortcut duckdb view/query commands will be released tomorrow: https://twitter.com/TarasNovak/status/1657726733880000513