gotermsql/demo.tape at main · sadopc/gotermsql · GitHub

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
# gotermsql Demo — SQLite
# VHS tape file - https://github.com/charmbracelet/vhs

Output demo.gif

Set Shell "bash"
Set FontSize 14
Set Width 1200
Set Height 700
Set Padding 20
Set Theme "Catppuccin Mocha"
Set TypingSpeed 40ms
Set PlaybackSpeed 0.5

# Start gotermsql with SQLite demo database
Type "bin/gotermsql --adapter sqlite --file demo.db"
Enter
Sleep 2s

# Editor is focused — type a simple query
Sleep 500ms
Type "SELECT * FROM users;"
Sleep 500ms

# Dismiss autocomplete, execute with Ctrl+G
Escape
Sleep 200ms
Ctrl+g
Sleep 2s

# Switch to results pane (Ctrl+J cycles focus)
Ctrl+j
Sleep 1s

# Navigate result rows — see cursor highlight + alternating colors
Down
Sleep 300ms
Down
Sleep 300ms
Down
Sleep 300ms
Down
Sleep 300ms

# Show help overlay from results pane
Type "?"
Sleep 3s

# Close help
Escape
Sleep 500ms

# Back to editor (Ctrl+J: results -> editor)
Ctrl+j
Sleep 500ms

# New tab — show autocomplete for a JOIN query
Ctrl+t
Sleep 1s

# Type query, let autocomplete appear on FROM
Type "SELECT u.name, p.name AS product, p.price, o.amount FROM ord"
Sleep 800ms

# Accept autocomplete suggestion (orders)
Tab
Sleep 300ms

# Continue typing
Type " o JOIN users u ON u.id = o.user_id JOIN products p ON p.name = o.product ORDER BY p.price DESC;"
Sleep 500ms

# Execute
Escape
Sleep 200ms
Ctrl+g
Sleep 2s

# Switch to sidebar to browse schema (Ctrl+J twice: editor -> results -> sidebar)
Ctrl+j
Sleep 300ms
Ctrl+j
Sleep 500ms

# Navigate schema tree
Down
Sleep 300ms
Enter
Sleep 500ms
Down
Sleep 300ms
Enter
Sleep 500ms
Down
Sleep 300ms
Down
Sleep 300ms
Down
Sleep 500ms

# New tab for aggregate query
Ctrl+t
Sleep 500ms

Type "SELECT p.category, COUNT(*) AS order_count, SUM(o.amount) AS revenue FROM orders o JOIN products p ON p.name = o.product GROUP BY p.category ORDER BY revenue DESC;"
Sleep 500ms

# Execute
Escape
Sleep 200ms
Ctrl+g
Sleep 2s

# Show results with zebra striping
Ctrl+j
Sleep 1s
Down
Sleep 300ms
Down
Sleep 300ms
Down
Sleep 300ms

Sleep 1s

# Quit
Ctrl+q
Sleep 500ms