NULL
|
Firefox
|
Firefox - Choose User Profile
|
NULL
|
NULL
|
Firefox
|
Firefox - Choose User Profile
|
NULL
|
|
# Schema of every important table
curl -s -X POST # Schema of every important table
curl -s -X POST http://localhost:3030/raw_sql \
-H "Content-Type: application/json" \
-d '{"query": "PRAGMA table_info(frames)"}' | python3 -m json.tool
curl -s -X POST http://localhost:3030/raw_sql \
-H "Content-Type: application/json" \
-d '{"query": "PRAGMA table_info(elements)"}' | python3 -m json.tool
curl -s -X POST http://localhost:3030/raw_sql \
-H "Content-Type: application/json" \
-d '{"query": "PRAGMA table_info(ui_events)"}' | python3 -m json.tool
curl -s -X POST http://localhost:3030/raw_sql \
-H "Content-Type: application/json" \
-d '{"query": "PRAGMA table_info(memories)"}' | python3 -m json.tool...
|
NULL
|
NULL
|
NULL
|
|
|
NULL
|
NULL
|
NULL
|
NULL
|
Firefox
|
Firefox - Choose User Profile
|
NULL
|
NULL
|
Firefox
|
Firefox - Choose User Profile
|
NULL
|
NULL
|
Firefox
|
Firefox - Choose User Profile
|
NULL
|
NULL
|
Firefox
|
Firefox - Choose User Profile
|
NULL
|
NULL
|
Firefox
|
Firefox - Choose User Profile
|
NULL
|
|
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~ $ # All lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~ $ # All confirmed params:
curl "[URL_WITH_CREDENTIALS] ~ $ # Schema of every important table
curl -s -X POST http://localhost:3030/raw_sql \
-H "Content-Type: application/json" \
-d '{"query": "PRAGMA table_info(frames)"}' | python3 -m json.tool
curl -s -X POST http://localhost:3030/raw_sql \
-H "Content-Type: application/json" \
-d '{"query": "PRAGMA table_info(elements)"}' | python3 -m json.tool
curl -s -X POST http://localhost:3030/ra......
|
NULL
|
NULL
|
NULL
|
NULL
|
Firefox
|
Firefox - Choose User Profile
|
NULL
|
|
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~ $ # All lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~ $ # All confirmed params:
curl "[URL_WITH_CREDENTIALS] ~ $ # Schema of every important table
curl -s -X POST http://localhost:3030/raw_sql \
-H "Content-Type: application/json" \
-d '{"query": "PRAGMA table_info(frames)"}' | python3 -m json.tool
curl -s -X POST http://localhost:3030/raw_sql \
-H "Content-Type: application/json" \
-d '{"query": "PRAGMA table_info(elements)"}' | python3 -m json.tool
curl -s -X POST http://localhost:3030/ra......
|
NULL
|
NULL
|
NULL
|
NULL
|
Firefox
|
Firefox - Choose User Profile
|
NULL
|
NULL
|
Firefox
|
Firefox - Choose User Profile
|
NULL
|
NULL
|
Firefox
|
Firefox - Choose User Profile
|
NULL
|
|
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~ $ # All lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~ $ # All confirmed params:
curl "[URL_WITH_CREDENTIALS] ~ $ # Schema of every important table
curl -s -X POST http://localhost:3030/raw_sql \
-H "Content-Type: application/json" \
-d '{"query": "PRAGMA table_info(frames)"}' | python3 -m json.tool
curl -s -X POST http://localhost:3030/raw_sql \
-H "Content-Type: application/json" \
-d '{"query": "PRAGMA table_info(elements)"}' | python3 -m json.tool
curl -s -X POST http://localhost:3030/ra......
|
NULL
|
NULL
|
NULL
|
NULL
|
Firefox
|
Firefox - Choose User Profile
|
NULL
|
NULL
|
Firefox
|
Firefox - Choose User Profile
|
NULL
|
|
cleqr
|
NULL
|
NULL
|
NULL
|
|
ar
|
NULL
|
NULL
|
NULL
|
|
|
NULL
|
NULL
|
NULL
|
NULL
|
Firefox
|
Firefox - Choose User Profile
|
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, 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
|
NULL
|
Firefox
|
Firefox - Choose User Profile
|
NULL
|
NULL
|
Firefox
|
Firefox - Choose User Profile
|
NULL
|
NULL
|
Firefox
|
Firefox - Choose User Profile
|
NULL
|
NULL
|
Firefox
|
Firefox - Choose User Profile
|
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
|
NULL
|
Firefox
|
Firefox - Choose User Profile
|
NULL
|
NULL
|
Firefox
|
Firefox - Choose User Profile
|
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
|
NULL
|
Firefox
|
Firefox - Choose User Profile
|
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
|
NULL
|
Firefox
|
Firefox - Choose User Profile
|
NULL
|
NULL
|
Firefox
|
Firefox - Choose User Profile
|
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
|
NULL
|
Firefox
|
Firefox - Choose User Profile
|
NULL
|
NULL
|
Firefox
|
Firefox - Choose User Profile
|
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
|
NULL
|
Firefox
|
Firefox - Choose User Profile
|
NULL
|
NULL
|
Firefox
|
Firefox - Choose User Profile
|
NULL
|
|
clear
|
NULL
|
NULL
|
NULL
|
NULL
|
Firefox
|
Firefox - Choose User Profile
|
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
|
NULL
|
Firefox
|
Firefox - Choose User Profile
|
NULL
|
NULL
|
Firefox
|
Firefox - Choose User Profile
|
NULL
|
NULL
|
Firefox
|
Firefox - Choose User Profile
|
NULL
|