oxibase 0.5.10

Autonomous relational database management system with MVCC, time-travel queries, and full ACID compliance
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

{% extends "workspace_layout.html" %}
{% block sidebar %}
    <a up-defer="insert" up-target="#sidebar-content" href="/workspace/sidebar/observe" class="block p-4 text-center text-sm opacity-50 animate-pulse">Loading...</a>
{% endblock %}
{% block content %}
<div class="h-full flex flex-col gap-4 overflow-hidden">
    <!-- Back Button -->
    <div>
        <a href="/workspace/data/system/traces" up-target=":main" class="btn btn-sm btn-ghost">
            <svg class="w-4 h-4 mr-1" fill="none" stroke="currentColor" viewBox="0 0 24 24"><path stroke-linecap="round" stroke-linejoin="round" stroke-width="2" d="M10 19l-7-7m0 0l7-7m-7 7h18"></path></svg>
            Back to Traces
        </a>
    </div>

    <!-- Header -->
    <div class="bg-base-100 p-4 rounded-box shadow-sm border border-base-200">
        <div class="flex items-center justify-between mb-4">
            <div>
                <div class="text-sm font-semibold opacity-60 mb-1">TRACE ID</div>
                <div class="text-2xl font-mono font-bold flex items-center gap-2">
                    {{ trace_id }}
                    <button class="btn btn-xs btn-ghost btn-square" onclick="navigator.clipboard.writeText('{{ trace_id }}')">
                        <svg class="w-4 h-4" fill="none" stroke="currentColor" viewBox="0 0 24 24"><path stroke-linecap="round" stroke-linejoin="round" stroke-width="2" d="M8 16H6a2 2 0 01-2-2V6a2 2 0 012-2h8a2 2 0 012 2v2m-6 12h8a2 2 0 002-2v-8a2 2 0 00-2-2h-8a2 2 0 00-2 2v8a2 2 0 002 2z"></path></svg>
                    </button>
                </div>
            </div>
            <div class="flex gap-4 text-sm">
                <div>
                    <div class="opacity-60 uppercase text-xs font-bold mb-1">Started</div>
                    <div class="font-mono">{{ trace_start_time }}</div>
                </div>
                <div>
                    <div class="opacity-60 uppercase text-xs font-bold mb-1">Ended</div>
                    <div class="font-mono">{{ trace_end_time }}</div>
                </div>
            </div>
        </div>
    </div>

    <!-- Timeline View -->
    <div class="card bg-base-100 shadow-sm border border-base-200 flex-1 flex flex-col overflow-hidden">
        <div class="bg-base-200/50 p-2 border-b border-base-200 flex text-xs font-semibold uppercase opacity-70">
            <div class="w-1/4 px-2">Span Name</div>
            <div class="w-1/6 px-2">Kind / Status</div>
            <div class="w-7/12 px-2">Timeline</div>
        </div>
        
        <div class="flex-1 overflow-y-auto" id="trace-timeline">
            {% if error %}
                <div class="p-6 text-error">{{ error }}</div>
            {% else %}
                {% if spans|length == 0 %}
                    <div class="p-10 text-center opacity-50">No spans found for this trace.</div>
                {% else %}
                    <!-- Spans rendered via JS to calculate widths correctly -->
                    <script>
                        const spans = {{ spans_json | safe }};
                        
                        let minStartTime = Infinity;
                        let maxEndTime = -Infinity;
                        
                        // Parse ISO strings to timestamps
                        const parsedSpans = spans.map(s => {
                            const start = new Date(s.start_time).getTime();
                            const end = new Date(s.end_time).getTime();
                            const duration = end - start;
                            
                            if (start < minStartTime) minStartTime = start;
                            if (end > maxEndTime) maxEndTime = end;
                            
                            return { ...s, startTimestamp: start, durationComputed: duration };
                        });
                        
                        const totalDuration = maxEndTime - minStartTime;
                        
                        const timelineEl = document.getElementById('trace-timeline');
                        let html = '';
                        
                        parsedSpans.forEach((span, index) => {
                            const leftPercent = totalDuration === 0 ? 0 : ((span.startTimestamp - minStartTime) / totalDuration) * 100;
                            let widthPercent = totalDuration === 0 ? 100 : (span.durationComputed / totalDuration) * 100;
                            
                            // Minimum width to make it visible
                            if (widthPercent < 0.5) widthPercent = 0.5;
                            
                            const statusColor = span.status_code === 'ERROR' ? 'bg-error' : 'bg-primary';
                            const depth = span.parent_span_id && span.parent_span_id !== 'none' ? 1 : 0;
                            // Naive depth indentation (could be improved with a real tree build)
                            const paddingLeft = 0.5 + (depth * 1.5);
                            
                            html += `
                                <div class="flex border-b border-base-200 hover:bg-base-200/30 text-sm group">
                                    <div class="w-1/4 p-2 truncate flex items-center gap-2" style="padding-left: ${paddingLeft}rem">
                                        <span class="opacity-50 text-xs font-mono w-4">${index + 1}</span>
                                        <span class="font-medium truncate" title="${span.name}">${span.name}</span>
                                    </div>
                                    <div class="w-1/6 p-2 flex items-center gap-2">
                                        <span class="badge badge-sm badge-outline">${span.span_kind || 'INTERNAL'}</span>
                                        ${span.status_code === 'ERROR' ? `<span class="badge badge-sm badge-error">ERR</span>` : ''}
                                    </div>
                                    <div class="w-7/12 p-2 relative flex items-center">
                                        <div class="absolute h-6 ${statusColor} rounded-sm opacity-80" 
                                             style="left: ${leftPercent}%; width: ${widthPercent}%;">
                                        </div>
                                        <div class="absolute text-xs font-mono opacity-0 group-hover:opacity-100 bg-base-100/80 px-1 rounded z-10" 
                                             style="left: ${leftPercent + widthPercent + 1}%">
                                            ${span.duration_ms}ms
                                        </div>
                                    </div>
                                </div>
                            `;
                        });
                        
                        timelineEl.innerHTML = html;
                    </script>
                {% endif %}
            {% endif %}
        </div>
    </div>
</div>
{% endblock %}