sqlite_micro_logger_arduino
brimming
sqlite_micro_logger_arduino | brimming | |
---|---|---|
2 | 1 | |
162 | 5 | |
- | - | |
3.3 | 5.4 | |
8 months ago | 7 months ago | |
C | Go | |
Apache License 2.0 | The Unlicense |
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.
brimming
-
Inserting One Billion Rows in SQLite Under a Minute
Very nice! I shall give that a try. I always get excited by SQLite and go projects.
I maintain a similar go tool for work, which I use to stuff around 1TB into MariaDB a time:
https://github.com/rcbensley/brimming
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.
usql - Universal command-line interface for SQL databases
scintillating_heatshrink - Converts animated GIFs to a custom format for playback on microcontrollers
migrate - Database migrations. CLI and Golang library.
TTS - Arduino Text-to-Speech Library
sqlitedatagen - Super simple (~180 lines) Go util to generate SQLite data files filled with test data
ESP-Arduino-Lua - Lua scripting engine integrated in Arduino IDE as a Library for ESP8266/ESP32
go-sql-driver/mysql - Go MySQL Driver is a MySQL driver for Go's (golang) database/sql package