cordoprod Posted August 16, 2007 Share Posted August 16, 2007 You vote. Quote Link to comment https://forums.phpfreaks.com/topic/65217-flat-file-or-mysql-poll/ Share on other sites More sharing options...
MadTechie Posted August 16, 2007 Share Posted August 16, 2007 really depends in the site setup.. if SQL is already used then why not.. if the news system is just a very simple one then why not use flatfile!! more info needed PS i voted SQL as you can do more advanced stuff later! Quote Link to comment https://forums.phpfreaks.com/topic/65217-flat-file-or-mysql-poll/#findComment-325678 Share on other sites More sharing options...
GingerRobot Posted August 16, 2007 Share Posted August 16, 2007 Flat files are a pain. The whole point of databases is to store data; use the right tool for the job. Quote Link to comment https://forums.phpfreaks.com/topic/65217-flat-file-or-mysql-poll/#findComment-325693 Share on other sites More sharing options...
cordoprod Posted August 16, 2007 Author Share Posted August 16, 2007 Yeah, I guess. But last time I got alot of complaintings because they didn't had a db, and blabla.. Quote Link to comment https://forums.phpfreaks.com/topic/65217-flat-file-or-mysql-poll/#findComment-325698 Share on other sites More sharing options...
LiamProductions Posted August 16, 2007 Share Posted August 16, 2007 mySql, But shouldnt this be in Polls Quote Link to comment https://forums.phpfreaks.com/topic/65217-flat-file-or-mysql-poll/#findComment-325735 Share on other sites More sharing options...
zq29 Posted August 16, 2007 Share Posted August 16, 2007 Yeah, I guess. But last time I got alot of complaintings because they didn't had a db, and blabla.. If 'they' want a database based application, they need to be installing a database server, not complaining. Moved to polls. Quote Link to comment https://forums.phpfreaks.com/topic/65217-flat-file-or-mysql-poll/#findComment-325744 Share on other sites More sharing options...
charliepage Posted October 27, 2007 Share Posted October 27, 2007 Of course using flat file for news isn't a horrible idea and it could be the better option in a very small amount of occasions, but in general, using MySQL is frankly all-around better. Much easier, much much more advanced (in the way, that you can use MySQL for just about unlimited possibilities) and it is on a very high majority of hosts. I suppose I am just a tad biased. Quote Link to comment https://forums.phpfreaks.com/topic/65217-flat-file-or-mysql-poll/#findComment-379005 Share on other sites More sharing options...
slapme Posted February 14, 2008 Share Posted February 14, 2008 MySQL definatley Quote Link to comment https://forums.phpfreaks.com/topic/65217-flat-file-or-mysql-poll/#findComment-466876 Share on other sites More sharing options...
karltanav Posted February 21, 2008 Share Posted February 21, 2008 Ive used plain txt files and those are a nightmare, nothing compared to the SQL databases in order to have the information well sorted and saved Quote Link to comment https://forums.phpfreaks.com/topic/65217-flat-file-or-mysql-poll/#findComment-472461 Share on other sites More sharing options...
sureshp Posted March 24, 2008 Share Posted March 24, 2008 Shall we use SQL Lite for this one? it is also well sorted and saved i think so. Quote Link to comment https://forums.phpfreaks.com/topic/65217-flat-file-or-mysql-poll/#findComment-499808 Share on other sites More sharing options...
Bladescope Posted March 31, 2008 Share Posted March 31, 2008 Always used MySQL. Quote Link to comment https://forums.phpfreaks.com/topic/65217-flat-file-or-mysql-poll/#findComment-505512 Share on other sites More sharing options...
unsider Posted April 1, 2008 Share Posted April 1, 2008 MySQL *quick, easy, pretty reliable flat files *pain in the arse Quote Link to comment https://forums.phpfreaks.com/topic/65217-flat-file-or-mysql-poll/#findComment-506232 Share on other sites More sharing options...
Daniel0 Posted April 1, 2008 Share Posted April 1, 2008 flat files *pain in the arse Why? Quote Link to comment https://forums.phpfreaks.com/topic/65217-flat-file-or-mysql-poll/#findComment-506234 Share on other sites More sharing options...
unsider Posted April 1, 2008 Share Posted April 1, 2008 I may be a little misguided here, but from the little I've used and read about them. I think they're a little out-dated/better methods avaliable, therefore resulting in ineffeciency. Hmm, now that I look back I could have used a better word to describe them...I guess there are just better, more effecient methods, and in this case mySQL. Quote Link to comment https://forums.phpfreaks.com/topic/65217-flat-file-or-mysql-poll/#findComment-506240 Share on other sites More sharing options...
Daniel0 Posted April 1, 2008 Share Posted April 1, 2008 I take it you haven't heard of SQLite. It stores the entire database in a single (flat) file. SQLite is in many instances more efficient than running running daemons such as MySQL, Oracle or PostgreSQL. It's used by Firefox, iPhone, Skype and Trac just to name a few. Your sig says you're using Mac OS X, so it's already on your computer. Quote Link to comment https://forums.phpfreaks.com/topic/65217-flat-file-or-mysql-poll/#findComment-506245 Share on other sites More sharing options...
unsider Posted April 1, 2008 Share Posted April 1, 2008 I take it you haven't heard of SQLite. It stores the entire database in a single (flat) file. SQLite is in many instances more efficient than running running daemons such as MySQL, Oracle or PostgreSQL. It's used by Firefox, iPhone, Skype and Trac just to name a few. Your sig says you're using Mac OS X, so it's already on your computer. Nope, I haven't, I'll have to check it out. Quote Link to comment https://forums.phpfreaks.com/topic/65217-flat-file-or-mysql-poll/#findComment-506313 Share on other sites More sharing options...
markjoe Posted May 1, 2008 Share Posted May 1, 2008 There situations that flat files are just fine and even easier, they are just few and far between. I needed to make an ultra simple web front end for our FTP server (upload+download). So i wrote about 20 lines of HTML+PHP and used a date/time algorithm for the password instead of installing an SQL database just for one username and password. Flat file would have worked just as well, I just went one step even lazier. Quote Link to comment https://forums.phpfreaks.com/topic/65217-flat-file-or-mysql-poll/#findComment-530859 Share on other sites More sharing options...
448191 Posted May 1, 2008 Share Posted May 1, 2008 I take it you haven't heard of SQLite. It stores the entire database in a single (flat) file. SQLite is in many instances more efficient than running running daemons such as MySQL, Oracle or PostgreSQL. It's used by Firefox, iPhone, Skype and Trac just to name a few. Your sig says you're using Mac OS X, so it's already on your computer. Before everybody starts dropping their RDBMS in favour of SQLite.... It should be noted that although efficient in the right application, SQLite doesn't scale too well. Tbh, I'm a bit surprised that Trac uses SQLite. I assume it's optional. Also, SQLite does not fall in the ' flat-file database'-category. It is a relational database system. The fact that it uses a single file for storage instead of many does not change that. SQLite is not build for high concurrency. It locks the entire db file. This isn't an issue for most applications, especially desktop applications like the ones in your list, but in applications with potentially high concurrency (such as these forums), it should be avoided IMHO. Check out this link, which gives some indication of how locking of the db file is going to affect concurrency: http://www.sqlite.org/lockingv3.html#writer_starvation Quote Link to comment https://forums.phpfreaks.com/topic/65217-flat-file-or-mysql-poll/#findComment-530898 Share on other sites More sharing options...
448191 Posted May 1, 2008 Share Posted May 1, 2008 Hmm.. It would seem Wikipedia thinks I'm wrong about this bit: Also, SQLite does not fall in the ' flat-file database'-category. It is a relational database system. The fact that it uses a single file for storage instead of many does not change that. Practical implementations * Berkeley DB, a robust flat file database for critical applications which does ACID. * TextDB, a file-based database designed to handle high loads. * SQLite, a small C library that implements a self-contained, embeddable, zero-configuration SQL database engine. * Mimesis, an ffdb that uses multiple files and folders in order to increase the reliability of atomic updates. Quote Link to comment https://forums.phpfreaks.com/topic/65217-flat-file-or-mysql-poll/#findComment-530903 Share on other sites More sharing options...
jcombs_31 Posted May 14, 2008 Share Posted May 14, 2008 I really think a flat file should only be used for something like a configuration file. It doesn't make any sense to store data in a flat file. Quote Link to comment https://forums.phpfreaks.com/topic/65217-flat-file-or-mysql-poll/#findComment-541088 Share on other sites More sharing options...
947740 Posted May 15, 2008 Share Posted May 15, 2008 To me, everything would be easier with a database. You can make scripts to edit the news stories, add news stories, delete news stories, etc. Sure, you can do that with a flat file, but it would be (I think) harder. It just seems that MySQL and other relational database systems would be better for that application. Quote Link to comment https://forums.phpfreaks.com/topic/65217-flat-file-or-mysql-poll/#findComment-542172 Share on other sites More sharing options...
dare87 Posted May 20, 2008 Share Posted May 20, 2008 MySQL all the way! Quote Link to comment https://forums.phpfreaks.com/topic/65217-flat-file-or-mysql-poll/#findComment-546017 Share on other sites More sharing options...
Darklink Posted May 23, 2008 Share Posted May 23, 2008 You can't vote which ones better! They depend on what you want to do. Using a flat-file system you can generate a cache (little to none resources needed), whilst using SQL will require resources. However SQL is incredibly useful when you want to find, update, join and delete data quickly. I would never recommend on creating a flat-file database, but rather a datastore which is used to simply cache small sets of data if needed. Quote Link to comment https://forums.phpfreaks.com/topic/65217-flat-file-or-mysql-poll/#findComment-548120 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.