PDA

View Full Version : Does anyone know if Powweb limits....

glbuzz
9-10-06, 10:56 AM
the number of sql databases that you can use? Thanks for anyone that an answer to this. I
IanS
9-10-06, 11:17 AM
You have 5 databases included in the standard package and extra ones can be bought.

Frequently, people use one database for many programs/applications such as bulletin boards and blogs by using prefixes to the table names.
glbuzz
9-10-06, 04:11 PM
You have 5 databases included in the standard package and extra ones can be bought.

Frequently, people use one database for many programs/applications such as bulletin boards and blogs by using prefixes to the table names.

Thanks for your answer. Can you explain that a bit further. Is it hard to do what you are suggesting (using prefixes)? I am relatively new to SQL so please make it simple.:o
IanS
9-11-06, 03:56 AM
Thanks for your answer. Can you explain that a bit further. Is it hard to do what you are suggesting (using prefixes)? I am relatively new to SQL so please make it simple.:oUnfortunately, I've not done it - maybe someone else can help with this?
mixerson
9-11-06, 11:49 AM
My only experience with database prefixes is with vBulletin, but the concept is the same for other database apps.

vBulletin lets you set a prefix string for all database tables in a single installation. For example, without prefixes, there is a table called "user". If you installed a second copy of vB (without prefixes) using the same database, it would overwrite the existing "user" table, and the first forum wouldn't work.

If you set the prefixes to "forum1_" and "forum2_", then the user tables will be named "forum1_user" and "forum2_user", and they can share the same database without any problems.
cdolson
9-14-06, 02:16 AM
Suppose you wanted to install two applications and set them both to use the same database.

The idea would be to add a prefix to each table so that you don't overwrite those tables by the installation of a second application. You would then prefix all of the tables for use in "Application 1" in a manner like:

app_1_users
app_1_orders
app_1_posts

You would then do the same for "Application 2".

ALSO you would have to make sure that Application 1 knows that it is looking for tables that are prefixed with 'app_1_' rather than tables that are not. This may be a system wide setting that you would be able to change, as the poster above suggested, or you may need to manually edit config files and such.