Results 1 to 8 of 8

Thread: Database Help

  1. #1
    Join Date
    Aug 2007
    Location
    Oakham England
    Posts
    499

    Database Help

    Hey,

    Ok, I posted about SQL but I was thinking... Would I be able to make a .txt file the database? then get all the info from there? So its like a database but not....
    Or is there any other way I can go a catalog on a Web only server?

    Danny
    Streama - Your WordPress Friend
    http://www.streama.co.uk

  2. #2
    Join Date
    Aug 2003
    Location
    California, USA
    Posts
    581
    You might want to look into SQLite, it's like a database/text file/etc. and you can use standard SQL query syntax on it.

  3. #3
    Join Date
    Jan 2006
    Location
    Athens, Greece
    Posts
    1,479
    If it's simple you can use php arrays.

  4. #4
    Join Date
    Aug 2007
    Location
    Oakham England
    Posts
    499
    Quote Originally Posted by Steve_Arm View Post
    If it's simple you can use php arrays.
    Can you post an EG?
    Streama - Your WordPress Friend
    http://www.streama.co.uk

  5. #5
    Join Date
    Feb 2003
    Location
    AR
    Posts
    2,381
    Sure you can use a text file for data storage. But you're going to run into issues of file locking and etc.. on a heavily loaded sites. YaBB was a VERY successful perl bulletin board that used flat files for storage.

  6. #6
    How much traffic will this website get? It's totally possible to use a flat file storage, I did it in perl years ago, or you could use XML, but like someone mentioned file locking and whatnot will likely be a problem. I agree that SQLite is probably the best way to go.
    XZBackup.com/partners
    100% White-Label Branded Online Backup Reseller Program
    Windows / Mac / Linux / FreeBSD / Solaris / Novell
    Call Now! 1-800-213-2157 sales (at) xzbackup.com

  7. #7
    Join Date
    Aug 2007
    Location
    Oakham England
    Posts
    499
    Quote Originally Posted by xzbackup View Post
    How much traffic will this website get? It's totally possible to use a flat file storage, I did it in perl years ago, or you could use XML, but like someone mentioned file locking and whatnot will likely be a problem. I agree that SQLite is probably the best way to go.
    Not that much, its not like ebay that has millions of people all at once, but it will have like say Max 5 people at any one time

    Danny
    Streama - Your WordPress Friend
    http://www.streama.co.uk

  8. #8
    I still think you should investigate SQLite. It's probably easier to implement, especially because you can still use SQL queries on it. I think creating a text file-based system is a pain. Why re-invent the wheel?
    XZBackup.com/partners
    100% White-Label Branded Online Backup Reseller Program
    Windows / Mac / Linux / FreeBSD / Solaris / Novell
    Call Now! 1-800-213-2157 sales (at) xzbackup.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •