Hacker News new | comments | show | ask | jobs | submit login

Why do you want "an Excel/DB setup"? In what ways is Excel not enough?

You mention that a DB would be far more efficient. What kind of efficiency do you have in mind?




Querying and manipulating millions of rows. Basic usage of Excel doesn't work well there, in my experience.

The technique I've used in the past is to use SQL to query and output the data I need, then manipulate it in Excel. I'll leave it open that I'm not good enough with Excel, but I find MySQL query language more powerful for filtering, grouping, etc. However, there are a few too many steps in there, and it's not something I'll be teaching my mother. Someone actually has to set up the database, and that's no cake walk for the lay person.

Now, I'm going to take a guess that you're implying that Excel already has these features, to which I'll answer: possibly, but nobody I know is using them. That's why I think it's a large market.

But hey, if you know a solution off the top of your head, let me know. I'm always looking!


No, I don't think Excel already has those features. It's an open question how to do it in a way that the average spreadsheet user will find intuitive. Sounds like you have some opinions about that, as do I. But it looks like these guys have a useful product and I don't want to hijack their thread. If you want to discuss it offline my email is in my profile.


Excel encourages visual data layout, and I almost always see people putting way too much information in one row that would better be split off in to a related table. The only viable thing to do there is 'sheets' in Excel, but then people generally can't see the data at the same time, without even more funky queries

Being able to automatically recognize patterns in data which would be suitable for normalization techniques, then managing those techniques behind the scenes, would allow for people using a GUI for data entry, but would open up the possibility for more flexible/powerful/efficient SQL when needed.




Guidelines | FAQ | Support | API | Security | Lists | Bookmarklet | DMCA | Apply to YC | Contact

Search: