Hi! I'm newbie!
I'm working on chat module using PHP and Postgre and I don't Know how to store the chats. Should I do it on files or as part of the data base??
If anyone has any pro ands cons or any new ideas I'm all ears..
Thanks!!! 
- aPaddedCell © Copyright 2006-2008 InterMedia. Site and all articles (unless otherwise specified) licensed under a Creative Commons License. Icons based upon the Tango icon set by various artists.
- All trademarks and copyrights on this page are owned by their respective owners. Forum posts are owned by the individual posters.
zollet posted this at 05:58 — 16th March 2004.
He has: 1,016 posts
Joined: May 2002
I don't believe there are any pros for using text file databases. They're slow, unreliable and eat all your server resources.
Saeed Sarvi [ Email | Profile ]
Greg K posted this at 19:10 — 16th March 2004.
He has: 1,669 posts
Joined: Nov 2003
Since it was said "or as part of the database", I think what was being asked is if the actual conversation should be stored in the database, or in a text file and maybe have the database point to that filename.
The pro to having it part of the database is that then you don't have to worry about creating filenames, etc and where to store them.
Now, if you have the database on a different server than the web server, then (depending on how big the files are), there could be some speed difference haivng the files saved as text files on the web server as the program would not have to pull all of the data across from another server, just a link to a file that is on the same web server.
-Greg
[This space intentionally left blank]
Cool Geek Supplies: www.ThinkGeek.com
s0da posted this at 19:32 — 16th March 2004.
He has: 159 posts
Joined: Mar 2004
do you mean like a chatterbox type thing? that can easily be stored in SQL .. much better than flat-file.