IT Technology ~ Network + Hardware + OS + Smart + Web = LiBe.net
From the network to the operating system to the smart home and your own private cloud.
I like to test new things and share my experiences on this page.
📰 New Posts
Display / output Home Assistant data as a table
Charts are great, but a simple table view of historical data would be desirable for certain evaluations. Unfortunately, Home Assistant has very little to offer out of the box. ... continue reading
HA - SQLite Insights: Database Layout / Example Queries
To be able to compile better SQL queries, I took a closer look at the Home-Assistant database schema. Initially mainly to correct certain historical data, later to improve the energy forecast of my PV system, which enables more efficient control of the heating. Details on the queries for the PV forecast will follow in a separate article.. ... continue reading
PrusaSlicer in version 2.9.2 published
I have used 2 different slicers extensively so far: Cura and PrusaSlicer. Both slicers are free, both deliver usable results with the manufacturer's default settings, both have their strengths and hardly any weaknesses. ... continue reading
Android: use any printer via WLAN
CUPS makes it easy to add and manage printers via a web browser. If the printer is enabled, printing is also possible from Android devices. Even an HP Laserjet 4050 that is over 20 years old can be used conveniently from a cell phone. This requires either a small mini-server or another device on which either a Linux distribution is used or Docker containers can be operated. ... continue reading
3 variants: SQLite database access - Home Assistant
There are several ways to access the SQLite database of Home Assistant directly. The easiest way is to use SQLite Web. ... continue reading
Docker - Mini server as PVR receiver for DVB-T/S/C
For a long time, I used a PVR:hard disk receiver, specifically a Dreambox DM7020HD with 2 DVB-C tuners, to supplement my TV. Originally for recording certain programs, later to be able to watch live TV purely via WLAN without a network or coax cable with a FireTV stick and to consume the recorded programs as a stream. Unfortunately, the Dreambox gave up the ghost after more than 10 years and simply wouldn't boot up. While looking for a replacement, I realized that new devices for classic TV rece... ... continue reading
Home Assistant: Range selection for mobile devices
Echarts is currently testing a function to select a specific range of charts on mobile devices ... continue reading
History & energy dashboard: last hour, week, 30 days
In December 2024, I submitted a pull request on GitHub to add additional time spans to Home-Assistant's history and energy dashboard. The time spans are expected to be part of the 2025.3 release. ... continue reading
Home Assistant Release 2025.2 - Construction site: Charts
Switch to a new graph library Echarts ... continue reading
Home Assistant heating control revised.
After around 20 years, I was able to use Home Assistant and an ESP32 to take control of my heat pump and control it. Combined with the performance data of the PV system, Home Assistant is able to use the PV surplus as directly as possible for heating and thus increase self-consumption: ... continue reading
OPNSense and Wireguard
After investing some time to successfully set up Wireguard in OPNsense, I would like to share some screenshots of my test setup here. In this configuration, I used OPNsense exclusively as a VPN server and deliberately omitted the WAN interface. For testing purposes, OPNsense was installed on a HyperV server. A prerequisite for the setup is port forwarding for port 51820 on the router to the IP address of the OPNSense installation and a public IP address, see: Making available from the Internet:... ... continue reading
Energy Dashboard - Cards also for other dashboards?
The Energy Dashboard provides a comprehensive overview of energy consumption immediately after installation, but its customization options are very limited. ... continue reading
📁 Topics
Smart Home
Retrofitting your existing home with smart home functions is now easier than ever. However, due to the large number of standards and available software components, choosing a suitable system is not so easy. If you are still looking for suitable software for home automation, you should take a look at Home Assistant.
