Thread: How do I get started?

How do I get started?

From
Mike Dorin
Date:

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?

Thanks,

-Mike

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 


Re: How do I get started?

From
John DeSoi
Date:
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



Re: How do I get started?

From
Dave Cramer
Date:
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
>