Forums / Developer / Connect extension to database on different server

Connect extension to database on different server

« 
Previous topic
|
Developer
|
Next topic
 »
Author Message

Pasha Iakhontov

Wednesday 12 November 2008 6:05:55 pm

I have a custom extension that needs to connect to a database on a different server.

I can create a new database connection file based on ezdb.php and just modify it to grab the settings from the extensions site.ini, but the problem I have is that all my classes extend eZPersistentObject and my data type extends eZDataType. Obviously those classes just include the the standard call to eZDB::instance() as well as those classes include other classes.

I am stuck as I don't see a simple way of achieving what I am after.....any help/ideas appreciated!

Łukasz Serwatka

Thursday 13 November 2008 12:31:20 am

Hi,

As fare as I remember this is not possible with standard eZ Publish persistent object. Kristof made a patch while ago which allow connect to extrnal DB with eZ P persistent object.

See http://issues.ez.no/IssueView.php?Id=10667

Patch was made against 3.9 series, thus you will need to clean up it a bit in order to make with work with 4.x

Personal website -> http://serwatka.net
Blog (about eZ Publish) -> http://serwatka.net/blog

Piotrek Karaś

Tuesday 17 March 2009 1:36:54 pm

How come hasn't Kristof's patch made it to the regular code?
I guess using some independent connection and abstraction layer would be much safer in this case...

--
Company: mediaSELF Sp. z o.o., http://www.mediaself.pl
eZ references: http://ez.no/partners/worldwide_partners/mediaself
eZ certified developer: http://ez.no/certification/verify/272585
eZ blog: http://ez.ryba.eu

eZ debug

Timing: Jan 18 2025 14:52:10
Script start
Timing: Jan 18 2025 14:52:10
Module start 'content'
Timing: Jan 18 2025 14:52:11
Module end 'content'
Timing: Jan 18 2025 14:52:12
Script end

Main resources:

Total runtime1.6051 sec
Peak memory usage4,096.0000 KB
Database Queries196

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0062 587.8594180.8125
Module start 'content' 0.00621.3943 768.6719582.1172
Module end 'content' 1.40050.2046 1,350.7891332.7422
Script end 1.6051  1,683.5313 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00380.2389210.0002
Check MTime0.00140.0902210.0001
Mysql Total
Database connection0.00060.038110.0006
Mysqli_queries1.537795.80051960.0078
Looping result0.00210.13111940.0000
Template Total1.578398.320.7892
Template load0.00190.115720.0009
Template processing1.576598.215520.7882
Template load and register function0.00020.009810.0002
states
state_id_array0.00090.059210.0009
state_identifier_array0.00190.115720.0009
Override
Cache load0.00150.0961160.0001
Sytem overhead
Fetch class attribute can translate value0.00150.094340.0004
Fetch class attribute name0.00090.053650.0002
XML
Image XML parsing0.00150.090640.0004
class_abstraction
Instantiating content class attribute0.00000.000550.0000
General
dbfile0.00350.2207360.0001
String conversion0.00000.000430.0000
Note: percentages do not add up to 100% because some accumulators overlap

CSS/JS files loaded with "ezjscPacker" during request:

CacheTypePacklevelSourceFiles
CSS0extension/community/design/community/stylesheets/ext/jquery.autocomplete.css
extension/community_design/design/suncana/stylesheets/scrollbars.css
extension/community_design/design/suncana/stylesheets/tabs.css
extension/community_design/design/suncana/stylesheets/roadmap.css
extension/community_design/design/suncana/stylesheets/content.css
extension/community_design/design/suncana/stylesheets/star-rating.css
extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css
extension/community_design/design/suncana/stylesheets/buttons.css
extension/community_design/design/suncana/stylesheets/tweetbox.css
extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css
extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css
extension/sevenx/design/simple/stylesheets/star_rating.css
extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css
extension/sevenx/design/simple/stylesheets/main.v02.css
extension/sevenx/design/simple/stylesheets/main.v02.res.css
JS0extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js
extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js
extension/community_design/design/suncana/javascript/jquery.ui.core.min.js
extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js
extension/community_design/design/suncana/javascript/jquery.easing.1.3.js
extension/community_design/design/suncana/javascript/jquery.ui.tabs.js
extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js
extension/community_design/design/suncana/javascript/jquery.popmenu.js
extension/community_design/design/suncana/javascript/jScrollPane.js
extension/community_design/design/suncana/javascript/jquery.mousewheel.js
extension/community_design/design/suncana/javascript/jquery.cycle.all.js
extension/sevenx/design/simple/javascript/jquery.scrollTo.js
extension/community_design/design/suncana/javascript/jquery.cookie.js
extension/community_design/design/suncana/javascript/ezstarrating_jquery.js
extension/community_design/design/suncana/javascript/jquery.initboxes.js
extension/community_design/design/suncana/javascript/app.js
extension/community_design/design/suncana/javascript/twitterwidget.js
extension/community_design/design/suncana/javascript/community.js
extension/community_design/design/suncana/javascript/roadmap.js
extension/community_design/design/suncana/javascript/ez.js
extension/community_design/design/suncana/javascript/ezshareevents.js
extension/sevenx/design/simple/javascript/main.js

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1node/view/full.tplfull/forum_topic.tplextension/sevenx/design/simple/override/templates/full/forum_topic.tplEdit templateOverride template
3content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
3content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
2content/datatype/view/ezimage.tpl<No override>extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tplEdit templateOverride template
1content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 11
 Number of unique templates used: 6

Time used to render debug report: 0.0002 secs