27 projects using sqlite
SQLite is a C-language library that implements a small, fast, self-contained, high-reliability, and full-featured SQL database engine. It functions as a serverless, zero-configuration database that compiles SQL statements into bytecode for execution on a custom virtual machine, making it the most widely deployed database engine in the world.
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.
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.
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.