Gossamer Forum
Home : Products : Others : MySQLMan :

postgreSQL?

Quote Reply
postgreSQL?
Hey,

I was wondering if MysqlMan can work with postgreSQL as well?

If not, would it require some minor modifications to the script, a full rewrite, or is it not possible? If only minor modifications, I may consider attempting to pull a version out of my... brain. :-)

And I don't have the option of switching to MySQL, BTW. I only have postgreSQL access.

Thanks,
Flame



Quote Reply
Re: postgreSQL? In reply to
Without looking at the code for sure, I would say "yes" it could be done.

You'd probably have to work on the authentication routines, and SQL syntax for statements. I don't think all the MySQL commands are supported in postgres, and in the same way.

This program, like the phpMyAdmin is a wrapper for the DBI interface to the SQL database. It makes the request, and formats the output. It doesn't really "hook" into the dabase. It's a front end or wrapper.

In that respect, you should be able to modify the program. I've never touched postgres so I wouldn't have any idea how big a job that would be.

It certainly would be an easier place to start from, than doing it from scratch :)



http://www.postcards.com
FAQ: http://www.postcards.com/FAQ/LinkSQL/

Quote Reply
Re: postgreSQL? In reply to
Well, I guess it won't hurt to give it a try. If I can get it working for postgres, maybe I can send it to g-t to distribute...

Thanks,
Jordan

Quote Reply
Re: postgreSQL? In reply to
I would think it's not possible. Last I checked, which was about 8 months ago, Postgres is missing to many functions to make this possible. You need things like DESCRIBE table, SHOW DATABASES, ALTER, etc to do a lot of the features. It would be quite involved to do a rewrite.

Cheers,

Alex

--
Gossamer Threads Inc.