3 ms·
Not in every respect. It's easy to create a schema in, and get a nice entity-relationship diagram, and knock some data in. I don't know of another tool that eve
by cturner 18y ago
Not in every respect. It's easy to create a schema in, and get a nice entity-relationship diagram, and knock some data in. I don't know of another tool that even comes close to being as lovely to work with for personal databases. Of course.. a lot of evil is done because people use it for more than that.
Excel and Word have the same dyanamic. They're quick to get started in and have a user interface to die for, and they're really really bad underneath.
For small single-user projects these things can be OK. I do most of my personal finances in a python tool, but run monthly position in excel. I write speclets in Word because I like the default styling. It's great for quick letters as well.
Both are dangerous for anything larger, or anything involving multiple users.
I'm trying to get my current organisation to be serious about using a wiki for documentation tracking. I want to scream most days because of the way that use of Word and email is hard-coded into people's brains regardless of how many times I try to find tactful ways of winning people over by making the case for how effective wiki is for merging, searching, history, navigation, version control and centralised single-port-of-call. It doesn't have any effect.
The problem would just go away if there was a way to get Word to sit as interface to a wiki, and excel as a frontend to something appropriate for its datastructures - even if it meant significantly reducing the functionality of the tools. Unfortunately the only way I know of of doing this involves using sharepoint which has lots of lockin and deletes files when I save them in vim. In the same way, I suspect Access would be fine if you used it as front-end to a serious SQL database (of the three tools, the only one where such a thing is practical).