Libgsqlite: A SQLite extension which loads a Google Sheet as a virtual table
1–10 of 85 posts
Re: Libgsqlite: A SQLite extension which loads a Google Sheet as a virtual table
#2This is perfect!
Re: Libgsqlite: A SQLite extension which loads a Google Sheet as a virtual table
#3This seems like the least sqlite-like possible thing. Immediately, it makes me ask if sqlite is the right tool for a job that involves Google Sheets. But I'm sure it fills a very particular need for some people.
Re: Libgsqlite: A SQLite extension which loads a Google Sheet as a virtual table
#4Last 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 being tracked in a couple of sheets. The faster data retrieval alone was worth it if we migrated it to a proper database.
Re: Libgsqlite: A SQLite extension which loads a Google Sheet as a virtual table
#5Last 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…
But could the hundreds of employees continue to make changes to the DB if it was moved out of sheets?
Re: Libgsqlite: A SQLite extension which loads a Google Sheet as a virtual table
#6I 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.
Re: Libgsqlite: A SQLite extension which loads a Google Sheet as a virtual table
#7I 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.
Re: Libgsqlite: A SQLite extension which loads a Google Sheet as a virtual table
#8Last 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…
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 rows, we have to connect that to their attendance, the day whether it is a weekday, weekend, holiday, rest day. The store they were assigned. The monthly quota they have, etc.
I lasted 3 months only, got tired of the sudden meetings discussing why can't we give fast and accurate results.
Re: Libgsqlite: A SQLite extension which loads a Google Sheet as a virtual table
#9[deleted]
Re: Libgsqlite: A SQLite extension which loads a Google Sheet as a virtual table
#10Last 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…
[deleted]