Can I run Siteseed on a single database?
 
 

Yes. Siteseed uses a single database for each project/website.

Also this message for Marcus (one of the Siteseed hackers suggests it is possible to have several projects running on a single database) with some hacking involved:


From: "Marcus Schweiker" <marcus@schweiker.net>
To: <siteseed@mrnet.pt>
Subject: different projects in one database, code documentation, rewrite rules, translation, other things...
Date: Thu, 17 Jan 2002 06:12:30 +0100

Hello,

I've tried to adapt siteseed to use a single database for different projects (or projectos ;-). My first approach was simple: A new variable called $database_tableprefix which was
then used as a prefix for all tables e.g.:

$DBT_areas = $database_tableprefix . "_areas";

After that I changed the table names in all queries (and in functions declared the table name variables global). This solution worked great for me. But it was not possible to use remote databases. Well that's actually not true, but the remote database has to use the same table prefix. So I thought, well lets use the project name as table prefix. But that doesn't work. For example you can rewrite the code: e.g.:

mysql_db_query("$projecto","SELECT * FROM ". $projecto ."_area where (...) , $dblink);

but this would mean that you cannot use the same database for different projects. Right now it is not possible to pass database and project names separately as access data for remote databases. Right now they are identical. That's the reason why I'm writing this email. I'd like to have this feature in future versions. And I think it's not possible without separating database name and project name (or without the introduction of a database_tableprefix). Therefore,
there would be other changes necessary e.g. passing a database name from the templates (why are they called interfaces?) to access a remote database.

Marcus



We have left this topic, for the time being, but you have the hints to follow if you need this feature. It is uncertain (ask him) at this point if Marcus will eventually make siteseed evolve in this matter.

 

Submit a message/question
Name

Email

Subject/question:





Login:

Password:




[New user]
Other sites:
  • siteseed.org
  • On-line manual

    FAQ
  • Generic
  • Install Windows
  • Install Unix
  • Install OS X
  • Menu Journalist
  • Menu Editor
  • Menu Technical
  • About Interfaces
  • About Objects
  • About Articles
  • About Foruns
  • Import files
  • Import Word
  • Manual
  • Translations
  • Source code
  • External modules
  • License
  • Performance
  • ML siteseed-dev
  • ML siteseed