Re: [Mailman-Developers] [Bug 860159] Re: Mailman 3.0 support for Postgres

On Sep 27, 2011, at 12:44 AM, Stephen A. Goss wrote:
I've attached a branch with the Postgres support code that I've cooked up.
Fantastic, thanks! Do be sure to add a merge proposal.
Do you have any thoughts on whether the two .sql files can possibly be shared? My biggest concern is that it will be difficult-ish to keep them in sync as I add or modify the SQLite version. If it's not possible, so be it.
I took a quick look at the Python changes, and I think I'm going to refactor the code to not hardcode so much in stock.py. For example, I'll probably rename StockDatabase to SQLiteDatabase and add a PostgresDatabase class, adding a common super class. That way, you'd only need to put this in your mailman.cfg file:
[database] class: mailman.database.postgres.PostgresDatabase
Don't worry about that too much, I can make that change when I merge your branch.
I'd definitely like to be able to run the test suite against Postgres, if even for now it's a manual select (e.g. because Postgres would obviously have to be installed and configured in order to work).

On 09/26/2011 09:03 PM, Barry Warsaw wrote:
Foreign key constraints are available in sqlite 3.6.19 and above. They are turned off by default. They can be enabled with:
PRAGMA foreign_keys = ON;
More details at: http://www.sqlite.org/foreignkeys.html

On 09/26/2011 09:03 PM, Barry Warsaw wrote:
Foreign key constraints are available in sqlite 3.6.19 and above. They are turned off by default. They can be enabled with:
PRAGMA foreign_keys = ON;
More details at: http://www.sqlite.org/foreignkeys.html
participants (2)
-
Barry Warsaw
-
Dan MacNeil