sqlite Projects

A high-performance desktop MQTT visualization and debugging tool for Windows, Mac, and Linux. It supports MQTT v3 and v5 protocols, Sparkplug B codecs, and concurrent broker connections, providing a comprehensive interface for monitoring IoT message traffic.

A self-hosted SMS gateway designed for GSM modem hardware, specifically targeting Raspberry Pi setups with GSM HATs. It provides HTTP and WebSocket APIs for messaging, GNSS location tracking, and modem control with encrypted database persistence using SQLite.

A Python-based orchestration platform for MeshCore mesh networks. It provides a complete stack including a serial-to-MQTT interface, data collector, REST API, and web dashboard for monitoring and managing LoRa-based mesh devices.

A bidirectional interface connecting the Loxone Miniserver with the Philips Hue Bridge (V2 API) and MQTT. It provides local, real-time control using Hue's Event Interface (SSE) and supports status reporting via UDP and MQTT. Designed for deployment on platforms like Raspberry Pi using Docker.

Raybot is a rail-based robotic delivery system designed for smart transportation in structured environments. It utilizes Go for control logic, featuring RFID-based tracking, distance sensors for obstacle detection, and dual-motor control for movement and payload lifting.

A lightweight LoRa mesh repeater daemon written in Python for Raspberry Pi-class hardware. It utilizes the pymc_core library to provide packet routing, neighbor discovery, and real-time monitoring via a built-in web dashboard.

An open-source IoT automation platform for real-time control and monitoring of electrical appliances using ESP8266 microcontrollers. The system features a Node.js backend with MQTT and WebSockets for low-latency communication, AI-driven voice control, and historical data logging via SQLite.

A comprehensive IoT environment monitoring solution built for ESP32 and ESP8266 microcontrollers. It provides real-time tracking of temperature, humidity, and water levels, featuring a Flask-based backend with SQLite storage and a responsive web dashboard for data visualization and remote threshold management.

StreamPulse is a lightweight Python-based microservice designed to monitor the operational health of IP camera networks. It tracks RTSP and MJPEG stream availability, logging heartbeats to an SQLite database and providing real-time status via a Flask dashboard and MQTT. The system is optimized for edge computing platforms like Raspberry Pi and Orange Pi.

A comprehensive open-source firmware for the LilyGo TWatch 2020 series based on the ESP32 and Arduino framework. It features a custom UI engine, Lua scripting, BLE/WiFi connectivity, and integration with Gadgetbridge for smartphone notifications.

A minimalist, asynchronous web micro-framework designed for the Pycopy Python implementation. It features a small memory footprint of approximately 36K heap and provides a Flask-like API for developing web applications on resource-constrained embedded systems and bare-metal platforms.

A comprehensive resource repository for the Microchip SAMA5D27 Cortex-A5 MPU, providing extensive documentation and guides for Linux development, bare-metal programming, and various RTOS ports. It features in-depth tutorials for NuttX, RT-Thread, and ThreadX, including driver integration for LVGL, EtherCAT, and TensorFlow Lite.

An MVC framework for embedded systems that mimics Java's Struts 1.0 architecture to decouple model, view, and controller logic. Built specifically for ChibiOS RTOS, it provides a structured pattern for developing scalable and maintainable IoT applications on STM32 microcontrollers.

A modular and extensible flight software framework designed for nanosatellites like the SUCHAI 1U CubeSat. It supports FreeRTOS and Linux, targeting platforms such as ATMEL AVR32, ESP32, and Raspberry Pi. The architecture utilizes a command processor pattern and LibCSP for subsystem communication.

A lightweight, pure C library providing client and server support for HTTP/1, HTTP/2, WebSockets, MQTT, and other protocols. It is designed for high scalability and security, targeting platforms ranging from embedded RTOS like FreeRTOS on ESP32 to mass cloud serving.

A comprehensive MicroPython port for the Kendryte K210 64-bit RISC-V SoC, built upon the Kendryte FreeRTOS SDK. It features dual-core support, advanced multi-threading, and extensive peripheral drivers for displays, networking, and file systems.

Bloom is a lightweight, Jester-based blogging engine written in Nim. It utilizes a serverless SQLite database and provides a web-based admin console within a single executable, prioritizing speed and simplicity for users and developers alike.

A comprehensive IoT chronothermostat system utilizing ESP32 nodes and a Raspberry Pi 3 gateway integrated with Amazon Web Services. It features multi-room temperature and humidity monitoring, remote control via MQTT, and a web-based GUI for scheduling and statistics.

CSVql is a Nim-based utility that enables querying CSV files using standard ANSI-SQL. By loading data into an in-memory SQLite database, it provides a powerful interface for complex data manipulation, including joins and filtering, without requiring manual data conversion.

db_wrapper is a high-performance Nim database library providing a unified interface for MySQL, PostgreSQL, and SQLite. It implements robust connection pooling to enable efficient parallel database processing, addressing performance limitations found in standard Nim database drivers.

A visual development tool for the MiniGUI Extend framework designed to streamline the creation of Harbour and xHarbour applications. It features a CRUD form wizard, native support for RDDSQL, and seamless integration with databases like PostgreSQL, SQLite, and Firebird.