Mailing List Archive

Extended database support
Hi,

I suppose this is one of the most commonly requested features for
DAViCal but due to the lack of an archive of this mailing list I wasn't
able to find any status on this apart from Andrew's answer to the MySQL
support request
(http://feedback.davical.org/forums/2973-general/suggestions/80691-support-mysql-database?ref=comments)
saying that he is not going to put any effort in supporting other DBMS.

Having had a short lock at DAViCal and especially AWL, I saw that
support for other DBMS will first have to be added to AWL
(AwlDBDialect.php). I have some profound knowledge of SQL in general,
but am not an expert for any DBMS (or, if any, then Oracle or Postgres).
Thus what I'm interested in is, if there are any tests for the
functionality of the AWL library. That could be used to ensure that the
functions (after applying changes) are working for other DBMS like
SQLLite or MySQL as well.

Best regards.
Extended database support [ In reply to ]
On Fri, 2010-11-26 at 17:50 +0100, Daniel H. Peger wrote:
> Hi,
>
> I suppose this is one of the most commonly requested features for
> DAViCal but due to the lack of an archive of this mailing list I wasn't
> able to find any status on this apart from Andrew's answer to the MySQL
> support request
> (http://feedback.davical.org/forums/2973-general/suggestions/80691-support-mysql-database?ref=comments)
> saying that he is not going to put any effort in supporting other DBMS.

Hi Daniel,

There is an archive for this list, but until recently not many people
have posted to it. It's great to see development stuff moving here
though, which was the intention, really.

http://lists.morphoss.com/pipermail/davical-dev/

It seems it's even indexed by Google :-)
http://www.google.com/search?q=site%3Alists.morphoss.com+mysql


> Having had a short lock at DAViCal and especially AWL, I saw that
> support for other DBMS will first have to be added to AWL
> (AwlDBDialect.php).

That's the intended path, yes.


> I have some profound knowledge of SQL in general, but am not an expert
> for any DBMS (or, if any, then Oracle or Postgres). Thus what I'm
> interested in is, if there are any tests for the functionality of the
> AWL library. That could be used to ensure that the functions (after
> applying changes) are working for other DBMS like SQLLite or MySQL as
> well.

The AWL dialect handling is in no way intended to provide a system for
constructing database-independent SQL. It is intended to provide a way
of writing support in PHP where some database or other cannot do what
the SQL is requesting.

I desire to code in SQL, a language I have many years of familiarity
with, and not by using some baroque SQL-constructing monolith.

As such I don't know what a test suite would look like. There are
regression tests for DAViCal, and so to a large extent that is my test
suite for AWL. While I have several other projects that depend on AWL
they are not under anything like as heavy development as DAViCal is, so
it necessarily tends to drive the library development as well.

Cheers,
Andrew.
--
------------------------------------------------------------------------
http://andrew.mcmillan.net.nz/ Porirua, New Zealand
Twitter: _karora Phone: +64(272)DEBIAN
The truth is rarely pure, and never simple. -- Oscar Wilde
------------------------------------------------------------------------

-------------- 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-dev/attachments/20101127/7a52de00/attachment.pgp>