Re: [GENERAL] Arduino SQL Connector

2014-04-28 Thread vincent elschot
On 18-04-14 06:21, John R Pierce wrote: On 4/17/2014 9:09 PM, Steve Spence wrote: You know what? Fine, it doesn't matter that much to me. I'm happy to continue using MySQL. It works with the Arduino quite nicely. Postgres doesn't work. That's Postgres loss not mine. I really thought the postgre

Re: [GENERAL] Arduino SQL Connector

2014-04-18 Thread Tomas Vondra
On 18 Duben 2014, 17:01, Adrian Klaver wrote: > On 04/18/2014 07:53 AM, Jan Wieck wrote: >> On 04/18/14 10:31, Steve Spence wrote: >>> Not a thing in that document about the Arduino. Just how to install >>> Postgres on a Raspberry Pi. My Postgres is on a hosted server at a ISP. >> >> You intend to

Re: [GENERAL] Arduino SQL Connector

2014-04-18 Thread Tomas Vondra
On 18 Duben 2014, 18:11, Edson Richter wrote: > Is Arduino capable of running Java apps? > If so, you can use the excellent high quality PgSQL JDBC driver. > Java interfacing with native libraries is not difficult, JNI are pretty > well know and documented (and long lived already). > > Just my 2c (

Re: [GENERAL] Arduino SQL Connector

2014-04-18 Thread Adrian Klaver
On 04/18/2014 07:53 AM, Jan Wieck wrote: On 04/18/14 10:31, Steve Spence wrote: Not a thing in that document about the Arduino. Just how to install Postgres on a Raspberry Pi. My Postgres is on a hosted server at a ISP. You intend to have thousands of Arduino devices, incapable of doing any so

Re: [GENERAL] Arduino SQL Connector

2014-04-18 Thread Jan Wieck
On 04/18/14 10:31, Steve Spence wrote: Not a thing in that document about the Arduino. Just how to install Postgres on a Raspberry Pi. My Postgres is on a hosted server at a ISP. You intend to have thousands of Arduino devices, incapable of doing any sort of encryption or other means of secure

Re: [GENERAL] Arduino SQL Connector

2014-04-18 Thread David Rysdam
Steve Spence writes: > It's actually quite freeing, not complicating. I can put the values > right into the fields I need them to be in (or get values from the > database I need to control the Arduino), without going through a > intermediate process. If you have a serial process I can look at that

Re: [GENERAL] Arduino SQL Connector

2014-04-18 Thread David Rysdam
Steve Spence writes: > The Arduino is very good at compiling includes written in C/C++. just > need a .h and .ccp file with the correct syntax, but very compact. It > used to be part of the fun making programs fit in 4-16k back in the > day. And what happened when you tried the suggestions you go

Re: [GENERAL] Arduino SQL Connector

2014-04-18 Thread David Rysdam
Steve Spence writes: > Need a Team lead on this, and I'll collaborate as much as I can on the > Arduino / Networking side. I don't understand why there is so much blowback to the idea that you can just use the existing code. Why exactly wouldn't it work? It compiles on that architecture already.

Re: [GENERAL] Arduino SQL Connector

2014-04-18 Thread Tomas Vondra
Steve, please stop top-posting, especially if others bottom-post. It turns the messages a hard to follow mess. I took the liberty to reshuffle the parts a bit. On 18 Duben 2014, 6:09, Steve Spence wrote: > > On Fri, Apr 18, 2014 at 12:02 AM, Jan Wieck wrote: >> On 04/17/14 20:01, Steve Spence wro

Re: [GENERAL] Arduino SQL Connector

2014-04-17 Thread Gavin Flower
On 18/04/14 16:27, Steve Spence wrote: On 4/18/2014 12:21 AM, John R Pierce wrote: personal opinion: I don't think a terminal device like a PC or an embedded system should be talking directly to SQL at all. instead, they should be talking to an application server which implements the "busi

Re: [GENERAL] Arduino SQL Connector

2014-04-17 Thread Jan Wieck
On 04/18/14 00:27, Steve Spence wrote: On 4/18/2014 12:21 AM, John R Pierce wrote: personal opinion: I don't think a terminal device like a PC or an embedded system should be talking directly to SQL at all. instead, they should be talking to an application server which implements the "busine

Re: [GENERAL] Arduino SQL Connector

2014-04-17 Thread John R Pierce
On 4/17/2014 9:09 PM, Steve Spence wrote: You know what? Fine, it doesn't matter that much to me. I'm happy to continue using MySQL. It works with the Arduino quite nicely. Postgres doesn't work. That's Postgres loss not mine. I really thought the postgres team would be interested in providing su

Re: [GENERAL] Arduino SQL Connector

2014-04-17 Thread Adrian Klaver
On 04/17/2014 03:04 PM, Tomas Vondra wrote: On 17.4.2014 16:51, Adrian Klaver wrote: On 04/17/2014 07:44 AM, David Rysdam wrote: Bruce Momjian 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

Re: [GENERAL] Arduino SQL Connector

2014-04-17 Thread Tomas Vondra
On 17.4.2014 19:43, Steve Spence wrote: > Oracle thought it was a good idea to put out a MySQL version, I > figure there should be some effort to counter that here . Really? I found no information about this on oracle.com or mysql.com, except for a section in the discussion forum with ~20 post

Re: [GENERAL] Arduino SQL Connector

2014-04-17 Thread Tomas Vondra
On 17.4.2014 16:51, Adrian Klaver wrote: > On 04/17/2014 07:44 AM, David Rysdam wrote: >> Bruce Momjian 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. >>> >>>

Re: [GENERAL] Arduino SQL Connector

2014-04-17 Thread Andy Colson
On 4/17/2014 9:44 AM, David Rysdam wrote: Bruce Momjian 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 w

Re: [GENERAL] Arduino SQL Connector

2014-04-17 Thread John R Pierce
On 4/17/2014 7:46 AM, Steve Spence wrote: Not using arm or debian. Using a atmel 328p. which is an AVR processor architecture. 16 bit, limited memory space. you should be able to compile libpq as a static linkable library if you have an AVR compiler, its pure C. I would leave out SSL supp

Re: [GENERAL] Arduino SQL Connector

2014-04-17 Thread David Rysdam
Steve Spence writes: > no, you can't run arm / debian on an arduino UNO. it's all c++ > compiled to machine code then uploaded. This is how all executables work. smime.p7s Description: S/MIME cryptographic signature

Re: [GENERAL] Arduino SQL Connector

2014-04-17 Thread Jan Wieck
On 04/17/14 10:49, Bruce Momjian wrote: On Thu, Apr 17, 2014 at 10:44:36AM -0400, David Rysdam wrote: Bruce Momjian 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

Re: [GENERAL] Arduino SQL Connector

2014-04-17 Thread David Rysdam
Bruce Momjian writes: > On Thu, Apr 17, 2014 at 10:44:36AM -0400, David Rysdam wrote: >> 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

Re: [GENERAL] Arduino SQL Connector

2014-04-17 Thread Adrian Klaver
On 04/17/2014 07:44 AM, David Rysdam wrote: Bruce Momjian 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

Re: [GENERAL] Arduino SQL Connector

2014-04-17 Thread Bruce Momjian
On Thu, Apr 17, 2014 at 10:44:36AM -0400, David Rysdam wrote: > Bruce Momjian 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

Re: [GENERAL] Arduino SQL Connector

2014-04-17 Thread David Rysdam
Bruce Momjian 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 t

Re: [GENERAL] Arduino SQL Connector

2014-04-17 Thread Bruce Momjian
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