Mercurial > sqlpython

comparison docs/source/intro.rst @ 464:26f60d5910a0

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
doubledashcomment moved into sqlpyPlus to define parser after local comment definition
author catherine@Drou
date Mon, 01 Mar 2010 23:26:38 -0500
parents 3efffbf7481f
children 920a45f244e8
comparison
equal deleted inserted replaced
463:317c0bb8afa4 464:26f60d5910a0
5 * PyPI: http://pypi.python.org/pypi/sqlpython 5 * PyPI: http://pypi.python.org/pypi/sqlpython
6 * News: http://catherinedevlin.blogspot.com/search/label/sqlpython 6 * News: http://catherinedevlin.blogspot.com/search/label/sqlpython
7 * Current docs: http://packages.python.org/sqlpython/ 7 * Current docs: http://packages.python.org/sqlpython/
8 * Mailing list: http://groups.google.com/group/sqlpython 8 * Mailing list: http://groups.google.com/group/sqlpython
9 9
10 SQLPython is a command-line interface to Oracle databases. It is intended as an alternative to Oracle's 10 SQLPython is a command-line interface to relational databases. It was created as an alternative to Oracle's
11 SQL\*Plus. For the most part, it can be used the same way SQL\*Plus would be used; this documentation 11 ``SQL\*Plus``, and can likewise be used instead of postgres' ``psql`` or mysql's ``mysql`` text clients.
12 focuses on the places where SQLPython differs. 12 For the most part, it can be used as any other text-based SQL interface would; this document focuses on
13 the extra capabilities
13 14
14 License 15 License
15 ------- 16 -------
16 17
17 sqlpython is free and open-source software. Its use is governed by the 18 sqlpython is free and open-source software. Its use is governed by the
85 `Senora <http://senora.sourceforge.net/>`_ and `YASQL <http://sourceforge.net/projects/yasql>`_. 86 `Senora <http://senora.sourceforge.net/>`_ and `YASQL <http://sourceforge.net/projects/yasql>`_.
86 87
87 Non-Oracle RDBMS 88 Non-Oracle RDBMS
88 ---------------- 89 ----------------
89 90
90 As of sqlpython 1.6.4, preliminary work has begun to adapt sqlpython to non-Oracle databases. 91 Version 1.7.0 of sqlpython works against PostgreSQL and MySQL, though the testing against
91 You may use it to run queries against postgreSQL, MySQL, etc., but data-dictionary access 92 those databases has been very slight thus far. Help in testing and improving sqlpython's
92 commands (`ls`, `grep`, `refs`, etc.) will generate errors. Connection to non-Oracle databases 93 functions against those databases is welcome. Support for Microsoft SQL Server and sqlite
93 is currently only possible via URL connection strings. 94 will be available as soon as those databases are added to the Gerald project, and volunteers
95 for Gerald will benefit sqlpython as well.
94 96
97 As of 1.7.0, sqlpython sessions can only "see" metadata within the named schema belonging
98 to the currently connected user. A fix for this is expected for 1.7.1.