Re: Arduino SQL Connector

Robin <robinstc@xxxxxxxxxx> · Fri, 18 Apr 2014 16:19:38 +0100



    Bottom posted

      
      On 18/04/2014 15: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.
        

          Steve Spence, KK4HFJ

            Director, Green Trust

            http://www.green-trust.org
            Http://arduinotronics.blogspot.com
          
        
        On Fri, Apr 18, 2014 at 10:04 AM, Robin
          <robinstc@xxxxxxxxxx>
          wrote:

          
              I have bottom posted

                
                On 18/04/2014 14:20, Steve Spence wrote:

              
                And that is the way I used to do it,
                  before the Arduino MySQL connector came out. It was
                  nice not to have to go though the double stepping any
                  more. Hence my interest in a Arduino PostgreSQL
                  Connector. 
                   

                  Here is how it works today. slim and clean - http://www.green-trust.org/lmanco/find.php
                
                
                     Steve Spence, KK4HFJ

                      Director, Green Trust

                      http://www.green-trust.org
                      Http://arduinotronics.blogspot.com
                    
                  
                  On Fri, Apr 18, 2014 at 8:15
                    AM, David Rysdam <drysdam@xxxxxxxxxx>
                    wrote:

                    
                      Steve Spence <greentrust@xxxxxxxxx>
                      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

                      > works with 1000 or more remote sensors all
                      over the world to a hosted

                      > database server, I'd love to look at it.
                      Right now what I have works,

                      > but I have no GIS functionality.

                      
                      I'm not going to claim this is a great design, but
                      it's at least an

                      order of magnitude easier than your proposal:

                      
                      Set up the simplest web server that will run PHP.
                      Program the Arduinos

                      to submit POST requests to it (which is just
                      networking you say you can

                      already handle), by which they submit their SQL
                      strings. Write a PHP

                      script that passes those to PostgreSQL.

                      
                      The webserver should be able to handle at least as
                      much as what you were

                      going to throw at the DB server, so there's no
                      load problem.

                    
              Here is a workable solution to using Arduino with
              PostgreSQL -
              http://wildraspy.blogspot.co.uk/2014/01/the-pi-as-postgresql-database-server.html

              
              If you are controlling lots of devices around the world,
              you should probably be clustering anyway.

              
              Robin St.Clair

            
    Whoops - I wasn't aware that I had to explain the relationship
    between Arduino and the Raspberry Pi - its pretty well exploited.

    
    R+C