Great you're making this application. But could it, as Drupal does, support Postgres? This would be very helpful, as I use Postgres as database. Thanks!

Comments

Souvent22’s picture

Souvent22 commented
Assigned: Unassigned » Souvent22

Yes, I do plan on making postgres support. Expect a patch rollout to update the module to support postgres in the next few days.

Souvent22’s picture

Souvent22 commented
Status: Active » Postponed

I want to stabalize the main code base before implmeneting postgres. i will get to is asap though.

Souvent22’s picture

Souvent22 commented
Status: Postponed » Active

Hello. I just wanted to open this up. If anyone wants to write the install file for postgres, I shall start to add/implement postgres support.

jmajb’s picture

jmajb commented

I manage to generate the tables with this:

CREATE TABLE pontomail_servers (
sid SERIAL PRIMARY KEY,
server_name varchar(200) default NULL,
server_port int default NULL,
server_type varchar(10) default NULL,
uid int NOT NULL default '0',
server_address varchar(50) default NULL,
"user" varchar(40) default NULL,
password varchar(20) default NULL,
enabled int default '1',
secure int default '0',
con_ssl char(1) default '0',
no_tls char(1) default '1',
validate_cert char(1) default '0',
archive_sent_mail int NOT NULL default 0,
save_remote_copy int NOT NULL default 0,
save_remote_copy_folder varchar(255)
);

CREATE TABLE pontomail_pager_holder (
id varchar(18) default NULL,
uid int default NULL
);

CREATE TABLE pontomail_sendmail_groups (
cid int NOT NULL default '0',
category varchar(255) NOT NULL default '',
recipients text NOT NULL,
reply text NOT NULL,
weight smallint NOT NULL default '0',
selected smallint NOT NULL default '0'
);

Mind you, my Postgres knowledge is fairly basic.

Jac

Souvent22’s picture

Souvent22 commented

Could someone place this in a patch? I'm an drupalcon, and I will patch it immediatley, I just don't want to do it right now. I know, it's simple, but doing tons of things right now. Thanks. :)

jmajb’s picture

jmajb commented

Or still better, maybe you could make it database independent (from http://drupal.org/node/87073 :-)):

http://drupal.org/node/1395

Jac

Souvent22’s picture

Souvent22 commented

Jac,

Good point. Here I am preaching about "dirty sql" statements, and patching Oracle, and I have my own ditry laundary. :).
I'll rewrite some sql statements and update the DDL and re-roll. Sheesh, I feel awful, my own hipocrite. Sorry guys. I'll re-roll and patch soon.

- Souvent22

khagans’s picture

khagans commented

I've been working with PostgreSQL on my site and have pontomail working but not thorouhgly tested.

The biggest challenge I bumped into that I'd like to suggest should be handled through a change in code is with the pontomail_servers table design.

This table contains a field called 'user' which is a challenge because 'user' is a reserved word in Postgres. It would be useful if we could change this to usernm or some similar alternative.

Other than that, I have a ponotmail.pgsql file written and would be happy to overhaul the install script if necessary.