[cacti-user] PostgreSQL support

[Stephen F. <sf...@sn...>]

* Ian Berry (ib...@ra...) wrote:
> I had no idea that this caused problems under FreeBSD... The cacti.sql
> file was generated with mysqldump, I am surprised it didn't escape
> reserved words better. Guess I have to make some changes in my code as
> well.

Here's a real fun question for you..  Any chance you'd make it possible
for cacti to work with PostgreSQL?  I'd rather not have to run two
different databases (and I don't particularly care for MySQL anyway).
I've done some initial work towards this but havn't been able to
actually get it to work yet.  Basically I went through and cleaned up
cacti.sql and then made the more obvious changes to the code (changing
replace into with update/insert, etc).

I'm not sure if one set of SQL code will be able to work with both,
unfortunately.  Perhaps moving the SQL code into it's own file/class and
then having one for MySQL and one for PostgreSQL.  Another alternative
would be to use of the PHP database abstraction layers that are
available and avoid having to write SQL code.

	Stephen