μSQLite module for MicroPython

dcexpert

μSQLite module for MicroPython [Copy link]

 

usqlite is a SQL database module for MicroPython built on top of the SQLite C library

. The usqlite SQL interface is designed as a subset of the DB-API 2.0 specification specified in PEP 249.

It is highly compatible with standard sqlite3 and has some additional features. Using the usqlite module is relatively simple. Import the usqlite module, connect to the database, and then execute SQL commands. For example:

import usqlite

if not usqlite.mem_status():
    usqlite.mem_status(True) # Enable memory status monitoring

con = usqlite.connect("data.db")

con.executemany(
    "BEGIN TRANSACTION;"
    "CREATE TABLE IF NOT EXISTS data (name TEXT, year INT);"+
    "INSERT INTO data VALUES ('Larry', 1902);"+
    "INSERT INTO data VALUES ('Cury', 1903);"+
    "INSERT INTO data VALUES ('Moe', 1897);"+
    "COMMIT;")

with con.execute("SELECT * from data") as cur:
    for row in cur:
        print("stooge:", row)
        
con.close()

print("usqlite mem - current:", usqlite.mem_current(), "peak:", usqlite.mem_peak())

游客，如果您要查看本帖隐藏内容请回复

qwqwqw2088

Need a reply? See below

极限零

To see how the performance is

freebsder

String '+' operation spelling SQL

kklam

There is indeed such a demand. The original SQLITE is too large. But if the project is written in C, it is too troublesome to compile the firmware yourself. I have been stuck in the network problem for a long time and cannot download the IDF package (ESP32))

leiyong711

See how the performance is

w403107442

How to compile this into the firmware? It has not been compiled successfully.