4 ms·

You can just use curl to get the csv from the gayest and pipe into SQLite using the .import command. Not sure what this has on top of that.

_jplc 4y ago
from the _what_
- deleted 4y ago
  [deleted]
- qolop 4y ago
  From the gayest
  - nonethewiser 4y ago
    Gayest what? Sheet? Account holder?
    - samstave 4y ago
      Hardware
  - garbagecoder 4y ago
    That sounds like me, but I don’t issue csvs.
    - samstave 4y ago
      I only issue .STLs
- xnx 4y ago
  typo of gsheet?
  - masklinn 4y ago
    More likely to be autocorrect doing it’s usual.
  - mixcocam 4y ago
    Yes that’s correct ! Oops
cristoperb 4y ago
I wrote a little cli[1] that is a bit easier than curl for getting data to and from google sheets as csv. I do think this sqlite extension would be even more convenient if it supported writing data with INSERT/UPDATE. 1: https://github.com/cristoper/gsheet https://github.com/cristoper/gsheet
- samstave 4y ago
  This needs its own post
fulafel 4y ago
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).
- jmull 4y ago
  > 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.
- cosmojg 4y ago
  > For one, there's no CSV standard This is false: https://www.rfc-editor.org/rfc/rfc4180 https://www.rfc-editor.org/rfc/rfc4180
  - fulafel 4y ago
    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/a2c8ff518b16e9188338cb809e06ccf1 https://gist.github.com/mrkrndvs/a2c8ff518b16e9188338cb809e0...
- samstave 4y ago
  >>"(which is quite non-obvious)." ELI5 what this means, please? (unpack this for the ignorant among us, plz)
  - fulafel 4y ago
    I mean the gsheets api access setup is convoluted and here it's well documented. It has about two dozen steps.

_jplc 4y ago

from the _what_

deleted 4y ago
[deleted]
qolop 4y ago
From the gayest
- nonethewiser 4y ago
  Gayest what? Sheet? Account holder?
  - samstave 4y ago
    Hardware
- garbagecoder 4y ago
  That sounds like me, but I don’t issue csvs.
  - samstave 4y ago
    I only issue .STLs
xnx 4y ago
typo of gsheet?
- masklinn 4y ago
  More likely to be autocorrect doing it’s usual.
- mixcocam 4y ago
  Yes that’s correct ! Oops

cristoperb 4y ago

I wrote a little cli[1] that is a bit easier than curl for getting data to and from google sheets as csv. I do think this sqlite extension would be even more convenient if it supported writing data with INSERT/UPDATE. 1: https://github.com/cristoper/gsheet https://github.com/cristoper/gsheet

samstave 4y ago
This needs its own post

fulafel 4y ago

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).

jmull 4y ago
> 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.
cosmojg 4y ago
> For one, there's no CSV standard This is false: https://www.rfc-editor.org/rfc/rfc4180 https://www.rfc-editor.org/rfc/rfc4180
- fulafel 4y ago
  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/a2c8ff518b16e9188338cb809e06ccf1 https://gist.github.com/mrkrndvs/a2c8ff518b16e9188338cb809e0...
samstave 4y ago
>>"(which is quite non-obvious)." ELI5 what this means, please? (unpack this for the ignorant among us, plz)
- fulafel 4y ago
  I mean the gsheets api access setup is convoluted and here it's well documented. It has about two dozen steps.