Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Libgsqlite: A SQLite extension which loads a Google Sheet as a virtual table

github.com

Post reply on HN
Print view View original

81–85 of 85 posts

Re: Libgsqlite: A SQLite extension which loads a Google Sheet as a virtual table

#81

Post by geocar »

recuter wrote: post #66
bargle0 wrote: post #57

Earlier quoted context omitted.

Improv brought me joy. There isn’t anything like it.

I read this many times on HN. As far as I can tell Excel copied most of it about a decade later with pivot tables.

Sort of. Improv lets you work in the pivot though, like that's the main view, and the ramifications of that are huge.

- You don't have to make your sum/avg/analytic rows because Improv does that automatically. Yes, Excel does this on the pivot tables, but because you can't work there, a lot of people make a SUM(B2:B999) or something to make summary data more accessible.

- Your formulas look simple like ConversionRate=Total:Closes/Total:Leads instead of =SUM(A2:A99)/SUM(B2:B99) and sure I know there's a way to make Excel do something like that, but nobody does, which is one thing that makes it hard to mix stuff between multiple documents in Excel -- someone moves the lead count on the lead sheet and it blows everything up back at headquarters. In Improv if someone renamed Leads to Pipe or something it'd break and you'd see that right away with much less chaos.

And so on

Re: Libgsqlite: A SQLite extension which loads a Google Sheet as a virtual table

#82

Post by fulafel »

samstave wrote: post #77
fulafel wrote: post #27

Earlier quoted context omitted.

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

>>" (which is quite non-obvious). " ELI5 what this means, please? (unpack this for the ignorant among us, plz)

I mean the gsheets api access setup is convoluted and here it's well documented. It has about two dozen steps.

Re: Libgsqlite: A SQLite extension which loads a Google Sheet as a virtual table

#84

Post by zarzavat »

satoshiiii wrote: post #18
cswhnjidd wrote: post #13

Earlier quoted context omitted.

The point the person above was trying to make is that the reason you got "blank stares" was that you were proposing replacing a system where the users could read and write the data, to a system where they can't access it. Everyone saw this but you. Im sure AGI would've seen it too. Also, the fact that you offered to do it for free makes me question your motivation. I think you were trying to make your own job easier…

They were using the wrong tool for the job. The R in RDBMS for the existing sheets, they were using R as in not machines but humans doing the RELATIONAL work. Yes I was trying to make my job easier, that is why mankind invented RDBMS right? To make our work easier and accurate? No?

The user interface is usually more important than the backend. If the user interface for a spreadsheet is more powerful, then that can make it a better solution than a database that has a better backend but terrible UI.

It can be very difficult to replace spreadsheets because the UI has had 30+ years of iteration.

Re: Libgsqlite: A SQLite extension which loads a Google Sheet as a virtual table

#85

Post by NoZebra120vClip »

satoshiiii wrote: post #4

Last project I was involved with deals with Google Sheets. They were using it as their multiuser read/write database. I offered to migrate it all to a proper database for FREE during my own personal time outside of work. Blank stares were all I got. I really hope AGI will soon be able to replace those humans that cannot be reasoned with logic. Millions were involved, hundreds of employees, thousands of sales, all bei…

I am not a lawyer, and I do not know your jurisdiction, but where I come from, it would be illegal for me to work off-the-clock for my employer. It opens up many cans of worms regarding liability, accounting, etc. I have to wonder whether those sorts of things were going through the heads which gave you "blank stares". Did you attempt to compromise by offering to do it on the clock instead?
Post reply on HN