Hi Friends, I'm developing a website where i use atleast 6 different applications (scripts). They all uses MY_SQL database. My question is what is the best choice out of these two following options........ 1. create 6 different Databases and then try to integrate them. ( i want a single user login and not 6 logins for 6 applications ) 2. A single database with all the tables of 6 applications. i guess i don't have to integrate and it would support a single login Are there any databse gurus out there who could give me the correct solution? pls help. i'm struck at the beginning Extecting your ideas and Thanks in advance. Cheers -Kay
No one has ever called me a DB guru so take all this as an opinion. If you are building this from scratch one database would be my choice. The user id, name and password would be common. For the other application you can always prefix the the table to eliminate the potential for duplicate fields. abc_item would be completely different from xyz_item. Each application could read the common fields for name and password. With the proper scripting once logged in they should be logged in for the entire session no matter which application they are trying to use.
Wow that was so fast Thankyou Colbyt, but, wouldn't it be a problem once the database grows. Will i face any problem in loading time? since i'm gonna use My-sql how big the database size can be for optimized results Cheers -Kay
You can have one login that can access all your databases. It's good to keep databases different if you you are just reading data sometimes and they have other functions. If they are all part of the same application and are used no where else, then I would say consolidate them. But, if you don't want to do that, you can access database tables from different databases pretty easily. Example: `select name, employee_id from db1.name, db2.employee where db1.name.id = db2.employee.employee_id`