Go to advanced search

by AlexKoe
Mon May 30, 2016 11:42 am
Forum: Automation, sensing and robotics
Topic: A SQL database for sensor and JSON data on Raspian
Replies: 17
Views: 12579

Re: A SQL database for sensor and JSON data on Raspian

nzDAVE wrote:Is there a version of IDS for the Raspberry Pi 3 ?
Hi nzDave,

you should currently use the ARM v6 port of IDS on the Raspberry Pi 3:

https://www-01.ibm.com/marketing/iwm/iw ... rce=ifxids

Please let me know if have any issues or further questions. ;)

- Alexander
by AlexKoe
Wed Mar 16, 2016 12:00 pm
Forum: Automation, sensing and robotics
Topic: Round robin sensor data storage with IBM Informix
Replies: 0
Views: 2567

Round robin sensor data storage with IBM Informix

Hi, this post is part 4 in a little how-to series on how to use the IBM Informix database on the Raspberry Pi to build an efficient sensor data data database for local sensor data analytics/processing/caching. The other posts can be found here: https://www.raspberrypi.org/forums/viewtopic.php?f=37&t...
by AlexKoe
Fri Feb 26, 2016 5:25 pm
Forum: Automation, sensing and robotics
Topic: How to create a sensor database with IBM Informix - Part 1
Replies: 12
Views: 5264

Re: How to create a sensor database with IBM Informix - Part

msd wrote:
It looks like this: http://i.imgur.com/3eGOXpJ.png
BTW, some time ago I also setup a backyard weather station at home (based on a Raspberry Pi 2 w/ Informix) and cooked up the following very basic UI (JavaScript based): http://i.imgur.com/HM5QnUr.png ;)

- Alexander
by AlexKoe
Fri Feb 26, 2016 10:46 am
Forum: Automation, sensing and robotics
Topic: How to create a sensor database with IBM Informix - Part 1
Replies: 12
Views: 5264

Re: How to create a sensor database with IBM Informix - Part

By aggregation I mean using a VTI to be able to select all sensor data at once and using the AggregateBy function: EXECUTE PROCEDURE TSCreateExpressionVirtualTab( 'sensor_data_1h_avg', 'sensor_ts', 'AggregateBy("avg($value)", "ts_1hour", sensor_values, 0, $ts_begin_time, $ts_end_time)', 'sensor_t',...
by AlexKoe
Wed Feb 24, 2016 8:39 pm
Forum: Automation, sensing and robotics
Topic: How to create a sensor database with IBM Informix - Part 1
Replies: 12
Views: 5264

Re: How to create a sensor database with IBM Informix - Part

Hi Alexander, thank you for your patience. Regarding adding a primary key: it does not make it faster, but it's ok, it's a RPi! At the end I wanted to get data from all sensors at once, and I used a VTI to do that aggregating data. I averaged over 1h or 1d for longer time ranges (1 week or more). I...
by AlexKoe
Wed Feb 24, 2016 6:20 pm
Forum: Automation, sensing and robotics
Topic: A SQL database for sensor and JSON data on Raspian
Replies: 17
Views: 12579

Re: A SQL database for sensor and JSON data on Raspian

Hi Marco,

just FYI: I just posted a new How-To on the Informix REST API:
viewtopic.php?f=37&t=137392&p=912405

- Alexander
by AlexKoe
Wed Feb 24, 2016 6:05 pm
Forum: Automation, sensing and robotics
Topic: How-To: The IBM Informix REST API on the Raspberry Pi
Replies: 0
Views: 2735

How-To: The IBM Informix REST API on the Raspberry Pi

Hi, I am sorry that it took some while before I could continue with my How-To series around IBM Informix and sensor data on the Raspberry Pi, but from time to time I need to work on some real and exciting sensor data projects for my employer. ;) Just in case you might have missed my other posts on h...
by AlexKoe
Wed Feb 24, 2016 11:13 am
Forum: Automation, sensing and robotics
Topic: How to create a sensor database with IBM Informix - Part 1
Replies: 12
Views: 5264

Re: How to create a sensor database with IBM Informix - Part

Hi Alexander, this works great, exactly as expected. Thank you! Is there any function to get e.g. last 24 hours of sensor data, other than just this following? SELECT ... WHERE timestamp > CURRENT - 24 UNITS HOUR; BR Marco Hi Marco, depending on your requirements, that approach would be the easiest...
by AlexKoe
Tue Feb 23, 2016 8:19 pm
Forum: Automation, sensing and robotics
Topic: How to create a sensor database with IBM Informix - Part 1
Replies: 12
Views: 5264

Re: How to create a sensor database with IBM Informix - Part

Hi Marco, although the VTI table provides you with a handy relational view of your time series data, its unfortunately not optimal for all SQL operations (like in your case the 'ORDER BY timestamp DESC LIMIT 1'). In that case its much more efficient to use one of the built-in time series SQL functio...
by AlexKoe
Tue Feb 23, 2016 9:38 am
Forum: Automation, sensing and robotics
Topic: How to create a sensor database with IBM Informix - Part 1
Replies: 12
Views: 5264

Re: How to create a sensor database with IBM Informix - Part

Hi Alexander, selecting data on a RPi1 from sensor_data table is very slow, even when reading a single value, do you know the reason why is it like that? BR Marco Hi Marco, it would be great, if you could share how your (intended) query looks like, how do you execute your query (e.g. via dbaccess o...
by AlexKoe
Mon Feb 22, 2016 9:44 am
Forum: Automation, sensing and robotics
Topic: A SQL database for sensor and JSON data on Raspian
Replies: 17
Views: 12579

Re: A SQL database for sensor and JSON data on Raspian

Hi, thanks a lot for this guide Alexander!! Could help me setting up the REST/JSON listener? BR Marco Hi Marco, interesting coincidence, I wanted to publish a how to on that topic soon. ;) In a nutshell: Make sure that you have Java installed: sudo apt-get install oracle-java8-jdk Create a new REST...
by AlexKoe
Wed Aug 19, 2015 6:50 pm
Forum: Automation, sensing and robotics
Topic: A SQL database for sensor and JSON data on Raspian
Replies: 17
Views: 12579

Re: A SQL database for sensor and JSON data on Raspian

Hallo rothariger, a very simple fix to your problem would be to replace 'localhost' in step 6 of my installation tutorial either with the IP address of the RPi in your local network or with its hostname. Before applying that change you need to shutdown Informix with an onmode -ky first and the re-st...
by AlexKoe
Sun Aug 16, 2015 9:12 pm
Forum: Automation, sensing and robotics
Topic: A SQL database for sensor and JSON data on Raspian
Replies: 17
Views: 12579

Re: A SQL database for sensor and JSON data on Raspian

Hi Ed,

please try the following link:

https://www-01.ibm.com/marketing/iwm/iw ... lang=en_US

...and choose the Informix 12.10.UC5DE ARM v6 version.

Good luck and have fun working with the product,

Alexander
by AlexKoe
Tue Aug 04, 2015 2:39 pm
Forum: Automation, sensing and robotics
Topic: How to create a sensor database with IBM Informix - Part 2
Replies: 4
Views: 4743

Re: How to create a sensor database with IBM Informix - Part

Hi Mike, you are on the right track! ;) A colleague of mine (from the Informix Lab in Munich) also just mentioned that you might have to set e.g. export LANG=en_US.UTF-8 or export LANG=en_US.8859-1 before executing the ids_install script. That should fix your install issue. I am sorry that you run i...
by AlexKoe
Mon Aug 03, 2015 4:30 pm
Forum: Automation, sensing and robotics
Topic: How to create a sensor database with IBM Informix - Part 2
Replies: 4
Views: 4743

Re: How to create a sensor database with IBM Informix - Part

Hi Mike,

I will look into it and will try to come back with an answer. ;)

Stay tuned.

- Alexander
by AlexKoe
Fri Feb 13, 2015 4:14 pm
Forum: Automation, sensing and robotics
Topic: How to create a sensor database with IBM Informix - Part 2
Replies: 4
Views: 4743

How to create a sensor database with IBM Informix - Part 2

Preface: This post is part 2 in a little how-to series on how to use the IBM Informix database on the Raspberry Pi to build an efficient sensor data data database for local sensor data analytics/processing/caching. The other posts can be found here: https://www.raspberrypi.org/forums/viewtopic.php?f...
by AlexKoe
Thu Jan 29, 2015 6:05 pm
Forum: Automation, sensing and robotics
Topic: A SQL database for sensor and JSON data on Raspian
Replies: 17
Views: 12579

Re: A SQL database for sensor and JSON data on Raspian

Hi Dougie, thanks for bringing up those very valid questions. Generally speaking every developer should choose the best tool(s) to tackle his/her development challenges. Let's start in reverse order of your questions, the development APIs. Informix is an object-relational, SQL database which follows...
by AlexKoe
Thu Jan 29, 2015 12:02 pm
Forum: Automation, sensing and robotics
Topic: A SQL database for sensor and JSON data on Raspian
Replies: 17
Views: 12579

Re: A SQL database for sensor and JSON data on Raspian

Install the 'libaio1' package for Informix under Raspian Unfortunately I forgot to mention that Informix prefers to use kernel asynchronous I/O (KAIO) for its database operations. In order to be able to utilize KAIO for Informix on Raspian, you need to install the 'libaio1' package: sudo apt-get in...
by AlexKoe
Wed Jan 28, 2015 3:35 pm
Forum: Automation, sensing and robotics
Topic: A SQL database for sensor and JSON data on Raspian
Replies: 17
Views: 12579

Re: A SQL database for sensor and JSON data on Raspian

Auto-start Informix during the boot sequence of Raspian If you would like to auto-start the Informix DB each time you (re-)boot your Raspberry Pi, first create a new script called 'informix' in the '/etc/init.d' directory with the following content (either become user 'root' and edit the file or us...
by AlexKoe
Wed Jan 28, 2015 1:14 pm
Forum: Automation, sensing and robotics
Topic: How to create a sensor database with IBM Informix - Part 1
Replies: 12
Views: 5264

Re: How to create a sensor database with IBM Informix - Part

A simple use case: read out the internal temperature of an Raspberry Pi every 60 secs and store it in the Informix 'sensor_data' table Ok, since we now have a working Informix instance and a database to store some sensor data in, let's have some fun and use that setup to store some real sensor data...
by AlexKoe
Mon Jan 26, 2015 9:43 pm
Forum: Automation, sensing and robotics
Topic: How to create a sensor database with IBM Informix - Part 1
Replies: 12
Views: 5264

How to create a sensor database with IBM Informix - Part 1

Preface: This post is part 1 in a little how-to series on how to use the IBM Informix database on the Raspberry Pi to build an efficient sensor data data database for local sensor data analytics/processing/caching. The other posts can be found here: https://www.raspberrypi.org/forums/viewtopic.php?f...
by AlexKoe
Sat Jan 24, 2015 9:43 pm
Forum: Automation, sensing and robotics
Topic: A SQL database for sensor and JSON data on Raspian
Replies: 17
Views: 12579

Re: A SQL database for sensor and JSON data on Raspian

Just a quick modification of the newly created Informix instance. To allow the database to automatically expand its storage area ('rootdbs') if required (e.g. while adding new data or database objects), simply execute the following command as user 'informix': echo "EXECUTE FUNCTION task('modify chun...
by AlexKoe
Fri Jan 23, 2015 10:27 pm
Forum: Automation, sensing and robotics
Topic: A SQL database for sensor and JSON data on Raspian
Replies: 17
Views: 12579

Re: A SQL database for sensor and JSON data on Raspian

In order to provide you a kick start for the Informix database on the Raspberry Pi, I have compiled the following how-to. If you follow the next steps, you should end up with a very simple Informix 12.10 instance which allows you to test some of Informix capabilties like optimized time series data p...
by AlexKoe
Tue Jan 20, 2015 4:27 pm
Forum: Automation, sensing and robotics
Topic: A SQL database for sensor and JSON data on Raspian
Replies: 17
Views: 12579

A SQL database for sensor and JSON data on Raspian

Preface: This post is the introductionary part in a little how-to series on how to use the IBM Informix database on the Raspberry Pi to build an efficient sensor data data database for local sensor data analytics/processing/caching. The other posts can be found here: https://www.raspberrypi.org/foru...
by AlexKoe
Tue Jan 20, 2015 4:05 pm
Forum: General discussion
Topic: STICKY: Introduce yourself!
Replies: 3468
Views: 71009

Re: Introduce yourself!

Hi, I am Alex and I am an IT-Specialist working for IBM in Germany. My professional interest is in databases with a specific focus on embeddable databases for platforms like the Raspberry Pi with features which support e.g. the Internet of Things (like time series and JSON support). I privately own ...

Go to advanced search