NAME
db-browser - Search and read in SQLite/MySQL/PostgreSQL databases.
VERSION
Version 0.001
SYNOPSIS
SQLite/MySQL/PostgreSQL:
db-browser
db-browser -h|--help
-h|--help show the config menu (which offers also this help text).SQLite:
db-browser [-s|--search] [directories to be searched]
If no directories are passed the home directory is searched for SQLite databases.
-s|--search new search of SQLite databases (don't use cached data).DESCRIPTION
Search and read in SQLite/MySQL/PostgreSQL databases.
db-browser expects an "UTF-8" environment
"q" key goes back ("Ctrl-D" instead of "q" if prompted for a string).
Options
Help
Show this Info.
Tabwidth
Set the number of spaces between columns.
Colwidth
Set the width the columns should have at least when printed.
Undef
Set the string that will be shown on the screen if a table value is undefined.
Rows
Set the maximum number of fetched table rows. Can be overwritten by setting a SQL "LIMIT" statement.
ProgressBar
Set the progress bar threshold. The threshold refers to the list size (rows x columns).
DB drivers
Choose the needed database drivers.
Operators
Choose the needed operators.
Separator
Choose the thousands separator displayed in menus.
Sssc mode
With the Sssc mode "compat" enabled back-arrows are offered in the SQL "sub-statement" menus. In the "simple" mode it can be used the "q" key instead of the back-arrows.
To reset a SQL "sub-statement" (e.g WHERE) re-enter into the "sub-statement" and choose '- OK -'.
Expand
Set the behavior of different menus.
Mouse mode
Set the mouse mode (see Term::Choose option "mouse").
Lock
Set the default value: Lk0 or Lk1.
Lk0: Reset the SQL-statement after each "PrintTable".
Lk1: Reset the SQL-statement only when a table is selected.Metadata
If enabled system tables/schemas/databases are appended to the respective list.
Regexp case
If enabled REGEXP will match case sensitive.
With MySQL the sensitive match is achieved be enabling the BINARY operator.
"Binary filter"
Print "BNRY" instead of arbitrary binary data.
If the data matches the repexp /[\x00-\x08\x0B-\x0C\x0E-\x1F]/ it is considered arbitrary binary data.
Printing arbitrary binary data could break the output.
DB defaults
Set Database defaults:
different Database settings ...
Database defaults can be overwritten for each Database with the "Database settings".
DB login
Determine how often db-browser asks for the login data:
-for every connection: log in data is asked for every new database connection.
-once per DB: log in data is asked only once per database.
-only once: log in data is asked only once and then used for all connections.AUTHOR
Matthäus Kiem <cuer2s@gmail.com>
LICENSE AND COPYRIGHT
Copyright 2012-2014 Matthäus Kiem.
This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.