Flatfile or SQL?

[NapalM]

What do you prefer?

SQL is a safe, but can be very difficult system to use. I've come to be very handy with my own form of flatfile systems.

What do you guys like/use?

[Nick]

I like SQL. Once you get used to it, it is the way to go. I want to one day make a flatfile system, but I find SQL just so much more efficient!

[NapalM]

The way i use flatfile (i dont know if this is even considerably flatfile.)

I create a directory for the holding of that ever information it may be.

then i have it where lets say the script is for a chat box.

i have the script create a php file holding info like this:

file_name_generated.php
<?php
 $name = "the users name";
 $content = "The content inputted";
?>


then ill get for the chat box part ill use a script to read the i don't know, 50 newest files within that directory and within this script i'll have each of the files instead of showing the file name ill have it include(''); then read the information like this.

You get what im saying?

It goes through many filters, and security scripts before alot of the generating, and posting of course though.

[Cam]

SQL

[Jordan]

SQL is actually easier than flatfiles in the long run because once you know how to use it you can do things faster and more efficiently. If you ever get to the point where you are having to manage huge amounts of data you'll be wishing you were using a database management system. I know Proboards initially used flatfiles but had to eventually switch over to using a sql database so they could more easily manage their databases.

[russellr]

SQL i'm not too sure i'd ever use anything else, has been good to me

[NapalM]

Feb 2, 2011 5:18:31 GMT Jordan said:

SQL is actually easier than flatfiles in the long run because once you know how to use it you can do things faster and more efficiently. If you ever get to the point where you are having to manage huge amounts of data you'll be wishing you were using a database management system. I know Proboards initially used flatfiles but had to eventually switch over to using a sql database so they could more easily manage their databases.

i did not know that they used flat file in the beg. Thats a good fact.


I think if you manage it correctly its as easy as SQL.

I set up my own "Database manager" for flat file systems kind of like PHPmyADMIN for mySQL but for flatfiles.... and everything. I might release the source soon.