esp32_arduino_sqlite3_lib
edge-sql
Our great sponsors
esp32_arduino_sqlite3_lib | edge-sql | |
---|---|---|
4 | 2 | |
341 | 555 | |
- | - | |
5.0 | 1.8 | |
2 months ago | over 3 years ago | |
C | C | |
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.
esp32_arduino_sqlite3_lib
-
so i just got hit with 160kb DRAM limit on esp
Then your debugging is mostly around writing thing that generates that flat file and then also around whatever functions read and index the flat file. There is a pretty decent sqlite3 library for Arduino on ESP32 at least: https://github.com/siara-cc/esp32_arduino_sqlite3_lib (and actually another one for idf: https://github.com/siara-cc/esp32-idf-sqlite3 )
-
How to communicate between ESP32 and MySQL using PHP?
there's sqlite for esp32 if the dataset is static and the sqlite file can fit on a SPIFFS partition
-
LittleDB
Interesting idea, I guess there's a use case for something with a lighter memory footprint than sqlite3 on an embedded platform.
- Hosting website on NodeMCU ESP8266
edge-sql
- Abusing AWS Lambda to Make an Aussie Search Engine
-
Serverless SQLite
edge-sql [1] allows arbitrary SQLite queries to be executed over an immutable external data set. The demo uses a Forex data set stored in Workers KV.
Client issued arbitrary queries is one of the use cases for GraphQL and publishing immutable data sets on the web is the main use case for Simon Wilson’s Datasette [2].
In-memory SQLite compiled to WASM works in the browser and Node.js too. In the future, we can expect proper ACID operations on any WASM runtime that supports fsync in WASI [3], a POSIX-like API.
[1] https://github.com/lspgn/edge-sql
[2] https://datasette.io/
[3] https://wasi.dev/
What are some alternatives?
SQLite3MultipleCiphers - SQLite3 encryption extension with support for multiple ciphers
dqlite - Embeddable, replicated and fault-tolerant SQL engine.
LittleDB - Little Sql like Database for ESP32 boards
lsqlite - lua sqlite module
SQLite-ICU-MinGW - Building SQLite and SQLiteODBC on Windows with ICU and other extensions using MSVC Build Tools and MSYS2/MinGW
torrent-net - Distributed search engines using BitTorrent and SQLite
go-sqlite-lite - SQLite driver for the Go programming language
sqlite-gui - Lightweight SQLite editor for Windows
LibSSH-ESP32 - Libssh SSH client & server port to ESP32 Arduino library
fatcow-icons - FatCow icons v3.9.2 (I was given a permission to host these on GitHub by FatCow support.)
Watchy - Watchy - An Open Source E-Ink Smartwatch
edgesearch - Serverless full-text search with Cloudflare Workers, WebAssembly, and Roaring Bitmaps