DBDB.io The Encyclopedia of Database Systems · Est. 2017
Database of Databases

Database Entry

LittleD


LittleD is a relational database system designed for embedded devices and sensor nodes. It operates with a minimal memory footprint, requiring as little as 1 kB of RAM for most queries. The system supports a subset of SQL syntax including SELECT-FROM-WHERE statements, inner joins, projections, CREATE TABLE, and INSERT operations. Data type support is currently limited to integers and fixed-width strings.[02][03]

Source Code
https://github.com/graemedouglas/LittleD[01]
Developer
Country of Origin
CA
Start Year
2014
End Year
2016
Project Types
Academic, Open Source
Written in
C
Operating System
Linux
License
Apache v2

Database Entry

LittleD


LittleD is a relational database system designed for embedded devices and sensor nodes. It operates with a minimal memory footprint, requiring as little as 1 kB of RAM for most queries. The system supports a subset of SQL syntax including SELECT-FROM-WHERE statements, inner joins, projections, CREATE TABLE, and INSERT operations. Data type support is currently limited to integers and fixed-width strings.[02][03]

History


LittleD was developed by Graeme Douglas as an academic research project targeting database management on resource-constrained microprocessors.

Data Model


Query Interface


SQL

Storage Architecture


System Architecture


Revision #4