Overview
The mysql node connects to MySQL and MariaDB databases. Widely used in web
applications, it integrates EdgeFlow with existing MySQL infrastructure. Supports connection pooling,
prepared statements, and transactions.
MySQL
Compatible
MariaDB
Compatible
Pool
Connections
SSL
Support
Properties
| Property | Type | Default | Description |
|---|---|---|---|
| host | string | "localhost" | Database host |
| port | number | 3306 | Database port |
| database | string | "edgeflow" | Database name |
| user | string | "root" | Username |
| password | string | "" | Password |
Example: Web App Integration
Sync IoT data with a web application's MySQL database.
-- Insert sensor reading
INSERT INTO device_readings (device_id, temperature, humidity, created_at)
VALUES (?, ?, ?, NOW());
-- Get device settings
SELECT settings FROM devices WHERE device_id = ?;
-- Update device status
UPDATE devices SET last_seen = NOW(), status = 'online' WHERE device_id = ?;