PDA

View Full Version : Quick newb question

twodayslate
01-15-2007, 08:30 PM
This should be fairly simple.

I am planning on having a forum, blog and a normal site (maybe a shopping cart). How many databases will I need for this? Do I need one for each or should each be on a separate database? I want it so one person can log into the blog and the go to the forum and then not have to log-in again.

BTW I have no idea what a database actual does.
flann
01-16-2007, 10:00 AM
you can use a single database, this will probably be easier seeing how you are new to databases. In the future though, if you wanted to, you can use multiple databases and link them all together if need be.
twodayslate
01-16-2007, 08:52 PM
you can use a single database, this will probably be easier seeing how you are new to databases. In the future though, if you wanted to, you can use multiple databases and link them all together if need be.
I will use more than one then. Thanks for you help!
Marlo
01-17-2007, 08:42 PM
You only really need one. just have lots ot tables inside of it.

things get messy when you use more than one database
twodayslate
01-20-2007, 11:52 PM
We are having a discrepancy here. What should I do?
Marlo
01-21-2007, 09:52 AM
have 1 database but have lots of tables in it.
each table can have many fields ;)
twodayslate
01-21-2007, 11:31 AM
have 1 database but have lots of tables in it.
each table can have many fields ;)
Then how would I do this? :rolleyes:
jaketone
01-21-2007, 04:25 PM
twodayslate, Have you ever used Microsoft Access?
The format and functions are very similar ifnot identical.

I also prefer to just have 1 database with lots of tables.
This makes it a lot easier to run multiple queries against tables all within the same database. You can also join tables together to produce results etc;
twodayslate
01-24-2007, 07:53 AM
twodayslate, Have you ever used Microsoft Access?
The format and functions are very similar ifnot identical.

I also prefer to just have 1 database with lots of tables.
This makes it a lot easier to run multiple queries against tables all within the same database. You can also join tables together to produce results etc;
I have that program. I think I am going to stick with the multiple databases and then hook them together.