Home > Archive > PHP Pear > June 2005 > Re: [PEAR] Re: [ANNOUNCEMENT] MDB2-2.0.0beta5 (beta) Released.
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Re: [PEAR] Re: [ANNOUNCEMENT] MDB2-2.0.0beta5 (beta) Released.
|
|
| Lukas Smith 2005-06-08, 3:58 pm |
| Michael Caplan wrote:
> Lukas,
>
> When you say MDB (2 I presume, but perhaps 1 as well) is about to be
> deprecated, what do you see replacing it? PDO? PDO plus another wrapper
> that provides further cross DB compatibility?
I was only talking about MDB version 1.x
MDB2 complements PDO quite nicely and eventually there will be PDO based
drivers for MDB2.
> I'd really like to know your thoughts on this matter, considering we are now
> very much an MDB2 shop, and we always need to keep an eye to the future.
MDB2 is the future for portability in PHP.
regards,
Lukas
| |
| Ken Restivo 2005-06-08, 8:57 pm |
| -----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Wed, Jun 08, 2005 at 06:00:48PM +0200, Lukas Smith wrote:
> Michael Caplan wrote:
>
> I was only talking about MDB version 1.x
>
> MDB2 complements PDO quite nicely and eventually there will be PDO based
> drivers for MDB2.
>
>
> MDB2 is the future for portability in PHP.
>
The only future? I have built my entire application on DB_DataObjects. If that gets deprecated I will cry a mighty river.
- -ken
- --
- ---------------
The world's most affordable web hosting.
http://www.nearlyfreespeech.net
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.0 (GNU/Linux)
iD8DBQFCpzi/ e8HF+6xeOIcRAkKUAJ4lLedbWkOhfy0+Esa7x8b2
1jX7lgCg4eW7
eL3u5jP9xFtCWWLt33SCJX0=
=CFWd
-----END PGP SIGNATURE-----
| |
| Joe Stump 2005-06-08, 8:57 pm |
| >
> The only future? I have built my entire application on
> DB_DataObjects. If that gets deprecated I will cry a mighty river.
I'm surprised you aren't already crying.
--Joe
| |
| Lukas Smith 2005-06-08, 8:57 pm |
| Ken Restivo wrote:
>
>
> The only future? I have built my entire application on DB_DataObjects. If that gets deprecated I will cry a mighty river.
well DB_DataObject is a different beast. I was not talking about OO
interfaces, but direct SQL interfaces. DB_DataObject will eventually
probably be replaced by Alan's dbdo pecl extension. But I think he reads
this list and will respond himself.
regards,
Lukas
| |
| Larry Garfield 2005-06-08, 8:57 pm |
| On Wednesday 08 June 2005 01:31 pm, Joe Stump wrote:
>
> I'm surprised you aren't already crying.
>
> --Joe
Low blow. :-)
Seriously, though, that's the main drawback of MDB2 right now, IMHO. Most of
the higher-level PEAR database packages (above the DB/MDB/MDB2 level) depend
on DB. If you want to use any of those (DataObjects, some of the pagers, the
FormBuilder tie-ins), then you're tying yourself to DB. I don't see MDB2
being "the future of portability in PHP" until the other tools support it
natively as well as / instead of DB. Until then, DB will remain the standard
for better or worse.
--
Larry Garfield AIM: LOLG42
larry@garfieldtech.com ICQ: 6817012
"If nature has made any one thing less susceptible than all others of
exclusive property, it is the action of the thinking power called an idea,
which an individual may exclusively possess as long as he keeps it to
himself; but the moment it is divulged, it forces itself into the possession
of every one, and the receiver cannot dispossess himself of it." -- Thomas
Jefferson
| |
| Joe Stump 2005-06-08, 8:57 pm |
| I think a larger problem is that package maintainers are even faced
with the problem of having to support multiple DB API's. With the
introduction of PHP5's interfaces I think a good idea would be to
standardize a basic DB API and require DB packages to implement said
interfaces so package maintainers can depend on a unified API
(arguments about who is faster at what aside).
Also, IIRC, MDB/MDB2 both have DB compliant interfaces. Though I
could be wrong as it's been a while since I've looked into the other
abstraction layers.
--Joe
On Jun 8, 2005, at 12:00 PM, Larry Garfield wrote:
> On Wednesday 08 June 2005 01:31 pm, Joe Stump wrote:
>
>
> Low blow. :-)
>
> Seriously, though, that's the main drawback of MDB2 right now,
> IMHO. Most of
> the higher-level PEAR database packages (above the DB/MDB/MDB2
> level) depend
> on DB. If you want to use any of those (DataObjects, some of the
> pagers, the
> FormBuilder tie-ins), then you're tying yourself to DB. I don't
> see MDB2
> being "the future of portability in PHP" until the other tools
> support it
> natively as well as / instead of DB. Until then, DB will remain
> the standard
> for better or worse.
>
> --
> Larry Garfield AIM: LOLG42
> larry@garfieldtech.com ICQ: 6817012
>
> "If nature has made any one thing less susceptible than all others of
> exclusive property, it is the action of the thinking power called
> an idea,
> which an individual may exclusively possess as long as he keeps it to
> himself; but the moment it is divulged, it forces itself into the
> possession
> of every one, and the receiver cannot dispossess himself of it."
> -- Thomas
> Jefferson
>
> --
> PEAR General Mailing List (http://pear.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
| |
| Lukas Smith 2005-06-08, 8:57 pm |
| Joe Stump wrote:
> I think a larger problem is that package maintainers are even faced
> with the problem of having to support multiple DB API's. With the
> introduction of PHP5's interfaces I think a good idea would be to
> standardize a basic DB API and require DB packages to implement said
> interfaces so package maintainers can depend on a unified API
> (arguments about who is faster at what aside).
that is why MDB2 is moving towards the PDO API
> Also, IIRC, MDB/MDB2 both have DB compliant interfaces. Though I could
> be wrong as it's been a while since I've looked into the other
> abstraction layers.
MDB does .. the MDB2 one is severely broken and I currently have no
plans of continueing its development since I never ever received a
single bit of feedback on any of the wrappers for DB I wrote.
regards,
Lukas
| |
| Lukas Smith 2005-06-08, 8:57 pm |
| Larry Garfield wrote:
> Seriously, though, that's the main drawback of MDB2 right now, IMHO. Most of
> the higher-level PEAR database packages (above the DB/MDB/MDB2 level) depend
> on DB. If you want to use any of those (DataObjects, some of the pagers, the
> FormBuilder tie-ins), then you're tying yourself to DB. I don't see MDB2
> being "the future of portability in PHP" until the other tools support it
> natively as well as / instead of DB. Until then, DB will remain the standard
> for better or worse.
Yes. Daniel Rossi put in alot of work making DataObjects run with both
DB and MDB2 .. so far there seems to be no interest by Alan to acutally
puts this into an official release, which is quite a pitty. Once that is
there, then FormBuilder should AFAIK work as well. Pager has MDB2
support (DB_Pager is deprecated), Cache does as well, Translation2 does,
DB_NestedSet does.
So there is only really a lack of OO interfaces based on MDB2:
- MDB_QueryTool could be ported to MDB2 fairly quickly I would presume.
- DB_DataObject appearently already has been ported to work with both DB
and MDB2.
- DB_Table .. I have not heard of anyone trying to stick MDB2 underneath
that one.
regards,
Lukas
| |
| Dan Rossi 2005-06-09, 8:57 am |
|
On 09/06/2005, at 4:28 AM, Ken Restivo wrote:
>
> The only future? I have built my entire application on DB_DataObjects.
> If that gets deprecated I will cry a mighty river.
>
>
Dude I think you should read my spam emails more often, check
DB_DataObject in cvs, it allows for MDB2 now, thanks to help from Alan
and Justin :D However the generator is still using DB and its
functionality. I've yet to get to that part and get it to use the
Manager and Reverse modules and of course get it screened by Alan. Alan
is building a DBDO extension for PHP5 but I doubt a full production
release until next year however its running in competition with PDO
with regards to its using different c libraries aparantly, I've yet to
get both installed as I run Mac OSX for development, but I'm gonna
power up my Sun Fire V100 shortly :)
So I think the plan is DBDO for the DataObjects stuff, which I am
assuming porting from DB_DataObject::factory will be seamless. PDO for
normal database work, I am assuming MDB2 is attempting to have the same
API so porting is also seamless am I right Lukas ?
| |
| Dan Rossi 2005-06-09, 8:57 am |
|
On 09/06/2005, at 5:38 AM, Lukas Smith wrote:
>
> Yes. Daniel Rossi put in alot of work making DataObjects run with both
> DB and MDB2 .. so far there seems to be no interest by Alan to
> acutally puts this into an official release, which is quite a pitty.
> Once that is there, then FormBuilder should AFAIK work as well.
Apart from my customisations of DB_DataObject which my DataObjects
extend I have been running MDB2 in the cvs DataObject fine for months
now, this also includes FormBuilder, its a killa combination. I assume
he is waiting for more testers ? As I said the Generator is still using
DB :|
> Pager has MDB2 support (DB_Pager is deprecated), Cache does as well,
> Translation2 does, DB_NestedSet does.
Right I am using pager with my Flexy renderer in the DataGrid, but
havent interfaced it directly with an MDB2 resultset as yet :\
| |
| Dan Rossi 2005-06-09, 8:57 am |
|
On 09/06/2005, at 8:54 PM, Dan Rossi wrote:
On 09/06/2005, at 8:54 PM, Dan Rossi wrote:
> thanks to help from Alan and Justin :D
Shit sorry Lukas left you off the creds, who helped me work out some of
the MDB2 API :)
Oh there is still one fix in the query method in terms of transactions,
I have submitted in to feature request already :\
| |
| Lukas Smith 2005-06-09, 8:57 am |
| Dan Rossi wrote:
> Dude I think you should read my spam emails more often, check
> DB_DataObject in cvs, it allows for MDB2 now, thanks to help from Alan
very  .. i wasnt aware of that
> and Justin :D However the generator is still using DB and its
> functionality. I've yet to get to that part and get it to use the
> Manager and Reverse modules and of course get it screened by Alan. Alan
ok, probably what one would want to do is generate things from the xml
schema files and not via the reverse/manager module. 2 people are
currently working on adding autoincrement and primary key support to
mdb2. foreign key support would really be the last key piece missing.
> assuming porting from DB_DataObject::factory will be seamless. PDO for
> normal database work, I am assuming MDB2 is attempting to have the same
> API so porting is also seamless am I right Lukas ?
yes the plan is to mimic the PDO API as much as possible in MDB2
regards,
Lukas
| |
| Dan Rossi 2005-06-09, 8:57 am |
|
On 09/06/2005, at 9:07 PM, Lukas Smith wrote:
As I was fearing, the upgrade shagged the mysql driver. Would be nice
to update is automatically.
Ok peeps you need to install the driver seperately.
pear install MDB2_Driver_mysql-beta
| |
| Lukas Smith 2005-06-09, 8:57 am |
| Dan Rossi wrote:
>
> On 09/06/2005, at 9:07 PM, Lukas Smith wrote:
>
> As I was fearing, the upgrade shagged the mysql driver. Would be nice to
> update is automatically.
>
> Ok peeps you need to install the driver seperately.
>
> pear install MDB2_Driver_mysql-beta
yes .. all the drivers are now unbundled. this will allow driver
maintainers alot more freedom. hopefully this will attract more driver
developers too.
aside from this it better allows us to specify driver specific
dependencies and state.
finally it will make it easier for people to just install the drivers
they actually need.
regards,
Lukas
|
|
|
|
|