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
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118

version: "3.9"

services:
  sqlrite-primary:
    image: sqlrite:local
    container_name: sqlrite-primary
    command:
      - serve
      - --db
      - /data/sqlrite.db
      - --bind
      - 0.0.0.0:8099
      - --ha-role
      - primary
      - --cluster-id
      - sqlrite-ha
      - --node-id
      - node-a
      - --advertise
      - sqlrite-primary:8099
      - --peer
      - sqlrite-replica-1:8099
      - --peer
      - sqlrite-replica-2:8099
      - --sync-ack-quorum
      - "2"
      - --failover
      - automatic
      - --control-token
      - ${SQLRITE_CONTROL_TOKEN:-dev-token}
    ports:
      - "8099:8099"
    volumes:
      - ./data/node-a:/data
    networks:
      - sqlrite-ha

  sqlrite-replica-1:
    image: sqlrite:local
    container_name: sqlrite-replica-1
    command:
      - serve
      - --db
      - /data/sqlrite.db
      - --bind
      - 0.0.0.0:8099
      - --ha-role
      - replica
      - --cluster-id
      - sqlrite-ha
      - --node-id
      - node-b
      - --advertise
      - sqlrite-replica-1:8099
      - --peer
      - sqlrite-primary:8099
      - --peer
      - sqlrite-replica-2:8099
      - --sync-ack-quorum
      - "2"
      - --failover
      - automatic
      - --control-token
      - ${SQLRITE_CONTROL_TOKEN:-dev-token}
    ports:
      - "8199:8099"
    volumes:
      - ./data/node-b:/data
    networks:
      - sqlrite-ha

  sqlrite-replica-2:
    image: sqlrite:local
    container_name: sqlrite-replica-2
    command:
      - serve
      - --db
      - /data/sqlrite.db
      - --bind
      - 0.0.0.0:8099
      - --ha-role
      - replica
      - --cluster-id
      - sqlrite-ha
      - --node-id
      - node-c
      - --advertise
      - sqlrite-replica-2:8099
      - --peer
      - sqlrite-primary:8099
      - --peer
      - sqlrite-replica-1:8099
      - --sync-ack-quorum
      - "2"
      - --failover
      - automatic
      - --control-token
      - ${SQLRITE_CONTROL_TOKEN:-dev-token}
    ports:
      - "8299:8099"
    volumes:
      - ./data/node-c:/data
    networks:
      - sqlrite-ha

  prometheus:
    image: prom/prometheus:v2.53.1
    container_name: sqlrite-prometheus
    ports:
      - "9090:9090"
    volumes:
      - ./prometheus.yml:/etc/prometheus/prometheus.yml:ro
    networks:
      - sqlrite-ha

networks:
  sqlrite-ha:
    driver: bridge