From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.org!not-for-mail From: Hadron Quark Newsgroups: gmane.emacs.help Subject: Re: Building a database interface in Emacs Date: Thu, 21 Dec 2006 17:42:21 +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 1166722845 27586 80.91.229.10 (21 Dec 2006 17:40:45 GMT) X-Complaints-To: usenet@sea.gmane.org NNTP-Posting-Date: Thu, 21 Dec 2006 17:40:45 +0000 (UTC) Original-X-From: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Thu Dec 21 18:40:42 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 1GxRuK-0004JY-PO for geh-help-gnu-emacs@m.gmane.org; Thu, 21 Dec 2006 18:40:41 +0100 Original-Received: from localhost ([127.0.0.1] helo=lists.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1GxRuK-0000C9-9n for geh-help-gnu-emacs@m.gmane.org; Thu, 21 Dec 2006 12:40:40 -0500 Original-Path: shelby.stanford.edu!newsfeed.stanford.edu!postnews.google.com!news4.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail Original-Newsgroups: gnu.emacs.help Original-Lines: 41 Original-X-Trace: individual.net 1iYuGKd/jU7ghGAdubuQOAbjoQbaa/gfUCuBg9xAZiE9v62BEg X-Orig-Path: news.individual.net!news X-Face: 2h#||Cd#d%F*NCm59[_6/{1a@jy%; |j>{D~4^gKg(^i%7j0IK?+,/GmW&:CD5fEKb_! User-Agent: Gnus Cancel-Lock: sha1:xH2a1HSpANAgisRP1gj/VzsVTBc= Original-Xref: shelby.stanford.edu gnu.emacs.help:144209 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:39814 Archived-At: Mathias Dahl writes: > 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... :) Create a simple customer loyalty interface : have a product table, a customer table and a purchase history table and log the purchases over a session and over a period. If you get anywhere with it, I would be interested in collaberating. I was kind of thinking of doing something similar to provide a simple text interface on a small monitor for a friends shop. --