This is where your IoT devices will actually connect and send real data. We will do it correctly and securely, step-by-step: 🔹 Step 1 — Install Mosquitto 🔹 Step 2…
Your server is currently running: ✔️ PostgreSQL 14 ✔️ TimescaleDB (installed specifically for your OS + PG version) ✔️ Mosquitto setup ✔️ Custom pg_hba.conf ✔️ Tuned postgresql.conf (via timescaledb-tune) If…
We will proceed with: ✔️ Adding Timescale apt repository ✔️ Installing TimescaleDB extension ✔️ Configuring PostgreSQL to load Timescale ✔️ Creating your first IoT telemetry hypertable now your PostgreSQL will…
In PostgreSQL’s pg_hba.conf: local all all trust host all all 0.0.0.0/0 trust trust = allow ANYONE to connect with NO password. Literally: Any local user → can log into ANY…
In PostgreSQL, a user and a role are actually the same thing —the difference is only permissions. CREATE USER xyz is really just CREATE ROLE xyz LOGIN; That means: the…
here’s a clear, no-nonsense comparison for building your IoT backend on Ubuntu 22.04 LTS CriteriaNode.js (TypeScript, Express/NestJS)Python (FastAPI/Django)Go (Fiber/Gin/Echo)StrengthsReal-time (WebSockets), huge ecosystem, one language (front+back), fast dev; great SDKs for…
Below are the complete, tested steps to install and set up PostgreSQL 15 (the default in Ubuntu 22.04) on Ubuntu 22.04 LTS . Step 1: Update System Packages bash sudo…
Welcome to the exciting world of Raspberry Pi Pico programming! If you love gadgets and enjoy making things work, you're in for a treat. The Raspberry Pi Pico is a…
The Arduino UNO is a favorite among students, engineers, and hobbyists. But how does it stack up against the newer Raspberry Pi Pico? Let's dive into the details and see…