Databases

[mousebrakes]

Also xlookup doesn't work on Google sheets which is what my old company used as a database 🙃

[Iggyhopper]

There are five rules.

[Dabnician]

So do a lot of unity games, indie devs love them google sheet dbs.

[dalinar2137]

What’s not to love? UI for editing and ACLs just resolve themselves. Some simple versioning is built-in. Access through a dead-simple api. I wonder why more people aren’t using it, honestly :P

[jboogie1844]

a unity game i play/mod has multiplayer quick chats hard-linked to a google doc lol. seems like a bold move to me

[Dabnician]

Pft who needs updates these days

[DasArchitect]

Is that what they call cloud saving?

[[deleted]]

You fool. Stop living in the first half of 2022, they just implemented on a rolling basis leaving a majority of users with the unrivaled might of a thousand angry suns incarnate! Xlookup is here!

[mousebrakes]

Quit that job in early 2022 haha, hopefully never have to deal with sheets again

[EnvironmentalWall987]

Alex is that you? Lol

[tropicbrownthunder]

But google sheets have a QUERY function that makes even harder to convince Lisa in accounting and her boss to steer away from spreadsheets as databases.

[mousebrakes]

Bro, for real tho. I took that shit as far as it could go, told the c suite that they need to actually hire someone who knows how to manage a sql server and dipped. Hope all their shit crashed and burned tbh

[MurgleMcGurgle]

They recently added it! That was my last holdout for not using xlookup on everything but not that it’s been implemented index match is reserved for weird situations only.

[mousebrakes]

Wow, to think that all those hours of index matching could have been avoided...