What is the best Mysql alternative ?

Discussion in 'PHP' started by omaryo, Dec 22, 2008.

0
  1. #1
    i want to know what is the best sql database alternative ??
    using .txt files or .csv ...? and how to store data in it ?
    i mean to avoid server eat recources !
    Thanks
     
    omaryo, Dec 22, 2008 IP
  2. goscript

    goscript Prominent Member

    Messages:
    2,753
    Likes Received:
    306
    Best Answers:
    0
    Trophy Points:
    315
    #2
    No way of using txt or csv files. Mysql is the best. Why are you searching for an alternative?
     
    goscript, Dec 22, 2008 IP
  3. omaryo

    omaryo Well-Known Member

    Messages:
    1,218
    Likes Received:
    10
    Best Answers:
    0
    Trophy Points:
    140
    #3
    i know that ! but im lookign for an alternative for just retriving data !!
     
    omaryo, Dec 22, 2008 IP
  4. DomainCo.US

    DomainCo.US Well-Known Member

    Messages:
    2,124
    Likes Received:
    18
    Best Answers:
    0
    Trophy Points:
    100
    #4
    You can try sqllite
     
    DomainCo.US, Dec 22, 2008 IP
  5. Justinee

    Justinee Guest

    Messages:
    6
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    http://www.alternative.to/MySQL,19545#nav-4236806 here you can find some alternatives with description :)
     
    Justinee, Jun 22, 2011 IP
  6. AdsMakeSense

    AdsMakeSense Active Member

    Messages:
    389
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    70
    #6
    SQlite is good but not really for heavy dosage read/write like mySQL.
     
    AdsMakeSense, Jun 22, 2011 IP
  7. themullet

    themullet Member

    Messages:
    110
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    26
    #7
    txt files or csv could work. do you have the options of mysql? as really for the amount of memory you'd save not using it pulling it back out of php would hurt more

    nosql could be an option as well if you have root on the server
     
    themullet, Jun 22, 2011 IP
  8. mallorcahp

    mallorcahp Peon

    Messages:
    141
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #8
    If ALL you are doing is storing and retrieving the information then text files could work but the minute you want to retrieve a subset of information based on criteria (eg. a SELECT statement) forget it.

    You will need to write you own query engine to search the file(s) data first, or, read all the file(s) data into memory and then search it.

    Stick to MySql would be my advice...
     
    mallorcahp, Jun 23, 2011 IP
  9. prashishh

    prashishh Peon

    Messages:
    12
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #9
    What about Oracle? But stick with MySQL
     
    prashishh, Jun 23, 2011 IP
  10. ntomsheck

    ntomsheck Peon

    Messages:
    87
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #10
    I guess the better question is, are you looking for a mysql alternative or a database alternative? For a mysql alternative, I've heard good things about PostgreSQL. If searching isn't a key factor, then flat files will work just fine. I use txt files for IP/user agent block lists, to prevent multiple votes.
     
    ntomsheck, Jun 23, 2011 IP