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.
Libgsqlite: A SQLite extension which loads a Google Sheet as a virtual table
11–20 of 85 posts
Re: Libgsqlite: A SQLite extension which loads a Google Sheet as a virtual table
#12I 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.
100% agree, user-friendliness is better in Sheets.
Re: Libgsqlite: A SQLite extension which loads a Google Sheet as a virtual table
#13Earlier quoted context omitted.
But could the hundreds of employees continue to make changes to the DB if it was moved out of sheets?
Actually there were only a handful of people updating it daily and it was my job to make all of those somehow give accurate results. The hundred of employees I was talking about were the ones making the sales, no direct access to those sheets, and their performance is going to be evaluated with the data that was recorded within those sheets. Data retrieval is so slow, a month of sales by 300 salesperson is around 30k…
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.
Re: Libgsqlite: A SQLite extension which loads a Google Sheet as a virtual table
#14You 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.
from the _what_
Re: Libgsqlite: A SQLite extension which loads a Google Sheet as a virtual table
#15Last 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…
So it probably would have been better to give them an excel-like frontend connected to an sql server?
Re: Libgsqlite: A SQLite extension which loads a Google Sheet as a virtual table
#16Re: Libgsqlite: A SQLite extension which loads a Google Sheet as a virtual table
#17Last 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.
Re: Libgsqlite: A SQLite extension which loads a Google Sheet as a virtual table
#18Earlier quoted context omitted.
Actually there were only a handful of people updating it daily and it was my job to make all of those somehow give accurate results. The hundred of employees I was talking about were the ones making the sales, no direct access to those sheets, and their performance is going to be evaluated with the data that was recorded within those sheets. Data retrieval is so slow, a month of sales by 300 salesperson is around 30k…
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?
Re: Libgsqlite: A SQLite extension which loads a Google Sheet as a virtual table
#19Re: Libgsqlite: A SQLite extension which loads a Google Sheet as a virtual table
#20Earlier quoted context omitted.
Actually there were only a handful of people updating it daily and it was my job to make all of those somehow give accurate results. The hundred of employees I was talking about were the ones making the sales, no direct access to those sheets, and their performance is going to be evaluated with the data that was recorded within those sheets. Data retrieval is so slow, a month of sales by 300 salesperson is around 30k…
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…
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).