News for hackers. Stuff that matters.

A comment on Query Google Sheets as virtual tables with SQLite extension – libgsqlite. Parent comment

Re:Query Google Sheets as virtual tables with SQLite extensi... by fulafel on Saturday March 18, 2023 @10:14AM (#35209295)
For one, there's no CSV standard and often csv based data exchange methods have lurking (and/or obvious) correctness problems. Maybe gsheets and sqlite are lucky there, maybe not.

This project is also well documented including the gsheets side (which is quite non-obvious).

[ Parent | on HN ]
Re:Query Google Sheets as virtual tables with SQLite extensi... by cosmojg on Saturday March 18, 2023 @11:17AM (#35209756)
> For one, there's no CSV standard

This is false: https://www.rfc-editor.org/rfc/rfc4180

[ Parent | on HN ]
Re:Query Google Sheets as virtual tables with SQLite extensi... by fulafel on Saturday March 18, 2023 @11:31AM (#35209881)
Well yes, there are actually many many CSV standards, my mistake for imprecise language. What I meant to say that there's no single CSV format that programs agree on. Starting with Excel...

Apparently it's quite common in Gsheet land to base your CSV export around things like this copypasta javascript code and customize as needed (follow forks, in parent direction too, for more of the story) https://gist.github.com/mrkrndvs/a2c8ff518b16e9188338cb809e0...

[ Parent | on HN ]
Re:Query Google Sheets as virtual tables with SQLite extensi... by jmull on Saturday March 18, 2023 @03:50PM (#35212474)
> Maybe gsheets and sqlite are lucky there, maybe not

Seems weird to to pooh-pooh the idea without any reason to think it isn't good. Also, it's not really a question of luck, is it? It's not that mysterious how to validate an integration like this.

[ Parent | on HN ]
Re:Query Google Sheets as virtual tables with SQLite extensi... by samstave on Saturday March 18, 2023 @10:37PM (#35215438)
>>"(which is quite non-obvious)."

ELI5 what this means, please? (unpack this for the ignorant among us, plz)

[ Parent | on HN ]
Re:Query Google Sheets as virtual tables with SQLite extensi... by fulafel on Sunday March 19, 2023 @03:10AM (#35216745)
I mean the gsheets api access setup is convoluted and here it's well documented. It has about two dozen steps.
[ Parent | on HN ]