I am interested in adding MySQL, and possibly MSSQL, support to
DAViCal. I did some poking around the AWL and DAViCal source code and
decided it shouldn't be too difficult. Correct me if I am wrong, but it
looks like the relevant database-specific code is primarily in
AwlDatabase.php and AwlDBDialect.php, and maybe PgQuery.php. The SQL
strings scattered throughout the DAViCal source code can be replaced
with function calls that return strings in the appropriate SQL dialect.
I think a generic approach is best, so that any database server and SQL
dialect can be added. It looks like there was already a good start on
the necessary abstractions.
Am I missing anything?
Jeff Kintscher
websurfer at surf2c.net
DAViCal. I did some poking around the AWL and DAViCal source code and
decided it shouldn't be too difficult. Correct me if I am wrong, but it
looks like the relevant database-specific code is primarily in
AwlDatabase.php and AwlDBDialect.php, and maybe PgQuery.php. The SQL
strings scattered throughout the DAViCal source code can be replaced
with function calls that return strings in the appropriate SQL dialect.
I think a generic approach is best, so that any database server and SQL
dialect can be added. It looks like there was already a good start on
the necessary abstractions.
Am I missing anything?
Jeff Kintscher
websurfer at surf2c.net