Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

mahaboob

macrumors member
Original poster
Jul 10, 2008
31
0
Hi all,
I'm developing an application that uses database. I have a table with around 30,000 rows. I want to use this table in my application and also I want to create the setup. So I can't use MySQL as database. I want to store the table as file, comma separated variables, xml file or like. How can I do this ? Is there any database that can be use to save as a file ?
 
I don't see why you wouldn't be able to write your application using MySQL.

Implement the models and controller(s) using MySQL, then pass that data to the NSTableView.
 
I don't see why you wouldn't be able to write your application using MySQL.

Implement the models and controller(s) using MySQL, then pass that data to the NSTableView.


If I'm using MySQL and trying to install the setup in another machine that do not have MySql, I want to install MySQL also. That is why I'm trying another way.
 
If I'm using MySQL and trying to install the setup in another machine that do not have MySql, I want to install MySQL also. That is why I'm trying another way.

You can ship you app with a compiled version of mysql inside it.
 
Hi all,
I'm developing an application that uses database. I have a table with around 30,000 rows. I want to use this table in my application and also I want to create the setup. So I can't use MySQL as database. I want to store the table as file, comma separated variables, xml file or like. How can I do this ? Is there any database that can be use to save as a file ?

XML is a terrible idea. CSV is doable, but you would need to load your entire dataset into memory before using any bit of it. This is fine for 30k rows, but what if you need more in the future?

Using a relational database (somebody else mentioned sqllite == good) would allow for more scalability.

I suggest you read this: http://www.joelonsoftware.com/articles/fog0000000319.html
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.