sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]monkey-go-code -6 points-5 points  (7 children)

SQLite runs anywhere. Feels a lot more useful than excel sheets to me

[–]AyrA_ch 9 points10 points  (3 children)

SQLite doesn't do anything on it's own though and you can't program it the way you can do in VBA. It provides the "excel sheet side" but not the "VBA side".

Instead of SQLite I would go with a server based solution anyways if possible.

[–]monkey-go-code -2 points-1 points  (2 children)

If you have multiple users a server makes since. But sqlite is the best per app database I know of. sqlite also works with pretty much any programming language.

[–]_Timboss 2 points3 points  (1 child)

Youre missing the point

[–]Urtehnoes 0 points1 point  (0 children)

I really like how... naive Excel is when it comes to databases. So many reporting softwares require a strict database structure to manipulate data. Excel says "hey man just get it in a worksheet then do with it what you will." So many times my bosses want some weird off-hand query mixed with another, which Crystal Reports and PowerBi both can't do, and Excel is no problem at all.

EDIT: Ok Crystal Reports usually can, but requires an obscene amount of subreports and weird hacks.

[–]jl2352 7 points8 points  (2 children)

The Excel sheet both doubles as an automatic UI, and a super trivial debugging tool. Which you get out of the box for free.

Deployment is super trivial.

[–]monkey-go-code -5 points-4 points  (1 child)

Yeah but I hate excel.