Mailing List Archive

moving to PDO and other database backends
Hi Andrew,

I would love to help out with the UI development, but currently cannot even install DAViCal, because of missing plpgsql support on my shared server. And now they are telling me to drop PostgreSQL support completely....
Are you intending to make use of other database backends as well in the future? Otherwise I will have to wait another couple of years until I can afford a VPS...

Not going to install a local copy on my laptop, sorry.

In an email dated Nov 14, 2008, you have written:
"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."

Now, I have never used perl and most providers have upgraded to PHP5.1 or 5.2. I am currently running SabreDAV on by server as that only depends on PHP5 with PDO and MySQL but is a rather new offspring with barebones only (no journals, no acls,...) but modular with various databases, even text only and various auth backends. So runs on anything really.

All "better" versions of php groupware and calendaring software only runs well on root servers with full configuartion access, but most if not all fail on shared servers because of some module missing, wrong and unchangeable mbstring settings, etc.
For professional use in large companies, that is no issue, but for the rather small SOHO's like me, this is a real problem, if you do not want to use google calendars and when you cannot (or want not) afford to pay $50 or more a month for a VPS.

I am checking for VPS now...


Regards,
Ingo


-----Original Message-----
Subject: Re: [DAViCal-general] (Sorting in) the delegation drop down menu
Date: Tue, 17 Aug 2010, 20:33
From: Andrew McMillan
To: Marc Patermann

> On Tue, 2010-08-17 at 10:07 +0200, Marc Patermann wrote:
> > Jason,
> >
> > Jason alavaliant schrieb am 17.08.2010 00:08 Uhr:
> > > It sounds like you are on an older release? For me at least this
> > > sorting issue was fixed in 0.9.9
> > No, I'm using 0.9.9 too.
> > I found out that sorting works for the principal (all the user's
> > collections) but not in the calender/collection delegation itself.
>
> Thanks for the clarification. I've added the necessary 'order by'
> clause now, and it'll be visible in Git as soon as I fix an annoying wee
> bug to do with principal-property-search reports in my tree at
> present...
>
> Also, I do agree that some of the elements on these pages can be a pain
> if you have a large list of values in a drop-down. Unfortunately I'm
> not any kind of a UI programmer, and I don't even play one at the
> movies... :-)
>
> I've spent the last five years coming to grips with the calendaring
> standards and so forth, and while I have some basic CSS and HTML skills
> I could really use help in improving the user interface stuff. The good
> thing is that the database structures for users / principals /
> collections are fairly well settled now, so it is definitely worthwhile
> starting to work on polishing these areas a bit more.
>
> Cheers,
> Andrew.
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.morphoss.com/pipermail/davical-users/attachments/20100818/549a165c/attachment.htm>
-------------- next part --------------

Make an app they can't live without
Enter the BlackBerry Developer Challenge
http://p.sf.net/sfu/RIM-dev2dev
-------------- next part --------------
_______________________________________________
rscds-general mailing list
rscds-general at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rscds-general
moving to PDO and other database backends [ In reply to ]
On Wed, 2010-08-18 at 12:05 +1200, Ingo Ratsdorf wrote:
> Hi Andrew,
>
> I would love to help out with the UI development, but currently cannot
> even install DAViCal, because of missing plpgsql support on my shared
> server. And now they are telling me to drop PostgreSQL support
> completely....

I use Host Virtual, though I realise that USD$15/month is a lot for some
situations, it does mean I can run whatever I please on there, so long
as it fits in 256M RAM :-)

No doubt there are cheaper options, though I do like that they have
native IPv6 and the server provisioning and control seems good, if
spartan.


> Are you intending to make use of other database backends as well in
> the future? Otherwise I will have to wait another couple of years
> until I can afford a VPS...

I'm not intending to write support for MySQL or SQLite or such myself
(nor did I ever intend that), but the database layer I'm using now can
theoretically support other dialects, with callout hooks back into PHP
to support those places where the database engine can't do some
particular thing.


> Not going to install a local copy on my laptop, sorry.

No, that's not hugely useful to do so, other than for development, of
course.


> In an email dated Nov 14, 2008, you have written:
>
> "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."

Yes, I did this, largely. DAViCal code is all PDO / PHP5, and for the
code I've been writing since the beginning of the year I have started to
take advantage of PHP5-only features.

The AWL libraries which are used by DAViCal, and some of my other
applications, are not purely PDO yet, although it is probably relatively
easy to make the switch now.


> Now, I have never used perl and most providers have upgraded to PHP5.1
> or 5.2. I am currently running SabreDAV on by server as that only
> depends on PHP5 with PDO and MySQL but is a rather new offspring with
> barebones only (no journals, no acls,...) but modular with various
> databases, even text only and various auth backends. So runs on
> anything really.
>
> All "better" versions of php groupware and calendaring software only
> runs well on root servers with full configuartion access, but most if
> not all fail on shared servers because of some module missing, wrong
> and unchangeable mbstring settings, etc.
>
> For professional use in large companies, that is no issue, but for the
> rather small SOHO's like me, this is a real problem, if you do not
> want to use google calendars and when you cannot (or want not) afford
> to pay $50 or more a month for a VPS.

s/50/15/ :-)


> I am checking for VPS now...

Hopefully this option might be useful to you then! I hope this
clarifies things for you in any case.

Cheers,
Andrew.

>
> Regards,
>
> Ingo
>
> -----Original Message-----
>
> Subject: Re: [DAViCal-general] (Sorting in) the delegation drop down
> menu
>
> Date: Tue, 17 Aug 2010, 20:33
>
> From: Andrew McMillan
>
> To: Marc Patermann
>
> > On Tue, 2010-08-17 at 10:07 +0200, Marc Patermann wrote:
>
> > > Jason,
>
> > >
>
> > > Jason alavaliant schrieb am 17.08.2010 00:08 Uhr:
>
> > > > It sounds like you are on an older release? For me at least
> this
>
> > > > sorting issue was fixed in 0.9.9
>
> > > No, I'm using 0.9.9 too.
>
> > > I found out that sorting works for the principal (all the user's
>
> > > collections) but not in the calender/collection delegation itself.
>
> >
>
> > Thanks for the clarification. I've added the necessary 'order by'
>
> > clause now, and it'll be visible in Git as soon as I fix an annoying
> wee
>
> > bug to do with principal-property-search reports in my tree at
>
> > present...
>
> >
>
> > Also, I do agree that some of the elements on these pages can be a
> pain
>
> > if you have a large list of values in a drop-down. Unfortunately I'm
>
> > not any kind of a UI programmer, and I don't even play one at the
>
> > movies... :-)
>
> >
>
> > I've spent the last five years coming to grips with the calendaring
>
> > standards and so forth, and while I have some basic CSS and HTML
> skills
>
> > I could really use help in improving the user interface stuff. The
> good
>
> > thing is that the database structures for users / principals /
>
> > collections are fairly well settled now, so it is definitely
> worthwhile
>
> > starting to work on polishing these areas a bit more.
>
> >
>
> > Cheers,
>
> > Andrew.
>
> >
>
> >

--
------------------------------------------------------------------------
andrew (AT) morphoss (DOT) com +64(272)DEBIAN
There is a 20% chance of tomorrow.
------------------------------------------------------------------------

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

Make an app they can't live without
Enter the BlackBerry Developer Challenge
http://p.sf.net/sfu/RIM-dev2dev
-------------- next part --------------
_______________________________________________
rscds-general mailing list
rscds-general at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rscds-general