Changes between Version 56 and Version 57 of DatabaseBackend

Timestamp:

May 26, 2018, 8:19:22 PM (6 years ago)

Author:

anonymous

Comment:

Reorganize

DatabaseBackend

@@ +1 @@
+[[PageOutline(2-3)]]
 = Database Backend
 
-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:
- * '''[http://www.sqlite.org SQLite]''', using '''PySqlite''', the default database
- * '''[http://www.postgresql.org PostgreSQL]''', using the
-   '''[http://initd.org/pub/software/psycopg/ psycopg2]''' bindings, support added as of Trac [milestone:0.9].
-   * Note that psycopg1 is no longer supported and that [http://pypgsql.sourceforge.net/ pyPgSQL] also presents issues for some users, see #5096.
-   * Finally, see #126 for historical notes.
- * '''[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.
-
-There is work in progress for the following databases:
- * [http://www.actian.com/products/operational-databases/ingres/ Ingres], see #6235.
- * [http://www.oracle.com/index.html Oracle], see #1874 and [th:#5487].
- * [http://www.microsoft.com/en-us/server-cloud/products/sql-server/ Microsoft SQL Server], see th:MsSqlBackendPlugin and #329.
+Trac supports the following databases:
+ * '''[http://www.sqlite.org SQLite]''', the default database
+ * '''[http://www.postgresql.org PostgreSQL]'''
+ * '''[http://www.mysql.org MySQL]'''
 
 == Database Installation Instructions
@@ -30 +23 @@
 Known issues: see [query:keywords=~sqlite&status=!closed SQLite-related tickets].
 
-=== Postgresql
+=== PostgreSQL
 
 Prerequisites:
+ * Trac >=[milestone:0.9].
  * Have a working copy of Postgresql.
- * Get the proper database driver for Python, see above.
+ * Get the proper database driver for Python: ''[http://initd.org/pub/software/psycopg/ psycopg2]'' bindings
  * Create a database for your Trac environment:
 {{{
@@ -60 +54 @@
 For a Postgresql recipe tested on CentOS4 (Red Hat -EL4) see [wiki:PostgresqlRecipe].
 
-Note: Since Trac [milestone:0.10 0.10] the psycopg1 Postgresql driver is no longer supported due to lack of Unicode support.
+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.
+
+Finally, see #126 for historical notes.
 
 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
 
+see [http://thread.gmane.org/gmane.comp.version-control.subversion.trac.devel/342/focus=348 status report] and #986 for historical notes.
+
 Known issues: see [query:keywords=~mysql&status=!closed mysql-related tickets].
 
@@ -91 +89 @@
 
 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. 
+
+== Other Databases
+
+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.
+
+Other databases where support has been requested or where support exists via plugins are:
+ * '''[http://www.actian.com/products/operational-databases/ingres/ Ingres]''': see #6235.
+ * '''[http://www.oracle.com/index.html Oracle]''': see #1874 and [th:#5487].
+ * '''[http://www.microsoft.com/en-us/server-cloud/products/sql-server/ Microsoft SQL Server]''': see th:MsSqlBackendPlugin and #329.