Database..... Help me Please......

Discussion in 'Mac Programming' started by mahaboob, Jul 20, 2008.

  1. mahaboob macrumors member

    Joined:
    Jul 10, 2008
    #1
    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 ?
     
  2. Sijmen macrumors 6502a

    Joined:
    Sep 7, 2005
    #2
    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.
     
  3. mahaboob thread starter macrumors member

    Joined:
    Jul 10, 2008
    #3

    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.
     
  4. Mac Player macrumors regular

    Joined:
    Jan 19, 2006
    #4
    You can ship you app with a compiled version of mysql inside it.
     
  5. alaceo macrumors member

    Joined:
    Feb 21, 2008
  6. savar macrumors 68000

    savar

    Joined:
    Jun 6, 2003
    Location:
    District of Columbia
    #6
    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
     

Share This Page