sqlite_micro_logger_arduino
sqlitedatagen
| sqlite_micro_logger_arduino | sqlitedatagen | |
|---|---|---|
| 2 | 1 | |
| 162 | 6 | |
| - | - | |
| 3.3 | 0.0 | |
| 8 months ago | about 5 years ago | |
| C | Go | |
| Apache License 2.0 | Apache License 2.0 |
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.
sqlitedatagen
-
Inserting One Billion Rows in SQLite Under a Minute
You mention wanting to do a Go version. Not sure if it's useful, but this is a SQLite "bulk data generation" util I threw together ages ago in Go:
https://github.com/sqlitebrowser/sqlitedatagen
There's some initial work to parallelise it with goroutines here:
https://github.com/sqlitebrowser/sqlitedatagen/blob/multi_ro...
Didn't go very far down that track though, as the mostly single threaded nature of writes in SQLite seemed to prevent that from really achieving much. Well, I _think_ that's why it didn't really help. ;)
What are some alternatives?
fast-sqlite3-inserts - Some bunch of test scripts to generate a SQLite DB with 1B rows in fastest possible way
remixdb - RemixDB: A read- and write-optimized concurrent KV store. Fast point and range queries. Extremely low write-amplification.
brimming - Row Stuffing
scintillating_heatshrink - Converts animated GIFs to a custom format for playback on microcontrollers
TTS - Arduino Text-to-Speech Library
ESP-Arduino-Lua - Lua scripting engine integrated in Arduino IDE as a Library for ESP8266/ESP32
RFLink - RFLink for ESP, with MQTT client