Re: Arduino SQL Connector

From: Jan Wieck <jan(at)wi3ck(dot)info>
To: Bruce Momjian <bruce(at)momjian(dot)us>, David Rysdam <drysdam(at)ll(dot)mit(dot)edu>
Cc: Steve Spence <greentrust(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Arduino SQL Connector
Date: 2014-04-17 15:10:31
Message-ID: 534FEEE7.5050600@wi3ck.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 04/17/14 10:49, Bruce Momjian wrote:
> On Thu, Apr 17, 2014 at 10:44:36AM -0400, David Rysdam wrote:
>> Bruce Momjian <bruce(at)momjian(dot)us> writes:
>> > On Thu, Apr 17, 2014 at 09:39:55AM -0400, Steve Spence wrote:
>> >> So, who wants to work on this with me? I'm a fair arduino programmer,
>> >> but know nothing about postgres.
>> >
>> > I would look at the MySQL one as a first step to see how that was done.
>> > You are basically going to need to duplicate libpq, which is a major
>> > undertaking.
>>
>> Maybe I'm being naive, but isn't libpq already being compiled for ARM by
>> Debian? As long as it fits, you should be good. If it doesn't, you'll
>> need to strip some stuff out.
>
> Oh, can you run Debian ARM code on Arduino? If so, Postgres's libpq
> could be used directly, though it is probably too big, as you mentioned.
> The MySQL driver is C++, which surprised me.

No, to do that you'd need something like a Beaglebone, which is ARM
Cortex A8 based and runs Linux anyway.

http://www.ti.com/tool/beaglebk?DCMP=PPC_Google_TI&k_clickid=63c22498-5f5d-3789-4b41-00000dabd35d

I don't think porting the whole libpq over to an Arduino would be a good
move. For practical purposes a small subset of functionality through
some gateway service would probably be a better approach.

Note that I am not an Arduino user/developer. I'm more familiar with the
Microchip PICs.

73 de WI3CK

--
Jan Wieck
Senior Software Engineer
http://slony.info

In response to

Browse pgsql-general by date

  From Date Subject
Next Message yhe 2014-04-17 15:12:27 Re: hot standby data folder bigger than primary
Previous Message David Rysdam 2014-04-17 15:10:29 Re: Arduino SQL Connector