Skip to content

Instantly share code, notes, and snippets.

Avatar

Florian Knodt adlerweb

View GitHub Profile
@adlerweb
adlerweb / ina-config.php
Created Nov 14, 2020
USB WiFi Power Logger
View ina-config.php
<?php
$mysql_serv = 'localhost';
$mysql_user = 'usblogger';
$mysql_pass = 'usblogger';
$mysql_datb = 'volkszaehler';
$uuid_v = 1;
$uuid_a = 2;
?>
@adlerweb
adlerweb / redis-mygrate.py
Last active Apr 13, 2020 — forked from romanmah/redis-mygrate.py
A small utility to dump/restore serialized redis data to text files
View redis-mygrate.py
#!/usr/bin/python
import redis
import pickle
import argparse
class RedisMigrate():
def __init__(self, host, port, db):
View ledBlink.cpp
View irFerraris.ino
/***************************************************************************
IR Ferraris Reader
2019 Adlerweb//Bitbastelei
Florian Knodt - www.adlerweb.info
Note: Just a few minutes of coding, not heavily tested, etc
***************************************************************************/
#include <Arduino.h>
View vzapi.php
<?php
/*
Usage:
- platform: command_line
name: foo
command: "php -f /home/homeassistant/vzapi.php 1"
unit_of_measurement: "W"
Todo:
- Rewrite in Python
View ledmatrix.ino
#include <LEDMatrixDriver.hpp>
extern "C" {
#include "user_interface.h"
}
// This sketch draw marquee text on your LED matrix using the hardware SPI driver Library by Bartosz Bielawski.
// https://github.com/bartoszbielawski/LEDMatrixDriver
// Example written 16.06.2017 by Marko Oette, www.oette.info
View EFTPOS-TestKbdLCD.ino
#include <Arduino.h>
#include <SPI.h>
#include <MCP23S17.h>
#include <Wire.h>
#include <LiquidCrystal_PCF8574.h>
extern "C" {
#include "user_interface.h"
}
@adlerweb
adlerweb / vz.md
Created Sep 12, 2018
Grafana MySQL query to visualize Volkszähler-Data
View vz.md

Using Channel-IDs (that's not UUID)

SELECT
  timestamp/1000 as time_sec, 
  data.value as value, 
  properties.value as metric
FROM data
  LEFT JOIN properties ON (properties.entity_id = data.channel_id)
  LEFT JOIN entities ON (entities.id = data.channel_id)
View mqtt-test.ino
#include <ESP8266WiFi.h>
#include <ESP8266mDNS.h>
#include <PubSubClient.h>
const char* cfg_wifi_ssid = "freifunk-myk.de";
const char* cfg_wifi_pwd = "";
const char* mqtt_server = "deinserver.local";
const unsigned int mqtt_port = 1883;
@adlerweb
adlerweb / LCDWiFi.ino
Created Jun 10, 2018
ESP8266 HD44780 WiFi
View LCDWiFi.ino
#include <LiquidCrystal.h>
#include <ESP8266WiFi.h>
#include <WiFiClient.h>
#include <ESP8266WebServer.h>
#include <ESP8266mDNS.h>
const char *ssid = "freifunk-myk.de";
const char *password = "";
const char *netname = "esp-lcd";