Store mailing list in DB or file?

Discussion in 'PHP' started by Tony Brar, Nov 10, 2012.

  1. #1
    Hi guys,

    Sorry for having so many questions all the time.
    You are awesome for all the quick answers.;)
    Anyway, should I store my site's mailing list in my DB or in a file?
    Obviously, if I used a file, the file's permissions would not allow a user to read or write to the file, and allow the owner to read and write to the file.
    When I ask this, I mean which should I use for security and speed purposes.

    Thanks,
    -Tony
     
    Solved! View solution.
    Last edited: Nov 10, 2012
    Tony Brar, Nov 10, 2012 IP
  2. EricBruggema

    EricBruggema Well-Known Member

    Messages:
    1,740
    Likes Received:
    28
    Best Answers:
    13
    Trophy Points:
    175
    #2
    i should choose for database, just not as easy to access then a file, second one is that you can easily read items add more information (for example, last send date for emails and such)
     
    EricBruggema, Nov 11, 2012 IP
  3. Tony Brar

    Tony Brar Active Member

    Messages:
    220
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    75
    #3
    That's a good point. I'll use that.
    Thanks!
     
    Tony Brar, Nov 11, 2012 IP
  4. #4
    The only logical solution would be a database.

    1. It's secure.

    2. It's searchable and sortable right out of the box.

    3. You can export the data to any kind of file format you wish to.

    4. Every webhost has a database viewer/administrator (like phpmyadmin) which makes it easy to export to CSV or view results via Point and Click.

    5. You can easily expand your database by adding columns to keep track of additional information.

    6. A database is fast to access and allows you to safely grow your list without taking a hit in performance.

    7. It's more fun =)
     
    NetStar, Nov 11, 2012 IP
  5. Tony Brar

    Tony Brar Active Member

    Messages:
    220
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    75
    #5
    Alright then! Database it is.

    Thanks,
    -Tony
     
    Tony Brar, Nov 12, 2012 IP