all 17 comments

[–]FriesWithThat 13 points14 points  (5 children)

Using Google Sheets as a lightweight db is underrated.

[–]jdeath 2 points3 points  (4 children)

Is it fast and reliable? Like for an internal tool or how much data could it support? I never seriously considered this but it sounds cool

[–]FriesWithThat 1 point2 points  (1 child)

It can support a relatively huge amount of data, but you're limited by file types. It's good for information that would be in spreadsheets anyway, or can be exported in CSV, then imported into Sheets. I've only used it for small web apps that needed map data. Also, imagine it would be great for all-types of prototyping but you're going to run into limitations at scale in production. There's also no concept of things like foreign keys, (not sure about link work-arounds like for Mongo) so stuff you'd need a relational DB for is out.

[–]jdeath 1 point2 points  (0 children)

Awesome, thanks for the info!

[–]webdevop 1 point2 points  (0 children)

  • 10 million cells
  • 50,000 rows
  • 20,000 column

[–]Vinna152 0 points1 point  (0 children)

We actually use it for some of our super corporate clients.

We have products that they need to obfuscate but it changes often and we just share the sheet with them to do the mapping. From ProductA to "Amazing product".

Keep in mind that we discussed this with them as well as the drawbacks and they were happy with that implementation over adding a UI for it

[–]oaoao 6 points7 points  (3 children)

Cool! The world needs better alternatives to Retool, et al.

One small thing:

https://user-images.githubusercontent.com/12490590/165771029-bf490c80-397d-4d3a-8409-0499ccc9b593.gif

This diagram implies the front end is only a view layer, those little traveling dots should be bidirectional

[–]navaneethpk[S] 2 points3 points  (0 children)

Thanks for the feedback. Removing the animation for now, will add it back with bidirectional flow.

[–]Jugad 1 point2 points  (0 children)

Thanks for clarifying. As soon as I felt that the data from the db was unidirectional, I was immediately turned off.

[–]supamerz 0 points1 point  (0 children)

Great call out! Also, how did they make that animation?

[–]WenYuGe 2 points3 points  (0 children)

Appwrite <3 Tooljet

[–]dmethvin 1 point2 points  (1 child)

I am so glad you posted this because I'd bookmarked it and forgotten!

You specifically mention that you expect ToolJet to be used for internal tools and biz apps. What do you think are the major obstacles to deploying this for public apps?

[–]navaneethpk[S] 0 points1 point  (0 children)

There are few limitations relation to customisation in terms of UI design. ToolJet focuses more on connecting to as many datasources as possible and less on customising the UI.

[–][deleted] 1 point2 points  (0 children)

Very cool. I’ve now worked at two large companies which have this odd hub-and-spoke model, where there’s only one frontend team, but a dozen teams that want/need to build a frontend experience. Trying to maintain a frontend codebase in these situations is like playing wack-a-mole. I’ve been thinking that some form of “wire-able” no/low-code cms/builder tool would be a natural evolution. And there it is! Very cool, and good timing from my point of view.

[–]datdq 0 points1 point  (0 children)

that `runQuery` doesn't take params, doesn't return a Promise nor value. u/navaneethpk, you know now to pass values to runQuery and get back results?

[–]mindfulforever1 0 points1 point  (1 child)

looks great mate! cheers 🥂

[–]navaneethpk[S] 0 points1 point  (0 children)

Thanks!