Author: reinhard Date: 2005-06-01 06:41:19 -0500 (Wed, 01 Jun 2005) New Revision: 7558
Removed: trunk/gnue-common/README.databases Modified: trunk/README.txt trunk/gnue-common/MANIFEST.in trunk/gnue-common/doc/Connections.txt trunk/gnue-forms/README.databases Log: Removed README.databases. It is outdated and obsolete, as the web page contains current information. Modified: trunk/README.txt =================================================================== --- trunk/README.txt 2005-06-01 11:26:50 UTC (rev 7557) +++ trunk/README.txt 2005-06-01 11:41:19 UTC (rev 7558) @@ -60,9 +60,7 @@ GNUe Common is required for any Python-based tools (GNUe Forms, Reports, and Designer.) It defines a common code base for other Python-based GNUe tools. GNUe-Common provides a consistent interface - to many databases and database middleware adapters. See - common/README for more information and common/README.databases for a - list of supported database backends. + to many databases and database middleware adapters. gnue-packages/ GNUe Packages is a set of definitions for geas that define various Modified: trunk/gnue-common/MANIFEST.in =================================================================== --- trunk/gnue-common/MANIFEST.in 2005-06-01 11:26:50 UTC (rev 7557) +++ trunk/gnue-common/MANIFEST.in 2005-06-01 11:41:19 UTC (rev 7558) @@ -5,7 +5,6 @@ include INSTALL include NEWS include README -include README.databases include THANKS include TODO include setup.cfg.in Deleted: trunk/gnue-common/README.databases =================================================================== --- trunk/gnue-common/README.databases 2005-06-01 11:26:50 UTC (rev 7557) +++ trunk/gnue-common/README.databases 2005-06-01 11:41:19 UTC (rev 7558) @@ -1,703 +0,0 @@ -INTRODUCTION -============ - -This is a summary of all backends supported by GNUe-Common (and, therefore, -GNUe-Forms and GNUe-Reports). If your database is not listed, you may be -able to connect using one of the middleware adapters. - - ----------------------------------------------------------------- -Quick chart of supported databases: - * PostgreSQL 6.x-7.x [via PyGreSQL, PyPgSQL, Psycopg, and PoPy] - * MySQL 3.22-4.x [via MySQLdb] - * Oracle 8.x/9i [via DCOracle2, cxOracle] - * IBM DB/2 7.1 [via DB2-Python] - * SAP-DB 7.x [via sapdb-python] - * Interbase 5.x-6.x and Firebird 1.x [via Kinterbasdb] - * Informix [via Kinfxdb] - * OpenIngres 1.2, CA Ingres 6.4, CA Ingres II [via ingmod] - * Sybase ASE 11.0.3/11.9.2 [via Sybase-Python] - * SQLite 2.7 [via PySQLite] - * Gadfly 1.0 - -Quick chart of supported middleware: - * GNUe AppServer [via GNURPC] - * ADO [via adodbapi] - * ODBC [via PythonWin ODBC] - * SQLRelay [via SQLRelay-Python] ----------------------------------------------------------------- - - -A NOTE ON LICENSES -================== - -Read each adapter's license carefully before using. Most licenses do allow -both unrestricted commercial and non-commercial use (with the notable -exception of mxODBC.) Restrictions on redistribution does, however, vary -between the adapters. - - -DATABASE ADAPTERS -================= - - -PostgreSQL -========== - -*** PyGreSQL [http://druid.net/pygresql/] - - POSIX Support: YES - Win32 Support: YES [no prebuilt binaries] - - Platforms Tested: - GNU/Linux [Debian 2.x, Slackware 8.0, RedHat 6.x/7.x] - - Description: - PyGreSQL is the standard PostgreSQL-Python driver. - It is compliant to Python's DB-API 2.0. - - Example connections.conf entry: - - [myconn] - provider=pygresql # Use the pygresql adapter - host=localhost # The hostname/IP of the postgresql host - dbname=mydb # The name of the pg database - encoding=ASCII # Optional: the client encoding for PG - - - -*** PyPgSQL [http://pypgsql.sf.net/] - - POSIX Support: YES - Win32 Support: YES [prebuilt binaries] - - Platforms Tested: - GNU/Linux [Debian 2.x, Slackware 8.0, RedHat 6.x/7.x] - Windows 98 - - Description: - Written by Billy Allie, PyPgSQL is a database interface for - PostgreSQL 7.x. - - Example connections.conf entry: - [myconn] - provider=pypgsql # Use the pypgsql adapter - host=localhost # The hostname/IP of the postgresql host - dbname=mydb # The name of the pg database - encoding=ASCII # Optional: the client encoding for PG - - - -*** Psycopg [http://initd.org/software/psycopg/] - - POSIX Support: YES - Win32 Support: ??? - - Platforms Tested: - ??? (We need your help!) - - Description: - From the Psycopg website: "It was written from scratch with the aim of - being very small and fast, and stable as a rock." Written by initd.org - volunteers. - - - Example connections.conf entry: - - [myconn] - provider=psycopg # Use the psycopg adapter - host=localhost # The hostname/IP of the postgresql host - dbname=mydb # The name of the pg database - encoding=ASCII # Optional: the client encoding for PG - - Notes: - - 1. Available in Debian [sid] as: "apt-get install python-psycopg" - - - -*** PoPy [http://popy.sf.net/] - - POSIX Support: YES - Win32 Support: ??? - - Platforms Tested: - ??? (We need your help!) - - Description: - Written by Thierry Michel and friends. Strong multi-thread support. - - Example connections.conf entry: - - [myconn] - provider=popy # Use the PoPy adapter - host=localhost # The hostname/IP of the postgresql host - dbname=mydb # The name of the pg database - encoding=ASCII # Optional: the client encoding for PG - - Notes: - - 1. Available in Debian [sid,woody] as: "apt-get install python-popy" - - - -MySQL -===== - -*** MySQLdb [http://sourceforge.net/projects/mysql-python] - - POSIX Support: YES - Win32 Support: YES [prebuilt binaries at http://www.cs.fhm.edu/~ifw00065/] - - Platforms Tested: - GNU/Linux [Debian Sarge,RedHat 7.x] - - Description: - Written by Andy Dustman, this driver supports MySQL 3.22, 3.23, and - 4.x. - - Example connections.conf entry: - - [myconn] - provider=mysql # Use the MySQLdb adapter - host=localhost # The hostname/IP of the MySQL host - dbname=mydb # The name of the MySQL database - - Notes: - - 1. Transactions are supported if MySQL is compiled with proper - transactional support (3.x series does NOT do this by default!) - - 2. This driver has been partially tested. If you are successfully using - this driver, please let us know. - - - -Oracle -====== - -*** DCOracle [http://www.zope.org/Members/matt/dco2] - - POSIX Support: YES - Win32 Support: YES [prebuilt binaries (WinNT only)] - - Platforms Tested: - GNU/Linux [Debian Woody/Sarge, RedHat 7.x] - - Description: - An Oracle driver from Digital Creations (Zope). Works with Oracle - 7.3, 8.x, 9i via Oracle's SQL-Net OCI interface. - - Example connections.conf entry: - - [myconn] - provider=oracle # Use the DCOracle2 adapter - service=mytnsname # The TNS connection string of the database - - Notes: - - 1. Requires Oracle Client Libraries - - 2. Does not recognize the TWO_TASK environment setting. - - - -*** cxOracle [http://www.computronix.com/utilities/] - - POSIX Support: YES - Win32 Support: YES [prebuilt binaries] - - Platforms Tested: - ??? - - Description: - An Oracle driver from Computronix. Works with Oracle 7.3 and 8.x via - Oracle's SQL-Net OCI interface. - - Example connections.conf entry: - - [myconn] - provider=cxoracle # Use the CX Oracle adapter - service=mytnsname # The TNS connection string of the database - - Notes: - - 1. Requires Oracle Client Libraries. - - 2. Does not recognize the TWO_TASK environment setting. - - 3. This driver has not been fully tested. If you are successfully using - this driver, please let us know. - - - -IBM DB/2 -======== - -** DB2-Python [ftp://people.linuxkorea.co.kr/pub/DB2/] - - POSIX Support: YES - Win32 Support: YES [prebuilt binaries] - - Platforms Tested: - ??? (We need your help!) - - Description: - A DB/2 driver from Bryan Lee. Works with IBM's DB/2 version 7.1. - - Example connections.conf entry: - - [myconn] - provider=db2 # Use the DB/2 adapter - service=mydsn # The DSN connection string of the database - - Notes: - - 1. The Win32 binaries are included in the tar'ed file (in win32/) - - 2. This driver has not been fully tested. If you are successfully using - this driver, please let us know. - - 3. This driver does not yet support schema introspection, so you will not - be able to use Wizards in GNUe Designer. - - - -SAP-DB -====== - -*** SAP-DB [http://www.sapdb.org/] - - POSIX Support: YES - Win32 Support: YES - - Platforms Tested: - ??? (We need your help!) - - Description: - Written by the SAP-DB people, this driver is part of the SAP DB - distribution. Works with the 7.x series of SAP-DB - - Example connections.conf entry: - - [myconn] - provider=sapdb # Use the SAP-DB adapter - host=localhost # The hostname/IP of the SAP-DB host - dbname=mydb # The name of the SAP-DB database - - Notes: - - 1. This driver has not been fully tested. If you are successfully using - this driver, please let us know. - - - -Informix -======== - -*** Kinfxdb [http://thor.prohosting.com/~alexan/pub/Kinfxdb/Kinfxdb-0.2.tar.gz] - - POSIX Support: YES - Win32 Support: ??? - - Platforms Tested: - ??? (We need your help!) - - Description: - Written by Alexander Kuznetsov, this driver provides support for - Informix. - - Example connections.conf entry: - - [myconn] - provider=informix # Use the Kinfxdb adapter - host=localhost # The hostname/IP of the Informix host - dbname=mydb # The name of the Informix database - - Notes: - - 1. This driver has not been fully tested. If you are successfully using - this driver, please let us know. - - 2. This driver does not yet support schema introspection, so you will not - be able to use Wizards in GNUe Designer. - - - -Interbase -========= - -*** Kinterbasdb [http://kinterbasdb.sf.net/] - - POSIX Support: YES - Win32 Support: YES [prebuilt binaries] - - Platforms Tested: - Win2k, Debian 3.0 - - Description: - Written by Alexander Kuznetsov, this driver provides support for - Interbase. - - Example connections.conf entry: - - [myconn] - provider=interbase # Use the Kinterbasedb adapter - host=localhost # The hostname/IP of the Interbase host - dbname=mydb # The name of the Interbase database - - Notes: - - 1. This driver has not been fully tested. If you are successfully using - this driver, please let us know. - - - -OpenIngres, CA Ingres, CA Ingres II -=================================== - -*** ingmod [http://www.informatik.uni-rostock.de/~hme/software/] - - POSIX Support: YES - Win32 Support: ??? - - Platforms Tested: - ??? (We need your help!) - - Description: - Written by Holger Meyer, this driver supports OpenIngres, as well as - the various CA Ingres solutions. - - Example connections.conf entry: - - [myconn] - provider=ingres # Use the ingmod adapter - dbname=mydb # The name of the Ingres database - - Notes: - - 1. This driver has not been fully tested. If you are successfully using - this driver, please let us know. - - 2. This driver does not yet support schema introspection, so you will not - be able to use Wizards in GNUe Designer. - - - -Informix -======== - -*** Kinfxdb [http://thor.prohosting.com/~alexan/pub/Kinfxdb/Kinfxdb-0.2.tar.gz] - - POSIX Support: YES - Win32 Support: ??? - - Platforms Tested: - ??? (We need your help!) - - Description: - Written by Alexander Kuznetsov, this driver provides support for - Informix. - - Example connections.conf entry: - - [myconn] - provider=informix # Use the Kinfxdb adapter - host=localhost # The hostname/IP of the Informix host - dbname=mydb # The name of the Informix database - - Notes: - - 1. This driver has not been fully tested. If you are successfully using - this driver, please let us know. - - 2. This driver does not yet support schema introspection, so you will not - be able to use Wizards in GNUe Designer. - - - -Sybase -====== - -*** Sybase [http://www.object-craft.com.au/projects/sybase/] - - POSIX Support: YES - Win32 Support: YES [no prebuilt binaries] - - Platforms Tested: - ??? (We need your help!) - - Description: - Written by David Cole, this driver works with the 11.x.x series - of Sybase ASE. - - Example connections.conf entry: - - [myconn] - provider=sybase # Use the Sybase adapter - host=localhost # The hostname/IP of the Sybase host - dbname=mydb # The name of the Sybase database - - Notes: - - 1. This driver has not been fully tested. If you are successfully using - this driver, please let us know. - - 2. This driver does not yet support schema introspection, so you will not - be able to use Wizards in GNUe Designer. - - - -SQLite -====== - -*** PySQLite [http://pysqlite.sourceforge.net/] - - POSIX Support: YES - Win32 Support: YES - - Platforms Tested: - Debian GNU/Linux 3.0 - - Description: - SQLite is a powerful embedded relational database management system - in a compact C library, developed by D. Richard Hipp. The library is - self-contained ... itself is uncopyrighted, and free to use for any - purpose. - - SQLite is not a client library used to connect to a big database server. - SQLite is the server. The SQLite library reads and writes directly to - and from the database files on disk. - - PySQLite is a Python extension for SQLite that conforms to the Python - Database API Specification 2.0. The source is released under the - Python license. - - - Example connections.conf entry: - - [myconn] - provider=sqlite # Use the SQLite adapter - dbname=/usr/db/testdb # The filename for the SQLite database - - Notes: - - 1. The database engine stores all data in string format. Many - SQL statements won't work. Comparison of date types won't work - correctly, etc. - - - -Gadfly -====== - -*** Gadfly [http://gadfly.sourceforge.net/] - - POSIX Support: YES - Win32 Support: YES - - Platforms Tested: - Debian GNU/Linux 3.0 - - Description: - Gadfly is a simple relational database system implemented in Python - based on the SQL Structured Query Language. - - Gadfly is not a client library used to connect to a big database server. - Gadfly is the server. The Gadfly library reads and writes directly to - and from the database files on disk. - - - Example connections.conf entry: - - [myconn] - provider=gadfly # Use the gadfly adapter - dbname=testdb # The filename for the gadfly database - # (without extension) - directory=/usr/db # The directory where the gadfly database - # is stored - - Notes: - - 1. The database engine stores all data in string format. Many - SQL statements won't work. Comparison of date types won't work - correctly, etc. - - 2. The database engine doesn't support the sql condition "LIKE", it - will replaced by the condition "=" (equal) for the moment. - - - - -MIDDLEWARE ADAPTERS -=================== - - -GNUe Application Server (gnue-appserver) -======================================== - -*** gnue/appserver [http://www.gnue.org/] - - POSIX Support: YES - Win32 Support: YES - - Platforms Tested: - Debian GNU/Linux 3.0 - MS Windows 98 - - Description: - GNUe's own Enterprise Application Server, currently under heavy - development, provides a business rules and data backend. Works - with a variety of databases. [Not yet stable] - - Example connections.conf entry: - - [myconn] - provider = appserver # Use the GNUe appserver adapter - rpctype = xmlrpc # connect via xmlrpc ( for a list of - # GNURPC protocols look at doc/RPC-status.txt - host = localhost # The hostname/IP of the GNUe App. host - port = 8765 # The portnumber of " " " - transport = http # The transport used by the RPC protocol - - -ADO -=== - -*** adodbapi [http://sourceforge.net/projects/adodbapi] - - POSIX Support: NO - Win32 Support: YES - - Platforms Tested: - ??? (We need your help!) - - Description: - A Python DB-API 2.0 module that makes it easy to use Microsoft ADO - for connecting with databases and other data sources. - - Features: - * 100% DB-API 2.0 compliant. - * Includes pyunit testcases that describes how to use the module. - * Fully implemented in Python. - * Licensed under the LGPL license, which means that it can be used freely even in commercial programs subject to certain restrictions. - * Supports eGenix mxDateTime, Python 2.3 datetime module and Python time module. - - Prerequisites: - * Python 1.5.2 or higher. - * Mark Hammond's win32all python for windows extensions. - - Example connections.conf entry: - - [myconn] - provider=adodbapi # Use the adodbapi adapter - connstr = Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydb.mdb; # The full connection string - - Notes: - - 1. This driver has not been fully tested. If you are successfully using - this driver, please let us know. - - -ODBC -==== - -*** PythonWin ODBC [http://aspn.activestate.com/ASPN/Downloads/ActivePython/Extensions/Win32all] - - POSIX Support: NO - Win32 Support: YES [prebuilt binaries] - - Platforms Tested: - ??? (We need your help!) - - Description: - A commercial ODBC interface for Python written by Marc-Andr�emburg. - Supports practically any database backend with ODBC drivers (are there - any without ODBC drivers?) - - Example connections.conf entry: - - [myconn] - provider=odbc # Use the ODBC adapter - service=mydsn # The DSN connection string of the database - - Notes: - - 1. This driver has not been fully tested. If you are successfully using - this driver, please let us know. - - 2. This driver does not yet support schema introspection, so you will not - be able to use Wizards in GNUe Designer. - - - -*** mxODBC [http://www.lemburg.com/files/python/mxODBC.html] - - POSIX Support: YES - Win32 Support: YES [prebuilt binaries] - - Platforms Tested: - ??? (We need your help!) - - Description: - A commercial ODBC interface for Python written by Marc-Andr�emburg. - Supports practically any database backend with ODBC drivers (are there - any without ODBC drivers?) - - Example connections.conf entry: - - [myconn] - provider=mxodbc # Use the mxODBC adapter - service=Subdriver|mydsn # The DSN connection string of the database - - Notes: - - 1. The mxODBC driver is only free for non-commercial use! Check their - license before using. - - 2. Uses Windows ODBC drivers natively, but on Unix, requires subpackages - to be installed. Under Windows, the Subdriver (in the service= - entry) will always be "Windows" (e.g., "service=Windows|mydsn" ) - However, under Unix, the Subdriver will be the subpackage name (e.g, - "PostgreSQL", "Oracle", "iODBC", "unixODBC") See the mxODBC - documentation for more information. - - 3. This driver has not been fully tested. If you are successfully using - this driver, please let us know. - - 4. This driver does not support schema introspection, so you will not - be able to use Wizards in GNUe Designer. - - - -SQLRelay -======== - -*** SQLRelay [http://www.firstworks.com/sqlrelay.html] - - POSIX Support: YES - Win32 Support: ??? - - Platforms Tested: - ??? (We need your help!) - - Description: - From FirstWork's website: "SQL Relay is a persistent database - connection pooling, proxying and load balancing system for Unix - and Linux." - - Example connections.conf entry: - - [myconn] - provider=sqlrelay # Use the SQLRelay adapter - host=hostname # The host running SQLRelay - port=9000 - - Notes: - - 1. This driver has not been fully tested. If you are successfully using - this driver, please let us know. - - 2. This driver does not support schema introspection, so you will not - be able to use Wizards in GNUe Designer. - Modified: trunk/gnue-common/doc/Connections.txt =================================================================== --- trunk/gnue-common/doc/Connections.txt 2005-06-01 11:26:50 UTC (rev 7557) +++ trunk/gnue-common/doc/Connections.txt 2005-06-01 11:41:19 UTC (rev 7558) @@ -133,7 +133,8 @@ Providers --------- -See README.databases for a complete list of providers. +See http://www.gnuenterprise.org/tools/common/databases/ for a complete list of +providers. -------------- Modified: trunk/gnue-forms/README.databases =================================================================== --- trunk/gnue-forms/README.databases 2005-06-01 11:26:50 UTC (rev 7557) +++ trunk/gnue-forms/README.databases 2005-06-01 11:41:19 UTC (rev 7558) @@ -1,3 +1,4 @@ -GNUe Forms supports numerous databases via GNUe-Common. See the -README.databases file in the GNUe-Common package for information -on supported databases. +GNUe Forms supports numerous databases via GNUe-Common. + +See http://www.gnuenterprise.org/tools/common/databases/ for information on +supported databases. _______________________________________________ Commit-gnue mailing list Commit-gnue@gnu.org http://lists.gnu.org/mailman/listinfo/commit-gnue