I want to use a database different to the standard joomla database - Joomla! Forum - community, help and support

hi,

this may sound similar other questions, isn't. have spent on ahour looking , nobody seems asking this. here's want do...

i have set of tables have components accessing , displaying data from, in pages on site. aware can give new prefix these tables , include them in default database joomla tables held.

i don't want this.

is wanting logical seperation of application data , joomla data 2 seperate databases unreasonable ? if , can explain why ?  don't think is. in ways see joomla database holding metadata (but that's story..)

i want know if joomla can handle before start looking @ doing through native php...


kind regards,


john mcgeechan.

this should possible using joomla api. suggest using database class connection separate db , extend mosdbtable or moscomponent classes access tables.

the database class' constructor provides dbname, user , password params specify totally separate database connection. pass mosdbtable/moscomponent constructor access tables in db.

you store connection details in separate config file it's easy change these details if need to.

separating out data in regards own customized components straightforward. applying same principles joomla core components , other 3rd party components should achievable mean have update , maintain new connection in each component/module/plugin roll out. unrealistic time consuming , introduce bugs have fix , maintain.