NULL
|
iTerm2
|
-zsh
|
NULL
|
|
sqlite3 ~/.screenpipe/db.sqlite "
SELECT f.win sqlite3 ~/.screenpipe/db.sqlite "
SELECT f.window_name, e.text
FROM elements e
JOIN frames f ON e.frame_id = f.id
WHERE f.app_name = 'Safari' AND e.text IS NOT NULL
LIMIT 20;"...
|
NULL
|
NULL
|
NULL
|
NULL
|
iTerm2
|
-zsh
|
NULL
|
|
sqlite3 ~/.screenpipe/db.sqlite "
SELECT f.win sqlite3 ~/.screenpipe/db.sqlite "
SELECT f.window_name, e.text
FROM elements e
JOIN frames f ON e.frame_id = f.id
WHERE f.app_name = 'Safari' AND e.text IS NOT NULL
LIMIT 20;"...
|
NULL
|
NULL
|
NULL
|
NULL
|
iTerm2
|
-zsh
|
NULL
|
NULL
|
iTerm2
|
-zsh
|
NULL
|
|
sqlite3 ~/.screenpipe/db.sqlite "
SELECT f.win sqlite3 ~/.screenpipe/db.sqlite "
SELECT f.window_name, e.text
FROM elements e
JOIN frames f ON e.frame_id = f.id
WHERE f.app_name = 'Safari' AND e.text IS NOT NULL
LIMIT 20;"...
|
NULL
|
NULL
|
NULL
|
|
|
NULL
|
NULL
|
NULL
|
NULL
|
iTerm2
|
-zsh
|
NULL
|
NULL
|
iTerm2
|
-zsh
|
NULL
|
NULL
|
iTerm2
|
-zsh
|
NULL
|
NULL
|
iTerm2
|
-zsh
|
NULL
|
NULL
|
iTerm2
|
-zsh
|
NULL
|
|
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~ $ sqlit lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~ $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT f.app_name, COUNT(*) as elements, COUNT(DISTINCT e.frame_id) as frames
FROM elements e
JOIN frames f ON e.frame_id = f.id
WHERE e.text IS NOT NULL
GROUP BY f.app_name
ORDER BY elements DESC;"
|24604|206
Dia|2884|17
iTerm2|2087|136
Claude|2040|8
Safari|1248|10
Firefox|454|1
Activity Monitor|380|2
Slack|234|1
Control Centre|178|1
UserNotificationCenter|20|4
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~ $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT e.text
FROM elements e
JOIN frames f ON e.frame_id = f.id
WHERE f.app_name = 'iTerm2' AND e.role = 'block' AND e.text NOT NULL
LIMIT 30;"
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~ $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT f.window_name, e.text
FROM elements e
JOIN frames f ON e.frame_id = f.id
WHERE f.app_name = 'Safari' AND e.text IS NOT NULL
LIMIT 20;"
Order Room Service • HBO Max|Back
Order Room Service • HBO Max|Search
Order Room Service • HBO Max|Uko......
|
NULL
|
NULL
|
NULL
|
NULL
|
iTerm2
|
-zsh
|
NULL
|
|
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~ $ sqlit lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~ $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT f.app_name, COUNT(*) as elements, COUNT(DISTINCT e.frame_id) as frames
FROM elements e
JOIN frames f ON e.frame_id = f.id
WHERE e.text IS NOT NULL
GROUP BY f.app_name
ORDER BY elements DESC;"
|24604|206
Dia|2884|17
iTerm2|2087|136
Claude|2040|8
Safari|1248|10
Firefox|454|1
Activity Monitor|380|2
Slack|234|1
Control Centre|178|1
UserNotificationCenter|20|4
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~ $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT e.text
FROM elements e
JOIN frames f ON e.frame_id = f.id
WHERE f.app_name = 'iTerm2' AND e.role = 'block' AND e.text NOT NULL
LIMIT 30;"
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~ $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT f.window_name, e.text
FROM elements e
JOIN frames f ON e.frame_id = f.id
WHERE f.app_name = 'Safari' AND e.text IS NOT NULL
LIMIT 20;"
Order Room Service • HBO Max|Back
Order Room Service • HBO Max|Search
Order Room Service • HBO Max|Uko......
|
NULL
|
NULL
|
NULL
|
NULL
|
iTerm2
|
-zsh
|
NULL
|
NULL
|
iTerm2
|
-zsh
|
NULL
|
NULL
|
iTerm2
|
-zsh
|
NULL
|
|
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~ $ sqlit lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~ $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT f.app_name, COUNT(*) as elements, COUNT(DISTINCT e.frame_id) as frames
FROM elements e
JOIN frames f ON e.frame_id = f.id
WHERE e.text IS NOT NULL
GROUP BY f.app_name
ORDER BY elements DESC;"
|24604|206
Dia|2884|17
iTerm2|2087|136
Claude|2040|8
Safari|1248|10
Firefox|454|1
Activity Monitor|380|2
Slack|234|1
Control Centre|178|1
UserNotificationCenter|20|4
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~ $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT e.text
FROM elements e
JOIN frames f ON e.frame_id = f.id
WHERE f.app_name = 'iTerm2' AND e.role = 'block' AND e.text NOT NULL
LIMIT 30;"
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~ $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT f.window_name, e.text
FROM elements e
JOIN frames f ON e.frame_id = f.id
WHERE f.app_name = 'Safari' AND e.text IS NOT NULL
LIMIT 20;"
Order Room Service • HBO Max|Back
Order Room Service • HBO Max|Search
Order Room Service • HBO Max|Uko......
|
NULL
|
NULL
|
NULL
|
|
|
NULL
|
NULL
|
NULL
|
NULL
|
iTerm2
|
-zsh
|
NULL
|
NULL
|
iTerm2
|
-zsh
|
NULL
|
NULL
|
iTerm2
|
-zsh
|
NULL
|
NULL
|
iTerm2
|
-zsh
|
NULL
|
|
clear
|
NULL
|
NULL
|
NULL
|
|
|
NULL
|
NULL
|
NULL
|
NULL
|
iTerm2
|
-zsh
|
NULL
|
|
# What roles exist in elements?
sqlite3 ~/.screenp # What roles exist in elements?
sqlite3 ~/.screenpipe/db.sqlite "SELECT role, COUNT(*) FROM elements GROUP BY role ORDER BY COUNT(*) DESC;"
# What are those 24k elements with no app_name?
sqlite3 ~/.screenpipe/db.sqlite "
SELECT f.window_name, COUNT(*) as cnt
FROM elements e
JOIN frames f ON e.frame_id = f.id
WHERE f.app_name IS NULL AND e.text IS NOT NULL
GROUP BY f.window_name
ORDER BY cnt DESC
LIMIT 10;"
# iTerm2 elements with any role
sqlite3 ~/.screenpipe/db.sqlite "
SELECT e.role, e.text
FROM elements e
JOIN frames f ON e.frame_id = f.id
WHERE f.app_name = 'iTerm2' AND e.text IS NOT NULL
LIMIT 20;"...
|
NULL
|
NULL
|
NULL
|
|
|
NULL
|
NULL
|
NULL
|
NULL
|
iTerm2
|
-zsh
|
NULL
|
NULL
|
iTerm2
|
-zsh
|
NULL
|
|
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~ $ # Wha lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~ $ # What roles exist in elements?
sqlite3 ~/.screenpipe/db.sqlite "SELECT role, COUNT(*) FROM elements GROUP BY role ORDER BY COUNT(*) DESC;"
# What are those 24k elements with no app_name?
sqlite3 ~/.screenpipe/db.sqlite "
SELECT f.window_name, COUNT(*) as cnt
FROM elements e
JOIN frames f ON e.frame_id = f.id
WHERE f.app_name IS NULL AND e.text IS NOT NULL
GROUP BY f.window_name
ORDER BY cnt DESC
LIMIT 10;"
# iTerm2 elements with any role
sqlite3 ~/.screenpipe/db.sqlite "
SELECT e.role, e.text
FROM elements e
JOIN frames f ON e.frame_id = f.id
WHERE f.app_name = 'iTerm2' AND e.text IS NOT NULL
LIMIT 20;"
zsh: no matches found: elements?
block|25522
AXStaticText|4681
AXButton|1364
AXLink|1123
AXRadioButton|1017
AXTextField|607
AXCell|297
AXHeading|166
AXTextArea|151
AXPopUpButton|83
AXCheckBox|59
AXComboBox|7
zsh: no matches found: app_name?
|25079
zsh: command not found: #
AXButton|Close Tab
AXButton|Close Tab
AXButton|Close Tab
AXButto......
|
NULL
|
NULL
|
NULL
|
NULL
|
iTerm2
|
-zsh
|
NULL
|
|
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~ $ # Wha lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~ $ # What roles exist in elements?
sqlite3 ~/.screenpipe/db.sqlite "SELECT role, COUNT(*) FROM elements GROUP BY role ORDER BY COUNT(*) DESC;"
# What are those 24k elements with no app_name?
sqlite3 ~/.screenpipe/db.sqlite "
SELECT f.window_name, COUNT(*) as cnt
FROM elements e
JOIN frames f ON e.frame_id = f.id
WHERE f.app_name IS NULL AND e.text IS NOT NULL
GROUP BY f.window_name
ORDER BY cnt DESC
LIMIT 10;"
# iTerm2 elements with any role
sqlite3 ~/.screenpipe/db.sqlite "
SELECT e.role, e.text
FROM elements e
JOIN frames f ON e.frame_id = f.id
WHERE f.app_name = 'iTerm2' AND e.text IS NOT NULL
LIMIT 20;"
zsh: no matches found: elements?
block|25522
AXStaticText|4681
AXButton|1364
AXLink|1123
AXRadioButton|1017
AXTextField|607
AXCell|297
AXHeading|166
AXTextArea|151
AXPopUpButton|83
AXCheckBox|59
AXComboBox|7
zsh: no matches found: app_name?
|25079
zsh: command not found: #
AXButton|Close Tab
AXButton|Close Tab
AXButton|Close Tab
AXButto......
|
NULL
|
NULL
|
NULL
|
NULL
|
iTerm2
|
-zsh
|
NULL
|
NULL
|
iTerm2
|
-zsh
|
NULL
|
NULL
|
iTerm2
|
-zsh
|
NULL
|
|
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~ $ # Wha lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~ $ # What roles exist in elements?
sqlite3 ~/.screenpipe/db.sqlite "SELECT role, COUNT(*) FROM elements GROUP BY role ORDER BY COUNT(*) DESC;"
# What are those 24k elements with no app_name?
sqlite3 ~/.screenpipe/db.sqlite "
SELECT f.window_name, COUNT(*) as cnt
FROM elements e
JOIN frames f ON e.frame_id = f.id
WHERE f.app_name IS NULL AND e.text IS NOT NULL
GROUP BY f.window_name
ORDER BY cnt DESC
LIMIT 10;"
# iTerm2 elements with any role
sqlite3 ~/.screenpipe/db.sqlite "
SELECT e.role, e.text
FROM elements e
JOIN frames f ON e.frame_id = f.id
WHERE f.app_name = 'iTerm2' AND e.text IS NOT NULL
LIMIT 20;"
zsh: no matches found: elements?
block|25522
AXStaticText|4681
AXButton|1364
AXLink|1123
AXRadioButton|1017
AXTextField|607
AXCell|297
AXHeading|166
AXTextArea|151
AXPopUpButton|83
AXCheckBox|59
AXComboBox|7
zsh: no matches found: app_name?
|25079
zsh: command not found: #
AXButton|Close Tab
AXButton|Close Tab
AXButton|Close Tab
AXButto......
|
NULL
|
NULL
|
NULL
|
|
|
NULL
|
NULL
|
NULL
|
NULL
|
iTerm2
|
-zsh
|
NULL
|
NULL
|
iTerm2
|
-zsh
|
NULL
|
NULL
|
iTerm2
|
-zsh
|
NULL
|
|
how to
|
NULL
|
NULL
|
NULL
|
|
use these
|
NULL
|
NULL
|
NULL
|
NULL
|
iTerm2
|
-zsh
|
NULL
|
NULL
|
iTerm2
|
-zsh
|
NULL
|
NULL
|
iTerm2
|
-zsh
|
NULL
|
|
clear
|
NULL
|
NULL
|
NULL
|
|
|
NULL
|
NULL
|
NULL
|