From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.org!not-for-mail From: Michael Mauger Newsgroups: gmane.emacs.devel Subject: Re: [patch] SQL enhancements Date: Fri, 16 Apr 2010 16:06:32 -0700 (PDT) Message-ID: <467448.14252.qm@web62501.mail.re1.yahoo.com> References: <313753.60852.qm@web62504.mail.re1.yahoo.com> <87sk6v2kpu.fsf@mail.jurta.org> NNTP-Posting-Host: lo.gmane.org Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Trace: dough.gmane.org 1271459210 25082 80.91.229.12 (16 Apr 2010 23:06:50 GMT) X-Complaints-To: usenet@dough.gmane.org NNTP-Posting-Date: Fri, 16 Apr 2010 23:06:50 +0000 (UTC) Cc: Emacs Devel To: Juri Linkov Original-X-From: emacs-devel-bounces+ged-emacs-devel=m.gmane.org@gnu.org Sat Apr 17 01:06:49 2010 connect(): No such file or directory Return-path: Envelope-to: ged-emacs-devel@m.gmane.org Original-Received: from lists.gnu.org ([199.232.76.165]) by lo.gmane.org with esmtp (Exim 4.69) (envelope-from ) id 1O2ucZ-0004Xn-BP for ged-emacs-devel@m.gmane.org; Sat, 17 Apr 2010 01:06:47 +0200 Original-Received: from localhost ([127.0.0.1]:41279 helo=lists.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1O2ucY-0008LI-Pp for ged-emacs-devel@m.gmane.org; Fri, 16 Apr 2010 19:06:46 -0400 Original-Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1O2ucT-0008Kh-5r for emacs-devel@gnu.org; Fri, 16 Apr 2010 19:06:41 -0400 Original-Received: from [140.186.70.92] (port=46433 helo=eggs.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1O2ucR-0008Jx-Ut for emacs-devel@gnu.org; Fri, 16 Apr 2010 19:06:40 -0400 Original-Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.69) (envelope-from ) id 1O2ucL-0005wv-6c for emacs-devel@gnu.org; Fri, 16 Apr 2010 19:06:39 -0400 Original-Received: from web62501.mail.re1.yahoo.com ([69.147.75.93]:42502) by eggs.gnu.org with smtp (Exim 4.69) (envelope-from ) id 1O2ucL-0005wf-2A for emacs-devel@gnu.org; Fri, 16 Apr 2010 19:06:33 -0400 Original-Received: (qmail 14704 invoked by uid 60001); 16 Apr 2010 23:06:32 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1271459192; bh=xJ6s/tMssrmeeq2uDmR9/jwxt0pdPG1GbKQaqekiQZw=; h=Message-ID:X-YMail-OSG:Received:X-Mailer:References:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type; b=J9kenamV0DloDMY7KD70NCQV8YZo/uLa1do87nWiYjUUBeUT/G5J7TGv8IOhXbAd55lUdT6reJ5WBN05brquKixS9yJ9D5iQPj5aufR9Q5xQ8ki3xPEP7ekat73GCTvIR2gsBIWVO93FvJquSjdji52842zAwiY6P0SidK29roM= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:X-YMail-OSG:Received:X-Mailer:References:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type; b=prHoBb3+xCIJa25VzxPVVnKS3Uu3Ow4AdTh1s0bU0F/OXV/7/mvdCQafP+76VixGt15lVh7/hxbPk7I4DS8I1so8269ih8ndzueF6mhARAmfbSHFum8OCiEEYIt419GncgBDMJT1AXyiXG5MECsaDli3ALwCSMGBLa2ZzelPiAo=; X-YMail-OSG: Mzc3h3UVM1mOFVICeIO60p.CWE4SRW9i2n.RxMy9bWk9tWm 6qvsOa.9OCKC7tF4Z6L9GYRsMOC9SRBoAzY..KFhfOW2RZbX3MMIsu8jhZgM CVoT1ZrMDJoYoQgwfgw.2d6k9Vsu9v5xzOsA_JaY_hPwW9tdgzygAIag3oHl O_15QIRIfgfI9sA61eGRnton.UknXPij7as7XHh9G.2f4dcThivNw181WYvx AGrRjC5E12b5al1D3YNdQVqA0YQ7UCdswUfXLK4GS3961xC4EOjP8rtRsWKO Kvu_Ag0h6aW716sPklhP8KqZtKA-- Original-Received: from [98.216.52.54] by web62501.mail.re1.yahoo.com via HTTP; Fri, 16 Apr 2010 16:06:32 PDT X-Mailer: YahooMailRC/348.5 YahooMailWebService/0.8.100.260964 In-Reply-To: <87sk6v2kpu.fsf@mail.jurta.org> X-detected-operating-system: by eggs.gnu.org: FreeBSD 6.x (1) X-BeenThere: emacs-devel@gnu.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: "Emacs development discussions." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Original-Sender: emacs-devel-bounces+ged-emacs-devel=m.gmane.org@gnu.org Errors-To: emacs-devel-bounces+ged-emacs-devel=m.gmane.org@gnu.org Xref: news.gmane.org gmane.emacs.devel:123786 Archived-At: > > Since my employer has decided that they no longer need my services, > > I've got time to dedicate to Emacs! > > I haven't looked at your patch yet, but could you answer > if you fixed annoyances that I noticed in the current SQL mode: > > 1. `sql-product' is not marked as a safe local variable. I have added (put 'sql-product 'safe-local-variable 'symbolp) in this patch (sql-user, sql-database, and sql-server have been marked safe as well) > 2. I see no way to start SQL interactive mode without entering > its login parameters (user, password, database, server) in the > minibuffer. > > I'd like to create a command that let-binds parameters: > > (let ((sql-database "database.sqlite")) > (sql-sqlite)) > > but it still asks for the database name (with the correct default value). > I mean it's right to ask this by default, but there should be a way > to skip confirmation of already defined parameters. With this patch you can do the following: (let ((sql-database "database.sqlite") (sql-sqlite-login-params nil)) (sql-sqlite)) to set the parameters and avoid the prompting. You can set `sql-sqlite-login-params' to a list of the parameters you want to be prompted for; the default for sqlite is '(user password server database). or (sql-set-product-feature 'sqlite :sqli-login nil) ; Permanently disable prompting (let ((sql-database "database.sqlite")) (sql-sqlite)) [There's actually a bug in my patch in this second case that I have since corrected.] > 3. And this is not directly related to SQL mode but important: > A colleague of mine has switched from Emacs to other editors > because in SQL mode Emacs doesn't have horizontal scroll bars! > > Unlike other modes, SQL mode produces the wide output where > it's necessary to easily scroll tabular data horizontally. I've encountered the same issue but found that C-x > (scroll-right) and C-x < (scroll-left) provide a useful way to pan left and right without having to reach for the mouse. But, point taken.