unofficial mirror of bug-gnu-emacs@gnu.org 
 help / color / mirror / code / Atom feed
* bug#7664: sql.el: In interactive sql-<product> command, Add C-u to set connection port
@ 2010-12-17 17:37 Jari Aalto
  2010-12-21  6:59 ` Chong Yidong
  0 siblings, 1 reply; 3+ messages in thread
From: Jari Aalto @ 2010-12-17 17:37 UTC (permalink / raw)
  To: 7664

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 





^ permalink raw reply	[flat|nested] 3+ messages in thread

* bug#7664: sql.el: In interactive sql-<product> command, Add C-u to set connection port
  2010-12-17 17:37 bug#7664: sql.el: In interactive sql-<product> command, Add C-u to set connection port Jari Aalto
@ 2010-12-21  6:59 ` Chong Yidong
  2010-12-22  3:04   ` Michael Mauger
  0 siblings, 1 reply; 3+ messages in thread
From: Chong Yidong @ 2010-12-21  6:59 UTC (permalink / raw)
  To: Michael R. Mauger; +Cc: Jari Aalto, 7664

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.






^ permalink raw reply	[flat|nested] 3+ messages in thread

* bug#7664: sql.el: In interactive sql-<product> command, Add C-u to set connection port
  2010-12-21  6:59 ` Chong Yidong
@ 2010-12-22  3:04   ` Michael Mauger
  0 siblings, 0 replies; 3+ messages in thread
From: Michael Mauger @ 2010-12-22  3:04 UTC (permalink / raw)
  To: Chong Yidong; +Cc: Jari Aalto, 7664

[-- 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 --]

^ permalink raw reply	[flat|nested] 3+ messages in thread

end of thread, other threads:[~2010-12-22  3:04 UTC | newest]

Thread overview: 3+ messages (download: mbox.gz follow: Atom feed
-- links below jump to the message on this page --
2010-12-17 17:37 bug#7664: sql.el: In interactive sql-<product> command, Add C-u to set connection port Jari Aalto
2010-12-21  6:59 ` Chong Yidong
2010-12-22  3:04   ` Michael Mauger

Code repositories for project(s) associated with this public inbox

	https://git.savannah.gnu.org/cgit/emacs.git

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).