absurder-sql 0.1.23

AbsurderSQL - SQLite + IndexedDB that's absurdly better than absurd-sql
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
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143

# Prometheus Recording Rules for AbsurderSQL
#
# Recording rules pre-compute expensive queries and store them as new time series.
# This improves dashboard performance and reduces query load on Prometheus.
#
# Naming Convention: level:metric:operation
#   - level: aggregation level (e.g., job, instance)
#   - metric: the metric being computed
#   - operation: the operation performed (e.g., rate, ratio)

groups:
  - name: absurdersql_aggregation_rules
    interval: 30s
    rules:
      # Query rate metrics
      - record: absurdersql:query_rate:5m
        expr: rate(absurdersql_queries_total[5m])
      
      - record: absurdersql:error_rate:5m
        expr: |
          rate(absurdersql_errors_total[5m]) 
          / 
          rate(absurdersql_queries_total[5m])
      
      # Cache performance
      - record: absurdersql:cache_hit_rate:5m
        expr: |
          rate(absurdersql_cache_hits_total[5m]) 
          / 
          (rate(absurdersql_cache_hits_total[5m]) + rate(absurdersql_cache_misses_total[5m]))
      
      - record: absurdersql:cache_miss_rate:5m
        expr: |
          rate(absurdersql_cache_misses_total[5m]) 
          / 
          (rate(absurdersql_cache_hits_total[5m]) + rate(absurdersql_cache_misses_total[5m]))
      
      # Query latency percentiles
      - record: absurdersql:query_latency_p50:5m
        expr: histogram_quantile(0.50, rate(absurdersql_query_duration_bucket[5m]))
      
      - record: absurdersql:query_latency_p95:5m
        expr: histogram_quantile(0.95, rate(absurdersql_query_duration_bucket[5m]))
      
      - record: absurdersql:query_latency_p99:5m
        expr: histogram_quantile(0.99, rate(absurdersql_query_duration_bucket[5m]))
      
      # IndexedDB performance
      - record: absurdersql:indexeddb_ops_rate:5m
        expr: rate(absurdersql_indexeddb_operations_total[5m])
      
      - record: absurdersql:indexeddb_latency_p95:5m
        expr: histogram_quantile(0.95, rate(absurdersql_indexeddb_duration_bucket[5m]))
      
      # VFS sync performance
      - record: absurdersql:sync_ops_rate:5m
        expr: rate(absurdersql_sync_operations_total[5m])
      
      - record: absurdersql:sync_latency_p95:5m
        expr: histogram_quantile(0.95, rate(absurdersql_sync_duration_bucket[5m]))
      
      # Leader election metrics
      - record: absurdersql:leader_election_rate:5m
        expr: rate(absurdersql_leader_elections_total[5m])
      
      - record: absurdersql:leadership_change_rate:5m
        expr: rate(absurdersql_leadership_changes_total[5m])
      
      - record: absurdersql:leader_election_latency_p95:5m
        expr: histogram_quantile(0.95, rate(absurdersql_leader_election_duration_bucket[5m]))
      
      # Memory allocation metrics
      - record: absurdersql:block_allocation_rate:5m
        expr: rate(absurdersql_blocks_allocated_total[5m])
      
      - record: absurdersql:block_deallocation_rate:5m
        expr: rate(absurdersql_blocks_deallocated_total[5m])
      
      - record: absurdersql:net_block_allocation_rate:5m
        expr: |
          rate(absurdersql_blocks_allocated_total[5m]) 
          - 
          rate(absurdersql_blocks_deallocated_total[5m])

  - name: absurdersql_derived_metrics
    interval: 1m
    rules:
      # Query success rate (inverse of error rate)
      - record: absurdersql:query_success_rate:5m
        expr: |
          1 - (
            rate(absurdersql_errors_total[5m]) 
            / 
            rate(absurdersql_queries_total[5m])
          )
      
      # Cache efficiency score (0-1, higher is better)
      - record: absurdersql:cache_efficiency:5m
        expr: |
          (
            rate(absurdersql_cache_hits_total[5m]) 
            / 
            (rate(absurdersql_cache_hits_total[5m]) + rate(absurdersql_cache_misses_total[5m]))
          )
      
      # Memory growth rate (bytes per second)
      - record: absurdersql:memory_growth_rate:5m
        expr: deriv(absurdersql_memory_bytes[5m])
      
      # Storage growth rate (bytes per second)
      - record: absurdersql:storage_growth_rate:5m
        expr: deriv(absurdersql_storage_bytes[5m])
      
      # Predicted memory usage in 1 hour
      - record: absurdersql:memory_predicted_1h:30m
        expr: predict_linear(absurdersql_memory_bytes[30m], 3600)
      
      # Predicted storage usage in 1 hour
      - record: absurdersql:storage_predicted_1h:30m
        expr: predict_linear(absurdersql_storage_bytes[30m], 3600)
      
      # Leader election stability (lower is better)
      - record: absurdersql:election_instability:5m
        expr: |
          (
            rate(absurdersql_leader_elections_total[5m]) * 60
          ) + (
            rate(absurdersql_leadership_changes_total[5m]) * 120
          )
      
      # Overall system health score (0-1, higher is better)
      - record: absurdersql:health_score:5m
        expr: |
          (
            # Low error rate (< 1%)
            min(1, 1 - (rate(absurdersql_errors_total[5m]) / rate(absurdersql_queries_total[5m]) * 100)) * 0.3
            +
            # High cache hit rate (> 80%)
            (rate(absurdersql_cache_hits_total[5m]) / (rate(absurdersql_cache_hits_total[5m]) + rate(absurdersql_cache_misses_total[5m]))) * 0.3
            +
            # Fast queries (P95 < 50ms)
            min(1, 1 - (histogram_quantile(0.95, rate(absurdersql_query_duration_bucket[5m])) / 50)) * 0.4
          )