Mercurial > sqlpython

comparison docs/source/comparison.rst @ 304:98975ce340ac

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
more docs changes
author catherine@dellzilla
date Wed, 25 Mar 2009 10:00:46 -0400
parents e7578e7ff9dd
children 9c727d6afdc0
comparison
equal deleted inserted replaced
300:154c2e44abce 304:98975ce340ac
170 170
171 On Windows, the up- and down-arrow keys can be used to scroll through 171 On Windows, the up- and down-arrow keys can be used to scroll through
172 the history of SQL\*Plus commands issued during the session. SQL\*Plus on UNIX does not provide this feature. You can restore the feature, however, by installing a free GNU tool called `rlwrap`, then invoking SQL*\Plus under it: `rlwrap sqlplus me@instance`. 172 the history of SQL\*Plus commands issued during the session. SQL\*Plus on UNIX does not provide this feature. You can restore the feature, however, by installing a free GNU tool called `rlwrap`, then invoking SQL*\Plus under it: `rlwrap sqlplus me@instance`.
173 `rlwrap` can also provide cursor-key history to senora, and in fact to any command-line program. 173 `rlwrap` can also provide cursor-key history to senora, and in fact to any command-line program.
174 174
175 Gqlplus, YASQL, and sqlpython provide cursor-key command history out of the box. 175 Gqlplus and sqlpytyhon provide cursor-key command history out of the box; Senora and YASQL do also, provided
176 that the Term::ReadLine::Perl module has been installed (see Installation).
176 177
177 In addition, senora and sqlpython have a `history` or `hi` command that gives a numbered list of all commands issued in the session. 178 In addition, senora and sqlpython have a `history` or `hi` command that gives a numbered list of all commands issued in the session.
178 179
179 Senora history commands 180 Senora history commands
180 ~~~~~~~~~~~~~~~~~~~~~~~ 181 ~~~~~~~~~~~~~~~~~~~~~~~
746 Senora depends on the DBI and DBD::Oracle packages. Perl's `cpan` tool is a fairly convenient way 747 Senora depends on the DBI and DBD::Oracle packages. Perl's `cpan` tool is a fairly convenient way
747 to install them:: 748 to install them::
748 749
749 $ cpan 750 $ cpan
750 751
751 cpan> install DBI 752 cpan> install DBI Term::ReadLine::Perl
752 cpan> force install DBD::Oracle 753 cpan> force install DBD::Oracle
753 754
754 If this is your first time running `cpan`, it will ask you many configuration questions 755 If this is your first time running `cpan`, it will ask you many configuration questions
755 on startup. Accepting the default answers is generally correct. 756 on startup. Accepting the default answers is generally correct.
756 Running under `sudo`, `cpan` may not find your $ORACLE_HOME; running as `root` avoids this problem. 757 Running under `sudo`, `cpan` may not find your $ORACLE_HOME; running as `root` avoids this problem.
769 Like senora, YASQL depends on the DBI and DBD::Oracle packages. Several other Perl packages 770 Like senora, YASQL depends on the DBI and DBD::Oracle packages. Several other Perl packages
770 are recommended and can also be installed through `cpan`:: 771 are recommended and can also be installed through `cpan`::
771 772
772 cpan> install DBI 773 cpan> install DBI
773 cpan> force install DBD::Oracle 774 cpan> force install DBD::Oracle
774 cpan> install Term::ReadKey Text::CSV_XS Time::HiRes 775 cpan> install Term::ReadKey Text::CSV_XS Time::HiRes Term::ReadLine::Perl
775 776
776 Download yasql-1.83.tar.gz from http://sourceforge.net/projects/yasql/, unzip and untar it, and 777 Download yasql-1.83.tar.gz from http://sourceforge.net/projects/yasql/, unzip and untar it, and
777 cd into yasql-1.83. Run `./configure`, `make`, and (as root) `make install`. 778 cd into yasql-1.83. Run `./configure`, `make`, and (as root) `make install`.
778 This will place the yasql executable into /usr/local/bin, so that you can run it from anywhere 779 This will place the yasql executable into /usr/local/bin, so that you can run it from anywhere
779 by simply typing `yasql`. 780 by simply typing `yasql`.
797 unzip the code so that you can modify it. 798 unzip the code so that you can modify it.
798 799
799 To generate graphs using sqlpython's `\\b`, `\\g`, and `\\l` terminators, you will need to install `pylab`:: 800 To generate graphs using sqlpython's `\\b`, `\\g`, and `\\l` terminators, you will need to install `pylab`::
800 801
801 $ easy_install pylab 802 $ easy_install pylab
803
804 Alternately, a Windows installer is available at http://pypi.python.org/pypi/sqlpython, though easy_install
805 works on Windows as well.
802 806
803 =================== 807 ===================
804 Extending the tools 808 Extending the tools
805 =================== 809 ===================
806 810