Query Google Sheets as virtual tables with SQLite extension

Re:Query Google Sheets as virtual tables with SQLite extensi... by cswhnjidd on Saturday March 18, 2023 @08:47AM (#35208651)

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 at the cost of the users no longer having the thing that worked for them.

[ Parent | on HN ]

Re:Query Google Sheets as virtual tables with SQLite extensi... by satoshiiii on Saturday March 18, 2023 @09:28AM (#35208973)

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?

[ Parent | on HN ]

Re:Query Google Sheets as virtual tables with SQLite extensi... by zarzavat on Sunday March 19, 2023 @08:23AM (#35218253)

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.

[ Parent | on HN ]

Re:Query Google Sheets as virtual tables with SQLite extensi... by nonethewiser on Saturday March 18, 2023 @09:49AM (#35209109)

Can’t they though? Presumably there would be a form that validates inputs that they can use. Part of the problem that OP described is that they were writing directly to the “database” (and OP had to validate input afterwards).

[ Parent | on HN ]