Blog

Aquascaping

|

Mal ein bisschen was fürs Auge auf meiner Seite. Während des Corona Lockdowns hat mich das Thema Aquascaping gepackt und nachdem ich die ersten Bilder im Internet gesehen hatte, war klar das ich sowas auch haben möchte. Mittlerweile habe ich ein eigenes 60f von ADA im Wohnzimmer stehen. Als Besatz schwimmen dort eine wachsende Anzahl Zwerggarnelen, ein paar Schnecken sowie zwei Zwergfadenfische herum.

ADA 60f Aquascape

Und auch wer weniger Platz zur Verfügung hat, kann sich schöne Pflanzenaquarien in die Wohnung stellen. Hier mein erstes Wabikusa mit Moosball

DOOA Neo Glas Air Wabikusa

Da die Lust auf Pflanzenaquarien damit noch immer nicht befriedigt ist, ist im Laufe des nächsten Jahres noch die Anschaffung eines ~250l Beckens geplant.

New Frontend for Opensource Smartmeter

|

I never really liked the structure of my piMeter software. The combination of websockets for live data and a database for the historical data was cluttered and prone to error. Added to this i never felt happy with the javascript frontend in which all graphs were hardcoded for visualization.

Time to streamline the software and leave the visualization to people who know about it. Grafana and InfluxDB were the right candidates for this.

Installation of InfluxDB and Grafana

Add the Package Source:

    curl -sL https://repos.influxdata.com/influxdb.key | sudo apt-key add - source 
    /etc/lsb-release echo "deb https://repos.influxdata.com/${DISTRIB_ID,,} 
    ${DISTRIB_CODENAME} stable" | sudo tee /etc/apt/sources.list.d/influxdb.list


Install the database with apt-get and start the service:

    sudo apt-get update && sudo apt-get install influxdb
    sudo service influxdb start


With the command:

    influx

you can start the InfluxDB console and add a database for your piMeter

    CREATE DATABASE piMeter

Thats it.

Installing Grafana works the same way.

Add Package Source:

    echo "deb https://packagecloud.io/grafana/stable/debian/ wheezy main" | 
    sudo tee /etc/apt/sources.list.d/grafana.list curl https://packagecloud.io/gpg.key | 
    sudo apt-key add -

Install Grafana with apt-get and start the service:

    sudo apt-get update && sudo apt-get install grafana
    sudo service grafana-server start


You can now Log-In to your installation at www.yourDomain:3000 and build your Dashboard.

Grafana Dashboard
Ressources

Github

The Old Repository gets cleaned up and will be renamed to piMeter_hardware.
I would like to thank  orca-zhang for the really easy to use InfluxDB-Cpp Lib!

Opensource Raspberry Pi Smartmeter

I was missing the ability of measuring and visualizing power consumption in my Smarthome. For this reason I have developed a Smartmeter / Energymonitor as an extension for the Raspberry Pi which I would like to share for rebuilding / improving / expanding. The piMeter.

The Smartmeter can record the following data on 3 phases:

Current RMS
Voltage RMS
Active power
Apparent power
Reactive power
Accumulated active power
Accumulated apparent power
Accumulated reactive power

All smartmeter data is visualized on a web frontend. It shows consumption data for a given day, month or year. It can also show real-time data of the actual consumption. The real-time data is stored in RAM. It holds 10 minutes of data in a buffer and sends it to the browser if needed. The long time data is stored in a mariaDB on my NAS. Storing this data on the pi directly is not recommended due to high read / write cycles on the sdcard.

The Smartmeter is based on the ADE9000 chip from Analog Devices which communicates over SPI with the Raspberry Pi. For current measurement I use SCT-013-000 Current Transformers from YHDC. They are cheap and can measure currents up to 100A.

Web Frontend

Dashboard
Realtime Data

Smartmeter Board

piMeter Board

Case

Case bottom with Pi Zero
Case bottom with piMeter
Case closed
Ressources

Github
schematics.pdf
SCT-013-000 Datasheet
ADE9000 Datasheet
BCM2835 SPI Lib

Disclaimer

When working with 230V there is danger to life. The board has no protection against contact. I assume no liability for damage to persons or objects that arise when replicating the meter.