Quote:
Originally Posted by jjshabado
You could probably argue the same thing about databases.
Which is why it could be a good question for starting a discussion. And a ****ty question if you just want people to say some specific answer.
Yeah, I think I could argue the same.
Once you start to interact with an interface, the world is different no matter if you are comparing RDMS or spreadsheet programs.
I did try to explain it to the friend.
- A database is more abstract, so you don't have tools for visualization, like you would in Excel.
- Excel is more interactive and ad hoc.
- A database is a collection of tables. A "well formed" database has strict definitions about tuples and relationships between data. Excel doesn't really enforce this. I would further argue that a database that doesn't enforce referential integrity isn't really a database.
"So, a table could just be a sheet in a workbook, right?"
- If someone asks you that question again, just say "I don't know."
Quote:
Originally Posted by Grue
Well one is a tool millions of brain-dead office drones stare at thousands of hours per year feebly interacting with its outdated UI and tools that was poorly designed decades ago by people who really should have known better. The other is one of Microsoft's flagship products.
The part that pisses me off is about Excel is how it converts large numbers to scientific notation. Reallly, MS? This is supposed to be a financial tool and it can't handle numbers? WTF is format 0 anyways?
There are things that are really cool about Excel. Try hooking up a DSN to a remote database and you have a very powerful combo.
I'll keep my opinions of SQL Server to myself.