Changes between Version 56 and Version 57 of DatabaseBackend
- Timestamp:
- May 26, 2018, 8:19:22 PM (6 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
DatabaseBackend
v56 v57 1 [[PageOutline(2-3)]] 1 2 = Database Backend 2 3 3 Trac offers an easily extensible layer for database support, see [source:trunk/trac/db/api.py trac.db.api]. The following databases have been integrated in this layer: 4 * '''[http://www.sqlite.org SQLite]''', using '''PySqlite''', the default database 5 * '''[http://www.postgresql.org PostgreSQL]''', using the 6 '''[http://initd.org/pub/software/psycopg/ psycopg2]''' bindings, support added as of Trac [milestone:0.9]. 7 * Note that psycopg1 is no longer supported and that [http://pypgsql.sourceforge.net/ pyPgSQL] also presents issues for some users, see #5096. 8 * Finally, see #126 for historical notes. 9 * '''[http://www.mysql.org MySQL]''', using MySqlDb, support added for Trac [milestone:0.10]; see [http://thread.gmane.org/gmane.comp.version-control.subversion.trac.devel/342/focus=348 status report] and #986 for historical notes. 10 11 There is work in progress for the following databases: 12 * [http://www.actian.com/products/operational-databases/ingres/ Ingres], see #6235. 13 * [http://www.oracle.com/index.html Oracle], see #1874 and [th:#5487]. 14 * [http://www.microsoft.com/en-us/server-cloud/products/sql-server/ Microsoft SQL Server], see th:MsSqlBackendPlugin and #329. 4 Trac supports the following databases: 5 * '''[http://www.sqlite.org SQLite]''', the default database 6 * '''[http://www.postgresql.org PostgreSQL]''' 7 * '''[http://www.mysql.org MySQL]''' 15 8 16 9 == Database Installation Instructions … … 30 23 Known issues: see [query:keywords=~sqlite&status=!closed SQLite-related tickets]. 31 24 32 === Postgre sql25 === PostgreSQL 33 26 34 27 Prerequisites: 28 * Trac >=[milestone:0.9]. 35 29 * Have a working copy of Postgresql. 36 * Get the proper database driver for Python , see above.30 * Get the proper database driver for Python: ''[http://initd.org/pub/software/psycopg/ psycopg2]'' bindings 37 31 * Create a database for your Trac environment: 38 32 {{{ … … 60 54 For a Postgresql recipe tested on CentOS4 (Red Hat -EL4) see [wiki:PostgresqlRecipe]. 61 55 62 Note: Since Trac [milestone:0.10 0.10] the psycopg1 Postgresql driver is no longer supported due to lack of Unicode support. 56 Note: Since Trac [milestone:0.10 0.10] the psycopg1 Postgresql driver is no longer supported due to lack of Unicode support. [http://pypgsql.sourceforge.net/ pyPgSQL] also presents issues for some users, see #5096. 57 58 Finally, see #126 for historical notes. 63 59 64 60 Known issues: see [query:keywords=~postgres&status=!closed postgres-related tickets] … … 86 82 * `unix_socket`: Use a Unix socket at the given path to connect 87 83 84 see [http://thread.gmane.org/gmane.comp.version-control.subversion.trac.devel/342/focus=348 status report] and #986 for historical notes. 85 88 86 Known issues: see [query:keywords=~mysql&status=!closed mysql-related tickets]. 89 87 … … 91 89 92 90 For Trac >= 1.3.2, the TracAdmin `convert_db` command allows an environment to be converted between the supported database backends. For Trac < 1.3.2, [th:TracMigratePlugin] provides equivalent functionality. 91 92 == Other Databases 93 94 Trac offers an easily extensible layer for database support, see [source:trunk/trac/db/api.py trac.db.api]. The databases above have been integrated in this layer. 95 96 Other databases where support has been requested or where support exists via plugins are: 97 * '''[http://www.actian.com/products/operational-databases/ingres/ Ingres]''': see #6235. 98 * '''[http://www.oracle.com/index.html Oracle]''': see #1874 and [th:#5487]. 99 * '''[http://www.microsoft.com/en-us/server-cloud/products/sql-server/ Microsoft SQL Server]''': see th:MsSqlBackendPlugin and #329.