Show HN: Use Google Spreadsheet as a Database
1–10 of 18 posts
Re: Show HN: Use Google Spreadsheet as a Database
#2Love the idea. Clearly, a ton of effort put into this, congrats on shipping. But if you're going to abstract away Google Sheets, you might as well make a thicker abstraction. I want to use Google Sheets like a key-value store or some Mongo-like API, without thinking about worksheet names, column names, or underlying worksheet-specific implementation details. Your custom designed API is too much of a leaky abstraction, seems that it's not too far from me learning and using the Google Sheets API directly. Consider how other libraries like diskDB abstracted away the filesystem behind a Mongo-like API.
Re: Show HN: Use Google Spreadsheet as a Database
#3Love the idea. Clearly, a ton of effort put into this, congrats on shipping. But if you're going to abstract away Google Sheets, you might as well make a thicker abstraction. I want to use Google Sheets like a key-value store or some Mongo-like API, without thinking about worksheet names, column names, or underlying worksheet-specific implementation details. Your custom designed API is too much of a leaky abstraction…
Then submit a pull request. Don't sob about it here.
Re: Show HN: Use Google Spreadsheet as a Database
#4Who said we're all just putting spreadsheets on the Internet?
This at least makes that easier...
Re: Show HN: Use Google Spreadsheet as a Database
#5Love the idea. Clearly, a ton of effort put into this, congrats on shipping. But if you're going to abstract away Google Sheets, you might as well make a thicker abstraction. I want to use Google Sheets like a key-value store or some Mongo-like API, without thinking about worksheet names, column names, or underlying worksheet-specific implementation details. Your custom designed API is too much of a leaky abstraction…
... or sign up for firebase.
Re: Show HN: Use Google Spreadsheet as a Database
#6Using google spreadsheets is a favorite of mine for prototypes. Especially without building out an admin app.
Re: Show HN: Use Google Spreadsheet as a Database
#7Using google spreadsheets is a favorite of mine for prototypes. Especially without building out an admin app.
It is indeed. Much faster, because of almost no setup.
You can also use Google Spreadsheets for your Sketch prototypes https://medium.com/@Fif/create-your-own-api-for-craft-data-p...
Re: Show HN: Use Google Spreadsheet as a Database
#8Love the idea. Clearly, a ton of effort put into this, congrats on shipping. But if you're going to abstract away Google Sheets, you might as well make a thicker abstraction. I want to use Google Sheets like a key-value store or some Mongo-like API, without thinking about worksheet names, column names, or underlying worksheet-specific implementation details. Your custom designed API is too much of a leaky abstraction…
That's a very good insight! We treat spreadsheet more like a database with a schema. What you propose is a schema-less approach. I like this idea, and I think we will try to implement it, as we see that in such solutions schema is needless and is adding more complexity for the end user, which, in most cases, don't care if there is any schema or not - she is just a spreadsheets user.
From the other hand, it's hard to map JSON to a spreadsheet, because - what to do with the nested keys. Any ideas?
Re: Show HN: Use Google Spreadsheet as a Database
#9Don't do that. Please.
Re: Show HN: Use Google Spreadsheet as a Database
#10Don't do that. Please.
Why?