Re:The Tyranny of Spreadsheets
by markus_zhang on Thursday July 22, 2021 @11:49PM
(#27926993)
Now that you mentioned, we didn't have access to SQL Server dwh until 6 months before I left for good.
Can you try sqlite? It's usually enough for simple things I think.
Re:The Tyranny of Spreadsheets
by kwyjobojoe on Friday July 23, 2021 @03:54AM
(#27928299)
But then we need something to interface with the db. Getting any programming language installed isn't going to happen in government.
Re:The Tyranny of Spreadsheets
by regularfry on Friday July 23, 2021 @08:14AM
(#27929819)
Best of both worlds: libsqlite.dll is almost certainly on any corporate Windows rollout somewhere already, and you can load it into Excel as an extension for a pretty front-end that happens to have a programming language built in.
Re:The Tyranny of Spreadsheets
by andrew_jef on Friday July 23, 2021 @05:08AM
(#27928698)
Nocodb is trying to solving the issues of implementing a spreadsheet-like frontend on top of a database backend
https://www.nocodb.com/
Why? Because we don't have access to any databases. I dread to think of the requests and committees I would need to find and traverse to get a database set up for my team, let alone a system that I can write and run code on. Yet we can guarantee that every internal and external user has access to Excel.
Unless you are working for a software firm, or are part of a dedicated analytics team with access to suitable systems, large companies and government pretty much have no chance of being able to roll your own database.
Don't suggest Access. Never suggest Access.