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

41–50 of 85 posts

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

#41

Post by pphysch »

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…

Spreadsheets have their place, not every sheet needs to be migrated to a database application. But some certainly should.

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

#42

Post by cloudking »

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 really hope AGI will soon be able to replace those humans that cannot be reasoned with logic.

Great use case

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

#43

Post by aarondia »

pphysch wrote: post #41
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…

Spreadsheets have their place, not every sheet needs to be migrated to a database application. But some certainly should.

Somewhere before "I had to procure a new VM just to open this Excel file", you should probably migrate to a database + Python

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

#44

Post by vaughan »

aarondia wrote: post #40
vaughan wrote: post #33

Spreadsheets are rather peculiar. I don't think anyone would come up with the concept of them today. This "fill formula down/right" feature is so strange. A developer would be like: let's just set a formula for the entire column, and make it refer to another column. And let's name the columns something. Like Airtable. But its surpringly flexible and hackable. I wish there was something like GSheets + Airtable.

If when you say GSheets + Airtable, you're looking for a spreadsheet that is designed for data analysis +a let's you name columns and sets formulas to the entire column, then checkout Mito ( https://www.trymito.io ). Disclosure: I created Mito. Mito doesn't have real time collaboration though. That is, not until Jupyter real time collaboration becomes more popular ( https://jupyterlab.readthedocs.io/en/stable/user/rt…

I think the real test is: can it quickly build an ad-hoc financial model. This is the bread and butter of spreadsheets.

Mito doesn't look like it keeps the flexibility of a spreadsheet in that way.

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

#45

Post by tylerchurch »

vaughan wrote: post #33

Spreadsheets are rather peculiar. I don't think anyone would come up with the concept of them today. This "fill formula down/right" feature is so strange. A developer would be like: let's just set a formula for the entire column, and make it refer to another column. And let's name the columns something. Like Airtable. But its surpringly flexible and hackable. I wish there was something like GSheets + Airtable.

> let's just set a formula for the entire column, and make it refer to another column. And let's name the columns something

If you turn a worksheet section into a proper Table in excel, it does exactly this.

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

#47

Post by anaisconce »

vaughan wrote: post #33

Spreadsheets are rather peculiar. I don't think anyone would come up with the concept of them today. This "fill formula down/right" feature is so strange. A developer would be like: let's just set a formula for the entire column, and make it refer to another column. And let's name the columns something. Like Airtable. But its surpringly flexible and hackable. I wish there was something like GSheets + Airtable.

Sounds like you're describing Grist! And it's open source. https://github.com/gristlabs/grist-core

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

#48

Post by dsagal »

vaughan wrote: post #33

Spreadsheets are rather peculiar. I don't think anyone would come up with the concept of them today. This "fill formula down/right" feature is so strange. A developer would be like: let's just set a formula for the entire column, and make it refer to another column. And let's name the columns something. Like Airtable. But its surpringly flexible and hackable. I wish there was something like GSheets + Airtable.

Grist is it, in fact "GSheets + Airtable" is how people often see it. From https://blog.appsumo.com/airtable-alternatives/#3_Grist: "Grist has been described as if Google Sheets + Microsoft Excel + Airtable had a beautiful baby."

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

#49

Post by nonethewiser »

vaughan wrote: post #33

Spreadsheets are rather peculiar. I don't think anyone would come up with the concept of them today. This "fill formula down/right" feature is so strange. A developer would be like: let's just set a formula for the entire column, and make it refer to another column. And let's name the columns something. Like Airtable. But its surpringly flexible and hackable. I wish there was something like GSheets + Airtable.

> let's just set a formula for the entire column, and make it refer to another column. And let's name the columns something.

I don’t understand because you obviously can do this with sheets/excel

Post reply on HN