|
|
|
186
 
Group: Forum Members
Last Login: 22/02/2007 10:39:35
Posts: 62,
Visits: 3
|
|
Can you set up multiple programs to use a single database?
For my setup I would require 5 databases which seems a bit excessive and I am not willing to pay a small fortune for the database services.
Any ideas?
Oh Globbits!!!
|
|
|
|
|
286
Group: Forum Members
Last Login: Yesterday @ 23:00:41
Posts: 491,
Visits: 932
|
|
If you use some like Mambo or nukes (content management system, CMS) you can
install other database driven apps like forums and picture things.
if you go with someone like dream-hosting.co.uk you get loads of databases
anyway.
Dedham Hardcore oldskool rave flyers and old skool tunes Dedham
|
|
|
|
|
186
Group: Forum Members
Last Login: 17/10/2005 13:30:00
Posts: 10,
Visits: 1
|
|
It could depend on which db you are using but assuming it is MySQL or the like it shouldn't be a problem. I'm also assuming that you are talking about several different Web applications so you are thinking of having a number of different Web sites that access the same db. If this is the case then you don't need to worry provided you don't connect to the db using mysql_pconnect ( or some other persistent connection). Of course it may be that you are thinking of setting up seperate tables for each site in which case you are definately not going to have a problem ( I've done this myself ). This is how cms work - they tend to insist on a single database for installation but, as Kumagoro pointed out, within that they will have a large number of tables for the different modules.
homo sum: humani nil a me alienum puto
|
|
|
|
|
186
Group: Forum Members
Last Login: 22/02/2007 10:39:35
Posts: 62,
Visits: 3
|
|
Sorry my info was bit vague...
My test site has
1. News (PHP Free News)
2. Forum (phpBB2)
3. Weblog (Wordpress)
4. Chat (X7Chat)
5. Poll (Fpoll)
All on one website I know phpBB can use an existing database as it has prefix tabs but the rest I am unsure about.
I was hoping say to put the News, Poll and Blog in one and the Forum and Chat in the other. The Forum and Chat can be done apparently but the other one could be more tricky to do.
I am using MySQL but am only limited by my host to 2 databases so I need to either do some database juggling or drop some applications.
I have looked at using CGI scripts for News,Chat etc but I am not sure whether Lycos supports Perl (It should)
Oh Globbits!!!
|
|
|
|
|
Root
Group: Moderators
Last Login: 04/01/2009 14:35:06
Posts: 610,
Visits: 2,563
|
|
All those should happily use the same database. Most systems have a table name prefix which stop them interfering with other applications - e.g. all Wordpress' table names start with wp_. Most apps should have this even if they don't tell you about it.
Your best bet is just to try it. You'll be told if there are any conflicts, as an application won't be able to create a table it needs, but I suspect you'll get away with it.
--
David Johnson
Micro Mart Writer & Forum Moderator
|
|
|
|