LittleDB vs esp32_arduino_sqlite3_lib

LittleDB

Little Sql like Database for ESP32 boards (by pouriamoosavi)

Source Code

Suggest alternative

Edit details

esp32_arduino_sqlite3_lib

Sqlite3 Arduino library for ESP32 (by siara-cc)

arduino-library Esp32 Sqlite3 Sqlite esp32-ardunio Database

Source Code

Suggest alternative

Edit details

Our great sponsors

InfluxDB - Power Real-Time Data Analytics at Scale

WorkOS - The modern identity platform for B2B SaaS

SaaSHub - Software Alternatives and Reviews

Our great sponsors

LittleDB		esp32_arduino_sqlite3_lib
	Project
1	Mentions	4
26	Stars	341
-	Growth	-
0.0	Activity	5.0
almost 3 years ago	Latest Commit	2 months ago
C++	Language	C
MIT License	License	Apache License 2.0

The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
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.

LittleDB

Posts with mentions or reviews of LittleDB. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2021-09-28.

LittleDB
2 projects | /r/esp32 | 28 Sep 2021

esp32_arduino_sqlite3_lib

Posts with mentions or reviews of esp32_arduino_sqlite3_lib. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2023-04-24.

so i just got hit with 160kb DRAM limit on esp
2 projects | /r/esp32 | 24 Apr 2023

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?
1 project | /r/arduino | 13 Feb 2023

there's sqlite for esp32 if the dataset is static and the sqlite file can fit on a SPIFFS partition
LittleDB
2 projects | /r/esp32 | 28 Sep 2021

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
1 project | /r/arduino | 1 Feb 2021

What are some alternatives?

When comparing LittleDB and esp32_arduino_sqlite3_lib you can also consider the following projects:

siodb - A simple SQL database engine. All encrypted. Execute multiple SQL queries at once through one REST query. No ORM and no additional modules required. Available for all programming languages.

SQLite3MultipleCiphers - SQLite3 encryption extension with support for multiple ciphers

better-sqlite3 - The fastest and simplest library for SQLite3 in Node.js.

SQLite-ICU-MinGW - Building SQLite and SQLiteODBC on Windows with ICU and other extensions using MSVC Build Tools and MSYS2/MinGW

xeus-sql - Jupyter kernel for SQL databases

go-sqlite-lite - SQLite driver for the Go programming language

better-sqlite3 - The fastest and simplest library for SQLite3 in Node.js. [Moved to: https://github.com/WiseLibs/better-sqlite3]

LibSSH-ESP32 - Libssh SSH client & server port to ESP32 Arduino library

sqlitebrowser - Official home of the DB Browser for SQLite (DB4S) project. Previously known as "SQLite Database Browser" and "Database Browser for SQLite". Website at:

edge-sql - Cloudflare Workers providing a SQL API

Watchy - Watchy - An Open Source E-Ink Smartwatch

usqlite - μSQLite library module for MicroPython