Mailing List Archive

Hi,

One and a half years later: can php4 support be killed and PDO be used to
access the database?

mysql support is pretty much the last obstacle that prevents me from using
the DAViCal...

--
Arie



On Fri, Nov 14, 2008 at 13:17, Bruno Friedmann <bruno at ioda-net.ch> wrote:

> I really thing there's nothing we can do for peole having php4.
> After all php4 is dead officially in March/April of 2008.
>
> Pro hosting provider provide php5 or eventually php6.
>
> Seriously what we should answer if people want to run a postgresql 6 or a
> mysql 3 ?
> People asking for a php4 are people that don't want to update their coding
> or software
> Most of 85% of php4 (good) code work directly under php5.
> It's their choice, not our ! Move on.
>
> I would be very happy to see a such nice piece of software adopting pdo.
> And Andrew if you need more help don't hesitate to ask us.
> (Test, money, time, code whatever)
>
>
>
> Arie Skliarouk wrote:
> > So, is anyone running DAViCal on PHP4?
> >
> > assuming that January is a complete writeoff.
> > Are you planning to rewrite the davical??
> >
> > --
> > Arie
> >
> > ---------- Forwarded message ----------
> > From: Andrew McMillan <andrew at morphoss.com>
> > Date: Fri, Nov 14, 2008 at 01:58
> > Subject: Re: [DAViCal-general] mysql support
> > To: Arie Skliarouk <skliarie at gmail.com>
> >
> >
> > On Wed, 2008-11-12 at 12:04 +0200, Arie Skliarouk wrote:
> >> Hi,
> >>
> >> Have the time arrived for switching to PDO to access database? IMHO
> >> perl 4 is dead enough for that already...
> >
> > I can certainly agree that Perl 4 is dead :-)
> >
> > However I still know of plenty of people who have installations (not
> > necessarily of DAViCal) which are dependent on PHP4.
> >
> > A quick show of hands on the list would be interesting. Is anyone
> > running DAViCal on PHP4? Not that this will be a representative sample,
> > of course, since people on this list are more likely to be early
> > adopters than otherwise.
> >
> > I'm still planning the shift to PDO and PHP5-only earlyish next year,
> > which fairly much sets the timeframe to be March / April, assuming that
> > January is a complete writeoff.
> >
> > Cheers,
> > Andrew.
> >
> > ------------------------------------------------------------------------
> > andrew (AT) morphoss (DOT) com +64(272)DEBIAN
> > Today is the first day of the rest of your life.
> > ------------------------------------------------------------------------
> >
> >
> >
> >
> >
> >
> >
> > ------------------------------------------------------------------------
> >
> > -------------------------------------------------------------------------
> > This SF.Net email is sponsored by the Moblin Your Move Developer's
> challenge
> > Build the coolest Linux based applications with Moblin SDK & win great
> prizes
> > Grand prize is a trip for two to an Open Source event anywhere in the
> world
> > http://moblin-contest.org/redirect.php?banner_id=100&url=/
> >
> >
> > ------------------------------------------------------------------------
> >
> > _______________________________________________
> > rscds-general mailing list
> > rscds-general at lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/rscds-general
>
>
> --
>
> Bruno Friedmann
>
> Ioda-Net S?rl
> 2830 Vellerat - Switzerland
>
> T?l : ++41 32 435 7171
> Fax : ++41 32 435 7172
> gsm : ++41 78 802 6760
> www.ioda-net.ch
>
> Centre de Formation et de Coaching En Ligne
> www.cfcel.com
>
>
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's
> challenge
> Build the coolest Linux based applications with Moblin SDK & win great
> prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> rscds-general mailing list
> rscds-general at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/rscds-general
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.morphoss.com/pipermail/davical-users/attachments/20100713/2b618a50/attachment.htm>
-------------- next part --------------

On Tue, 2010-07-13 at 12:25 +0100, Ian Clark wrote:
> Hi there,
>
> Using PDO won't automatically make DAViCAL work with MySQL. The stored
> procedures will also have to be ported from plpgsql to whatever MySQL
> uses (something like DB2 IIRC).
>
> Take a look at the sql files at
> http://repo.or.cz/w/davical.git/blob/HEAD:/dba/ to see the kind of
> functions that'll need translating.

That's correct, although I've reimplemented a number of those in PHP, in
particular the RRULE handling has been rewritten in PHP which means I
can move that part of it which depends on in-database processing back
out of the database now. There's still significant in-database handling
of permission checking, however, and likely other stuff that MySQL (in
particular) doesn't support so well. I expect SQLite or Drizzle support
would be an easier job - or even MSSQL - than MySQL would be.

Also, while I've developed (and switched to) a new DB layer in DAViCal
which does use PDO, and which provides for database-specific bypassing
of this kind of functionality, so that a DB driver author could
implement it outside the database, the AWL libraries used by DAViCal
continue to use the older libraries.

I expect to convert the library code over to the new PDO-based DB layer
when I get back home from my holiday - it's mostly a mechanical process,
although the new libraries offer some better features in a few places. I
also have to confirm that the various other applications that use AWL
will continue to work, and they don't all have the regression testing
framework that DAViCal does.

Cheers,
Andrew.

>
> Ian.
>
> On 13 Jul 2010, at 12:05, Arie Skliarouk wrote:
> > Hi,
> >
> > One and a half years later: can php4 support be killed and PDO be used to access the database?
> >
> > mysql support is pretty much the last obstacle that prevents me from using the DAViCal...
> >
> > --
> > Arie
> >
> >
> >
> > On Fri, Nov 14, 2008 at 13:17, Bruno Friedmann <bruno at ioda-net.ch> wrote:
> > I really thing there's nothing we can do for peole having php4.
> > After all php4 is dead officially in March/April of 2008.
> >
> > Pro hosting provider provide php5 or eventually php6.
> >
> > Seriously what we should answer if people want to run a postgresql 6 or a mysql 3 ?
> > People asking for a php4 are people that don't want to update their coding or software
> > Most of 85% of php4 (good) code work directly under php5.
> > It's their choice, not our ! Move on.
> >
> > I would be very happy to see a such nice piece of software adopting pdo.
> > And Andrew if you need more help don't hesitate to ask us.
> > (Test, money, time, code whatever)
> >
> >
> >
> > Arie Skliarouk wrote:
> > > So, is anyone running DAViCal on PHP4?
> > >
> > > assuming that January is a complete writeoff.
> > > Are you planning to rewrite the davical??
> > >
> > > --
> > > Arie
> > >
> > > ---------- Forwarded message ----------
> > > From: Andrew McMillan <andrew at morphoss.com>
> > > Date: Fri, Nov 14, 2008 at 01:58
> > > Subject: Re: [DAViCal-general] mysql support
> > > To: Arie Skliarouk <skliarie at gmail.com>
> > >
> > >
> > > On Wed, 2008-11-12 at 12:04 +0200, Arie Skliarouk wrote:
> > >> Hi,
> > >>
> > >> Have the time arrived for switching to PDO to access database? IMHO
> > >> perl 4 is dead enough for that already...
> > >
> > > I can certainly agree that Perl 4 is dead :-)
> > >
> > > However I still know of plenty of people who have installations (not
> > > necessarily of DAViCal) which are dependent on PHP4.
> > >
> > > A quick show of hands on the list would be interesting. Is anyone
> > > running DAViCal on PHP4? Not that this will be a representative sample,
> > > of course, since people on this list are more likely to be early
> > > adopters than otherwise.
> > >
> > > I'm still planning the shift to PDO and PHP5-only earlyish next year,
> > > which fairly much sets the timeframe to be March / April, assuming that
> > > January is a complete writeoff.
> > >
> > > Cheers,
> > > Andrew.
> > >
> > > ------------------------------------------------------------------------
> > > andrew (AT) morphoss (DOT) com +64(272)DEBIAN
> > > Today is the first day of the rest of your life.
> > > ------------------------------------------------------------------------
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > ------------------------------------------------------------------------
> > >
> > > -------------------------------------------------------------------------
> > > This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> > > Build the coolest Linux based applications with Moblin SDK & win great prizes
> > > Grand prize is a trip for two to an Open Source event anywhere in the world
> > > http://moblin-contest.org/redirect.php?banner_id=100&url=/
> > >
> > >
> > > ------------------------------------------------------------------------
> > >
> > > _______________________________________________
> > > rscds-general mailing list
> > > rscds-general at lists.sourceforge.net
> > > https://lists.sourceforge.net/lists/listinfo/rscds-general
> >
> >
> > --
> >
> > Bruno Friedmann
> >
> > Ioda-Net S?rl
> > 2830 Vellerat - Switzerland
> >
> > T?l : ++41 32 435 7171
> > Fax : ++41 32 435 7172
> > gsm : ++41 78 802 6760
> > www.ioda-net.ch
> >
> > Centre de Formation et de Coaching En Ligne
> > www.cfcel.com
> >
> >
> > -------------------------------------------------------------------------
> > This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> > Build the coolest Linux based applications with Moblin SDK & win great prizes
> > Grand prize is a trip for two to an Open Source event anywhere in the world
> > http://moblin-contest.org/redirect.php?banner_id=100&url=/
> > _______________________________________________
> > rscds-general mailing list
> > rscds-general at lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/rscds-general
> >

--
------------------------------------------------------------------------
andrew (AT) morphoss (DOT) com +64(272)DEBIAN
You may be recognized soon. Hide.
------------------------------------------------------------------------

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 198 bytes
Desc: This is a digitally signed message part
URL: <http://lists.morphoss.com/pipermail/davical-users/attachments/20100715/8d776bcd/attachment.pgp>
-------------- next part --------------