SQLite Is Serverless

Re:SQLite Is Serverless by bradgessler on Sunday January 26, 2020 @03:40PM (#22154644)

I’d love a SQLite to macOS Excel (or any macOS spreadsheet application) workflow so less technical users can do analysis. Has anybody pulled this off?

[ Parent | on HN ]

Re:SQLite Is Serverless by drongoking on Sunday January 26, 2020 @03:49PM (#22154689)

You mean like the .excel command?

"... causes them to accumulate output as Comma-Separated-Values (CSV) in a temporary file, then invoke the default system utility for viewing CSV files (usually a spreadsheet program) on the result. This is a quick way of sending the result of a query to a spreadsheet for easy viewing"

[ Parent | on HN ]

Re:SQLite Is Serverless by simonb on Monday January 27, 2020 @12:01PM (#22161226)

Or load it in Metabase (as an macOS app).

[ Parent | on HN ]

Re:SQLite Is Serverless by iagovar on Sunday January 26, 2020 @08:01PM (#22156040)

You can do that with powerquery

[ Parent | on HN ]