Sunday, January 05, 2014

Excel and databases should go hand in hand

Data is database driven and I am really surprised at the lack of good tools to visualise and update data in databases. Why is it that for every application that we need specialised applications used to connect to some database in some model? It doesn't make sense to me.

Even now after working with databases for about the past year, the current way that data management in databases is terrible, where we are restricted to using queries, inspecting the data and then writing update commands to update the data. This entire step needs to be done away with and there should be something in excel that could be used to go straight into the database and modify the data instead of using this currently terrible method. The market is huge for corporate users and I am willing to bet that given right pitch, it would be easy to get corporate users to use the product.

No comments: