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

Previous Next

To add a comment to this bug, you must first unarchive it, by sending
a message to control AT debbugs.gnu.org, with unarchive 7664 in the body.
You can then email your comments to 7664 AT debbugs.gnu.org in the normal way.

Toggle the display of automated, internal messages from the tracker.

Message #5 received at submit <at> debbugs.gnu.org (full text, mbox):

From: Jari Aalto <jari.aalto <at> cante.net>
To: submit <at> debbugs.gnu.org
Subject: sql.el: In interactive sql-<product> command,
	Add C-u to set connection port
Date: Fri, 17 Dec 2010 19:37:54 +0200

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 

Message #8 received at 7664 <at> debbugs.gnu.org (full text, mbox):

From: Chong Yidong <cyd <at> stupidchicken.com>
To: "Michael R. Mauger"  <mmaug <at> yahoo.com>
Cc: 7664 <at> debbugs.gnu.org, Jari Aalto <jari.aalto <at> cante.net>
Subject: Re: bug#7664: sql.el: In interactive sql-<product> command,
	Add C-u to set connection port
Date: Tue, 21 Dec 2010 14:59:40 +0800

Jari Aalto <jari.aalto <at> 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.

Message #11 received at 7664 <at> debbugs.gnu.org (full text, mbox):

From: Michael Mauger <mmaug <at> yahoo.com>
To: Chong Yidong <cyd <at> stupidchicken.com>
Cc: 7664 <at> debbugs.gnu.org, Jari Aalto <jari.aalto <at> cante.net>
Subject: Re: bug#7664: sql.el: In interactive sql-<product> command,
	Add C-u to set connection port
Date: Tue, 21 Dec 2010 19:04:30 -0800 (PST)

[Message part 1 (text/plain, inline)]

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 <at> stupidchicken.com>
To: Michael R. Mauger <mmaug <at> yahoo.com>
Cc: Jari Aalto <jari.aalto <at> cante.net>; 7664 <at> 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 <at> 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.

[Message part 2 (text/html, inline)]

Previous Next

GNU bug tracking system
Copyright (C) 1999 Darren O. Benham, 1997,2003 nCipher Corporation Ltd, 1994-97 Ian Jackson.