Journal TopShelf's Journal: Which free (as in beer) database would you recommend? 6
At the risk of starting a classic flame war, I have a pressing request for assistance.
As a hobby, I blog about NHL hockey, in particular the extension of statistical analysis which until recent years has been about as sophisticated as ancient cave drawings. For the last year or so, I've pursued this by compiling data in spreadsheets for a series of ad-hoc analytical pursuits, but the time has come to formalize my data structures into a database with tables fed by scripts that parse game data as posted at NHL.com. But which free database should I use?
Some operational parameters to consider: I'm envisioning some basic data import tables (I'm developing scripts in Excel to pull the web data down and parse into columns), followed by a series of tables fed by programs which pull data together from a variety of sources (stored in table form for ease of reporting). Most of these tables would only run in the 1,000 - 100,000 range, while one in particular could run as high as 5,000,000 or so. There aren't many instances where multiple indexes over a given table would be required, but the reporting built off these tables could be computationally intense (i.e. exponential moving averages built off of subtotals).
So which DB should I choose? MySQL, PostgreSQL, Open Office's Base? I'm at a bit of a loss as to which direction to go in, and I'd rather not head down a particular path only to find it's not going to pan out.
well (Score:2)
You mention Excel - so you must already be using windows and sql server ties in very nicely with windows and other ms products. The interface is pretty nice and simple to use. I don't think the interface on Oracle is quite as easy - but you do gain the ability to run
Re: (Score:2)
Re: (Score:2)
I'm no MS fan- but SQL Server has come a long way and really isn't a bad
I like Postgres (Score:1)
Re: (Score:2)
I've only done small stuff - but I like MySQL (Score:2)
And one year, at home I set up MySQL on Winders and used it for mail-merge to generate the Christmas Card address labels from OpenOffice. Talk about using a sledge where a tack hammer would do.... Yes, last year I went back to WordPerfect mail