Re: How do I get started? - Mailing list pgsql-interfaces

From John DeSoi
Subject Re: How do I get started?
Date
Msg-id BC83CE75-EB4C-4C94-8F1A-6260D26A4ECB@pgedit.com
Whole thread Raw
In response to How do I get started?  (Mike Dorin <bsddorin@yahoo.com>)
Responses Re: How do I get started?  (Dave Cramer <pg@fastcrypt.com>)
List pgsql-interfaces
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



pgsql-interfaces by date:

Previous
From: Mike Dorin
Date:
Subject: How do I get started?
Next
From:
Date:
Subject: SPI_getvalue gives a core dump