News for hackers. Stuff that matters.
Re:Excel and SQL by magicg on Thursday May 23, 2013 @04:18PM (#5759264)
Which database is best for stuff like this?

And works with Python.

Re:Excel and SQL by IanChiles on Thursday May 23, 2013 @04:28PM (#5759331)
Python has bindings for pretty much everything, so I'd imagine that the database you're most familiar with, or that there is the most information on (most likely MySQL, Postgres, or SQLite)
Re:Excel and SQL by kevinthew on Thursday May 23, 2013 @04:41PM (#5759409)
I'd suggest SQLite unless you had a ton of users interacting all at once (if it's something involving editing excel spreadsheets, I doubt you'd have a problem with this).
Re:Excel and SQL by IanChiles on Thursday May 23, 2013 @05:06PM (#5759544)
Slightly off topic, but has anyone built an Excel-esque program on top of SQL? I feel like something of the sort could really be an improvement, as now it'd be easy for end users (who normally use excel) and developers to collaborate on the same data.
Re:Excel and SQL by trapezoid on Thursday May 23, 2013 @04:31PM (#5759346)
Like the article says, SQLite is a good choice when you're starting out. It's included in Python and is great for the basics.

Once you have a lot of data, it really depends on your specific situation. If you don't have any preferences, you can try something new - MongoDB is interesting.

Re:Excel and SQL by tinsel on Thursday May 23, 2013 @04:36PM (#5759379)
MongoDB/NoSQL is not for the type of analysis mentioned in the article and is NOT a replacement for a spreadsheet.

Out of all the nosql options, why pick the one with the most broken default configuration? People complain that MongoDB is has a bad rep when used for things its not meant to, and then its constantly offered as solution.