sqlrite 1.0.2

RAG-oriented SQLite wrapper for AI agent workloads
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
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67

# Distribution

This guide covers the packaging and shipping paths that are current today.

## Packaging options

| Artifact | Command | Notes |
|---|---|---|
| source install | `cargo install --path .` | installs full CLI toolchain |
| release archive | `bash scripts/create-release-archive.sh --version 1.0.2` | packages `sqlrite` |
| release installer | `bash scripts/sqlrite-install.sh --version 1.0.2` | installs `sqlrite` |
| Docker image | `docker build -t sqlrite:local .` | service deployment baseline |
| seeded Docker Compose demo | `docker compose -f deploy/docker-compose.seeded-demo.yml up --build` | seeded local demo server |

## Release archive

```bash
bash scripts/create-release-archive.sh --version 1.0.2
```

Outputs:

- `dist/sqlrite-v1.0.2-<target>.tar.gz`
- `dist/sqlrite-v1.0.2-<target>.sha256`

## Linux packages

When `nfpm` is installed:

```bash
bash scripts/package-linux.sh --version 1.0.2
```

## Docker

```bash
docker build -t sqlrite:local .
docker run --rm -p 8099:8099 -v "$PWD/docker-data:/data" sqlrite:local
```

Container behavior:

| Behavior | Result |
|---|---|
| database path | `/data/sqlrite.db` |
| empty mounted directory | SQLRite creates an empty schema-applied database |
| default command | `sqlrite serve --db /data/sqlrite.db --bind 0.0.0.0:8099` |

If you want a ready-to-query container immediately:

```bash
mkdir -p docker-data
sqlrite init --db ./docker-data/sqlrite.db --seed-demo
docker run --rm -p 8099:8099 -v "$PWD/docker-data:/data" sqlrite:local
```

## Seeded Docker Compose demo

```bash
docker compose -f deploy/docker-compose.seeded-demo.yml up --build
```

This flow:

- seeds the database once if the volume is empty
- starts the HTTP server on `8099`
- keeps the database in a named volume