|
curl -s -X POST http://localhost:3030/raw_sql \
curl -s -X POST http://localhost:3030/raw_sql \
-H "Content-Type: application/json" \
-d '{"query": "SELECT app_name, COUNT(*) as frames FROM frames WHERE timestamp > datetime(\"now\",\"-1 day\") AND app_name != \"\" GROUP BY app_name ORDER BY frames DESC LIMIT 50"}' \
| python3 -m json.tool...
|
NULL
|
NULL
|
NULL
|
|
|
NULL
|
NULL
|
NULL
|
|
curl -s -X POST http://localhost:3030/raw_sql \
curl -s -X POST http://localhost:3030/raw_sql \
-H "Content-Type: application/json" \
-d '{"query": "SELECT * FROM ui_events WHERE timestamp > datetime(\"now\",\"-1 day\") LIMIT 10"}' \
| python3 -m json.tool...
|
NULL
|
NULL
|
NULL
|
|
|
NULL
|
NULL
|
NULL
|
|
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~ $ curl lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~ $ curl -s -X POST http://localhost:3030/raw_sql \
-H "Content-Type: application/json" \
-d '{"query": "SELECT app_name, COUNT(*) as frames FROM frames WHERE timestamp > datetime(\"now\",\"-1 day\") AND app_name != \"\" GROUP BY app_name ORDER BY frames DESC LIMIT 50"}' \
| python3 -m json.tool
[
{
"app_name": "Firefox",
"frames": 338
},
{
"app_name": "iTerm2",
"frames": 327
},
{
"app_name": "Claude",
"frames": 100
},
{
"app_name": "Code",
"frames": 35
},
{
"app_name": "Alfred",
"frames": 24
},
{
"app_name": "Finder",
"frames": 18
},
{
"app_name": "QuickTime Player",
"frames": 16
},
{
"app_name": "Boosteroid",
"frames": 15
},
{
"app_name": "NetAuthAgent",
"frames": 3
},
{
"app_name": "Raycast",
"frames":......
|
NULL
|
NULL
|
NULL
|
|
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~ $ curl lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~ $ curl -s -X POST http://localhost:3030/raw_sql \
-H "Content-Type: application/json" \
-d '{"query": "SELECT app_name, COUNT(*) as frames FROM frames WHERE timestamp > datetime(\"now\",\"-1 day\") AND app_name != \"\" GROUP BY app_name ORDER BY frames DESC LIMIT 50"}' \
| python3 -m json.tool
[
{
"app_name": "Firefox",
"frames": 338
},
{
"app_name": "iTerm2",
"frames": 327
},
{
"app_name": "Claude",
"frames": 100
},
{
"app_name": "Code",
"frames": 35
},
{
"app_name": "Alfred",
"frames": 24
},
{
"app_name": "Finder",
"frames": 18
},
{
"app_name": "QuickTime Player",
"frames": 16
},
{
"app_name": "Boosteroid",
"frames": 15
},
{
"app_name": "NetAuthAgent",
"frames": 3
},
{
"app_name": "Raycast",
"frames":......
|
NULL
|
NULL
|
NULL
|
|
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~ $ curl lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~ $ curl -s -X POST http://localhost:3030/raw_sql \
-H "Content-Type: application/json" \
-d '{"query": "SELECT app_name, COUNT(*) as frames FROM frames WHERE timestamp > datetime(\"now\",\"-1 day\") AND app_name != \"\" GROUP BY app_name ORDER BY frames DESC LIMIT 50"}' \
| python3 -m json.tool
[
{
"app_name": "Firefox",
"frames": 338
},
{
"app_name": "iTerm2",
"frames": 327
},
{
"app_name": "Claude",
"frames": 100
},
{
"app_name": "Code",
"frames": 35
},
{
"app_name": "Alfred",
"frames": 24
},
{
"app_name": "Finder",
"frames": 18
},
{
"app_name": "QuickTime Player",
"frames": 16
},
{
"app_name": "Boosteroid",
"frames": 15
},
{
"app_name": "NetAuthAgent",
"frames": 3
},
{
"app_name": "Raycast",
"frames":......
|
NULL
|
NULL
|
NULL
|
|
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~ $ curl lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~ $ curl -s -X POST http://localhost:3030/raw_sql \
-H "Content-Type: application/json" \
-d '{"query": "SELECT app_name, COUNT(*) as frames FROM frames WHERE timestamp > datetime(\"now\",\"-1 day\") AND app_name != \"\" GROUP BY app_name ORDER BY frames DESC LIMIT 50"}' \
| python3 -m json.tool
[
{
"app_name": "Firefox",
"frames": 338
},
{
"app_name": "iTerm2",
"frames": 327
},
{
"app_name": "Claude",
"frames": 100
},
{
"app_name": "Code",
"frames": 35
},
{
"app_name": "Alfred",
"frames": 24
},
{
"app_name": "Finder",
"frames": 18
},
{
"app_name": "QuickTime Player",
"frames": 16
},
{
"app_name": "Boosteroid",
"frames": 15
},
{
"app_name": "NetAuthAgent",
"frames": 3
},
{
"app_name": "Raycast",
"frames":......
|
NULL
|
NULL
|
NULL
|
|
clear
|
NULL
|
NULL
|
NULL
|
|
curl -s -X POST http://localhost:3030/raw_sql \
curl -s -X POST http://localhost:3030/raw_sql \
-H "Content-Type: application/json" \
-d '{"query": "SELECT * FROM memories LIMIT 5"}' \
| python3 -m json.tool...
|
NULL
|
NULL
|
NULL
|
|
|
NULL
|
NULL
|
NULL
|
|
curl -s -X POST http://localhost:3030/raw_sql \
curl -s -X POST http://localhost:3030/raw_sql \
-H "Content-Type: application/json" \
-d '{"query": "SELECT e.text, f.app_name, f.window_name, f.timestamp FROM elements e JOIN frames f ON e.frame_id = f.id WHERE e.text LIKE \"%JY-%\" AND f.timestamp > datetime(\"now\",\"-1 day\") ORDER BY f.timestamp DESC LIMIT 50"}' \
| python3 -m json.tool...
|
NULL
|
NULL
|
NULL
|
|
|
NULL
|
NULL
|
NULL
|
|
curl -s -X POST http://localhost:3030/raw_sql \
curl -s -X POST http://localhost:3030/raw_sql \
-H "Content-Type: application/json" \
-d '{"query": "SELECT browser_url, window_name, COUNT(*) as frames FROM frames WHERE timestamp > datetime(\"now\",\"-1 day\") AND browser_url != \"\" GROUP BY browser_url ORDER BY frames DESC LIMIT 30"}' \
| python3 -m json.tool...
|
NULL
|
NULL
|
NULL
|
|
|
NULL
|
NULL
|
NULL
|
|
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~ $ curl lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~ $ curl -s -X POST http://localhost:3030/raw_sql \
-H "Content-Type: application/json" \
-d '{"query": "SELECT browser_url, window_name, COUNT(*) as frames FROM frames WHERE timestamp > datetime(\"now\",\"-1 day\") AND browser_url != \"\" GROUP BY browser_url ORDER BY frames DESC LIMIT 30"}' \
| python3 -m json.tool
[
{
"browser_url": "http://[IP_ADDRESS]:8766",
"frames": 72,
"window_name": "Screenpipe Dashboard \u2014 Personal"
},
{
"browser_url": "nas.lakylak.xyz/desktop/#/",
"frames": 28,
"window_name": "DXP4800PLUS-B5F8 \u2014 Personal"
},
{
"browser_url": "screenpi.pe/onboarding",
"frames": 19,
"window_name": "Download screenpipe \u2014 get started in minutes \u2014 Personal"
},
{
"browser_url": "jiminny.atlassian.net/jira/software/c/projects/JY/boards/37",
"frames": 17,
"window_name": "Platform Sprint 1 Q2......
|
NULL
|
NULL
|
NULL
|
|
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~ $ curl lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~ $ curl -s -X POST http://localhost:3030/raw_sql \
-H "Content-Type: application/json" \
-d '{"query": "SELECT browser_url, window_name, COUNT(*) as frames FROM frames WHERE timestamp > datetime(\"now\",\"-1 day\") AND browser_url != \"\" GROUP BY browser_url ORDER BY frames DESC LIMIT 30"}' \
| python3 -m json.tool
[
{
"browser_url": "http://[IP_ADDRESS]:8766",
"frames": 72,
"window_name": "Screenpipe Dashboard \u2014 Personal"
},
{
"browser_url": "nas.lakylak.xyz/desktop/#/",
"frames": 28,
"window_name": "DXP4800PLUS-B5F8 \u2014 Personal"
},
{
"browser_url": "screenpi.pe/onboarding",
"frames": 19,
"window_name": "Download screenpipe \u2014 get started in minutes \u2014 Personal"
},
{
"browser_url": "jiminny.atlassian.net/jira/software/c/projects/JY/boards/37",
"frames": 17,
"window_name": "Platform Sprint 1 Q2......
|
NULL
|
NULL
|
NULL
|
|
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~ $ curl lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~ $ curl -s -X POST http://localhost:3030/raw_sql \
-H "Content-Type: application/json" \
-d '{"query": "SELECT browser_url, window_name, COUNT(*) as frames FROM frames WHERE timestamp > datetime(\"now\",\"-1 day\") AND browser_url != \"\" GROUP BY browser_url ORDER BY frames DESC LIMIT 30"}' \
| python3 -m json.tool
[
{
"browser_url": "http://[IP_ADDRESS]:8766",
"frames": 72,
"window_name": "Screenpipe Dashboard \u2014 Personal"
},
{
"browser_url": "nas.lakylak.xyz/desktop/#/",
"frames": 28,
"window_name": "DXP4800PLUS-B5F8 \u2014 Personal"
},
{
"browser_url": "screenpi.pe/onboarding",
"frames": 19,
"window_name": "Download screenpipe \u2014 get started in minutes \u2014 Personal"
},
{
"browser_url": "jiminny.atlassian.net/jira/software/c/projects/JY/boards/37",
"frames": 17,
"window_name": "Platform Sprint 1 Q2......
|
NULL
|
NULL
|
NULL
|
|
clear
|
NULL
|
NULL
|
NULL
|
|
curl -s -X POST http://localhost:3030/raw_sql \
curl -s -X POST http://localhost:3030/raw_sql \
-H "Content-Type: application/json" \
-d '{"query": "SELECT * FROM memories LIMIT 5"}' \
| python3 -m json.tool...
|
NULL
|
NULL
|
NULL
|
|
|
NULL
|
NULL
|
NULL
|
|
curl -s -X POST http://localhost:3030/raw_sql \
curl -s -X POST http://localhost:3030/raw_sql \
-H "Content-Type: application/json" \
-d '{"query": "SELECT e.text, f.app_name, f.window_name, f.timestamp FROM elements e JOIN frames f ON e.frame_id = f.id WHERE e.text LIKE \"%JY-%\" AND f.timestamp > datetime(\"now\",\"-1 day\") ORDER BY f.timestamp DESC LIMIT 50"}' \
| python3 -m json.tool...
|
NULL
|
NULL
|
NULL
|
|
|
NULL
|
NULL
|
NULL
|
|
curl -s -X POST http://localhost:3030/raw_sql \
curl -s -X POST http://localhost:3030/raw_sql \
-H "Content-Type: application/json" \
-d '{"query": "SELECT e.text, f.app_name, f.window_name, f.timestamp FROM elements e JOIN frames f ON e.frame_id = f.id WHERE e.text LIKE \"%JY-%\" AND f.timestamp > datetime(\"now\",\"-1 day\") ORDER BY f.timestamp DESC LIMIT 50"}' \
| python3 -m json.tool...
|
NULL
|
NULL
|
NULL
|
|
returns a
|
NULL
|
NULL
|
NULL
|
|
lo
|
NULL
|
NULL
|
NULL
|
|
t
|
NULL
|
NULL
|
NULL
|
|
|
NULL
|
NULL
|
NULL
|
|
clear
|
NULL
|
NULL
|
NULL
|
|
curl -s -X POST http://localhost:3030/raw_sql \
curl -s -X POST http://localhost:3030/raw_sql \
-H "Content-Type: application/json" \
-d '{"query": "SELECT capture_trigger, COUNT(*) as n FROM frames WHERE timestamp > datetime(\"now\",\"-1 day\") GROUP BY capture_trigger ORDER BY n DESC LIMIT 20"}' \
| python3 -m json.tool...
|
NULL
|
NULL
|
NULL
|
|
|
NULL
|
NULL
|
NULL
|
|
curl -s -X POST http://localhost:3030/raw_sql \
curl -s -X POST http://localhost:3030/raw_sql \
-H "Content-Type: application/json" \
-d '{"query": "SELECT app_name, text_source, COUNT(*) as n FROM frames WHERE timestamp > datetime(\"now\",\"-1 day\") AND app_name != \"\" GROUP BY app_name, text_source ORDER BY n DESC LIMIT 30"}' \
| python3 -m json.tool...
|
NULL
|
NULL
|
NULL
|
|
|
NULL
|
NULL
|
NULL
|
|
sp
|
NULL
|
NULL
|
NULL
|
|
-s
|
NULL
|
NULL
|
NULL
|
|
boo
|
NULL
|
NULL
|
NULL
|
|
|
NULL
|
NULL
|
NULL
|
|
p
|
NULL
|
NULL
|
NULL
|
|
p
|
NULL
|
NULL
|
NULL
|
|
p
|
NULL
|
NULL
|
NULL
|
|
p
|
NULL
|
NULL
|
NULL
|
|
p
|
NULL
|
NULL
|
NULL
|
|
p
|
NULL
|
NULL
|
NULL
|
|
p
|
NULL
|
NULL
|
NULL
|
|
p
|
NULL
|
NULL
|
NULL
|
|
p
|
NULL
|
NULL
|
NULL
|
|
p
|
NULL
|
NULL
|
NULL
|
|
p
|
NULL
|
NULL
|
NULL
|
|
p
|
NULL
|
NULL
|
NULL
|
|
p
|
NULL
|
NULL
|
NULL
|