Arduino SQL Connector
I'm using a MySQL library on my arduino that allows me to directly
connect to a MySQL database and perform SQL queries on the Arduino.
I need something similar for Postgres. Anyone have the knowledge and
interest to work with me?
Here is a sample of what I'm doing currently, and the results:
http://arduinotronics.blogspot.com/2014/04/arduino-based-sql-queries.html
http://green-trust.org/lmanco/find.php
Steve Spence, KK4HFJ
Director, Green Trust
http://www.green-trust.org
Http://arduinotronics.blogspot.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Thu, Apr 17, 2014 at 08:00:50AM -0400, Steve Spence wrote:
I'm using a MySQL library on my arduino that allows me to directly
connect to a MySQL database and perform SQL queries on the Arduino.I need something similar for Postgres. Anyone have the knowledge and
interest to work with me?Here is a sample of what I'm doing currently, and the results:
http://arduinotronics.blogspot.com/2014/04/arduino-based-sql-queries.html
I have never heard of anyone writing a Postgres client connector for
Arduino, but it would certainly be possible to write if MySQL can have
one.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ Everyone has their own god. +
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
So, who wants to work on this with me? I'm a fair arduino programmer,
but know nothing about postgres.
Steve Spence, KK4HFJ
Director, Green Trust
http://www.green-trust.org
Http://arduinotronics.blogspot.com
On Thu, Apr 17, 2014 at 9:37 AM, Bruce Momjian <bruce@momjian.us> wrote:
On Thu, Apr 17, 2014 at 08:00:50AM -0400, Steve Spence wrote:
I'm using a MySQL library on my arduino that allows me to directly
connect to a MySQL database and perform SQL queries on the Arduino.I need something similar for Postgres. Anyone have the knowledge and
interest to work with me?Here is a sample of what I'm doing currently, and the results:
http://arduinotronics.blogspot.com/2014/04/arduino-based-sql-queries.html
I have never heard of anyone writing a Postgres client connector for
Arduino, but it would certainly be possible to write if MySQL can have
one.--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com+ Everyone has their own god. +
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
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. There are some interfaces written in non-C languages like
Ruby and Java.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ Everyone has their own god. +
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Here is the home for the mysql connector -
http://drcharlesbell.blogspot.com/2013/04/introducing-mysql-connectorarduino_6.html
Steve Spence, KK4HFJ
Director, Green Trust
http://www.green-trust.org
Http://arduinotronics.blogspot.com
On Thu, Apr 17, 2014 at 10:37 AM, Bruce Momjian <bruce@momjian.us> wrote:
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. There are some interfaces written in non-C languages like
Ruby and Java.--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com+ Everyone has their own god. +
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Not using arm or debian. Using a atmel 328p.
Steve Spence, KK4HFJ
Director, Green Trust
http://www.green-trust.org
Http://arduinotronics.blogspot.com
On Thu, Apr 17, 2014 at 10:44 AM, David Rysdam <drysdam@ll.mit.edu> 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.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
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.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ Everyone has their own god. +
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 04/17/2014 07:44 AM, 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.
If you get the MySQL connector from here:
https://launchpad.net/mysql-arduino/+milestone/release-1.0.2-beta
you will see they are doing the equivalent, using the MySQL libmysqlclient:
http://dev.mysql.com/downloads/connector/c/
--
Adrian Klaver
adrian.klaver@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
no, you can't run arm / debian on an arduino UNO. it's all c++
compiled to machine code then uploaded.
Steve Spence, KK4HFJ
Director, Green Trust
http://www.green-trust.org
Http://arduinotronics.blogspot.com
On Thu, Apr 17, 2014 at 10:49 AM, Bruce Momjian <bruce@momjian.us> 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.--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com+ Everyone has their own god. +
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Bruce Momjian <bruce@momjian.us> 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 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.
Well, I don't know about just picking it up and moving it over. But back
in the day I wrote a C library which I cross-compiled for ARM on my
Intel Linux box and used with my Arduino. At least, I think that's what
I did. This was 6 years ago.
The fact that it (presumably) compiles on Debian under ARM should mean
it would Just Cross-Compile for Arduino. Whether it would fit is another
question.
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.
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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
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 support if you
can, as openssl is a mess.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 4/17/2014 9:44 AM, 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.
Yeah, agreed, no need to rewrite it. Just cross compile it. Even if
you cant use the Debian build, you are already cross compiling stuff,
right?
-Andy
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Oracle thought it was a good idea to put out a MySQL version, I figure
there should be some effort to counter that here .....
Need a Team lead on this, and I'll collaborate as much as I can on the
Arduino / Networking side.
Steve Spence, KK4HFJ
Director, Green Trust
http://www.green-trust.org
Http://arduinotronics.blogspot.com
On Thu, Apr 17, 2014 at 1:37 PM, Andy Colson <andy@squeakycode.net> wrote:
On 4/17/2014 9:44 AM, 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.Yeah, agreed, no need to rewrite it. Just cross compile it. Even if you
cant use the Debian build, you are already cross compiling stuff, right?-Andy
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 17.4.2014 16:51, Adrian Klaver wrote:
On 04/17/2014 07:44 AM, 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.If you get the MySQL connector from here:
https://launchpad.net/mysql-arduino/+milestone/release-1.0.2-beta
you will see they are doing the equivalent, using the MySQL libmysqlclient:
Really? I see no reference to libmysqlclient there. It seems they're
simply reimplementing only a (small) subset of the library.
Tomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
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 posts. It's true
that the author is apparently a Senior Software Engineer at Oracle, but
this seems like a his own project. So much regarding the "Oracle
thought" part ...
BTW I doubt the approach "Oracle does X => you should do X too" will be
fruitful here.
Need a Team lead on this, and I'll collaborate as much as I can on the
Arduino / Networking side.
I'm a bit confused. What do you mean by "team lead"? I was thinking that
maybe this would be a fun project for the holidays, refreshing my
Arduino-fu. But no way I'm interested in being a TL of anything.
I was messing with the PostgreSQL protocol [1]http://www.postgresql.org/docs/9.3/interactive/protocol.html recently, and writing a
code implementing something like what the mysql connector does would be
quite trivial. A day of work, maybe two if you know networking but not
the protocol.
regards
Tomas
[1]: http://www.postgresql.org/docs/9.3/interactive/protocol.html
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
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 <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.If you get the MySQL connector from here:
https://launchpad.net/mysql-arduino/+milestone/release-1.0.2-beta
you will see they are doing the equivalent, using the MySQL libmysqlclient:
Really? I see no reference to libmysqlclient there. It seems they're
simply reimplementing only a (small) subset of the library.
My mistake, was reading to fast and assumed facts not in evidence.
Tomas
--
Adrian Klaver
adrian.klaver@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I'm trying to port my application from mysql to postgres (for the GIS
supoort). I had hoped there would be wild enthsuiasm for such a
project, as the Arduino community is extremely large, and this would
push postgres into a wider audience. I expected it would take multiple
people with varying backgrounds to accomplish the task. If you can do
it on your own, great. I'll be happy to lend what knowledge I have of
the Arduino and using the mysql connector -
http://www.green-trust.org/lmanco/find.php
Steve Spence, KK4HFJ
Director, Green Trust
http://www.green-trust.org
Http://arduinotronics.blogspot.com
On Thu, Apr 17, 2014 at 6:21 PM, Tomas Vondra <tv@fuzzy.cz> wrote:
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 posts. It's true
that the author is apparently a Senior Software Engineer at Oracle, but
this seems like a his own project. So much regarding the "Oracle
thought" part ...BTW I doubt the approach "Oracle does X => you should do X too" will be
fruitful here.Need a Team lead on this, and I'll collaborate as much as I can on the
Arduino / Networking side.I'm a bit confused. What do you mean by "team lead"? I was thinking that
maybe this would be a fun project for the holidays, refreshing my
Arduino-fu. But no way I'm interested in being a TL of anything.I was messing with the PostgreSQL protocol [1] recently, and writing a
code implementing something like what the mysql connector does would be
quite trivial. A day of work, maybe two if you know networking but not
the protocol.regards
Tomas[1] http://www.postgresql.org/docs/9.3/interactive/protocol.html
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
