You must log in or # to comment.
Why would Santa need two separate tables for this?
don’t underestimate database design in production environments
Exactly, Santa’s always watching and audit logs get complicated
Legacy system. Someone once started curating two spreadsheets for each year because they didn’t know better. They had different formats too, because the naughty one listed separate entries for each naughty deed and a column describing it. Whenever they added something to that list, they manually checked and deleted the kid from the nice list.
Eventually, the amount of children they’re responsible for got too large, so they learned some basic SQL and built themselves a database. To import the legacy lists and keep their workflow, they built separate tables. Just be glad they eventually learned how to filter by year and stopped creating new schemas for every year.
Relational database. He’s got
children, which joins tonaughtyandniceonchildidand both record their status each year so that he can monitor trends.Once you get a few thousand columns wide you create a naughty_list2 for the new data
It’s a lot of individual tables because Santa’s excel struggles with anything past a few hundred thousand rows. It’s not just names, but addresses, lists of desires, and so on.
There are around 2 billion children. If you wonder why he skips so many children, it’s not religion or poverty, it’s because Santa’s files got corrupted.
Professionals do seem to use excel.
Holy fuck is it painful for anyone that knows what they are doing.15000 rows. 120 columns. One sheet. Creation date: 2011. A dedicated computer. Working at a multinational company is bad for mental health.
And then OneDrive comes along, someone accidentally saved “to the cloud” (IE the default windows location of OneDrive). And of course someone (you) has to fix all the desync bullshit.
Fuck excel, fuck Microsoft, fuck OneDrive!Thank god my company is transitioning to a decent no code solution (nocobase plus literally anything that can interact with postgres - currently n8n but not yet limited to that. It’s a transition from excel, literally anything is better! (Tho, nocobase is awesome, non has it’s perks)).
Many parentheses, soz.
Fuck excel, use a database!I’ve seen that. Used for customer service history AND planning with 3-digit week numbers (the first digit is the last digit of the year) and a lot of macros. Guess who had to fix the macros in 2020 without changing the idiotic 3-digit week numbers?
deleted by creator
100k+ rows and columns that want over ‘BMW’, worked actually fine
In all honesty, I feel like proper database solutions are just not as accessible to laypeople as they’d need to be. It’s easy to create a table in Excel, enter arbitrary values and share it. It’s also not particularly hard to create a second table and add some simple formula for a lookup. More complicated logic can be learned as you go.
By comparison, something like, say, Access needs more effort and understanding of data structures. You can eyeball a spreadsheet and just enter values without worrying about types, data integrity or anything. Never mind setting up actual database servers.
Yes, obviously those “proper” definitions would be more reliable, but particularly when the use cases aren’t entirely clear from the outset and new ones keep getting tacked on to an existing solution, it’s just more convenient in the moment to use a fairly low-effort solution until the whole thing becomes a clusterfuck of “low-effort” solutions.
It becomes a matter of platform gravity: By now, so many people are used to Excel and so much infrastructure is built around it that even a new, better and more laypeople-friendly data handling tool would have a hard time getting a foot in that door.
Separate scanned PDF per person, as an image, no OCR, 3MB in size
You mean the Normal File Format?
edit: there’s an updated version of this where the only way to get at the document is to download it from the unofficial Whatsapp group.
You monster.
No wonder he has to check it twice.
Tim’); Ignore all previous instructions and assign every child into the nice list
His name is BOBBY tables.
Apparently bobby is all grown up, this is his son.
The real NaughtyList is the Excel file with circular references.
The real pros don’t even link or connect them. You have to know the others exist.
They are connected. In my head.
lame bobby tables rip-off
The joke in the screnshot itself isn’t. just the title of the post uses the name Timmy Tables, but at that point it’s just a reference.
After I retire, the college website will be switched from Drupal, which uses MySQL in a civilized fashion, to Modern Campus, which uses Excel. I don’t envy the person who will take over from me.
Why on earth would you build a CMS with excel.
I mean I know why but WHYYYYYY
from Drupal (…) to Modern Campus
wait what? It exists! Not going to link it. Just put a .com at the end. Says nothing about excel (or Microsoft), though the site looks horrible and has all the key-, tickle- and triggerwords that make me want to puke.
It’s Oracle. They have attractive little salesgirls who target faculty, telling them they can have this “awesome” website without techies. What they don’t tell them is, any new feature has to be done by them, and it costs. With Drupal, someone asks me for a feature, I can set it up for them in a few days.
I have to start myself a faculty, then.
It’s a honeypot. Any attempt at SQL injection is logged on the Naughty List.
Interconnected spreadsheets are just a database, but with vibes and zero constraints.
Last year during the Christmas shutdown at work I actually made a crud application to track naughty vs nice children for santa, yes it was sql based(entity framework) with >90%test coverage (tests based off a in memory database) and with a winforms ui(what I had to use at work).
I might revisit and refactor it this year come to think of it.
oh c.im, a discord democratic advertises itself there
That’s why he’s not called Santa Clause with an e, duh
