sqlite_micro_logger_arduino
RFLink
sqlite_micro_logger_arduino | RFLink | |
---|---|---|
2 | 1 | |
161 | 68 | |
- | - | |
3.3 | 0.0 | |
8 months ago | about 1 year ago | |
C | C | |
Apache License 2.0 | GNU General Public License v3.0 or later |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
sqlite_micro_logger_arduino
-
Can an RFID card or keychain tag be programmed for a single use?
There is a tiny SQLite library for Arduino that works with SD cards. I haven't used it myself, but it's probably easier to get an Arduino right now than it is to get a Pi, so it might be worth investigating.
-
Inserting One Billion Rows in SQLite Under a Minute
Potentially interesting:
https://github.com/siara-cc/sqlite_micro_logger_arduino
https://github.com/siara-cc/sqlite_micro_logger_arduino/blob...
This is a heavily subsetted implementation of SQLite3 that can read/write databases (presumably on SD cards) from very small microcontrollers.
It presumably doesn't have the same ACID compliance properties, but with a single <1.5k source file, may represent a particularly efficient way to rapidly learn the intrinsics.
Now I'm thinking it could actually be interesting to see what drh thinks of this implementation (and any gotchas in it) because of its small size and accessibility.
RFLink
-
Make cheap weather station smart
Besides the rtl_433 / usb sdr approach mentioned I have been playing with this for my sensors. https://github.com/couin3/RFLink
What are some alternatives?
fast-sqlite3-inserts - Some bunch of test scripts to generate a SQLite DB with 1B rows in fastest possible way
nodemcu-firmware - Lua based interactive firmware for ESP8266, ESP8285 and ESP32
remixdb - RemixDB: A read- and write-optimized concurrent KV store. Fast point and range queries. Extremely low write-amplification.
mongoose-os - Mongoose OS - an IoT Firmware Development Framework. Supported microcontrollers: ESP32, ESP8266, CC3220, CC3200, STM32F4, STM32L4, STM32F7. Amazon AWS IoT, Microsoft Azure, Google IoT Core integrated. Code in C or JavaScript.
scintillating_heatshrink - Converts animated GIFs to a custom format for playback on microcontrollers
wasm3 - 🚀 A fast WebAssembly interpreter and the most universal WASM runtime
TTS - Arduino Text-to-Speech Library
esp8266-oled-ssd1306 - Driver for the SSD1306 and SH1106 based 128x64, 128x32, 64x48 pixel OLED display running on ESP8266/ESP32
sqlitedatagen - Super simple (~180 lines) Go util to generate SQLite data files filled with test data
grbl-Mega-5X - 5/6 Axis version of Grbl, the open source, embedded, high performance g-code-parser and CNC milling controller written in optimized C that will run on an Arduino Mega2560
ESP-Arduino-Lua - Lua scripting engine integrated in Arduino IDE as a Library for ESP8266/ESP32
TFT_eSPI - Arduino and PlatformIO IDE compatible TFT library optimised for the Raspberry Pi Pico (RP2040), STM32, ESP8266 and ESP32 that supports different driver chips