ANN: dbext.vim version 22.00 - Database access from within Vim

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, RDB,  SAP HANA and Interbase are supported.

If you have a Perl enabled Vim, it also allows database connections via

DBI and ODBC.

It abstracts database access, so the same Vim commands will produce

the same output regardless of the database you use.

Extensive help file with full tutorials.

New Features

------------

- Overhauled the prompting for SQL statement variable substitution (i.e. host variables, named parameters, question marks, ...).  The actions and user interface are hopefully more clear, useful and efficient.  For a full updated tutorial on how it works see :h dbext-tutorial-variables

- Saved variables can now hold multiple values for the same parameter, see :h dbext-tutorial-variables for how it works.

- Added C++ language support for variables (pull #12) (Anatolii Sakhnik).

- Added the ability to specify special characters (i.e. "\t") for column delimiters when using ODBC or DBI database types (Michael Krnac).

- Added new option, "passwd_use_secret", which is used when entering a password, if the value should be masked.  When using a GUI version of Vim, the prompt is not displayed in a dialog unlike the other parameters.  This option is OFF (0) by default. (pull #13) (petteja)

- Added new option, "strip_into", which is used when executing statements which have variable assignments using the INTO clause.  To test these queries, you need to remove the INTO clause so that when they execute the query you can see the result set returned.  This was on for all databases, but for TransactSQL or TSQL databases like SQLSRV and ASE, stripping the INTO clause may be the wrong action.  Now it can be controlled using this setting.  This can also be set / overridden using DBSetOption strip_into=1 or as part of a dbext profile.

- Added new option, "strip_at_variables", which is executing statements which have variable assignments in the SELECT list instead of the INTO clause.  To test these queries, you need to remove the assignments when they execute to see the result set returned.  This was on for all databases, but for TransactSQL or TSQL databases like SQLSRV and ASE, stripping the variable assignments in the SELECT list is required. This can be controlled via this setting.  This can also be set / overridden using DBSetOption strip_at_variables=1 or as part of a dbext profile.

                                                                                 

Bug Fixes

---------

- Minor correction to DBSetVar example (Cedric Simon).

- When deleting a buffer, all syntax highlighting of your existing buffer is sometimes lost, which was a problem with one of the

  dbext autocmds (Anatolii Sakhnik).

- Update Postgres get column list join conditions (pull #9) (Dickson S. Guedes).

- dbext autocmd for checking for modelines messed up the jumplist (Justin M. Keyes)

I am always open to suggestions, just email me.  See :h dbext.txt for contact details.

David

--
--
You received this message from the "vim_use" maillist.
Do not top-post! Type your reply below the text you are replying to.
For more information, visit http://www.vim.org/maillist.php

---
You received this message because you are subscribed to the Google Groups "vim_use" group.
To unsubscribe from this group and stop receiving emails from it, send an email to vim_use+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.