Changes between Version 11 and Version 12 of DatabaseBackend
- Timestamp:
- Sep 30, 2005, 8:56:34 PM (19 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
DatabaseBackend
v11 v12 7 7 == Existing Proposals and Implementations == 8 8 9 * There has been an attempt to provide support for [http://www.postgresql.org PostgreSQL]: source:/branches/rocky-dev/features/postgresql_support/ though this branch is not so active this days... 9 Postgresql is supported as of Trac 0.9. Here are some limited instructions. 10 * Have a working copy of Postgresql 11 * Get the proper database driver for Python - [http://initd.org/projects/psycopg1 psycopg1], [http://initd.org/projects/psycopg2 psycopg2], or [http://pypgsql.sourceforge.net/ pyPgSQL] 12 * Create a database for your Trac environment 13 {{{ 14 % createdb dbname 15 }}} 16 * Run trac-admin to create a new Trac environment. When prompted for a Database connection string, use: 17 {{{ 18 postgres://user:pass@localhost:5432/dbname 19 }}} 10 20 11 * A more recent PostgreSQL effort is [http://trac.dsource.org/projects/test/wiki/PostgresqlPatch here].12 13 * Data Model Change14 If SQLObject (see below) works well, this proposal may not be necessary, but I would like some feedback (brad at dsource dot org) on the following proposal: [http://trac.dsource.org/projects/test/wiki/TracTicketDataModelChanges TracTicketDataModelChanges]15 16 I like its elegance in handling custom fields, allowing multiple ticket attributes per ticket (i.e. the ability to indicate all the versions of the software that a bug is present in, rather than being limited to indicating a single version), and I imagine it results in reduced code overall for the app because of the use of metadata.17 21 18 22 == Object-Relational Mapper ==