simple-db, relational DB for micropython

[ctimmer]

A few weeks ago I started this discussion about a module I was tinkering with. It is now in a repository if you are interested in taking a look. Discussions are enabled for comment/suggestions.

The 3 modules available are:

1. simple_db.py - direct interface to a database stored on the microprocessor or SD card.
2. simple_db_client.py - When your database gets too big for the microprocessor, it can be moved to a separate server.
3. simple_db_microdot.py - Server for the client interface using the microdot http module. It has only been tested on the unix version of micropython.

These modules are in a working state but are kind of fragile at this point. There is NO documentation but the modules contain lots of examples in the main function.

The big down side is the btree builtin module is required but is not available on all firmware distributions. I used this post to include btree in my pico2w firmware.

Curt

[jonnor]

Consider submitting your project to Awesome MicroPython for visibility. And to describe how to install it using mip (at least the .py module), to make it easier to use.

I would love if we shipped a .mpy file for btree that could be installed at runtime using mip.

[ctimmer]

Added some installation and "Quick Start" documentation.

submitted to Awesome MicroPython

Curt