Give projects some love

Author Message

Xavier Dutoit

Thursday 08 November 2007 10:23:50 pm

Following Tony's cry.

Same needs applies, and most of the suggestions about contrib can apply on projects as well, after the merge (next week ?).

X+

http://www.sydesy.com

Paul Forsyth

Friday 09 November 2007 1:42:59 am

Should we ask eZ to provide an activity list e.g: http://sourceforge.net/top/mostactive.php?type=week?

Paul

Heath

Friday 09 November 2007 2:07:22 am

Fantastic!

That is a great idea Paul, I second the idea.

With a little more notice on which projects are most active.

This might just increase activity on projects through friendly competition :)

Cheers,
Heath

Brookins Consulting | http://brookinsconsulting.com/
Certified | http://auth.ez.no/certification/verify/380350
Solutions | http://projects.ez.no/users/community/brookins_consulting
eZpedia community documentation project | http://ezpedia.org

Paul Forsyth

Friday 09 November 2007 2:14:42 am

Added as an enhancement:

http://issues.ez.no/11878

Gaetano Giunta

Friday 09 November 2007 7:10:33 am

One other thing that would be nice: have extensions to specify their db compatibility besides the ususal ez version.

As most extension developers likely not very interested in this, it could be made a mandatory attribute:
N/A - no db needed
Unknown
mysql
oracle
postgres

btw: Filed under bug id #011883

Principal Consultant International Business
Member of the Community Project Board

Tony Wood

Friday 09 November 2007 9:07:02 am

Great!

Lets spread the Lurve!

Tony Wood : twitter.com/tonywood
Vision with Technology
Experts in eZ Publish consulting & development

Power to the Editor!

Free eZ Training : http://www.VisionWT.com/training
eZ Future Podcast : http://www.VisionWT.com/eZ-Future

kracker (the)

Sunday 11 November 2007 11:13:07 am

<i>@Gaetano Giunta</i>

We were under the impression that the design of the eZ Publish would free most extensions from general database specific requirements.

eZ Publish already provides detailed requirements for databases (and versions) which may be used such as MySQL, Oracle, PostgreSQL.

eZ Publish extensions traditionally make use of the database abstracted through eZ Publish.

So unless your greatly pushing beyond standard use of eZ Publish the 'db compatibility' requirements are specified by eZ Publish so asking each extension to document this detail seems to me to be a trivial notion of duplication only bound to introduce further confusion rather than reduce it.

Certainly extensions which do truly have specific requirements should indeed document these unique requirements, yet for almost all extensions currently this is not necessary or applicable (IMHO).

<i>//kracker

Blink 182 - I Miss You | Gwen Stephani - Whatcha Waiting For | Kanye West - Stronger ...</i>

Member since: 2001.07.13 || http://ezpedia.se7enx.com/

Gaetano Giunta

Sunday 11 November 2007 12:49:36 pm

Sorry, but this is just wishful thinking.
To do real cross-database development there are about a thousand abstractions that the library in us must provide, eg:
- a string concatenation operator
- a string escaping function
- some functions/schemas to define tables, indexes and sequences
- datetime functions
etc...

the ez db lib provides most of those (except for the datetime stuff, since times are treated as integers), BUT...

...as soon as you are allowed to write SQL in your code, you have huge chances of breaking some database.
The most basic example being: "SELECT NAME FROM EMP AS E, ..."
The "as" for table names is ok with postgres and mysql, but it is a fault with oracle.
If you start looking at native string manipulation functions or, worse, bit manipulation functions, you will find that different databases have different function names.

So the careless developer, wh coded his extensions and relased to the community without ever getting paid for proper testing and docs, is likely to never have tested his code with oracle, and compatibility is far from being guaranteed.

Principal Consultant International Business
Member of the Community Project Board

Sunday 11 November 2007 1:44:31 pm

I <i>challenge</i> Gaetano to cite at least five existing eZ Publish extensions which are affected by this problem. Developers are supposed to use the API and -not- write sql directly.

Gaetano Giunta

Sunday 11 November 2007 2:20:48 pm

Hey guys, take it eZ.

I never said that I know for a fact that any single given extension is not compatible with Oracle or Postgres. In fact, I would be very happy to find out that it is not the case.

But I ran a quick grep for "arrayquery" on my harddisk and found sql embedded in:
ezapprove2
ezlabel
ezmedia
eznewsletter
ezodf
ezwebin
(note: not "wrong" sql, just plain sql)

I have not at the moment a full svn copy of all the community contributions, but my educated guess is that at least some of those do manipulate sql queries.

Principal Consultant International Business
Member of the Community Project Board

Paul Forsyth

Monday 12 November 2007 2:25:20 am

I think Gaetano has a good point. Certified extensions cost more when the db is 'touched' and by clarifying when the api is not used for db access it will be very clear what the risk is with an extension.

The automated approval tool should be able to work this all out to be honest which would make auto-generation of stats a doddle.

Paul

André R.

Wednesday 14 November 2007 3:07:45 pm

Mummy: All extensions that need some extra database table needs to do this, and I don't think that will improve much before we switch to persistantObject from eZ Components (but even then you will always have edge cases)

Gaetano Giunta: isn't 'as' a fairly standard sql functionality, do they have support for it in more recent versions? How do you normally do queries on oracle where you need to relate to 1 table several times?

Maybe a tested on / certified for: mysql/pgsql/mssql/oracle thingy??

eZ Online Editor 5: http://projects.ez.no/ezoe || eZJSCore (Ajax): http://projects.ez.no/ezjscore || eZ Publish EE http://ez.no/eZPublish/eZ-Publish-Enterprise-Subscription
@: http://twitter.com/andrerom

Gaetano Giunta

Thursday 15 November 2007 12:14:07 am

<i>isn't 'as' a fairly standard sql functionality, do they have support for it in more recent versions? How do you normally do queries on oracle where you need to relate to 1 table several times?</i>

SELECT ... FROM TABLE1 T1, TABLE2 T2, etc...

this is supported on all other rdbms, so it is really a no brainer.
AS is still supported (and needed) to alias names of select items

Principal Consultant International Business
Member of the Community Project Board

shekhar sarkar

Monday 19 January 2009 11:43:35 pm

hi guys,

The above article is nice. I know little bit about it. I want to know more about it. Thanks

NYK

From Tony: If this is not Spam let me know. Otherwise it will be deleted.

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.