Defending People

I need an OS X program to handle 1.5 million lines of data. Prefer freeware / open source / shareware, but will go commercial if necessary.

Suggestions?

on 14 Apr 2008 at 4:19 pm1Ron in Houston

Surely MySQL has a OS X version?
on 14 Apr 2008 at 5:35 pm2Windypundit

That was my thought too, and the server is available for OX X, but I don’t know if the tools are there to import the data from a file and do ad hoc queries. I don’t know MySQL well enough to tell which tools you’d need, and some of them only run on Windows. It might get a bit technical.
on 14 Apr 2008 at 6:04 pm3PJ

Mark wrote: Suggestions?

Get less data.
on 15 Apr 2008 at 2:43 am4Windypundit

What sort of results or capabilities are you looking for once the data is loaded?
on 15 Apr 2008 at 9:40 am5Mark Bennett

I’ve got a 1.5 million line CSV file of district clerk records. I’d like to be able to manipulate the data on my mac (convert yyyy-mm-dd dates to another format, split fields with LN, FN into separate fields, and so forth), then upload it to an SQL database online.
on 15 Apr 2008 at 10:57 pm6Windypundit

I hope somebody else sent you something useful, because I haven’t got much. The Apple world is foreign to me. If I had to throw out a wild guess, I’d say download the trial version of FileMaker Pro and see if it does what you need. The commercial license will set you back $300.
on 21 Apr 2008 at 9:33 am7Allison Fisher

Check out Oracle’s offerings…

http://www.oracle.com/technology/tech/macos/index.html

Need Spreadsheet / Database Program for Monster File