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

apiVersion: apps/v1
kind: StatefulSet
metadata:
  name: sqlrite-ha
  labels:
    app: sqlrite-ha
spec:
  serviceName: sqlrite-ha-headless
  replicas: 3
  selector:
    matchLabels:
      app: sqlrite-ha
  template:
    metadata:
      labels:
        app: sqlrite-ha
    spec:
      containers:
        - name: sqlrite
          image: sqlrite:local
          command:
            - /bin/sh
            - -c
          args:
            - |
              ROLE="replica"
              if [ "${HOSTNAME##*-}" = "0" ]; then ROLE="primary"; fi
              exec sqlrite serve \
                --db /var/lib/sqlrite/sqlrite.db \
                --bind 0.0.0.0:8099 \
                --ha-role "${ROLE}" \
                --cluster-id sqlrite-ha \
                --node-id "${HOSTNAME}" \
                --advertise "${HOSTNAME}.sqlrite-ha-headless:8099" \
                --peer sqlrite-ha-0.sqlrite-ha-headless:8099 \
                --peer sqlrite-ha-1.sqlrite-ha-headless:8099 \
                --peer sqlrite-ha-2.sqlrite-ha-headless:8099 \
                --sync-ack-quorum 2 \
                --failover automatic \
                --control-token "${SQLRITE_CONTROL_TOKEN}"
          ports:
            - containerPort: 8099
              name: http
          env:
            - name: SQLRITE_CONTROL_TOKEN
              valueFrom:
                secretKeyRef:
                  name: sqlrite-ha-secret
                  key: control_token
          volumeMounts:
            - name: data
              mountPath: /var/lib/sqlrite
  volumeClaimTemplates:
    - metadata:
        name: data
      spec:
        accessModes:
          - ReadWriteOnce
        resources:
          requests:
            storage: 5Gi