Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 0FAEB9FB33F for ; Sat, 7 Apr 2007 09:53:43 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 08089-09 for ; Sat, 7 Apr 2007 09:53:40 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from beaver.fastcrypt.com (beaver.fastcrypt.com [64.7.141.17]) by postgresql.org (Postfix) with ESMTP id 302619FB33C for ; Sat, 7 Apr 2007 09:53:40 -0300 (ADT) Received: from [192.168.1.14] (dcdsl.ebox.com [64.7.143.116]) by beaver.fastcrypt.com (Postfix) with ESMTP id DA61C1580615; Sat, 7 Apr 2007 08:56:49 -0400 (EDT) In-Reply-To: References: <20060725220150.35712.qmail@web32904.mail.mud.yahoo.com> Mime-Version: 1.0 (Apple Message framework v752.3) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: <0C58D5F7-DE98-4738-995F-01CB6434B1E7@fastcrypt.com> Cc: dorin@chaski.com, pgsql-interfaces@postgresql.org Content-Transfer-Encoding: 7bit From: Dave Cramer Subject: Re: How do I get started? Date: Sat, 7 Apr 2007 08:53:28 -0400 To: John DeSoi X-Mailer: Apple Mail (2.752.3) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/4 X-Sequence-Number: 6492 Mike, Candidly you would be better off writing a small http proxy service and talking to that as opposed to a full blown psql client. DAve On 25-Jul-06, at 8:52 PM, John DeSoi wrote: > > On Jul 25, 2006, at 6:01 PM, Mike Dorin wrote: > >> I would like to create a small client on a small >> embedded >> microprocessor. The device has Ethernet and can >> do TCP or UDP with a bit of finesse. >> >> I would like the client to shove events into a >> database. >> >> What should I read to get started? > > The easiest way to go is to use libpq, assuming you can compile it > for your microprocessor. > > http://www.postgresql.org/docs/8.1/interactive/libpq.html > > If not, you can communicate with PostgreSQL via the frontend/ > backend protocol with nothing more than a TCP stream: > > http://www.postgresql.org/docs/8.1/interactive/protocol.html > > This is a lot more work, but the protocol is not too hard to > implement. There are various open source versions in different > languages which might help you get started. > > > > John DeSoi, Ph.D. > http://pgedit.com/ > Power Tools for PostgreSQL > > > ---------------------------(end of > broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that > your > message can get through to the mailing list cleanly >