Re: Arduino SQL Connector

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@momjian.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