Re: Postgres with phpScheduleIt

I did get it working with 8.3, but it took some time and several posts
to the forums there. The changes were fairly minor on the phpscheduleit
side to make it work. They were specific to differences between mysql
and Postgres; there weren't any changes that were Postgres version
specific. It does require a working knowledge of Postgres to get it
working though. If anyone is interested in what I had to do, search for
posts from skreien on the forums at phpscheduleit website.

From what I saw of how it uses Postgres there shouldn't be any reason it
can't use almost any recent version; the database usage is fairly
simple. The setup script never did work properly though.

Still using phpscheduleit with Postgres 8.3, I haven't touched it since
I built it some months ago.

Thanks,

Scot Kreienkamp
La-Z-Boy Inc.
skreien(at)la-z-boy(dot)com
734-242-1444 ext 6379

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Peter
Eisentraut
Sent: Thursday, March 05, 2009 2:05 PM
To: pgsql-general(at)postgresql(dot)org
Cc: Stuart Luppescu
Subject: Re: [GENERAL] Postgres with phpScheduleIt

On Thursday 05 March 2009 18:39:11 Stuart Luppescu wrote:
> Hello, I'm trying to install phpScheduleIt (an on-line calendaring
> application) on my system that has postgres 8.0.15 running. I have to
> admit upfront that I have very little idea how postgres works; my
> small-business accounting system uses it, but it's sort of like a
black
> box to me.
>
> phpScheduleIt uses mySQL by default, but they claim is should work
with
> postgres. The setup uses a script that starts like this:
>
> # phpScheduleIt 1.2.0 #
> drop database if exists phpScheduleIt;
> create database phpScheduleIt;
> use phpScheduleIt;

I downloaded phpscheduleit to check it out, and the brief answer is, it
won't
work out of the box with PostgreSQL. It looks like you could make it
work
with a bit of effort, but if you are very new to PostgreSQL, this might
not
be the best use of your time.

Btw., the latest phpscheduleit version is 1.2.11, and the latest
PostgreSQL
version of that branch is 8.0.20. Make sure you run up to date
software.