Earlier quoted context omitted.
from the _what_
From the gayest
Gayest what? Sheet? Account holder?
Libgsqlite: A SQLite extension which loads a Google Sheet as a virtual table
21–30 of 85 posts
Re: Libgsqlite: A SQLite extension which loads a Google Sheet as a virtual table
#22Re: Libgsqlite: A SQLite extension which loads a Google Sheet as a virtual table
#23Last 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 hate to break it to you, but an equally likely outcome of the introduction of AGI would be to replace you instead, and give those users exactly what they asked for, even if it's not optimal (or improving it, but preserving the interface they are used to).
Re: Libgsqlite: A SQLite extension which loads a Google Sheet as a virtual table
#24In case you don't read the whole README, note this in limitations:
> The extension will load the spreadsheet only once while creating a virtual table. If you want to pick up recent changes, drop the table and create it again.
Re: Libgsqlite: A SQLite extension which loads a Google Sheet as a virtual table
#25You 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.
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.
Re: Libgsqlite: A SQLite extension which loads a Google Sheet as a virtual table
#26Last 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…
Nothing you’ve described sounds like a valid reason to move “a couple of spreadsheets” to a database system which might require: budget planning, database administrator, system design, server, colocation, query optimization, report system, monitoring, user interface, backup/recovery plan, authentication system, change management logs, user training, business process analysis, etc.
The two planks of wood across the canyon work fine, there's no valid reason to build a bridge! That would require planning, architects, engineers, safety inspections, construction, etc. Let's just keep ferrying cars across the wood planks, we all know how wood planks work, and we've got plenty of duct tape for when they break!
Re: Libgsqlite: A SQLite extension which loads a Google Sheet as a virtual table
#27You 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.
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).
Re: Libgsqlite: A SQLite extension which loads a Google Sheet as a virtual table
#28This project actually started as a fork of https://github.com/x2bool/xlite - SQLite extension for querying .xls and .xlsx spreadsheets.
Re: Libgsqlite: A SQLite extension which loads a Google Sheet as a virtual table
#29Earlier quoted context omitted.
Nothing you’ve described sounds like a valid reason to move “a couple of spreadsheets” to a database system which might require: budget planning, database administrator, system design, server, colocation, query optimization, report system, monitoring, user interface, backup/recovery plan, authentication system, change management logs, user training, business process analysis, etc.
The two planks of wood across the canyon work fine, there's no valid reason to build a bridge! That would require planning, architects, engineers, safety inspections, construction, etc. Let's just keep ferrying cars across the wood planks, we all know how wood planks work, and we've got plenty of duct tape for when they break!
This is a deeply flawed analogy. Hosted cloud spreadsheet has effectively perfect availability and durability compared to most database solutions, and never requires maintenance, and costs nothing.
Re: Libgsqlite: A SQLite extension which loads a Google Sheet as a virtual table
#30I get it. Google Sheets costs you Zero money. BUT you can get a proper SQL managed instance(with much faster query, larger data store, Geo-replication, point-in-time backup etc) for less than $5 a month. Do your due diligence, identify your needs, compare the price of engineering hours with $5/month and go ahead with whatever suites you the best.
Sheets has a human-friendly, readily-understood, multi-user capable user interface. You’re likely correct that $5/mo isn’t the barrier to switching.
Sheets are also geo-replicated and have infinite version history. I seriously doubt that anyone has ever lost data in Sheets.