mq-db 0.1.13

Markdown-specialized embedded database with interval-indexed block storage and hierarchical query support
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41

# REPL

The interactive REPL supports both query modes in a single session.

```bash
mq-db repl --db store.mq-db --mode sql
```

```text
mq-db  (.help for commands  .quit to exit)
mode: sql  (.mode mq | .mode sql)

sql> SELECT content FROM blocks WHERE block_type = 'heading' LIMIT 3;
┌──────────────────┐
│ content          │
├──────────────────┤
│ Overview         │
│ Architecture     │
│ Query Engine     │
└──────────────────┘
(3 rows)

sql> .mode mq
→ mq mode
mq> .h2
## Architecture
## Query Engine
```

## Dot commands

| Command | Description |
| --- | --- |
| `.help` | List available commands |
| `.mode sql` | Switch to SQL query mode |
| `.mode mq` | Switch to mq query mode |
| `.quit` | Exit the REPL |

The initial mode can be set with `--mode sql` or `--mode mq` (default `sql`).

Pass `--attach path.mq-db:alias` (repeatable) to mount other stores at startup, queryable as `alias.blocks`/`alias.documents` — see [ATTACH / DETACH](../reference/sql-ddl.md#attach--detach).