Anybody got Sqlite3 running on Microcontroller? (RP-2040)

(1.1) By midijohnny on 2022-06-03 19:30:57 edited from 1.0 [source]

I am intrigued by the possibility of running Sqlite3 on a Microcontroller. To that end: I'm trying the library micropython-sqlite3 0.2.3 with a Raspberry Pi Pico using micropython.

Its not currently working for me: but I know this isn't the forum to explore that. But just using this forum as an outreach to see if anybody else has got Sqlite3 running on a Pico who could advise?

I'm actually trying this on a badger board - rather than a Pico Board per-say, but its the same RP2040 chip - so it is practically the same. (Using Thonny as my IDE)

(2) By anonymous on 2023-11-06 13:39:57 in reply to 1.1 [link] [source]

Somebody built a version ("usqlite") to Pico.
See here: https://github.com/spatialdude/usqlite/blob/main/README.md

(3) By oyama (_oyama) on 2024-06-01 16:08:33 in reply to 1.1 [link] [source]

Hello,

I have created a SQLite3 port not for MicroPython but for Raspberry Pi Pico pico-sdk (C/C++), which can interact with shell.c via UART and also provides an INTERFACE library for C/C++ projects: https://github.com/oyama/pico-sqlite

For reference, this implementation is intended as a technical validation of the project pico-vfs, which adds a POSIX-compatible file API to pico-sdk, and does not use the SQLite VFS interface. I was impressed that the RDBMS runs on a microcontroller that costs only $5.

(4) By midijohnny on 2024-06-01 22:01:52 in reply to 3 [link] [source]

Nice one - I look forward to trying that at some point!