Dynamic and flat file databases
 

Hi there.

I am just after some information to put in to the background research for a project i am doing.

I have started an online business application in PHP and mySql.

I understand mySQL is a dynamic database - is that correct?

What are the advantages of this type of database??

Is postgreSQL a flat file database? What are the disadvantages of this sort of database???

PostgreSQL is not a flat file database, it's a relational database management system. So is MySql. You have a number of posts that indicate that you're try to learn about databases. That's good. One begins by looking up definitions, and by studying, and maybe by experimenting. Truthfully, one comes to a forum such as this for help with a problem, for links or references to appropriate material, possibly to find a tutorial. One doesn't come for exhaustive teaching. You should put forth individual effort; learning isn't going to come free via spoon-feeding. How do I know you haven't invested any (at least sensible) effort? The top hit on a Google for postgreSQL tells me you haven't. Googles on flat-file database and relational databases indicate the same thing.

MySQL and PostgreSQL do use flat files to manage their relational database managment system, if this is what you mean k4pil. But yea, you should google the difference between what a "flat file" database is and "relational database management systems that use SQL", because neither of them are "flat file".

Thanks for the constructive critisism! lol

Your right, some research needed!

But when i get stuck, be sure i'l be back!

thanks