Tutorial

This tutorial walks through the basics in a Python REPL. MonaDB runs in-process — no server, no config file.

Connect

import monadb

db = monadb.connect("demo.db")  # omit the path for :memory:

Declare an open schema when you open the handle. Key columns are optional; here we declare an integer id:

todos = db.table("todos", {"id": int})

You can also create tables with raw SQL when you prefer:

db.execute("create table todos (id int);")
todos = db.table("todos", {"id": int})

Generated-key insert (returns the key; raises on duplicate):

tid = todos.insert({"id": 1, "text": "Buy milk", "done": False})

Upsert at a caller-supplied key:

todos[1] = {"text": "Buy milk", "done": False}

Or via SQL:

db.execute("""
    insert into todos ({id: 1, text: "Buy milk", done: false});
""")

Dict-style point lookup:

todos[1]

Predicate-driven reads return a lazy Rows handle:

for row in todos.select("done = false"):
    print(row)

open_todos = todos.select("done = false").fetchall()

Raw SQL still works on the connection cursor:

db.execute("select * from todos where done = false order by id;")
db.fetchall()

Patch matching rows (whole-table updates require an explicit None predicate):

todos.update({"done": True}, "id = ?", [1])