bug#7664: sql.el: In interactive sql-<product> command, Add C-u to set connection port

bug#7664: sql.el: In interactive sql-<product> command, Add C-u to set connection port

[Jari Aalto]

Package: emacs
Version: 23.2+1-5.1
Severity: wishlist

In production environments the database servers run in multiple ports, like

    M-x sql-mysql

It would be nice to be able to specify PORT number during interactive call, like:

    C-u M-x sql-mysql
    ...
    Port: .....

Related read:

   "At Digg, we have a lot of databases (...) What we’ve settled on is one
   physical host running four different MySQL instance, one for each pool,
   each listening on a different port."

    * Better SQL buffer names
    * Support TCP ports
    * Support for preset connections

    http://atomized.org/2008/10/enhancing-emacs%E2%80%99-sql-mode/

Jari

-- System Information
Debian Release: squeeze/sid
  APT Prefers testing
  APT policy: (990, testing) (500, unstable) (1, experimental)
Architecture: amd64
Kernel: Linux picasso 2.6.32-5-amd64 #1 SMP Fri Sep 17 21:50:19 UTC 2010 x86_64 GNU/Linux
Locale: LANG=en_DK.UTF-8

-- Versions of packages `emacs depends on'.
Depends:
emacs23         23.2+1-5.1      GNU Emacs is the extensible self-documenting 
emacs23-lucid   23.2+1-5.1      GNU Emacs is the extensible self-documenting 
emacs23-nox     23.2+1-5.1      GNU Emacs is the extensible self-documenting 

bug#7664: sql.el: In interactive sql-<product> command, Add C-u to set connection port

[Chong Yidong]

Jari Aalto <jari.aalto@cante.net> writes:

> In production environments the database servers run in multiple ports,
> like
>
>     M-x sql-mysql
>
> It would be nice to be able to specify PORT number during interactive
> call, like:
>
>     C-u M-x sql-mysql
>     ...
>     Port: .....

Michael, could you take a look at this wishlist item?  Currently,
sql-mysql already uses a prefix argument to output into a new buffer.
If you decide this suggestion is worth implementing, there are a couple
of possibilities: (i) add another interactive command that prompts for a
port number, or (ii) change the interactive spec so that a prefix arg
prompts the user about whether to use a new buffer and what port to use.
I don't use sql.el, so I don't know which makes more sense.

bug#7664: sql.el: In interactive sql-<product> command, Add C-u to set connection port

[Michael Mauger]

[-- Attachment #1: Type: text/plain, Size: 1575 bytes --]

In Emacs 24, SQL.el supports the port login parameter.  

By customizing `sql-mysql-login-params'  to include the atom `port' the port 
will be prompted for during login.  If you don't specify a value, it will not be 
specified when you connect so it will use the default.   You can also set a 
default value for port by customizing `sql-port'.

   (setq sql-mysql-login-params '(user password server port database))

Both MySQL and Postgres support the use of port during login. 





________________________________
From: Chong Yidong <cyd@stupidchicken.com>
To: Michael R. Mauger <mmaug@yahoo.com>
Cc: Jari Aalto <jari.aalto@cante.net>; 7664@debbugs.gnu.org
Sent: Tue, December 21, 2010 1:59:40 AM
Subject: Re: bug#7664: sql.el: In interactive sql-<product> command, Add C-u to 
set connection port

Jari Aalto <jari.aalto@cante.net> writes:

> In production environments the database servers run in multiple ports,
> like
>
>     M-x sql-mysql
>
> It would be nice to be able to specify PORT number during interactive
> call, like:
>
>     C-u M-x sql-mysql
>     ...
>     Port: .....

Michael, could you take a look at this wishlist item?  Currently,
sql-mysql already uses a prefix argument to output into a new buffer.
If you decide this suggestion is worth implementing, there are a couple
of possibilities: (i) add another interactive command that prompts for a
port number, or (ii) change the interactive spec so that a prefix arg
prompts the user about whether to use a new buffer and what port to use.
I don't use sql.el, so I don't know which makes more sense.

[-- Attachment #2: Type: text/html, Size: 2497 bytes --]