sqlite Projects

A sophisticated physical chess board utilizing Hall effect sensors for piece detection and dual displays for game status and clock. It runs on Go-powered Raspberry Pi or Orange Pi hardware, featuring deep Lichess integration, local Stockfish analysis, and a custom DietPi-based OS image with power-loss protection.

AgentDeck is a multi-surface physical control interface for AI coding agents, enabling real-time steering of agents like Claude Code and Codex via hardware. It supports 13 different display surfaces simultaneously, utilizing a Node.js or Swift-based bridge to coordinate between terminal-based agents and devices like the Stream Deck+, Android tablets, and ESP32 displays. The system includes a sophisticated performance evaluation framework (APME) that uses local SQLite storage to track and optimize agent efficiency.

Velxio is an open-source, multi-board emulator that allows users to write, compile, and simulate Arduino C++ or Python code directly in the browser. It supports five CPU architectures including AVR8, ARM Cortex-M0+, RISC-V, Xtensa, and ARM Cortex-A53, utilizing specialized engines like avr8js, rp2040js, and QEMU. The platform features an integrated code editor, a library manager, and over 48 interactive electronic components for complex circuit simulation.

QBIT is an open-source desktop companion robot and personal IoT avatar based on the ESP32-C3. It features a custom monochrome animation system, integrated Wi-Fi management via NetWizard, and seamless Home Assistant integration through MQTT. The project includes a full-stack web platform for remote interaction, device claiming, and community animation sharing.

pico-vfs is a modular virtual file system designed for the Raspberry Pi Pico that provides a unified POSIX-compliant API for various storage media. It allows developers to mount multiple file systems, such as littlefs and FatFs, across physical storage like onboard flash and SD cards. The project streamlines embedded development by abstracting hardware differences and supporting standard C file operations.

A port of the SQLite3 database engine for the Raspberry Pi Pico, enabling structured data storage on microcontrollers. It leverages littlefs for flash persistence and pico-vfs for flexible filesystem support, providing both a C/C++ library and an interactive shell.

A port of the SQLite3 relational database engine for ESP32 microcontrollers using the ESP-IDF framework. It supports ESP-IDF V5.x, offers specialized PSRAM memory management, and integrates with various filesystems including SPIFFS, LittleFS, and FATFS.

A comprehensive IoT solution for real-time environmental monitoring using ESP32 or ESP8266 microcontrollers. It tracks temperature, humidity, and water levels, transmitting data via HTTP to a Flask-based server with SQLite storage and a responsive web dashboard. Features include remote threshold management and local LED alerts.

An IoT-based automatic pet feeder that utilizes an ESP32-CAM for live streaming and a servo motor for dispensing food. It features a Flask web interface for remote control and employs a YOLOv8 object detection model to automatically feed pets when they are recognized.

An open-source platform for always-on wearable AI that captures and processes life experiences using LLMs. It supports custom hardware like the ESP32S3 and Sony Spresense alongside consumer devices like the Apple Watch, providing a full stack from firmware to mobile interfaces.

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.