What is it?
-----------
dbext.vim : Provides database access to most databases.
http://www.vim.org/scripts/script.php?script_id=356
This plugin contains functions/mappings/commands to enable Vim to access
several databases. Currently Mysql, PostgreSQL, Ingres, Oracle, Sybase
Adaptive Server Anywhere, Sybase Adaptive Server Enterprise, Microsoft SQL
Server, DB2 and Interbase are supported. It abstracts database access, so
the same Vim commands will produce the same output regardless of the
database you are connected to.
What is new in 3.00?
--------------------
The new autoload/sqlcomplete.vim plugin which shipped with Vim 7.0 utiliizes
the features of the dbext.vim 3.0 plugin to provide dynamic table /
procedure / view / column completion while editing SQL code. To take
advantage of the new 7.0 omni completion to it's fullest you need this
update to the dbext.vim plugin.
New Features
------------
- dbext supports a history of previous commands. The DBHistory command will
display a numbered list of previous SQL statements. Pressing <enter> or
double clicking on one of the items will execute the statement. The number
of items in the list is configurable via your vimrc. The history items are
stored in a file, dbext_sql_history.txt. The location of the file can also
be controlled.
- The 'refresh' feature added in version 2.30 has been updated to take
advantage of the history feature.
- The PHP parser has improved and can handle single or double quoted
strings, string concatenation and host variables. It will correctly strip
the quotes, join the concatenated strings and prompt the user for host
variables before executing the SQL statement.
- Updated documentation for Vim 7 SQL code completion.
- Table, procedure and view dictionaries include the owner name of the
object. This is on by default, but can be controlled via a new global
option, dbext_default_dict_show_owner. This has not been enabled for all
databases it depends on whether the database supports this feature. The
autoload\sqlcomplete.vim plugin takes advantage of this feature.
- Added support for stored procedures / functions in MySQL 5.
Bug Fixes
------------
- Updated the PHP parser to work with a more varied string quotes and string
concatenation.
- The "extra" feature did not add a leading space for MySQL. Using the
tabbed output required updates to the parsing of the output generated by
MySQL.
- Miscellaneous documentation updates.
As usual, I would like any and all feedback from those who try it. Don't be
shy!
Both plugins provide help and tutorials to help you learn how to take
advantage these plugins.
After installing the plugins you can use:
:h dbext.txt
:h dbext-tutorial.txt
:h sql.txt
:h sql-completion-tutorial
David Fishburn
