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 use.
What is new in 5.0?
- Added Perl's DBI and DBI::ODBC support. This opens additional database support without having to adjust the scripts. You must have a Perl enabled Vim (:echo has('perl')). Using the DBI layer offers some advantages over using the native binary tools:
- Transaction support which allows you to maintain a transaction during your editing session and either commit or rollback and changes. This is not possible without using the DBI layer.
- Speed improvements, since the database connection is maintained, the there is less overhead per command.
- Huge thanks to Jean-Christophe Clavier and Albie Janse van Rensburg for their beta testing and suggestions.
- New commands are available to select only a few rows instead of an entire result set. In most databases this is referred to as TOP X. DBExecSQLTopX, DBExecVisualSQLTopX, DBExecSQLUnderCursorTopX have been added plus associated mappings (Albie Janse van Rensburg).
- Made Cygwin detection a bit easier using the shellslash option (Steve Gibson)
- dbext now supports Vim 7's autoload feature.
- SQL Server support had issues with the queries when running DBCompleteTable, DBCompleteProcedure, DBCompleteView which also affected the
sqlcomplete.vim plugin included with Vim7 (Albie Janse van Rensburg).
- Oracle reported "rows will be truncated", added "set linesize 10000" to the Oracle headers (Stuart Brock)
- When prompting for connection parameters if you choose a profile of "0" which is no profile, you had to re-run the wizard to prompt for the rest of the parameters, now the wizard continues as expected.
After installing the plugin you can use:
You received this message from the "vim_use" maillist.
For more information, visit http://www.vim.org/maillist.php