Sogo7 Posted May 27, 2011 Share Posted May 27, 2011 Do you allways use some form of SQL database for projects or revert to 'flat file' system such as CSV for simpler tasks? Quote Link to comment https://forums.phpfreaks.com/topic/237683-flat-file-or-sql/ Share on other sites More sharing options...
trq Posted May 27, 2011 Share Posted May 27, 2011 Databases are optimized for storing data, I find it often simpler to use them. Quote Link to comment https://forums.phpfreaks.com/topic/237683-flat-file-or-sql/#findComment-1221426 Share on other sites More sharing options...
QuickOldCar Posted May 28, 2011 Share Posted May 28, 2011 For holding temporary information, reading lists, or any data that you don't need to search through, flat files are fine to use. It takes less time to develop something to work with. If you are concerned with not losing data, being searchable, multiple or complex queries, the database is the better way to go. You have a lot more control over it as well. sqlite is a mix of the 2, it keeps everything in files but also acts like a database. http://www.sqlite.org/ Quote Link to comment https://forums.phpfreaks.com/topic/237683-flat-file-or-sql/#findComment-1221474 Share on other sites More sharing options...
jawef Posted May 28, 2011 Share Posted May 28, 2011 Most times using a database is easier for me and more efficient but there few exceptions. Properties files (either application properties or languages application messages) and application scope cashing. In latter case I use flat files where objects have already been serialized. Of course in both cases those files shouldn’t be in public_html but in a protected directory above (in a sub directory of src for example). Quote Link to comment https://forums.phpfreaks.com/topic/237683-flat-file-or-sql/#findComment-1221530 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.