Need Spreadsheet / Database Program for Monster File
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?
About The Author
-
.: Recent Posts :.
.: They Like Me. They Really Like Me. :.
.:
Dennis Elias’s Latest Tweet :..:
Injustice News Twitter Feed :.- InjusticeNews: Baton Rouge LA cops accused of brutality at parade & threatening people taking pics, college paper editor blames victims: http://is.gd/aFTax
- InjusticeNews: Williamston SC cop who also appears to work for Belton SC PD suspended after arrested on DV and kidnapping charges: http://is.gd/aFx20
- InjusticeNews: Torrance CA police accused of racial profiling by pastor pulled over and frisked in an alleged case of mistaken identity: http://is.gd/aFvoo
.: Search :.
.: Subscribe via Email :.
.: Most-Commented Posts :.
-
.: Recent Comments :.
-
.: Recent Posts :.
.: Archives :.
.: Categories :.
Surely MySQL has a OS X version?
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.
Mark wrote: Suggestions?
Get less data.
What sort of results or capabilities are you looking for once the data is loaded?
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.
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.
Check out Oracle’s offerings…
http://www.oracle.com/technology/tech/macos/index.html