Raspberry Pi: log sensor data to SQLite and query it
Store sensor history in SQLite on a Pi: schema, insert loop, retention, and the queries that answer 'what happened last week'.
Tag
#raspberry-pi
21 tutorials
Raspberry Pi: time-series dashboards with InfluxDB + Grafana
The self-hosted dashboard stack: InfluxDB stores sensor time series, Grafana graphs them. Install, wire an ESP32's MQTT feed, retention included.
Raspberry Pi: build a sensor REST API with Flask
Expose your Pi's sensors as a JSON REST API with Flask. GET readings, POST control commands, and the structure that keeps it honest.
Raspberry Pi: send email alerts from shell scripts with msmtp
Configure msmtp on a Raspberry Pi so any shell script or cron job can send email alerts through your own SMTP relay. The pattern that survives.
Raspberry Pi: transfer files with FileZilla over SFTP
Move files between your computer and a Raspberry Pi with FileZilla over SFTP. No FTP server, no extra packages, no plaintext passwords on the network.
Raspberry Pi: gesture recognition with MediaPipe
Run hand gesture recognition on a Raspberry Pi camera feed with MediaPipe: count fingers, detect an open palm or fist, and trigger real actions in Python.
Raspberry Pi: internet anywhere with a 4G/LTE HAT
Get a Raspberry Pi online over cellular with a SIM7600 4G/LTE HAT, check signal honestly, and run your own WireGuard bridge over the link instead of port forwarding.
Raspberry Pi: live camera stream in the browser with Picamera2 MJPEG
Stream a Raspberry Pi camera feed live into any browser with Picamera2 and MJPEG. One Python file, no plugins, works on your phone over Wi-Fi.
Raspberry Pi: Sense HAT (LEDs, sensors, joystick)
Plug a Sense HAT onto a Raspberry Pi and read temperature, humidity, pressure, and orientation from Python, drive the LED matrix, and fix the two traps every owner hits.
Raspberry Pi: back up and clone an SD card the safe way
Image a Raspberry Pi SD card with the right tool for each job: Raspberry Pi Imager for restores, dd and gzip for raw backups, rsync for daily copies.
Raspberry Pi: use the Camera Module v3 with libcamera and Picamera2
Wire a Camera Module v3 to a Raspberry Pi, capture stills and video from the command line with libcamera, and write Python with the modern Picamera2 library.
Raspberry Pi: GPIO with Python and gpiozero, the right way
Wire an LED and a button to a Raspberry Pi's GPIO and control them from Python using gpiozero. The simplest way to get started with physical computing on the Pi.
Raspberry Pi: WireGuard VPN with PiVPN, your own private tunnel
Set up WireGuard on a Raspberry Pi using PiVPN, configure your phone as a peer, and tunnel back to your home network from anywhere on the internet.
Raspberry Pi: install Home Assistant the right way, with backups and automations
Install Home Assistant OS on a Raspberry Pi, set up the integrations (MQTT, ESPHome, Hue), build a GUI automation, and recover from a bricked install with a full backup.
Raspberry Pi: install Docker the right way and run multi-service stacks
Set up Docker on a Raspberry Pi 4 or 5, run multi-container stacks with docker-compose, and avoid the arm64 vs amd64 trap that wastes a weekend.
Raspberry Pi: run Pi-hole to block ads network-wide
Install Pi-hole on a Raspberry Pi and block ads, trackers, and malware domains for every device on your network. The single most useful Pi project.
Raspberry Pi: serve files on your network with Samba
Turn a Raspberry Pi into a small NAS by setting up Samba file sharing. Access the Pi's files from any computer on your network.
Raspberry Pi: run Node-RED for visual automations
Install Node-RED on a Raspberry Pi and build a visual automation flow. The tool that ties together MQTT, sensors, dashboards, and notifications.
Raspberry Pi: install and configure Mosquitto MQTT broker
Set up a local MQTT broker on a Raspberry Pi so your ESP32s and other devices can publish and subscribe without depending on a cloud.
Raspberry Pi: read a DHT22 with Python and the GPIO pins
Wire a DHT22 to a Raspberry Pi's GPIO and read temperature and humidity from Python. The smallest useful Pi project.
Raspberry Pi: headless setup without a monitor
Set up a Raspberry Pi without ever plugging in a monitor or keyboard. Write the SD card, SSH in, and configure Wi-Fi from your laptop.