Enabling ezpublish with an Apache Derby database

Next topic

Author	Message
Jeff Levitt	Friday 05 August 2005 2:39:43 pm Hi, I am interested in using an Apache Derby database (open source java database) instead of MySQL with EzPublish. The first thing I did was to modify the kernel_schema.sql statements to work with Derby syntax. That now works, but I don't know where to begin in terms of pointing EZPublish to my Derby database. I've set up my Windows environment so that PHP and Apache HTTP server both work with my Derby database, which is registered via a DB2 ODBC Lite client. Do I need to create an extension, and if so, can someone explain what it is I need to do?
Lazaro Ferreira	Saturday 06 August 2005 4:26:03 am Hi, I think you have to implement an EZPublish DB interface for Derby (assuming Derby is similar to MySQL and PostgreSQL , I mean a RDBSQL Server ) : Looking to EZP code you will find the implemented interfaces at : lib/ezdb lib/ezdbschema Then at least you have to override settings at : site.ini,dbschema.ini In site.ini look at [DatabaseSettings] like [DatabaseImplementation],[ImplementationAlias] In dbschema.ini, you will have to add support for your database in every related setting Last, I have never implemented a DB interface in EZP, but I think EZP is designed to support new SQL Databases Server via a pluging architecture, like mentioned above, exist also Oracle and MS-SQL commercial plugings , and AFAIK EZ can develop additional plugings for you (commercial stuff) Lazaro http://www.mzbusiness.com

Author

Message

Friday 05 August 2005 2:39:43 pm

Hi,

I am interested in using an Apache Derby database (open source java database) instead of MySQL with EzPublish. The first thing I did was to modify the kernel_schema.sql statements to work with Derby syntax. That now works, but I don't know where to begin in terms of pointing EZPublish to my Derby database. I've set up my Windows environment so that PHP and Apache HTTP server both work with my Derby database, which is registered via a DB2 ODBC Lite client.

Do I need to create an extension, and if so, can someone explain what it is I need to do?

Lazaro Ferreira

Saturday 06 August 2005 4:26:03 am

Hi,

I think you have to implement an EZPublish DB interface for Derby (assuming Derby is similar to MySQL and PostgreSQL , I mean a RDBSQL Server ) :

Looking to EZP code you will find the implemented interfaces at :

lib/ezdb
lib/ezdbschema

Then at least you have to override settings at :
site.ini,dbschema.ini

In site.ini look at [DatabaseSettings] like [DatabaseImplementation],[ImplementationAlias]

In dbschema.ini, you will have to add support for your database in every related setting

Last, I have never implemented a DB interface in EZP, but I think EZP is designed to support new SQL Databases Server via a pluging architecture, like mentioned above, exist also Oracle and MS-SQL commercial plugings , and AFAIK EZ can develop additional plugings for you (commercial stuff)

Lazaro
http://www.mzbusiness.com

eZ debug

Timing:	Jan 20 2025 10:48:43
Script start
Timing:	Jan 20 2025 10:48:43
Module start 'layout'
Timing:	Jan 20 2025 10:48:43
Module start 'content'
Timing:	Jan 20 2025 10:48:44
Module end 'content'
Timing:	Jan 20 2025 10:48:44
Script end

Main resources:

Total runtime	1.0897 sec
Peak memory usage	4,096.0000 KB
Database Queries	54

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0125	589.2891	152.6406
Module start 'layout'	0.0125	0.0033	741.9297	39.4766
Module start 'content'	0.0158	1.0723	781.4063	488.1250
Module end 'content'	1.0881	0.0015	1,269.5313	8.1250
Script end	1.0896		1,277.6563

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0032	0.2956	16	0.0002
Check MTime	0.0013	0.1206	16	0.0001
Mysql Total
Database connection	0.0007	0.0611	1	0.0007
Mysqli_queries	1.0498	96.3421	54	0.0194
Looping result	0.0005	0.0433	52	0.0000
Template Total	1.0536	96.7	2	0.5268
Template load	0.0018	0.1663	2	0.0009
Template processing	1.0518	96.5232	2	0.5259
Template load and register function	0.0002	0.0169	1	0.0002
states
state_id_array	0.0008	0.0763	1	0.0008
state_identifier_array	0.0009	0.0853	2	0.0005
Override
Cache load	0.0015	0.1373	17	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0005	0.0489	2	0.0003
Fetch class attribute name	0.0010	0.0879	2	0.0005
XML
Image XML parsing	0.0004	0.0324	2	0.0002
class_abstraction
Instantiating content class attribute	0.0000	0.0005	2	0.0000
General
dbfile	0.0007	0.0614	10	0.0001
String conversion	0.0000	0.0009	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
2	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
4	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
2	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 10 Number of unique templates used: 5

Time used to render debug report: 0.0001 secs