From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.org!not-for-mail From: Mathias Dahl Newsgroups: gmane.emacs.help Subject: Re: Building a database interface in Emacs Date: Thu, 21 Dec 2006 10:03:01 +0100 Message-ID: References: NNTP-Posting-Host: dough.gmane.org Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Trace: sea.gmane.org 1166694121 17868 80.91.229.10 (21 Dec 2006 09:42:01 GMT) X-Complaints-To: usenet@sea.gmane.org NNTP-Posting-Date: Thu, 21 Dec 2006 09:42:01 +0000 (UTC) Original-X-From: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Thu Dec 21 10:41:59 2006 Return-path: Envelope-to: geh-help-gnu-emacs@m.gmane.org Original-Received: from lists.gnu.org ([199.232.76.165]) by dough.gmane.org with esmtp (Exim 4.50) id 1GxKR4-0007qn-Ug for geh-help-gnu-emacs@m.gmane.org; Thu, 21 Dec 2006 10:41:59 +0100 Original-Received: from localhost ([127.0.0.1] helo=lists.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1GxKR4-0005ZC-5J for geh-help-gnu-emacs@m.gmane.org; Thu, 21 Dec 2006 04:41:58 -0500 Original-Path: shelby.stanford.edu!newsfeed.stanford.edu!postnews.google.com!news1.google.com!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail Original-Newsgroups: gnu.emacs.help Original-Lines: 28 Original-X-Trace: individual.net EcaPnDvhs8BJDvV0ab07JgrjhqhmtF/lnF9CFG/gIFutkJv09U User-Agent: Gnus/5.11 (Gnus v5.11) Emacs/22.0.91 (windows-nt) Cancel-Lock: sha1:/vIGELuzTqQGqfChhrQpCeK9fHM= Original-Xref: shelby.stanford.edu gnu.emacs.help:144195 Original-To: help-gnu-emacs@gnu.org X-BeenThere: help-gnu-emacs@gnu.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Users list for the GNU Emacs text editor List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Original-Sender: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Errors-To: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Xref: news.gmane.org gmane.emacs.help:39799 Archived-At: jason haslup writes: >> Is there any smarter way of doing it? > > I did something using comint's filter functions, but it requires > having a *SQL* buffer open to the database you're interested in: > > http://www.haslup.com/index.cgi/emacs/2006/12/20/ Nice! There are probably some ideas worth checking up in there. > I'm not too familiar with sqlplus, but I know the mysql client has a > raw mode and also an XML mode for queries that might help in looking > for the end of a query's results. Yes, sqlplus has an option to output things as HTML. That might makes things easier to parse as well as easier to see when the output is done. > Or, if sqlplus doesn't work, I wonder if a simple helper client > using oracle's libraries would be something you could use with > start-process. Yes, using OCI would be the best I guess, but I am too lazy and do not have experience fiddling with that. My experiements are working OK, now I just have to figure out what the heck I *really* want to use it for... :)