RE: [PEAR-DEV] Re: [metabase-dev] MDB news (http://pear.php.net/package-info.php?package=MDB)

Manuel you are right. I may end up having to make some serious decisions of ditching features down the road. I was in a difficult situation of having to pelase both the Metabase and the PEAR DB userbase. I am trying to win both sides for MDB. People don't like to give up features if they don't know what they will gian in return. So I guess what I did is give both sides all the features they are used to. Since especially PEAR DB does not abstract as much this may end up being a problem once we actually have to work out compatiblity to more RDBMS. I allready had to make some changes to the code for PostGreSQL support (I did not have to remove features however or change the API). For all intents and purposes MDB 1.0 should be considered to be a more public development version. If you do not want to ever have to look at the MDB code for even one second then this release is probably not for you. This release should be viewed as a pre Final version in order for people to prepare moving over and to contribute drivers. Because yes you are right, we might run into trouble with other RDBMS down the road. Also keep in mind MDB is not here to compete with Metabase, but more to expose Metabase to a new userbase and to ready it for future development. Again I thank you for your insights and your persistance in making your experience available to the community. If I do things differently than you recommend it is sometimes not for technical but for diplomatic reasons. I have to please a lot of people for them to accept MDB. I hope the choices I am making will not turn off to many people. Regards, Lukas > -----Original Message----- > From: Manuel Lemos [mailto:mlemos@acm.org] > Sent: Friday, September 06, 2002 12:40 AM > To: metabase-dev@yahoogroups.com > Cc: pear-dev@lists.php.net; dev@binarycloud.tigris.org > Subject: Re: [PEAR-DEV] Re: [metabase-dev] MDB news > (http://pear.php.net/package-info.php?package=MDB) > > Hello, > > On 09/04/2002 07:19 PM, Lukas Smith wrote: > >>From: Manuel Lemos [mailto:mlemos@acm.org] > >>Sent: Wednesday, September 04, 2002 3:47 PM > >> > >>Anyway, I also noticed that you assume a default for dates that is not > >>valid for most databases and even less is portable. 0000-00-00 is a > > > > date > > > >>that never existed. The date count after Christ started in 0001-01-01 > > > > . > > > >>The year before 1 is -1, not 0. > >> > >>Still, even if you assumed 0001-01-01 as default, not all databases > >>allow arbitrary ranges of 4 digit years . Some do not allow dates > > > > before > > > >>1970 or 1900. > > > > > > I will look into this issue after 1.0 more deeply. > > For now I guess its atleast a step in the right direction to rather use > > 0001-01-01. But it is only relevant for the reverse engineering really > > and people will have to manually edit the resulting xml schema file > > anyways until further advancements are made (like an interactive > > application etc). > > This is really not that important. It was just an example of one thing > that you are doing that will break with other databases because you were > not aware of the valid ranges of dates. > > Anyway, 1) it should be up to the driver to assume defaults if really > needed, 2) if needed, the drivers should assume defaults with safely > dates like 2000-01-01 , 3) if you really want to be sure that all > drivers return defaults for not null fields, throw an error in the > manager class regarding that problem so it does not go unnoticed when a > developer writes a new driver. > > > -- > > Regards, > Manuel Lemos > > > ------------------------ Yahoo! Groups Sponsor ---------------------~--> > 4 DVDs Free +s&p Join Now > http://us.click.yahoo.com/pt6YBB/NXiEAA/MVfIAA/saFolB/TM > ---------------------------------------------------------------------~-> > > To Unsubscribe, send a blank message to: metabase-dev- > unsubscribe@eGroups.com > Need other Metabase drivers? > http://www.egroups.com/surveys/metabase- > dev?id=263873 > Latest beta version: http://www.egroups.com/files/metabase-dev > Vote on Metabase: Å_Eÿ3²˜ > 6ŒMJÿ5Úhttp://www.zend.com/apps.php?id=122&single=1 > > > Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/