|
20130
|
433
|
2
|
2026-04-15T08:27:16.613683+00:00
|
/Users/lukas/.screenpipe/data/data/2026-04-15/1776 /Users/lukas/.screenpipe/data/data/2026-04-15/1776241636613_m1.jpg...
|
NULL
|
NULL
|
1
|
NULL
|
monitor_1
|
NULL
|
NULL
|
NULL
|
NULL
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelpSupport Daily • in 3 h 33 m100% <478-zshWed 15 Apr 11:27:16T81DOCKER₴81DEV (-zsh)₴82APP (-zsh)83ec2-user@ip-10-...884-zsh*5-zsh86-zshFirefox 36613405.6885245901611iTerm2|1012601.110UserNotificationCenter|1|664.010Tailscalel213256.510Raycast|2|1539.510QuickTime Player|1513574.3333333333310Preview|112829.010Finder|3812407.4473684210510Dial6312062.6507936507910CoreServicesUIAgent|1|1962.010Control Centrel1214385.8333333333310lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ du -sh~/.screenpipe2.6G/Users/lukas/.screenpipelukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ du -sh~/.screenpipe/*4.0K1.3G/Users/lukas/.screenpipe/config.json/Users/lukas/.screenpipe/data1.3G/Users/lukas/.screenpipe/db.sqlite64K/Users/lukas/.screenpipe/db.sqlite-shm16M/Users/lukas/.screenpipe/db.sqlite-wal24K/Users/lukas/.screenpipe/pipes132K/Users/lukas/.screenpipe/screenpipe.2026-04-09.0.10g96K/Users/lukas/.screenpipe/screenpipe.2026-04-11.0.log72K/Users/lukas/.screenpipe/screenpipe.2026-04-12.0.log72K/Users/lukas/.screenpipe/screenpipe.2026-04-13.0.log196K/Users/lukas/.screenpipe/screenpipe.2026-04-14.0.10glukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $cp -r ~/.screenpipe/data/data/2026-04-13 /Nolumes/Test/screenpipe/data/lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $cp -r ~/.screenpipe/data/data/2026-04-14 /Volumes/Test/screenpipe/data/lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ cp ~/.screenpipe/db.sqlite /Volumes/Test/screenpipe/db.sqliteLukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $cp ~/.screenpipe/db.sqlite /Volumes/Test/screenpipe/db.sqlitelukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ du -sh ~/.screenpipe2.7G/Users/lukas/.screenpipelukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ du -sh ~/.screenpipe/*4.0K/Users/lukas/.screenpipe/config.json1.3G/Users/lukas/.screenpipe/data1.4G64K/Users/lukas/.screenpipe/db.sqlite/Users/lukas/.screenpipe/db.sqlite-shm7.0M/Users/lukas/.screenpipe/db.sqlite-wal24K/Users/lukas/.screenpipe/pipes132K/Users/lukas/.screenpipe/screenpipe.2026-04-09.0.1og96K/Users/lukas/.screenpipe/screenpipe.2026-04-11.0.log72K/Users/lukas/.screenpipe/screenpipe.2026-04-12.0.log72K/Users/lukas/.screenpipe/screenpipe.2026-04-13.0.log160K/Users/lukas/.screenpipe/screenpipe.2026-04-14.0.log60K/Users/lukas/.screenpipe/screenpipe.2026-04-15.0.1oglukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ UO ₴7.* Unable to a...O 88-zsh...
|
NULL
|
-2190339669314861726
|
NULL
|
click
|
ocr
|
NULL
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelpSupport Daily • in 3 h 33 m100% <478-zshWed 15 Apr 11:27:16T81DOCKER₴81DEV (-zsh)₴82APP (-zsh)83ec2-user@ip-10-...884-zsh*5-zsh86-zshFirefox 36613405.6885245901611iTerm2|1012601.110UserNotificationCenter|1|664.010Tailscalel213256.510Raycast|2|1539.510QuickTime Player|1513574.3333333333310Preview|112829.010Finder|3812407.4473684210510Dial6312062.6507936507910CoreServicesUIAgent|1|1962.010Control Centrel1214385.8333333333310lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ du -sh~/.screenpipe2.6G/Users/lukas/.screenpipelukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ du -sh~/.screenpipe/*4.0K1.3G/Users/lukas/.screenpipe/config.json/Users/lukas/.screenpipe/data1.3G/Users/lukas/.screenpipe/db.sqlite64K/Users/lukas/.screenpipe/db.sqlite-shm16M/Users/lukas/.screenpipe/db.sqlite-wal24K/Users/lukas/.screenpipe/pipes132K/Users/lukas/.screenpipe/screenpipe.2026-04-09.0.10g96K/Users/lukas/.screenpipe/screenpipe.2026-04-11.0.log72K/Users/lukas/.screenpipe/screenpipe.2026-04-12.0.log72K/Users/lukas/.screenpipe/screenpipe.2026-04-13.0.log196K/Users/lukas/.screenpipe/screenpipe.2026-04-14.0.10glukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $cp -r ~/.screenpipe/data/data/2026-04-13 /Nolumes/Test/screenpipe/data/lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $cp -r ~/.screenpipe/data/data/2026-04-14 /Volumes/Test/screenpipe/data/lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ cp ~/.screenpipe/db.sqlite /Volumes/Test/screenpipe/db.sqliteLukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $cp ~/.screenpipe/db.sqlite /Volumes/Test/screenpipe/db.sqlitelukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ du -sh ~/.screenpipe2.7G/Users/lukas/.screenpipelukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ du -sh ~/.screenpipe/*4.0K/Users/lukas/.screenpipe/config.json1.3G/Users/lukas/.screenpipe/data1.4G64K/Users/lukas/.screenpipe/db.sqlite/Users/lukas/.screenpipe/db.sqlite-shm7.0M/Users/lukas/.screenpipe/db.sqlite-wal24K/Users/lukas/.screenpipe/pipes132K/Users/lukas/.screenpipe/screenpipe.2026-04-09.0.1og96K/Users/lukas/.screenpipe/screenpipe.2026-04-11.0.log72K/Users/lukas/.screenpipe/screenpipe.2026-04-12.0.log72K/Users/lukas/.screenpipe/screenpipe.2026-04-13.0.log160K/Users/lukas/.screenpipe/screenpipe.2026-04-14.0.log60K/Users/lukas/.screenpipe/screenpipe.2026-04-15.0.1oglukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ UO ₴7.* Unable to a...O 88-zsh...
|
20129
|
NULL
|
|
20131
|
434
|
1
|
2026-04-15T08:27:16.593255+00:00
|
/Users/lukas/.screenpipe/data/data/2026-04-15/1776 /Users/lukas/.screenpipe/data/data/2026-04-15/1776241636593_m2.jpg...
|
NULL
|
NULL
|
1
|
NULL
|
monitor_2
|
NULL
|
NULL
|
NULL
|
NULL
|
CaudeFileEoit000+ New chatQ SearchcustomizeChatsPr CaudeFileEoit000+ New chatQ SearchcustomizeChatsProjects88 ArtifactsStarredBulgarian citizenship application...Dawarich location tracking projecthecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter API...Screenpipe 14-day retention exp...neaalt nomepage reed overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso...Importing Google Timeline data t...chromecast remote volume buct...Screenpipe free version guideSelf-hosted LLM alternatives to .Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General niorm.ron realestRed dots on neck causesViewWindowHelp. 40 ll#Support Daily - in 3h 33 m100% C•8Wed 15 Apr 11:27:16ChatLOWOrkCodeLinux SQLite Ul for NAS v• (pipe_executions)/ (pipe_scheduler_state - Screenpipe "pipes" (plugins) runhistory• (vi_events) — UI interaction eventssqlx migrations- migration version tracking•(sqlite_sequence) - SQLite autoincrement countersTo get size per table + schema, run this in the Query tab:SELECTWlallie,(SELECT COUNT(*) FROM sqlite_master WHERE type='table' AND name=m.name) as existsFROM sqlite masterwaonr tvoe- ragleURDER bY name;For row counts + estimated size:SELECT'video_chunks' as tbl, COUNT(*) as rows FROM video_chunksUNION ALL SELECT'audio_chunks', COUNT(*) FROM audio_chunksUNION ALL SELECT'frames', COUNT(*) FROM framesUNION ALL SELECT'ocr_text', COUNT(*) FROM ocr_textUNION ALL SELECT'audio_transcriptions', COUNT(*) FROM audio_transcriptionsUNION ALL SELECT'elements',COUNT (*) FROM elementsUNION ALL SCLECIcourx rrov menorlesUNION ALL SELECT'meetings', COUNT(*) FROM meetingsUNION ALL SELECT'ui_events', COUNT(*) FROM vi_eventsUNION ALL SELECT'pipe_executions',COUNT (*) FROM pipe_executions;For actual byte size per table (SQLite page-level):SELECTpgsize * pageno / 1024 / 1024 as size_mbrru dostadWHERE aggregate = TRUEORDER BY pgsize * pageno DESC;Updated to 1.2581.0RelaunchLukas KovalikPro nianRegarding retention - yes, you need a strategy. Screenpipe has a built-in retention setting(in its config) that deletes old video/audio files + their DB rows after N days. The problemfor your NAS sync architecture is:Reply...sonnet 46 vClaudtro mrand can make mistakes. rlease double-cneck responses....
|
NULL
|
-4065707857065288930
|
NULL
|
click
|
ocr
|
NULL
|
CaudeFileEoit000+ New chatQ SearchcustomizeChatsPr CaudeFileEoit000+ New chatQ SearchcustomizeChatsProjects88 ArtifactsStarredBulgarian citizenship application...Dawarich location tracking projecthecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter API...Screenpipe 14-day retention exp...neaalt nomepage reed overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso...Importing Google Timeline data t...chromecast remote volume buct...Screenpipe free version guideSelf-hosted LLM alternatives to .Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General niorm.ron realestRed dots on neck causesViewWindowHelp. 40 ll#Support Daily - in 3h 33 m100% C•8Wed 15 Apr 11:27:16ChatLOWOrkCodeLinux SQLite Ul for NAS v• (pipe_executions)/ (pipe_scheduler_state - Screenpipe "pipes" (plugins) runhistory• (vi_events) — UI interaction eventssqlx migrations- migration version tracking•(sqlite_sequence) - SQLite autoincrement countersTo get size per table + schema, run this in the Query tab:SELECTWlallie,(SELECT COUNT(*) FROM sqlite_master WHERE type='table' AND name=m.name) as existsFROM sqlite masterwaonr tvoe- ragleURDER bY name;For row counts + estimated size:SELECT'video_chunks' as tbl, COUNT(*) as rows FROM video_chunksUNION ALL SELECT'audio_chunks', COUNT(*) FROM audio_chunksUNION ALL SELECT'frames', COUNT(*) FROM framesUNION ALL SELECT'ocr_text', COUNT(*) FROM ocr_textUNION ALL SELECT'audio_transcriptions', COUNT(*) FROM audio_transcriptionsUNION ALL SELECT'elements',COUNT (*) FROM elementsUNION ALL SCLECIcourx rrov menorlesUNION ALL SELECT'meetings', COUNT(*) FROM meetingsUNION ALL SELECT'ui_events', COUNT(*) FROM vi_eventsUNION ALL SELECT'pipe_executions',COUNT (*) FROM pipe_executions;For actual byte size per table (SQLite page-level):SELECTpgsize * pageno / 1024 / 1024 as size_mbrru dostadWHERE aggregate = TRUEORDER BY pgsize * pageno DESC;Updated to 1.2581.0RelaunchLukas KovalikPro nianRegarding retention - yes, you need a strategy. Screenpipe has a built-in retention setting(in its config) that deletes old video/audio files + their DB rows after N days. The problemfor your NAS sync architecture is:Reply...sonnet 46 vClaudtro mrand can make mistakes. rlease double-cneck responses....
|
20128
|
NULL
|
|
20132
|
433
|
3
|
2026-04-15T08:27:17.912277+00:00
|
/Users/lukas/.screenpipe/data/data/2026-04-15/1776 /Users/lukas/.screenpipe/data/data/2026-04-15/1776241637912_m1.jpg...
|
NULL
|
NULL
|
1
|
NULL
|
monitor_1
|
NULL
|
NULL
|
NULL
|
NULL
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelpSupport Daily • in 3 h 33 m100% <478-zshWed 15 Apr 11:27:17181DOCKER₴81DEV (-zsh)₴82APP (-zsh)83ec2-user@ip-10-...884-zsh*5-zsh86-zshFirefox 36613405.6885245901611iTerm2|1012601.110UserNotificationCenter|1|664.010Tailscalel213256.510Raycast|2|1539.510QuickTime Player|1513574.3333333333310Preview|112829.010Finder|3812407.4473684210510Dial6312062.6507936507910CoreServicesUIAgent|1|1962.010Control Centrel1214385.8333333333310lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ du -sh~/.screenpipe2.6G/Users/lukas/.screenpipelukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ du -sh~/.screenpipe/*4.0K1.3G/Users/lukas/.screenpipe/config.json/Users/lukas/.screenpipe/data1.3G/Users/lukas/.screenpipe/db.sqlite64K/Users/lukas/.screenpipe/db.sqlite-shm16M/Users/lukas/.screenpipe/db.sqlite-wal24K/Users/lukas/.screenpipe/pipes132K/Users/lukas/.screenpipe/screenpipe.2026-04-09.0.10g96K/Users/lukas/.screenpipe/screenpipe.2026-04-11.0.log72K/Users/lukas/.screenpipe/screenpipe.2026-04-12.0.log72K/Users/lukas/.screenpipe/screenpipe.2026-04-13.0.log196K/Users/lukas/.screenpipe/screenpipe.2026-04-14.0.10glukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $cp -r ~/.screenpipe/data/data/2026-04-13 /Nolumes/Test/screenpipe/data/lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $cp -r ~/.screenpipe/data/data/2026-04-14 /Volumes/Test/screenpipe/data/lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ cp ~/.screenpipe/db.sqlite /Volumes/Test/screenpipe/db.sqliteLukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $cp ~/.screenpipe/db.sqlite /Volumes/Test/screenpipe/db.sqlitelukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ du -sh ~/.screenpipe2.7G/Users/lukas/.screenpipelukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ du -sh ~/.screenpipe/*4.0K/Users/lukas/.screenpipe/config.json1.3G/Users/lukas/.screenpipe/data1.4G64K/Users/lukas/.screenpipe/db.sqlite/Users/lukas/.screenpipe/db.sqlite-shm7.0M/Users/lukas/.screenpipe/db.sqlite-wal24K/Users/lukas/.screenpipe/pipes132K/Users/lukas/.screenpipe/screenpipe.2026-04-09.0.1og96K/Users/lukas/.screenpipe/screenpipe.2026-04-11.0.log72K/Users/lukas/.screenpipe/screenpipe.2026-04-12.0.log72K/Users/lukas/.screenpipe/screenpipe.2026-04-13.0.log160K/Users/lukas/.screenpipe/screenpipe.2026-04-14.0.log60K/Users/lukas/.screenpipe/screenpipe.2026-04-15.0.1oglukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ UO ₴7.* Unable to a...O 88-zsh...
|
NULL
|
-1737508003430583581
|
NULL
|
click
|
ocr
|
NULL
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelpSupport Daily • in 3 h 33 m100% <478-zshWed 15 Apr 11:27:17181DOCKER₴81DEV (-zsh)₴82APP (-zsh)83ec2-user@ip-10-...884-zsh*5-zsh86-zshFirefox 36613405.6885245901611iTerm2|1012601.110UserNotificationCenter|1|664.010Tailscalel213256.510Raycast|2|1539.510QuickTime Player|1513574.3333333333310Preview|112829.010Finder|3812407.4473684210510Dial6312062.6507936507910CoreServicesUIAgent|1|1962.010Control Centrel1214385.8333333333310lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ du -sh~/.screenpipe2.6G/Users/lukas/.screenpipelukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ du -sh~/.screenpipe/*4.0K1.3G/Users/lukas/.screenpipe/config.json/Users/lukas/.screenpipe/data1.3G/Users/lukas/.screenpipe/db.sqlite64K/Users/lukas/.screenpipe/db.sqlite-shm16M/Users/lukas/.screenpipe/db.sqlite-wal24K/Users/lukas/.screenpipe/pipes132K/Users/lukas/.screenpipe/screenpipe.2026-04-09.0.10g96K/Users/lukas/.screenpipe/screenpipe.2026-04-11.0.log72K/Users/lukas/.screenpipe/screenpipe.2026-04-12.0.log72K/Users/lukas/.screenpipe/screenpipe.2026-04-13.0.log196K/Users/lukas/.screenpipe/screenpipe.2026-04-14.0.10glukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $cp -r ~/.screenpipe/data/data/2026-04-13 /Nolumes/Test/screenpipe/data/lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $cp -r ~/.screenpipe/data/data/2026-04-14 /Volumes/Test/screenpipe/data/lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ cp ~/.screenpipe/db.sqlite /Volumes/Test/screenpipe/db.sqliteLukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $cp ~/.screenpipe/db.sqlite /Volumes/Test/screenpipe/db.sqlitelukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ du -sh ~/.screenpipe2.7G/Users/lukas/.screenpipelukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ du -sh ~/.screenpipe/*4.0K/Users/lukas/.screenpipe/config.json1.3G/Users/lukas/.screenpipe/data1.4G64K/Users/lukas/.screenpipe/db.sqlite/Users/lukas/.screenpipe/db.sqlite-shm7.0M/Users/lukas/.screenpipe/db.sqlite-wal24K/Users/lukas/.screenpipe/pipes132K/Users/lukas/.screenpipe/screenpipe.2026-04-09.0.1og96K/Users/lukas/.screenpipe/screenpipe.2026-04-11.0.log72K/Users/lukas/.screenpipe/screenpipe.2026-04-12.0.log72K/Users/lukas/.screenpipe/screenpipe.2026-04-13.0.log160K/Users/lukas/.screenpipe/screenpipe.2026-04-14.0.log60K/Users/lukas/.screenpipe/screenpipe.2026-04-15.0.1oglukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ UO ₴7.* Unable to a...O 88-zsh...
|
NULL
|
NULL
|
|
20133
|
434
|
2
|
2026-04-15T08:27:17.946470+00:00
|
/Users/lukas/.screenpipe/data/data/2026-04-15/1776 /Users/lukas/.screenpipe/data/data/2026-04-15/1776241637946_m2.jpg...
|
NULL
|
NULL
|
1
|
NULL
|
monitor_2
|
NULL
|
NULL
|
NULL
|
NULL
|
CaudeFileEoit000+ New chatQ SearchcustomizeChatsPr CaudeFileEoit000+ New chatQ SearchcustomizeChatsProjects88 ArtifactsStarredBulgarian citizenship application...Dawarich location tracking projecthecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter API...Screenpipe 14-day retention exp...neaalt nomepage reed overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso...Importing Google Timeline data t...chromecast remote volume buct...Screenpipe free version guideSelf-hosted LLM alternatives to .Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General niorm.ron realestRed dots on neck causesViewWindowHelp. 40 ll#Support Daily • in 3h 33m100% C8Wed 15 Apr 11:27:17ChatcoworkCodeLinux SQLite Ul for NAS v• (pipe_executions)/ (pipe_scheduler_state - Screenpipe "pipes" (plugins) runhistory• (vi_events) — UI interaction eventssqlx migrations- migration version tracking•(sqlite_sequence) - SQLite autoincrement countersTo get size per table + schema, run this in the Query tab:SELECTWlallie,(SELECT COUNT(*) FROM sqlite_master WHERE type='table' AND name=m.name) as existsFROM sqlite masterwaonr tvoe- ragleURDER bY name:For row counts + estimated size:SELECT'video_chunks' as tbl, COUNT(*) as rows FROM video_chunksUNION ALL SELECT 'audio_chunks', COUNT(*) FROM audio_chunksUNION ALL SELECT'frames', COUNT(*) FROM framesUNION ALL SELECT'ocr_text', COUNT(*) FROM ocr_textUNION ALL SELECT'audio_transcriptions', COUNT(*) FROM audio_transcriptionsUNION ALL SELECT'elements',COUNT (*) FROM elementsUNION ALL SCLECICOUNT(*) FROM memoriesUNION ALL SELECT'meetings', COUNT(*) FROM meetingsUNION ALL SELECT'ui_events', COUNT(*) FROM vi_eventsUNION ALL SELECT'pipe_executions',COUNT (*) FROM pipe_executions;For actual byte size per table (SQLite page-level):SELECTPgsize * pageno / 1024 / 1024 as size_mbrru dostadWHERE aggregate = TRUEORDER BY pgsize * pageno DESC;CopyUpdated to 1.2581.0RelaunchLukas KovalikPro nianRegarding retention - yes, you need a strategy. Screenpipe has a built-in retention setting(in its config) that deletes old video/audio files + their DB rows after N days. The problemfor your NAS sync architecture is:Reply...sonnet 46 vClaudtro mrand can make mistakes. rlease double-cneck responses....
|
NULL
|
7803490300253883791
|
NULL
|
click
|
ocr
|
NULL
|
CaudeFileEoit000+ New chatQ SearchcustomizeChatsPr CaudeFileEoit000+ New chatQ SearchcustomizeChatsProjects88 ArtifactsStarredBulgarian citizenship application...Dawarich location tracking projecthecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter API...Screenpipe 14-day retention exp...neaalt nomepage reed overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso...Importing Google Timeline data t...chromecast remote volume buct...Screenpipe free version guideSelf-hosted LLM alternatives to .Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General niorm.ron realestRed dots on neck causesViewWindowHelp. 40 ll#Support Daily • in 3h 33m100% C8Wed 15 Apr 11:27:17ChatcoworkCodeLinux SQLite Ul for NAS v• (pipe_executions)/ (pipe_scheduler_state - Screenpipe "pipes" (plugins) runhistory• (vi_events) — UI interaction eventssqlx migrations- migration version tracking•(sqlite_sequence) - SQLite autoincrement countersTo get size per table + schema, run this in the Query tab:SELECTWlallie,(SELECT COUNT(*) FROM sqlite_master WHERE type='table' AND name=m.name) as existsFROM sqlite masterwaonr tvoe- ragleURDER bY name:For row counts + estimated size:SELECT'video_chunks' as tbl, COUNT(*) as rows FROM video_chunksUNION ALL SELECT 'audio_chunks', COUNT(*) FROM audio_chunksUNION ALL SELECT'frames', COUNT(*) FROM framesUNION ALL SELECT'ocr_text', COUNT(*) FROM ocr_textUNION ALL SELECT'audio_transcriptions', COUNT(*) FROM audio_transcriptionsUNION ALL SELECT'elements',COUNT (*) FROM elementsUNION ALL SCLECICOUNT(*) FROM memoriesUNION ALL SELECT'meetings', COUNT(*) FROM meetingsUNION ALL SELECT'ui_events', COUNT(*) FROM vi_eventsUNION ALL SELECT'pipe_executions',COUNT (*) FROM pipe_executions;For actual byte size per table (SQLite page-level):SELECTPgsize * pageno / 1024 / 1024 as size_mbrru dostadWHERE aggregate = TRUEORDER BY pgsize * pageno DESC;CopyUpdated to 1.2581.0RelaunchLukas KovalikPro nianRegarding retention - yes, you need a strategy. Screenpipe has a built-in retention setting(in its config) that deletes old video/audio files + their DB rows after N days. The problemfor your NAS sync architecture is:Reply...sonnet 46 vClaudtro mrand can make mistakes. rlease double-cneck responses....
|
NULL
|
NULL
|
|
20140
|
433
|
7
|
2026-04-15T08:28:33.286708+00:00
|
/Users/lukas/.screenpipe/data/data/2026-04-15/1776 /Users/lukas/.screenpipe/data/data/2026-04-15/1776241713286_m1.jpg...
|
NULL
|
NULL
|
1
|
NULL
|
monitor_1
|
NULL
|
NULL
|
NULL
|
NULL
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelpSupport Daily - in 3 h 32 m100% <47-zsh8Wed 15 Apr 11:28:33T₴1DOCKER₴81DEV (-zsh)H82APP (-zsh)83ec2-user@ip-10-.. 884-zsh60K/Users/lukas/.screenpipe/screenpipe.2026-04-15.0.1oglukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ sqlite3~/.screenpipe/db.sqlite"SELECTname,pgsizepageno / 1024 / 1024 assize_mbFROMdbstatWHEREaggregate = TRUEORDER BY pgsize * pageno DESC;"ocr_textl64681806frames147636741elements/9058218frames_fts_content|2282176idx_elements_frame_source_rolel270725idx_elements_source_role_textl264067elements_fts_datal166311frames_fts_datal156816idx_elements_frame_sourcel136761idx_elements_sourcel86289idx_elements_frame_idl55048elements_fts_docsizel50120idx_elements_parent_idl39775ui_events|4996idx_ui_events_session_idl438idx_ui_events_timestamp|353idx_frames_timestamp_devicel315idx_frames_timestamp|197ui_events_fts_datal159idx_ui_events_event_typel35idx_ui_events_app_name|33ui_events_fts_docsizel26frames_fts_docsizel19idx_ui_events_frame_idl14idx_ui_events_sync_idl14idx_ui_events_synced_at|14idx_ui_events_unsynced|14idx_frames_video_chunk_idl12idx_ocr_text_frame_app_windowl10idx_ocr_text_lengthl7idx_ocr_text_frame_idl7idx_frames_elements_ref_frame_idl3frames_fts_idxl2elements_fts_idx|1video_chunks10sqlite_schemaloidx_frames_snapshot_pathi0*5-zsh86-zshO ₴7.* Unable to a...O 88-zsh...
|
NULL
|
-7685335999440023546
|
NULL
|
visual_change
|
ocr
|
NULL
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelpSupport Daily - in 3 h 32 m100% <47-zsh8Wed 15 Apr 11:28:33T₴1DOCKER₴81DEV (-zsh)H82APP (-zsh)83ec2-user@ip-10-.. 884-zsh60K/Users/lukas/.screenpipe/screenpipe.2026-04-15.0.1oglukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ sqlite3~/.screenpipe/db.sqlite"SELECTname,pgsizepageno / 1024 / 1024 assize_mbFROMdbstatWHEREaggregate = TRUEORDER BY pgsize * pageno DESC;"ocr_textl64681806frames147636741elements/9058218frames_fts_content|2282176idx_elements_frame_source_rolel270725idx_elements_source_role_textl264067elements_fts_datal166311frames_fts_datal156816idx_elements_frame_sourcel136761idx_elements_sourcel86289idx_elements_frame_idl55048elements_fts_docsizel50120idx_elements_parent_idl39775ui_events|4996idx_ui_events_session_idl438idx_ui_events_timestamp|353idx_frames_timestamp_devicel315idx_frames_timestamp|197ui_events_fts_datal159idx_ui_events_event_typel35idx_ui_events_app_name|33ui_events_fts_docsizel26frames_fts_docsizel19idx_ui_events_frame_idl14idx_ui_events_sync_idl14idx_ui_events_synced_at|14idx_ui_events_unsynced|14idx_frames_video_chunk_idl12idx_ocr_text_frame_app_windowl10idx_ocr_text_lengthl7idx_ocr_text_frame_idl7idx_frames_elements_ref_frame_idl3frames_fts_idxl2elements_fts_idx|1video_chunks10sqlite_schemaloidx_frames_snapshot_pathi0*5-zsh86-zshO ₴7.* Unable to a...O 88-zsh...
|
20136
|
NULL
|
|
20142
|
434
|
7
|
2026-04-15T08:28:54.543665+00:00
|
/Users/lukas/.screenpipe/data/data/2026-04-15/1776 /Users/lukas/.screenpipe/data/data/2026-04-15/1776241734543_m2.jpg...
|
NULL
|
NULL
|
1
|
NULL
|
monitor_2
|
NULL
|
NULL
|
NULL
|
NULL
|
FirefoxFileEoitViewHistoryBookmarksProfilesToolsWi FirefoxFileEoitViewHistoryBookmarksProfilesToolsWindow HelpNew chatQ SearchLinux SQLite Ul for NAScustomizeChatsProjects88 ArtifactsStarredBulgarian citizenship application..Dawarich location tracking projecthecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter API...Screenpipe 14-day retention exp...neaalt nomepage reea overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso...Importing Google Timeline data t...chromecast remote volume buct...Screenpipe free version guideSelf-hosted LLM alternatives to .Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General niorm.ron realestRed dots on neck causesUpdated to 1.2581.0RelaunchLukas KovalikPro nianC+40kiCCSepportaily in 3h 32mA100% C2. 8 Wed 15 Apr 11:28:54p! Western Digital Red Plus 3.5 6TB 5400rpm 256MB SASi I SeneticТвърд диск, Western Digital Red 6TB Plus ( 3.5", 256k@ SQLite Web: db.sqlite→ Screenpipe Dashboaro+ New lab• Not Secure http://[IP_ADDRESS]:8767/video_chunks/sqlite-web 0.7.2 db.sqlite video_chunkstable name.._sqlx_migrationsaudio_chunksaudio_tagsaudio_transcriptionsaudio_transcriptions_fts (v)audio_transcriptions_.audio_transcriptions_audio_transcriptions_...elementselements_fts (v)elements_fts_configelements_fts_dataelements_fts_idxframesframes_fts (v)frames_fts_configframes_fts_dataframes_fts_idxmeetingsmemoriesmemories_fts (v)memories_fts_configmemories_fts_datamemories_fts_idxocr_textpipe_executionspipe_scheduler_statespeaker_embeddingsspeakerssqlite_sequencetagsui_eventsui_events_fts (v)ui_events_fts_configui_events_fts_dataui_events_fts_idxvideo_chunksvision_tagsSQLite database browser v0.7.2, powered by Flask and Peewee. © 2026 Charles LeiferToggle helper tablesStructureContentQueryExportSQLCREATE TABLE video_chunks(id INTEGER PRIMARY KEY AUTOINCREMENT,file_path TEXT NOT NULL,device_name TEXT NOT NULL DEFAULT "',sync_id TEXT,machine_id TEXT,synced_at DATETIME,fps REAL NOT NULL DEFAULT 0.5,cloud_blob_id TEXT DEFAULT NULLColumnsColumnfile_pathdevice_namesync_idmachine_idsynced_atfpscloud_blob_idIndexesNameidx_video_chunks_cloud_blob_ididx_video_chunks_device_nameidx_video_chunks_device_name_id=Allow nullPrimary keyColumnscloud_blob_iddevice_name: devsce_naneUniqueSQLSQLSQLSQLActionsread-onlyread-onlyread-onlyread-onlyread-onlyread-onlyread-onlyread-onlyDrop?read-onivread-onlyread-onlyhttp://[IP_ADDRESS]:8767/frames/...
|
NULL
|
4198894765132019474
|
NULL
|
visual_change
|
ocr
|
NULL
|
FirefoxFileEoitViewHistoryBookmarksProfilesToolsWi FirefoxFileEoitViewHistoryBookmarksProfilesToolsWindow HelpNew chatQ SearchLinux SQLite Ul for NAScustomizeChatsProjects88 ArtifactsStarredBulgarian citizenship application..Dawarich location tracking projecthecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter API...Screenpipe 14-day retention exp...neaalt nomepage reea overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso...Importing Google Timeline data t...chromecast remote volume buct...Screenpipe free version guideSelf-hosted LLM alternatives to .Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General niorm.ron realestRed dots on neck causesUpdated to 1.2581.0RelaunchLukas KovalikPro nianC+40kiCCSepportaily in 3h 32mA100% C2. 8 Wed 15 Apr 11:28:54p! Western Digital Red Plus 3.5 6TB 5400rpm 256MB SASi I SeneticТвърд диск, Western Digital Red 6TB Plus ( 3.5", 256k@ SQLite Web: db.sqlite→ Screenpipe Dashboaro+ New lab• Not Secure http://[IP_ADDRESS]:8767/video_chunks/sqlite-web 0.7.2 db.sqlite video_chunkstable name.._sqlx_migrationsaudio_chunksaudio_tagsaudio_transcriptionsaudio_transcriptions_fts (v)audio_transcriptions_.audio_transcriptions_audio_transcriptions_...elementselements_fts (v)elements_fts_configelements_fts_dataelements_fts_idxframesframes_fts (v)frames_fts_configframes_fts_dataframes_fts_idxmeetingsmemoriesmemories_fts (v)memories_fts_configmemories_fts_datamemories_fts_idxocr_textpipe_executionspipe_scheduler_statespeaker_embeddingsspeakerssqlite_sequencetagsui_eventsui_events_fts (v)ui_events_fts_configui_events_fts_dataui_events_fts_idxvideo_chunksvision_tagsSQLite database browser v0.7.2, powered by Flask and Peewee. © 2026 Charles LeiferToggle helper tablesStructureContentQueryExportSQLCREATE TABLE video_chunks(id INTEGER PRIMARY KEY AUTOINCREMENT,file_path TEXT NOT NULL,device_name TEXT NOT NULL DEFAULT "',sync_id TEXT,machine_id TEXT,synced_at DATETIME,fps REAL NOT NULL DEFAULT 0.5,cloud_blob_id TEXT DEFAULT NULLColumnsColumnfile_pathdevice_namesync_idmachine_idsynced_atfpscloud_blob_idIndexesNameidx_video_chunks_cloud_blob_ididx_video_chunks_device_nameidx_video_chunks_device_name_id=Allow nullPrimary keyColumnscloud_blob_iddevice_name: devsce_naneUniqueSQLSQLSQLSQLActionsread-onlyread-onlyread-onlyread-onlyread-onlyread-onlyread-onlyread-onlyDrop?read-onivread-onlyread-onlyhttp://[IP_ADDRESS]:8767/frames/...
|
NULL
|
NULL
|
|
20147
|
433
|
10
|
2026-04-15T08:29:18.677844+00:00
|
/Users/lukas/.screenpipe/data/data/2026-04-15/1776 /Users/lukas/.screenpipe/data/data/2026-04-15/1776241758677_m1.jpg...
|
NULL
|
NULL
|
1
|
NULL
|
monitor_1
|
NULL
|
NULL
|
NULL
|
NULL
|
iTerm2ShellEditViewSessionScriptsProfilesWindowH iTerm2ShellEditViewSessionScriptsProfilesWindowHelp(abl• Support Daily - in 3 h 31 m100% <47-zshDOCKER₴81DEV (-zsh)₴82APP (-zsh)83ec2-user@ip-10-.. 884-zsh*5-zsh86-zsh16M/Users/lukas/.screenpipe/db.sqlite-wal24K/Users/lukas/.screenpipe/pipes132K/Users/lukas/.screenpipe/screenpipe.2026-04-09.0.log96K/Users/lukas/.screenpipe/screenpipe.2026-04-11.0.log72K/Users/lukas/.screenpipe/screenpipe.2026-04-12.0.1og72K/Users/lukas/.screenpipe/screenpipe.2026-04-13.0.log196K/Users/lukas/.screenpipe/screenpipe.2026-04-14.0.1oglukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe$cp -r ~/.screenpipe/data/data/2026-04-13 /Volumes/Test/screenpipe/data/lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe$cp-r ~/.screenpipe/data/data/2026-04-14 /Volumes/Test/screenpipe/data/lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $cp ~/.screenpipe/db.sqlite /Volumes/Test/screenpipe/db.sqlitelukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $lukas@Lukas-Kovaliks-MacBook-Pro-Jiminnycp ~/.screenpipe/db.sqlite /Volumes/Test/screenpipe/db.sqlite~/.screenpipe $ du -sh ~/.screenpipe2.7G/Users/lukas/.screenpipelukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ du -sh ~/.screenpipe/*4.0K1.3G/Users/lukas/.screenpipe/config.json/Users/lukas/.screenpipe/data1.4G/Users/lukas/.screenpipe/db.sqlite64K7.0M/Users/lukas/.screenpipe/db.sqlite-shm/Users/lukas/.screenpipe/db.sqlite-wal24K/Users/lukas/.screenpipe/pipes132K96K/Users/Lukas/.screenpipe/screenpipe.2026-04-09.0.10g/Users/lukas/.screenpipe/screenpipe.2026-04-11.0.log72K/Users/lukas/.screenpipe/screenpipe.2026-04-12.0.log72K/Users/lukas/.screenpipe/screenpipe.2026-04-13.0.log160K60K/Users/lukas/.screenpipe/screenpipe.2026-04-14.0.10g/Users/lukas/.screenpipe/screenpipe.2026-04-15.0.loglukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3~/.screenpipe/db.sqlite "SELECTname,pgsize * pageno / 1024 / 1024 as size_mbFROM dbstatWHERE aggregate = TRUEORDER BY pgsize * pageno DESC;"ocr_textl64681806frames147636741elements19058218frames_fts_content|2282176idx_elements_frame_source_rolel270725idx_elements_source_role_textl264067elements_fts_datal166311frames_fts_datal156816idx_elements_frame_sourcel136761idx_elements_source| 86289idx_elements_frame_idl55048elements_fts_docsizel50120O 87* Unable to a...888Wed 15 Apr 11:29:18T81-zsh+...
|
NULL
|
-586030057635384828
|
NULL
|
visual_change
|
ocr
|
NULL
|
iTerm2ShellEditViewSessionScriptsProfilesWindowH iTerm2ShellEditViewSessionScriptsProfilesWindowHelp(abl• Support Daily - in 3 h 31 m100% <47-zshDOCKER₴81DEV (-zsh)₴82APP (-zsh)83ec2-user@ip-10-.. 884-zsh*5-zsh86-zsh16M/Users/lukas/.screenpipe/db.sqlite-wal24K/Users/lukas/.screenpipe/pipes132K/Users/lukas/.screenpipe/screenpipe.2026-04-09.0.log96K/Users/lukas/.screenpipe/screenpipe.2026-04-11.0.log72K/Users/lukas/.screenpipe/screenpipe.2026-04-12.0.1og72K/Users/lukas/.screenpipe/screenpipe.2026-04-13.0.log196K/Users/lukas/.screenpipe/screenpipe.2026-04-14.0.1oglukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe$cp -r ~/.screenpipe/data/data/2026-04-13 /Volumes/Test/screenpipe/data/lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe$cp-r ~/.screenpipe/data/data/2026-04-14 /Volumes/Test/screenpipe/data/lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $cp ~/.screenpipe/db.sqlite /Volumes/Test/screenpipe/db.sqlitelukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $lukas@Lukas-Kovaliks-MacBook-Pro-Jiminnycp ~/.screenpipe/db.sqlite /Volumes/Test/screenpipe/db.sqlite~/.screenpipe $ du -sh ~/.screenpipe2.7G/Users/lukas/.screenpipelukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ du -sh ~/.screenpipe/*4.0K1.3G/Users/lukas/.screenpipe/config.json/Users/lukas/.screenpipe/data1.4G/Users/lukas/.screenpipe/db.sqlite64K7.0M/Users/lukas/.screenpipe/db.sqlite-shm/Users/lukas/.screenpipe/db.sqlite-wal24K/Users/lukas/.screenpipe/pipes132K96K/Users/Lukas/.screenpipe/screenpipe.2026-04-09.0.10g/Users/lukas/.screenpipe/screenpipe.2026-04-11.0.log72K/Users/lukas/.screenpipe/screenpipe.2026-04-12.0.log72K/Users/lukas/.screenpipe/screenpipe.2026-04-13.0.log160K60K/Users/lukas/.screenpipe/screenpipe.2026-04-14.0.10g/Users/lukas/.screenpipe/screenpipe.2026-04-15.0.loglukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3~/.screenpipe/db.sqlite "SELECTname,pgsize * pageno / 1024 / 1024 as size_mbFROM dbstatWHERE aggregate = TRUEORDER BY pgsize * pageno DESC;"ocr_textl64681806frames147636741elements19058218frames_fts_content|2282176idx_elements_frame_source_rolel270725idx_elements_source_role_textl264067elements_fts_datal166311frames_fts_datal156816idx_elements_frame_sourcel136761idx_elements_source| 86289idx_elements_frame_idl55048elements_fts_docsizel50120O 87* Unable to a...888Wed 15 Apr 11:29:18T81-zsh+...
|
NULL
|
NULL
|
|
20148
|
434
|
10
|
2026-04-15T08:29:18.791448+00:00
|
/Users/lukas/.screenpipe/data/data/2026-04-15/1776 /Users/lukas/.screenpipe/data/data/2026-04-15/1776241758791_m2.jpg...
|
NULL
|
NULL
|
1
|
NULL
|
monitor_2
|
NULL
|
NULL
|
NULL
|
NULL
|
CaudeFileFdit000+ New chatQ SearchcustomizeChatsPr CaudeFileFdit000+ New chatQ SearchcustomizeChatsProjects88 ArtifactsStarredBulgarian citizenship application...Dawarich location tracking projectHecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter API...Screenpipe 14-day retention exp...neaalt nomepage reea overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso...Importing Google Timeline data t...chromecast remote volume buct...Screenpipe free version guideSelf-hosted LLM alternatives to .Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General niorm.ron realestRed dots on neck causesViewWindowHelp40 lhlf Support Daily - in 3h 31m100% C8Wed 15 Apr 11:29:18ChatLOWOrkCodeLinux SQLite Ul for NAS vdirectly.App internals• (pipe_executions/ (pipe_scheduler_state) - Screenpipe "pipes" (plugins) runmistory• (vi_events) — UI interaction events(sqlx migrations - migration version tracking(sqlite_sequence — SQLite autoincrement countersTo get size per table + schema, run this in the Query tab:SELECTname,(SELECT COUNT(*) FROM sqlite_master WHERE type='table' AND name=m.name) as existsFROM sqlite_masterWHERE type='table'ORDER BY name;For row counts + estimated size:'video_chunks' as tbl, COUNT(*) as rows FROM video_chunksUNION ALL SELECT 'audio_chunks', COUNT(*) FROM audio_chunksUNION ALL SELECT'frames', COUNT(*) FROM framesUNION ALL SELECT'ocr_text',COUNT(*) FROM ocr_textUNION ALL SELECT'audio_transcriptions', COUNT(*) FROM audio_transcriptionsUNION ALL SELECT 'elements', COUNT(*) FROM elementsUNION ALL SELECT"memlo mes.COUNT (*) FROM memoriesUNION ALL SELECI'meetings', COUNT(*) FROM meetingsUNION ALL SELECT 'Ui_eventff, COUNT(*) FROM vi_eventsUNION ALL SELECT'pipe_executions', COUNT(*) FROM pipe_executions;For actual byte size per table (SQLite page-level):SELECTnamepgsize * pageno / 1024 / 1024 as size_mbFROM dbstatWHERE aggregate = TRUEORDER BY pgsize * pageno DESC;Updated to 1.2581.0RelaunchLukas KovalikPro nianRegarding retention - yes, you need a strategy. Screenpipe has a built-in retention settingReply...sonnet 46 vClaudtro mrand can make mistakes. rlease double-cneck responses....
|
NULL
|
-514787693380398630
|
NULL
|
visual_change
|
ocr
|
NULL
|
CaudeFileFdit000+ New chatQ SearchcustomizeChatsPr CaudeFileFdit000+ New chatQ SearchcustomizeChatsProjects88 ArtifactsStarredBulgarian citizenship application...Dawarich location tracking projectHecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter API...Screenpipe 14-day retention exp...neaalt nomepage reea overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso...Importing Google Timeline data t...chromecast remote volume buct...Screenpipe free version guideSelf-hosted LLM alternatives to .Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General niorm.ron realestRed dots on neck causesViewWindowHelp40 lhlf Support Daily - in 3h 31m100% C8Wed 15 Apr 11:29:18ChatLOWOrkCodeLinux SQLite Ul for NAS vdirectly.App internals• (pipe_executions/ (pipe_scheduler_state) - Screenpipe "pipes" (plugins) runmistory• (vi_events) — UI interaction events(sqlx migrations - migration version tracking(sqlite_sequence — SQLite autoincrement countersTo get size per table + schema, run this in the Query tab:SELECTname,(SELECT COUNT(*) FROM sqlite_master WHERE type='table' AND name=m.name) as existsFROM sqlite_masterWHERE type='table'ORDER BY name;For row counts + estimated size:'video_chunks' as tbl, COUNT(*) as rows FROM video_chunksUNION ALL SELECT 'audio_chunks', COUNT(*) FROM audio_chunksUNION ALL SELECT'frames', COUNT(*) FROM framesUNION ALL SELECT'ocr_text',COUNT(*) FROM ocr_textUNION ALL SELECT'audio_transcriptions', COUNT(*) FROM audio_transcriptionsUNION ALL SELECT 'elements', COUNT(*) FROM elementsUNION ALL SELECT"memlo mes.COUNT (*) FROM memoriesUNION ALL SELECI'meetings', COUNT(*) FROM meetingsUNION ALL SELECT 'Ui_eventff, COUNT(*) FROM vi_eventsUNION ALL SELECT'pipe_executions', COUNT(*) FROM pipe_executions;For actual byte size per table (SQLite page-level):SELECTnamepgsize * pageno / 1024 / 1024 as size_mbFROM dbstatWHERE aggregate = TRUEORDER BY pgsize * pageno DESC;Updated to 1.2581.0RelaunchLukas KovalikPro nianRegarding retention - yes, you need a strategy. Screenpipe has a built-in retention settingReply...sonnet 46 vClaudtro mrand can make mistakes. rlease double-cneck responses....
|
20146
|
NULL
|
|
20149
|
433
|
11
|
2026-04-15T08:29:22.789419+00:00
|
/Users/lukas/.screenpipe/data/data/2026-04-15/1776 /Users/lukas/.screenpipe/data/data/2026-04-15/1776241762789_m1.jpg...
|
NULL
|
NULL
|
1
|
NULL
|
monitor_1
|
NULL
|
NULL
|
NULL
|
NULL
|
iTerm2ShellEditViewSessionScriptsProfilesWindowH iTerm2ShellEditViewSessionScriptsProfilesWindowHelp(abl• Support Daily - in 3 h 31 m100% <47-zshDOCKER₴81DEV (-zsh)₴82APP (-zsh)83ec2-user@ip-10-... 984-zsh*5-zsh86-zsh16M/Users/lukas/.screenpipe/db.sqlite-wal24K/Users/lukas/.screenpipe/pipes132K/Users/lukas/.screenpipe/screenpipe.2026-04-09.0.log96K/Users/lukas/.screenpipe/screenpipe.2026-04-11.0.log72K/Users/lukas/.screenpipe/screenpipe.2026-04-12.0.1og72K/Users/lukas/.screenpipe/screenpipe.2026-04-13.0.log196K/Users/lukas/.screenpipe/screenpipe.2026-04-14.0.1oglukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe$cp -r ~/.screenpipe/data/data/2026-04-13 /Volumes/Test/screenpipe/data/lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe$cp-r ~/.screenpipe/data/data/2026-04-14 /Volumes/Test/screenpipe/data/lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ cp ~/.screenpipe/db.sqlite /Volumes/Test/screenpipe/db.sqlitelukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $lukas@Lukas-Kovaliks-MacBook-Pro-Jiminnycp ~/.screenpipe/db.sqlite /Volumes/Test/screenpipe/db.sqlite~/.screenpipe $ du -sh ~/.screenpipe2.7G/Users/lukas/.screenpipelukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ du -sh ~/.screenpipe/*4.0K1.3G/Users/lukas/.screenpipe/config.json/Users/lukas/.screenpipe/data1.4G/Users/lukas/.screenpipe/db.sqlite64K7.0M/Users/lukas/.screenpipe/db.sqlite-shm/Users/lukas/.screenpipe/db.sqlite-wal24K/Users/lukas/.screenpipe/pipes132K96K/Users/Lukas/.screenpipe/screenpipe.2026-04-09.0.10g/Users/lukas/.screenpipe/screenpipe.2026-04-11.0.log72K/Users/lukas/.screenpipe/screenpipe.2026-04-12.0.log72K/Users/lukas/.screenpipe/screenpipe.2026-04-13.0.log160K60K/Users/lukas/.screenpipe/screenpipe.2026-04-14.0.10g/Users/lukas/.screenpipe/screenpipe.2026-04-15.0.loglukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3~/.screenpipe/db.sqlite "SELECTname,pgsize * pageno / 1024 / 1024 as size_mbFROM dbstatWHERE aggregate = TRUEORDER BY pgsize * pageno DESC;"ocr_textl64681806frames147636741elements19058218frames_fts_content|2282176idx_elements_frame_source_rolel270725idx_elements_source_role_textl264067elements_fts_datal166311frames_fts_datal156816idx_elements_frame_sourcel136761idx_elements_source| 86289idx_elements_frame_idl55048elements_fts_docsizel50120O ₴7.* Unable to a...888Wed 15 Apr 11:29:22T81-zsh+...
|
NULL
|
-456869132654229856
|
NULL
|
click
|
ocr
|
NULL
|
iTerm2ShellEditViewSessionScriptsProfilesWindowH iTerm2ShellEditViewSessionScriptsProfilesWindowHelp(abl• Support Daily - in 3 h 31 m100% <47-zshDOCKER₴81DEV (-zsh)₴82APP (-zsh)83ec2-user@ip-10-... 984-zsh*5-zsh86-zsh16M/Users/lukas/.screenpipe/db.sqlite-wal24K/Users/lukas/.screenpipe/pipes132K/Users/lukas/.screenpipe/screenpipe.2026-04-09.0.log96K/Users/lukas/.screenpipe/screenpipe.2026-04-11.0.log72K/Users/lukas/.screenpipe/screenpipe.2026-04-12.0.1og72K/Users/lukas/.screenpipe/screenpipe.2026-04-13.0.log196K/Users/lukas/.screenpipe/screenpipe.2026-04-14.0.1oglukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe$cp -r ~/.screenpipe/data/data/2026-04-13 /Volumes/Test/screenpipe/data/lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe$cp-r ~/.screenpipe/data/data/2026-04-14 /Volumes/Test/screenpipe/data/lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ cp ~/.screenpipe/db.sqlite /Volumes/Test/screenpipe/db.sqlitelukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $lukas@Lukas-Kovaliks-MacBook-Pro-Jiminnycp ~/.screenpipe/db.sqlite /Volumes/Test/screenpipe/db.sqlite~/.screenpipe $ du -sh ~/.screenpipe2.7G/Users/lukas/.screenpipelukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ du -sh ~/.screenpipe/*4.0K1.3G/Users/lukas/.screenpipe/config.json/Users/lukas/.screenpipe/data1.4G/Users/lukas/.screenpipe/db.sqlite64K7.0M/Users/lukas/.screenpipe/db.sqlite-shm/Users/lukas/.screenpipe/db.sqlite-wal24K/Users/lukas/.screenpipe/pipes132K96K/Users/Lukas/.screenpipe/screenpipe.2026-04-09.0.10g/Users/lukas/.screenpipe/screenpipe.2026-04-11.0.log72K/Users/lukas/.screenpipe/screenpipe.2026-04-12.0.log72K/Users/lukas/.screenpipe/screenpipe.2026-04-13.0.log160K60K/Users/lukas/.screenpipe/screenpipe.2026-04-14.0.10g/Users/lukas/.screenpipe/screenpipe.2026-04-15.0.loglukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3~/.screenpipe/db.sqlite "SELECTname,pgsize * pageno / 1024 / 1024 as size_mbFROM dbstatWHERE aggregate = TRUEORDER BY pgsize * pageno DESC;"ocr_textl64681806frames147636741elements19058218frames_fts_content|2282176idx_elements_frame_source_rolel270725idx_elements_source_role_textl264067elements_fts_datal166311frames_fts_datal156816idx_elements_frame_sourcel136761idx_elements_source| 86289idx_elements_frame_idl55048elements_fts_docsizel50120O ₴7.* Unable to a...888Wed 15 Apr 11:29:22T81-zsh+...
|
20147
|
NULL
|
|
20150
|
434
|
11
|
2026-04-15T08:29:22.803143+00:00
|
/Users/lukas/.screenpipe/data/data/2026-04-15/1776 /Users/lukas/.screenpipe/data/data/2026-04-15/1776241762803_m2.jpg...
|
NULL
|
NULL
|
1
|
NULL
|
monitor_2
|
NULL
|
NULL
|
NULL
|
NULL
|
CaudeFileFdit000+ New chatQ SearchcustomizeChatsPr CaudeFileFdit000+ New chatQ SearchcustomizeChatsProjects88 ArtifactsStarredBulgarian citizenship application...Dawarich location tracking projecthecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter API...Screenpipe 14-day retention exp...neaalt nomepage reed overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso...Importing Google Timeline data t...chromecast remote volume buct...Screenpipe free version guideSelf-hosted LLM alternatives to .Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General niorm.ron realestRed dots on neck causesViewWindowHelp40 lhlf Support Daily - in 3h 31m100% C8Wed 15 Apr 11:29:22ChatLOWOrkCodeLinux SQLite Ul for NAS vdirectly.App internals• (pipe_executions)/ (pipe_scheduler_state) - Screenpipe "pipes" (plugins) runhistory• (vi_events) — Ul interaction events_sqlx_migrations) - migration version tracking• (sqlite_sequence) — SQLite autoincrement countersTo get size per table + schema, run this in the Query tab:FELECTmalle,(SELECT COUNT(*) FROM sqlite _master WHERE type='table' AND name=m.name) as existsFROM sqlite masterWHERE type='table'ORDER BY name;For row counts + estimated size:SELECT'video_chunks' as tbl, COUNT(*) as rows FROM video_chunksUNION ALL SELECT 'audio_chunks', COUNT(*) FROM audio_chunksUNION ALL SELECT 'frames', COUNT(*) FROM framesUNION ALL SELECT'ocr_text', COUNT(*) FROM ocr_textUNION ALL SELECT 'audio_transcriptions', COUNT(*) FROM audio_transcriptionsUNION ALL SELECT 'elements', COUNT(*) FROM elementsUNION ALL SELECT"memorles,COUNT (*) FROM memoriesUNION ALL SELECTMmeeuunes .COUNT(*) FROM meetingsUNION ALL SELECT'vi_events', COUNT(*) FROM vi_eventsUNION ALL SELECT'pipe_executions', COUNT(*) FROM pipe_executions;For actual byte size per table (SQLite page-level):SELECTWlallie,pgsize * pageno / 1024 / 1024 as size_mbFROM dbstatWHERE aggregate = TRUEORDER BY pgsize * pageno DESC;Updated to 1.2581.0RelaunchLukas KovalikPro nianRegarding retention - yes, you need a strategy. Screenpipe has a built-in retention settingReply...sonnet 46 vClaudtro mrand can make mistakes. rlease double-cneck responses....
|
NULL
|
-4163521696360281643
|
NULL
|
click
|
ocr
|
NULL
|
CaudeFileFdit000+ New chatQ SearchcustomizeChatsPr CaudeFileFdit000+ New chatQ SearchcustomizeChatsProjects88 ArtifactsStarredBulgarian citizenship application...Dawarich location tracking projecthecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter API...Screenpipe 14-day retention exp...neaalt nomepage reed overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso...Importing Google Timeline data t...chromecast remote volume buct...Screenpipe free version guideSelf-hosted LLM alternatives to .Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General niorm.ron realestRed dots on neck causesViewWindowHelp40 lhlf Support Daily - in 3h 31m100% C8Wed 15 Apr 11:29:22ChatLOWOrkCodeLinux SQLite Ul for NAS vdirectly.App internals• (pipe_executions)/ (pipe_scheduler_state) - Screenpipe "pipes" (plugins) runhistory• (vi_events) — Ul interaction events_sqlx_migrations) - migration version tracking• (sqlite_sequence) — SQLite autoincrement countersTo get size per table + schema, run this in the Query tab:FELECTmalle,(SELECT COUNT(*) FROM sqlite _master WHERE type='table' AND name=m.name) as existsFROM sqlite masterWHERE type='table'ORDER BY name;For row counts + estimated size:SELECT'video_chunks' as tbl, COUNT(*) as rows FROM video_chunksUNION ALL SELECT 'audio_chunks', COUNT(*) FROM audio_chunksUNION ALL SELECT 'frames', COUNT(*) FROM framesUNION ALL SELECT'ocr_text', COUNT(*) FROM ocr_textUNION ALL SELECT 'audio_transcriptions', COUNT(*) FROM audio_transcriptionsUNION ALL SELECT 'elements', COUNT(*) FROM elementsUNION ALL SELECT"memorles,COUNT (*) FROM memoriesUNION ALL SELECTMmeeuunes .COUNT(*) FROM meetingsUNION ALL SELECT'vi_events', COUNT(*) FROM vi_eventsUNION ALL SELECT'pipe_executions', COUNT(*) FROM pipe_executions;For actual byte size per table (SQLite page-level):SELECTWlallie,pgsize * pageno / 1024 / 1024 as size_mbFROM dbstatWHERE aggregate = TRUEORDER BY pgsize * pageno DESC;Updated to 1.2581.0RelaunchLukas KovalikPro nianRegarding retention - yes, you need a strategy. Screenpipe has a built-in retention settingReply...sonnet 46 vClaudtro mrand can make mistakes. rlease double-cneck responses....
|
NULL
|
NULL
|
|
20152
|
434
|
12
|
2026-04-15T08:29:24.901011+00:00
|
/Users/lukas/.screenpipe/data/data/2026-04-15/1776 /Users/lukas/.screenpipe/data/data/2026-04-15/1776241764901_m2.jpg...
|
NULL
|
NULL
|
1
|
NULL
|
monitor_2
|
NULL
|
NULL
|
NULL
|
NULL
|
CaudeFileEoit000+ New chatQ SearchcustomizeChatsPr CaudeFileEoit000+ New chatQ SearchcustomizeChatsProjects88 ArtifactsStarredBulgarian citizenship application...Dawarich location tracking projectHecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter API...Screenpipe 14-day retention exp...neaalt nomepage reea overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso...Importing Google Timeline data t...chromecast remote volume buct...Screenpipe free version guideSelf-hosted LLM alternatives to .Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General normarion redlestRed dots on neck causesViewWindowHelp40 l6lj Support Daily - in 3h 31mA100% C8Wed 15 Apr 11:29:24ChatLOWOrkCodeLinux SQLite Ul for NAS vdirectly.App internals• (pipe_executions)/ (pipe_scheduler_state - Screenpipe "pipes" (plugins) runhistory• (vi_events) — UI interaction events_sqlx_migrations - migration version tracking•sqlite sequence — suLite automnerement countersTo get size per table + schema, run this in the Query tab:Reply +Mallle(SELECT COUNT(*) FROM sqlite_master WHERE type='table' AND name=m.name) as existsFROM sqlite masterWHERE type='table'ORDER BY name:For row counts + estimated size:SELECT'vifleo_chunks' as tbl, COUNT(*) as rows FROM video_chunksUNION ALL SELECT 'audio_chunks', COUNT(*) FROM audio_chunksUNION ALL SELECT 'frames', COUNT(*) FROM framesUNION ALL SELECT'ocr_text', COUNT(*) FROM ocr_textUNION ALL SELECT 'audio_transcriptions', COUNT(*) FROM audio_transcriptionsUNION ALL SELECT 'elements',COUNT(*) FROM elementsUNION ALL SELECT"memorles,COUNT (*) FROM memoriesUNION ALL SELECTCOUNT(*) FROM meetingsUNION ALL SELECT'vi_events', COUNT(*) FROM vi_eventsUNION ALL SELECT'pipe_executions', COUNT(*) FROM pipe_executions;For actual byte size per table (SQLite page-level):SELECTWlallie,pgsize * pageno / 1024 / 1024 as size_mbFROM dbstatWHERE aggregate = TRUEORDER BY pgsize * pageno DESC;Updated to 1.2581.0RelaunchLukas KovalikPro nianRegarding retention - yes, you need a strategy. Screenpipe has a built-in retention settingReply...sonnet 46 vClaudtro mrand can make mistakes. rlease double-cneck responses....
|
NULL
|
6090952286928090910
|
NULL
|
visual_change
|
ocr
|
NULL
|
CaudeFileEoit000+ New chatQ SearchcustomizeChatsPr CaudeFileEoit000+ New chatQ SearchcustomizeChatsProjects88 ArtifactsStarredBulgarian citizenship application...Dawarich location tracking projectHecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter API...Screenpipe 14-day retention exp...neaalt nomepage reea overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso...Importing Google Timeline data t...chromecast remote volume buct...Screenpipe free version guideSelf-hosted LLM alternatives to .Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General normarion redlestRed dots on neck causesViewWindowHelp40 l6lj Support Daily - in 3h 31mA100% C8Wed 15 Apr 11:29:24ChatLOWOrkCodeLinux SQLite Ul for NAS vdirectly.App internals• (pipe_executions)/ (pipe_scheduler_state - Screenpipe "pipes" (plugins) runhistory• (vi_events) — UI interaction events_sqlx_migrations - migration version tracking•sqlite sequence — suLite automnerement countersTo get size per table + schema, run this in the Query tab:Reply +Mallle(SELECT COUNT(*) FROM sqlite_master WHERE type='table' AND name=m.name) as existsFROM sqlite masterWHERE type='table'ORDER BY name:For row counts + estimated size:SELECT'vifleo_chunks' as tbl, COUNT(*) as rows FROM video_chunksUNION ALL SELECT 'audio_chunks', COUNT(*) FROM audio_chunksUNION ALL SELECT 'frames', COUNT(*) FROM framesUNION ALL SELECT'ocr_text', COUNT(*) FROM ocr_textUNION ALL SELECT 'audio_transcriptions', COUNT(*) FROM audio_transcriptionsUNION ALL SELECT 'elements',COUNT(*) FROM elementsUNION ALL SELECT"memorles,COUNT (*) FROM memoriesUNION ALL SELECTCOUNT(*) FROM meetingsUNION ALL SELECT'vi_events', COUNT(*) FROM vi_eventsUNION ALL SELECT'pipe_executions', COUNT(*) FROM pipe_executions;For actual byte size per table (SQLite page-level):SELECTWlallie,pgsize * pageno / 1024 / 1024 as size_mbFROM dbstatWHERE aggregate = TRUEORDER BY pgsize * pageno DESC;Updated to 1.2581.0RelaunchLukas KovalikPro nianRegarding retention - yes, you need a strategy. Screenpipe has a built-in retention settingReply...sonnet 46 vClaudtro mrand can make mistakes. rlease double-cneck responses....
|
20150
|
NULL
|
|
20156
|
433
|
16
|
2026-04-15T08:29:41.313899+00:00
|
/Users/lukas/.screenpipe/data/data/2026-04-15/1776 /Users/lukas/.screenpipe/data/data/2026-04-15/1776241781313_m1.jpg...
|
NULL
|
NULL
|
1
|
NULL
|
monitor_1
|
NULL
|
NULL
|
NULL
|
NULL
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelpSupport Daily - in 3h 31 m100% (C47-zsh-zsh*5-zshDOCKER₴81DEV (-zsh)182APP (-zsh)83ec2-user@ip-10-...884ui_events_fts_idx10ui_events_fts_configl0idx_audio_transcription_chunk_textl0pipe_executions10idx_pipe_exec_name_status10idx_pipe_exec_runningl0idx_pipe_exec_name_timel0pipe_scheduler_statel0sqlite_autoindex_pipe_scheduler_state_110meetingsl0idx_meetings_startl0idx_meetings_endI0elements_fts_configl0audio_transcriptions_fts_datal0audio_transcriptions_fts_idx10audio_transcriptions_fts_docsizel0audio_transcriptions_fts_configl0idx_video_chunks_cloud_blob_idl0idx_frames_cloud_blob_idl0memories10idx_memories_created_atl0idx_memories_importancel0idx_memories_sourcel0memories_fts_datal0memories_fts_idx10memories_fts_docsizel0memories_fts_configl0frames_fts_configl0idx_memories_frame_idl0idx_frames_sync_idl0idx_ocr_text_sync_idl0idx_audio_transcriptions_sync_idl0secrets10sqlite_autoindex_secrets_110lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "SELECTname,(SELECT COUNT(*) FROM sqlite_master WHERE type='table' AND name=m.name) as existsFROMsqlite_masterWHERE type='table'ORDER BY name;"Error: in prepare,near "exists":syntaxerrorite_master WHERE type='table' AND name=m.name)as existsFROM sqlite_masterWerror here---hlukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ |86-zshO ₴7.* Unable to a...88Wed 15 Apr 11:29:41-zshT81+...
|
NULL
|
1823594470546061790
|
NULL
|
click
|
ocr
|
NULL
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelpSupport Daily - in 3h 31 m100% (C47-zsh-zsh*5-zshDOCKER₴81DEV (-zsh)182APP (-zsh)83ec2-user@ip-10-...884ui_events_fts_idx10ui_events_fts_configl0idx_audio_transcription_chunk_textl0pipe_executions10idx_pipe_exec_name_status10idx_pipe_exec_runningl0idx_pipe_exec_name_timel0pipe_scheduler_statel0sqlite_autoindex_pipe_scheduler_state_110meetingsl0idx_meetings_startl0idx_meetings_endI0elements_fts_configl0audio_transcriptions_fts_datal0audio_transcriptions_fts_idx10audio_transcriptions_fts_docsizel0audio_transcriptions_fts_configl0idx_video_chunks_cloud_blob_idl0idx_frames_cloud_blob_idl0memories10idx_memories_created_atl0idx_memories_importancel0idx_memories_sourcel0memories_fts_datal0memories_fts_idx10memories_fts_docsizel0memories_fts_configl0frames_fts_configl0idx_memories_frame_idl0idx_frames_sync_idl0idx_ocr_text_sync_idl0idx_audio_transcriptions_sync_idl0secrets10sqlite_autoindex_secrets_110lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "SELECTname,(SELECT COUNT(*) FROM sqlite_master WHERE type='table' AND name=m.name) as existsFROMsqlite_masterWHERE type='table'ORDER BY name;"Error: in prepare,near "exists":syntaxerrorite_master WHERE type='table' AND name=m.name)as existsFROM sqlite_masterWerror here---hlukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ |86-zshO ₴7.* Unable to a...88Wed 15 Apr 11:29:41-zshT81+...
|
NULL
|
NULL
|
|
20157
|
434
|
13
|
2026-04-15T08:29:41.313907+00:00
|
/Users/lukas/.screenpipe/data/data/2026-04-15/1776 /Users/lukas/.screenpipe/data/data/2026-04-15/1776241781313_m2.jpg...
|
NULL
|
NULL
|
1
|
NULL
|
monitor_2
|
NULL
|
NULL
|
NULL
|
NULL
|
caudeFileEditViewWindowHelp‹$0Support Daily • in 3 caudeFileEditViewWindowHelp‹$0Support Daily • in 3h 31 m100% CWed 15 Apr 11:29:41ChatLOWOrkCode+ New chatQ SearchcustomizeQ ChatsProjects88 ArtifactsStarredBulgarian citizenship application...Dawarich location tracking projectHecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter API ...Screenpipe 14-day retention exp...neaalt nomepage reea overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso...Importing Google Timeline data t...chromecast remote volume buct...Screenpipe free version guideSelf-hosted LLM alternatives to .Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General niorm.ron realestRed dots on neck causesLinux SQLite Ul for NAS vdirectly.App internals• (pipe_executions)/(pipe_scheduler_state-- Screenpipe "pipes" (plugins) runhistory• (vi_events) — UI interaction events_sqlx_migrations - migration version tracking•sqlite_sequence - SQLite autoincrement countersTo get size per table + schema, run this in the Query tab:Reply 4Mallle(SELECT COUNT(*) FROM sqlite_master WHERE type='table' AND name=m.name) as existsFROM sqlite_masterWHERE type='table'ORDER BY name:For row counts + estimated size:SELECT'video_chunks' as tbl, COUNT(*) as rows FROM video_chunksUNION ALL SELECT 'audio_chunks', COUNT(*) FROM audio_chunksUNION ALL SELECT 'frames', COUNT(*) FROM framesUNION ALL SELECT'ocr_text', COUNT(*) FROM ocr_textUNION ALL SELECT 'audio_transcriptions', COUNT(*) FROM audio_transcriptionsUNION ALL SELECT 'elements',COUNT(*) FROM elementsUNION ALL SELECT"memorles,COUNT (*) FROM memoriesUNION ALL SELECTCOUNT(*) FROM meetingsUNION ALL SELECT'vi_events', COUNT(*) FROM vi_eventsUNION ALL SELECI'pipe_executions', COUNT(*) FROM pipe_executions;For actual byte size per table (SQLite page-level):SELECTWlallie,pgsize * pageno / 1024 / 1024 as size_mbFROM dbstatWHERE aggregate = TRUEORDER BY pgsize * pageno DESC;Updated to 1.2581.0RelaunchLukas KovalikPro nianRegarding retention - yes, you need a strategy. Screenpipe has a built-in retention settingReply...sonnet 46 vClaudtro mrand can make mistakes. rlease double-cneck responses....
|
NULL
|
-55924235683889495
|
NULL
|
click
|
ocr
|
NULL
|
caudeFileEditViewWindowHelp‹$0Support Daily • in 3 caudeFileEditViewWindowHelp‹$0Support Daily • in 3h 31 m100% CWed 15 Apr 11:29:41ChatLOWOrkCode+ New chatQ SearchcustomizeQ ChatsProjects88 ArtifactsStarredBulgarian citizenship application...Dawarich location tracking projectHecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter API ...Screenpipe 14-day retention exp...neaalt nomepage reea overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso...Importing Google Timeline data t...chromecast remote volume buct...Screenpipe free version guideSelf-hosted LLM alternatives to .Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General niorm.ron realestRed dots on neck causesLinux SQLite Ul for NAS vdirectly.App internals• (pipe_executions)/(pipe_scheduler_state-- Screenpipe "pipes" (plugins) runhistory• (vi_events) — UI interaction events_sqlx_migrations - migration version tracking•sqlite_sequence - SQLite autoincrement countersTo get size per table + schema, run this in the Query tab:Reply 4Mallle(SELECT COUNT(*) FROM sqlite_master WHERE type='table' AND name=m.name) as existsFROM sqlite_masterWHERE type='table'ORDER BY name:For row counts + estimated size:SELECT'video_chunks' as tbl, COUNT(*) as rows FROM video_chunksUNION ALL SELECT 'audio_chunks', COUNT(*) FROM audio_chunksUNION ALL SELECT 'frames', COUNT(*) FROM framesUNION ALL SELECT'ocr_text', COUNT(*) FROM ocr_textUNION ALL SELECT 'audio_transcriptions', COUNT(*) FROM audio_transcriptionsUNION ALL SELECT 'elements',COUNT(*) FROM elementsUNION ALL SELECT"memorles,COUNT (*) FROM memoriesUNION ALL SELECTCOUNT(*) FROM meetingsUNION ALL SELECT'vi_events', COUNT(*) FROM vi_eventsUNION ALL SELECI'pipe_executions', COUNT(*) FROM pipe_executions;For actual byte size per table (SQLite page-level):SELECTWlallie,pgsize * pageno / 1024 / 1024 as size_mbFROM dbstatWHERE aggregate = TRUEORDER BY pgsize * pageno DESC;Updated to 1.2581.0RelaunchLukas KovalikPro nianRegarding retention - yes, you need a strategy. Screenpipe has a built-in retention settingReply...sonnet 46 vClaudtro mrand can make mistakes. rlease double-cneck responses....
|
NULL
|
NULL
|
|
20158
|
433
|
17
|
2026-04-15T08:29:41.920492+00:00
|
/Users/lukas/.screenpipe/data/data/2026-04-15/1776 /Users/lukas/.screenpipe/data/data/2026-04-15/1776241781920_m1.jpg...
|
NULL
|
NULL
|
1
|
NULL
|
monitor_1
|
NULL
|
NULL
|
NULL
|
NULL
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp(a6]• Support Daily - in 3 h 31 m100% <478Wed 15 Apr 11:29:41T₴1-zsh-zshDOCKER₴81DEV (-zsh)₴82APP (-zsh)83ec2-user@ip-10-...884ui_events_fts_idxl0ui_events_fts_configl0idx_audio_transcription_chunk_textl0pipe_executions10idx_pipe_exec_name_status10idx_pipe_exec_runningl0idx_pipe_exec_name_timel0pipe_scheduler_statel0sqlite_autoindex_pipe_scheduler_state_110meetingsl0idx_meetings_startl0idx_meetings_endI0elements_fts_configl0audio_transcriptions_fts_datal0audio_transcriptions_fts_idx10audio_transcriptions_fts_docsizel0audio_transcriptions_fts_configl0idx_video_chunks_cloud_blob_idl0idx_frames_cloud_blob_idl0memories10idx_memories_created_atl0idx_memories_importancel0idx_memories_sourcel0memories_fts_datal0memories_fts_idx10memories_fts_docsizel0memories_fts_configl0frames_fts_configl0idx_memories_frame_idl0idx_frames_sync_idl0idx_ocr_text_sync_idl0idx_audio_transcriptions_sync_idl0secrets10sqlite_autoindex_secrets_110lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "SELECTname,(SELECT COUNT(*) FROM sqlite_master WHERE type='table' AND name=m.name) as existsFROMsqlite_masterWHERE type='table'ORDER BY name;"Error: in prepare,near "exists":syntaxerrorite_master WHERE type='table' AND name=m.name)as exists FROM sqlite_masterWerror here---/lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ l*5-zsh86-zshO ₴7.* Unable to a...O 88-zsh...
|
NULL
|
-2035679059944109644
|
NULL
|
click
|
ocr
|
NULL
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp(a6]• Support Daily - in 3 h 31 m100% <478Wed 15 Apr 11:29:41T₴1-zsh-zshDOCKER₴81DEV (-zsh)₴82APP (-zsh)83ec2-user@ip-10-...884ui_events_fts_idxl0ui_events_fts_configl0idx_audio_transcription_chunk_textl0pipe_executions10idx_pipe_exec_name_status10idx_pipe_exec_runningl0idx_pipe_exec_name_timel0pipe_scheduler_statel0sqlite_autoindex_pipe_scheduler_state_110meetingsl0idx_meetings_startl0idx_meetings_endI0elements_fts_configl0audio_transcriptions_fts_datal0audio_transcriptions_fts_idx10audio_transcriptions_fts_docsizel0audio_transcriptions_fts_configl0idx_video_chunks_cloud_blob_idl0idx_frames_cloud_blob_idl0memories10idx_memories_created_atl0idx_memories_importancel0idx_memories_sourcel0memories_fts_datal0memories_fts_idx10memories_fts_docsizel0memories_fts_configl0frames_fts_configl0idx_memories_frame_idl0idx_frames_sync_idl0idx_ocr_text_sync_idl0idx_audio_transcriptions_sync_idl0secrets10sqlite_autoindex_secrets_110lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "SELECTname,(SELECT COUNT(*) FROM sqlite_master WHERE type='table' AND name=m.name) as existsFROMsqlite_masterWHERE type='table'ORDER BY name;"Error: in prepare,near "exists":syntaxerrorite_master WHERE type='table' AND name=m.name)as exists FROM sqlite_masterWerror here---/lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ l*5-zsh86-zshO ₴7.* Unable to a...O 88-zsh...
|
20156
|
NULL
|
|
20159
|
434
|
14
|
2026-04-15T08:29:43.095867+00:00
|
/Users/lukas/.screenpipe/data/data/2026-04-15/1776 /Users/lukas/.screenpipe/data/data/2026-04-15/1776241783095_m2.jpg...
|
NULL
|
NULL
|
1
|
NULL
|
monitor_2
|
NULL
|
NULL
|
NULL
|
NULL
|
CaudeFileFdit000+ New chatQ SearchcustomizeChatsPr CaudeFileFdit000+ New chatQ SearchcustomizeChatsProjects88 ArtifactsStarredBulgarian citizenship application..Dawarich location tracking projectHecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter API...Screenpipe 14-day retention exp...neaalt nomepage reed overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso...Importing Google Timeline data t...chromecast remote volume buct...Screenpipe free version guideSelf-hosted LLM alternatives to .Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General niorm.ron realestRed dots on neck causesViewWindowHelp40 l6lj Support Daily - in 3h 31mA100% C8Wed 15 Apr 11:29:42ChatLOWOrkCodeLinux SQLite Ul for NAS vdirectly.App internals• (pipe_executions)/ (pipe_scheduler_state) - Screenpipe "pipes" (plugins) runhistory• (vi_events) — Ul interaction events_sqlx_migrations) - migration version tracking•sqlite sequence — suLite automnerement countersTo get size per table + schema, run this in the Query tab:Reply 4malle,(SELECT COUNT(*) FROM sqlite _master WHERE type='table' AND name=m.name) as existsFROM sqlite masterWHERE type='table'ORDER BY name;For row counts + estimated size:SELECT'video_chunks' as tbl, COUNT(*) as rows FROM video_chunksLUNION ALLSELECT 'audio_chunks', COUNT(*) FROM audio_chunksUNION ALL SELECT 'frames', COUNT(*) FROM framesUNION ALL SELECT'ocr_text', COUNT(*) FROM ocr_textUNION ALL SELECT'audio_transcriptions', COUNT(*) FROM audio_transcriptionsUNION ALL SELECT 'elements', COUNT(*) FROM elementsUNION ALL SELECT"memorlesCOUNT(*) FROM memoriesUNION ALL SELECTmeetings,COUNT(*) FROM meetingsUINLUN ALLSELEE'vi_events', COUNT(*) FROM vi_eventsUNION ALL SELECT 'pipe_executions',COUNT (*) FROM pipe_executions;For actual byte size per table (SQLite page-level):SELECTWlallie,pgsize * pageno / 1024 / 1024 as size_mbFROM dbstatWHERE aggregate = TRUEORDER BY pgsize * pageno DESC;Updated to 1.2581.0RelaunchLukas KovalikPro nianRegarding retention - yes, you need a strategy. Screenpipe has a built-in retention settingReply...sonnet 46 vClaudtro mrand can make mistakes. rlease double-cneck responses....
|
NULL
|
-6082834805532984148
|
NULL
|
visual_change
|
ocr
|
NULL
|
CaudeFileFdit000+ New chatQ SearchcustomizeChatsPr CaudeFileFdit000+ New chatQ SearchcustomizeChatsProjects88 ArtifactsStarredBulgarian citizenship application..Dawarich location tracking projectHecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter API...Screenpipe 14-day retention exp...neaalt nomepage reed overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso...Importing Google Timeline data t...chromecast remote volume buct...Screenpipe free version guideSelf-hosted LLM alternatives to .Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General niorm.ron realestRed dots on neck causesViewWindowHelp40 l6lj Support Daily - in 3h 31mA100% C8Wed 15 Apr 11:29:42ChatLOWOrkCodeLinux SQLite Ul for NAS vdirectly.App internals• (pipe_executions)/ (pipe_scheduler_state) - Screenpipe "pipes" (plugins) runhistory• (vi_events) — Ul interaction events_sqlx_migrations) - migration version tracking•sqlite sequence — suLite automnerement countersTo get size per table + schema, run this in the Query tab:Reply 4malle,(SELECT COUNT(*) FROM sqlite _master WHERE type='table' AND name=m.name) as existsFROM sqlite masterWHERE type='table'ORDER BY name;For row counts + estimated size:SELECT'video_chunks' as tbl, COUNT(*) as rows FROM video_chunksLUNION ALLSELECT 'audio_chunks', COUNT(*) FROM audio_chunksUNION ALL SELECT 'frames', COUNT(*) FROM framesUNION ALL SELECT'ocr_text', COUNT(*) FROM ocr_textUNION ALL SELECT'audio_transcriptions', COUNT(*) FROM audio_transcriptionsUNION ALL SELECT 'elements', COUNT(*) FROM elementsUNION ALL SELECT"memorlesCOUNT(*) FROM memoriesUNION ALL SELECTmeetings,COUNT(*) FROM meetingsUINLUN ALLSELEE'vi_events', COUNT(*) FROM vi_eventsUNION ALL SELECT 'pipe_executions',COUNT (*) FROM pipe_executions;For actual byte size per table (SQLite page-level):SELECTWlallie,pgsize * pageno / 1024 / 1024 as size_mbFROM dbstatWHERE aggregate = TRUEORDER BY pgsize * pageno DESC;Updated to 1.2581.0RelaunchLukas KovalikPro nianRegarding retention - yes, you need a strategy. Screenpipe has a built-in retention settingReply...sonnet 46 vClaudtro mrand can make mistakes. rlease double-cneck responses....
|
20157
|
NULL
|
|
20166
|
433
|
22
|
2026-04-15T08:30:06.537370+00:00
|
/Users/lukas/.screenpipe/data/data/2026-04-15/1776 /Users/lukas/.screenpipe/data/data/2026-04-15/1776241806537_m1.jpg...
|
NULL
|
NULL
|
1
|
NULL
|
monitor_1
|
NULL
|
NULL
|
NULL
|
NULL
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp‹ >0 lblSupport Daily - in 3h 30 mA100% CWed 15 Apr 11:30:06181-zsh-zshDOCKER₴81idx_memories_sourcel0memories_fts_datal0memories_fts_idxl0memories_fts_docsizel0memories_fts_configl0frames_fts_configl0idx_memories_frame_idi0idx_frames_sync_idl0idx_ocr_text_sync_idl0idx_audio_transcriptions_sync_idl0DEV (-zsh)$82APP (-zsh)83ec2-user@ip-10-... 884sqlite_autoindex_secrets_110Lukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "SELECTname,(SELECT COUNT(*) FROM sqlite_master WHERE type='table' AND name=m.name) as existsFROM sqlite_masterWHERE type='table'ORDER BY name;"Error: in prepare, near "exists": syntax errorite_master WHERE type='table' AND name=m.name) as exists FROM sqlite_master Werror here ---^lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "SELECTUNTON deLL SunkS asutbl, chouVTC, OSNTC-) FROM ideo-ChunksUNION ALL SELECT 'frames', COUNT(*) FROM framesUNION ALL SELECT 'ocr_text', COUNT(*) FROM ocr_textUNION ALL SELECT 'audio_transcriptions', COUNT(*) FROM audio_transcriptionsUNION ALL SELECT 'elements'., COUNT(*) FROM elementsUNION ALL SELECT 'memories',, COUNT(* FROM memoriesUNION ALL SELECT 'meetings', COUNT(*) FROM meetingsUNION ALL SELECT 'ui_events', COUNT(*) FROM ui_eventsUNION ALL SELECT 'pipe_executions', COUNT(*) FROM pipe_executions;"video_chunks 1428audio_chunks 190frames|20163ocr_text|15011audio_transcriptionsl3elements/1222571memorieslomeetings10ui_events |26965pipe_executions 10lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $*5-zsh86-zsh> 87* Unable to a...O x8-zsh...
|
NULL
|
-7884952625928240807
|
NULL
|
click
|
ocr
|
NULL
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp‹ >0 lblSupport Daily - in 3h 30 mA100% CWed 15 Apr 11:30:06181-zsh-zshDOCKER₴81idx_memories_sourcel0memories_fts_datal0memories_fts_idxl0memories_fts_docsizel0memories_fts_configl0frames_fts_configl0idx_memories_frame_idi0idx_frames_sync_idl0idx_ocr_text_sync_idl0idx_audio_transcriptions_sync_idl0DEV (-zsh)$82APP (-zsh)83ec2-user@ip-10-... 884sqlite_autoindex_secrets_110Lukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "SELECTname,(SELECT COUNT(*) FROM sqlite_master WHERE type='table' AND name=m.name) as existsFROM sqlite_masterWHERE type='table'ORDER BY name;"Error: in prepare, near "exists": syntax errorite_master WHERE type='table' AND name=m.name) as exists FROM sqlite_master Werror here ---^lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "SELECTUNTON deLL SunkS asutbl, chouVTC, OSNTC-) FROM ideo-ChunksUNION ALL SELECT 'frames', COUNT(*) FROM framesUNION ALL SELECT 'ocr_text', COUNT(*) FROM ocr_textUNION ALL SELECT 'audio_transcriptions', COUNT(*) FROM audio_transcriptionsUNION ALL SELECT 'elements'., COUNT(*) FROM elementsUNION ALL SELECT 'memories',, COUNT(* FROM memoriesUNION ALL SELECT 'meetings', COUNT(*) FROM meetingsUNION ALL SELECT 'ui_events', COUNT(*) FROM ui_eventsUNION ALL SELECT 'pipe_executions', COUNT(*) FROM pipe_executions;"video_chunks 1428audio_chunks 190frames|20163ocr_text|15011audio_transcriptionsl3elements/1222571memorieslomeetings10ui_events |26965pipe_executions 10lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $*5-zsh86-zsh> 87* Unable to a...O x8-zsh...
|
NULL
|
NULL
|
|
20167
|
434
|
17
|
2026-04-15T08:30:06.537358+00:00
|
/Users/lukas/.screenpipe/data/data/2026-04-15/1776 /Users/lukas/.screenpipe/data/data/2026-04-15/1776241806537_m2.jpg...
|
NULL
|
NULL
|
1
|
NULL
|
monitor_2
|
NULL
|
NULL
|
NULL
|
NULL
|
caudeFileEditViewWindowHelp→0 i.Support Daily • in caudeFileEditViewWindowHelp→0 i.Support Daily • in 3 h 30 m100% C2Wed 15 Apr 11:30:06ChatLoWOrkCode+ New chatQ SearchcustomizeQ Chats6 Projects88 ArtifactsStarredBulgarian citizenship application...Dawarich location tracking projectHecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter API...Screenpipe 14-day retention exp...neaalt nomepage reea overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso...Importing Google Timeline data t...chromecast remote volume buct...Screenpipe free version guideSelf-hosted LLM alternatives to .Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General niorm.ron realestRed dots on neck causesLinux SQLite Ul for NAS vFor row counts + estimated size:'video_chunks' as tbl, COUNT(*) as rows FROM video_chunksUNION ALL SELECT 'audio_chunks', COUNT(*) FROM audio_chunksUNION ALL SELECT'frames', COUNT(*) FROM framesUNION ALL SELECT'ocr_text', COUNT(*) FROM ocr_textUNION ALL SELECT'audio_transcriptions', COUNT(*) FROM audio_transcriptionsUNION ALL SELECT'elenencs'.COUNT(*) FROM elementsUNION ALL SELECT"menlo miesCOUNT(*) FROM memoriesUNIUN ALL S2LECI'meetings', COUNT(*) FROM meetingsUNIION ALL SELECT'vi_events', COUNT(*) FROM ui_eventsUNION ALL SELECT'pipe_executions', COUNT(*) FROM pipe_executions;For actual byte size per table (SQLite page-level):SELECTpgsize * pageno / 1024 / 1024 as size_mbFROM dbstatWHERE aggregate = TRUEORDER BY pgsize * pageno DESC;Regarding retention - yes, you need a strategy. Screenpipe has a built-in retention setting(in its config) that deletes old video/audio files and their DB rows after N days. The problemfor your NAS sync architecture is:• If Screenpipe deletes rows locally, your NAS copy (from last night) still has them -good, that's your long-term archive• But file_path values in the NAS DB still point to the MacBook's local paths, which nolonger existThe approach we discussed previously (nightly full DB copy + media accumulating on NAS,paths rewritten) handles this correctly — the NAS DB becomes the source of truth forhistory. The local MacBook DB is just the live working set.Want me to draft the path-rewriting SQL and sync script based on what I can see of theschema here?Updated to 1.2581.0RelaunchLukas KovalikPro nianReplh.sonner40 vclaudo ezand can make mistakas Poase douhla-chock racnoncas...
|
NULL
|
-8729919213196119445
|
NULL
|
click
|
ocr
|
NULL
|
caudeFileEditViewWindowHelp→0 i.Support Daily • in caudeFileEditViewWindowHelp→0 i.Support Daily • in 3 h 30 m100% C2Wed 15 Apr 11:30:06ChatLoWOrkCode+ New chatQ SearchcustomizeQ Chats6 Projects88 ArtifactsStarredBulgarian citizenship application...Dawarich location tracking projectHecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter API...Screenpipe 14-day retention exp...neaalt nomepage reea overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso...Importing Google Timeline data t...chromecast remote volume buct...Screenpipe free version guideSelf-hosted LLM alternatives to .Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General niorm.ron realestRed dots on neck causesLinux SQLite Ul for NAS vFor row counts + estimated size:'video_chunks' as tbl, COUNT(*) as rows FROM video_chunksUNION ALL SELECT 'audio_chunks', COUNT(*) FROM audio_chunksUNION ALL SELECT'frames', COUNT(*) FROM framesUNION ALL SELECT'ocr_text', COUNT(*) FROM ocr_textUNION ALL SELECT'audio_transcriptions', COUNT(*) FROM audio_transcriptionsUNION ALL SELECT'elenencs'.COUNT(*) FROM elementsUNION ALL SELECT"menlo miesCOUNT(*) FROM memoriesUNIUN ALL S2LECI'meetings', COUNT(*) FROM meetingsUNIION ALL SELECT'vi_events', COUNT(*) FROM ui_eventsUNION ALL SELECT'pipe_executions', COUNT(*) FROM pipe_executions;For actual byte size per table (SQLite page-level):SELECTpgsize * pageno / 1024 / 1024 as size_mbFROM dbstatWHERE aggregate = TRUEORDER BY pgsize * pageno DESC;Regarding retention - yes, you need a strategy. Screenpipe has a built-in retention setting(in its config) that deletes old video/audio files and their DB rows after N days. The problemfor your NAS sync architecture is:• If Screenpipe deletes rows locally, your NAS copy (from last night) still has them -good, that's your long-term archive• But file_path values in the NAS DB still point to the MacBook's local paths, which nolonger existThe approach we discussed previously (nightly full DB copy + media accumulating on NAS,paths rewritten) handles this correctly — the NAS DB becomes the source of truth forhistory. The local MacBook DB is just the live working set.Want me to draft the path-rewriting SQL and sync script based on what I can see of theschema here?Updated to 1.2581.0RelaunchLukas KovalikPro nianReplh.sonner40 vclaudo ezand can make mistakas Poase douhla-chock racnoncas...
|
NULL
|
NULL
|
|
20168
|
433
|
23
|
2026-04-15T08:30:07.105744+00:00
|
/Users/lukas/.screenpipe/data/data/2026-04-15/1776 /Users/lukas/.screenpipe/data/data/2026-04-15/1776241807105_m1.jpg...
|
NULL
|
NULL
|
1
|
NULL
|
monitor_1
|
NULL
|
NULL
|
NULL
|
NULL
|
iTerm2Shell Edit ViewSessionScriptsProfilesWindo iTerm2Shell Edit ViewSessionScriptsProfilesWindowHelp‹ >0 lolSupport Daily - in 3 h 30m(A100% C47 8 Wed 15 Apr 11:30:06-zsh-zshDOCKER₴81idx_memories_sourcel0memories_fts_datal0memories_fts_idx10memories_fts_docsizel0memories_fts_configl0frames_fts_configl0idx_memories_frame_idi0idx_frames_sync_idl0idx_ocr_text_sync_idl0idx_audio_transcriptions_sync_idl0DEV (-zsh)H82APP (-zsh)83ec2-user@ip-10-.. 884sqlite_autoindex_secrets_110Lukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "SELECTname,(SELECT COUNT(*) FROM sqlite_master WHERE type='table' AND name=m.name) as existsFROM sqlite_masterWHERE type='table'ORDER BY name;"Error: in prepare, near "exists": syntax errorite_master WHERE type='table' AND name=m.name) as exists FROM sqlite_master Werror here ---^lukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "SELECTUNTON deLL SunkS asutbl, chouVTC, OSNTC-) FROM ideo-ChunksUNION ALL SELECT 'frames', COUNT(*) FROM framesUNION ALL SELECT 'ocr_text', COUNT(*) FROM ocr_textUNION ALL SELECT 'audio_transcriptions', COUNT(*) FROM audio_transcriptionsUNION ALL SELECT 'elements',, COUNT(*) FROM elementsUNION ALL SELECT 'memories',, COUNT(* FROM memoriesUNION ALL SELECT 'meetings', COUNT(*) FROM meetingsUNION ALL SELECT 'ui_events', COUNT(*) FROM ui_eventsUNION ALL SELECT 'pipe_executions', COUNT(*) FROM pipe_executions;"video_chunks 1428audio_chunks 190frames|20163ocr_text|15011audio_transcriptionsl3elements/1222571memoriesl0meetings10ui_events126965pipe_executions 10lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $*5-zsh86-zshO ₴7.* Unable to a...O 88-zsh...
|
NULL
|
4054653107488379910
|
NULL
|
visual_change
|
ocr
|
NULL
|
iTerm2Shell Edit ViewSessionScriptsProfilesWindo iTerm2Shell Edit ViewSessionScriptsProfilesWindowHelp‹ >0 lolSupport Daily - in 3 h 30m(A100% C47 8 Wed 15 Apr 11:30:06-zsh-zshDOCKER₴81idx_memories_sourcel0memories_fts_datal0memories_fts_idx10memories_fts_docsizel0memories_fts_configl0frames_fts_configl0idx_memories_frame_idi0idx_frames_sync_idl0idx_ocr_text_sync_idl0idx_audio_transcriptions_sync_idl0DEV (-zsh)H82APP (-zsh)83ec2-user@ip-10-.. 884sqlite_autoindex_secrets_110Lukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "SELECTname,(SELECT COUNT(*) FROM sqlite_master WHERE type='table' AND name=m.name) as existsFROM sqlite_masterWHERE type='table'ORDER BY name;"Error: in prepare, near "exists": syntax errorite_master WHERE type='table' AND name=m.name) as exists FROM sqlite_master Werror here ---^lukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "SELECTUNTON deLL SunkS asutbl, chouVTC, OSNTC-) FROM ideo-ChunksUNION ALL SELECT 'frames', COUNT(*) FROM framesUNION ALL SELECT 'ocr_text', COUNT(*) FROM ocr_textUNION ALL SELECT 'audio_transcriptions', COUNT(*) FROM audio_transcriptionsUNION ALL SELECT 'elements',, COUNT(*) FROM elementsUNION ALL SELECT 'memories',, COUNT(* FROM memoriesUNION ALL SELECT 'meetings', COUNT(*) FROM meetingsUNION ALL SELECT 'ui_events', COUNT(*) FROM ui_eventsUNION ALL SELECT 'pipe_executions', COUNT(*) FROM pipe_executions;"video_chunks 1428audio_chunks 190frames|20163ocr_text|15011audio_transcriptionsl3elements/1222571memoriesl0meetings10ui_events126965pipe_executions 10lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $*5-zsh86-zshO ₴7.* Unable to a...O 88-zsh...
|
20166
|
NULL
|
|
20169
|
434
|
18
|
2026-04-15T08:30:07.398580+00:00
|
/Users/lukas/.screenpipe/data/data/2026-04-15/1776 /Users/lukas/.screenpipe/data/data/2026-04-15/1776241807398_m2.jpg...
|
NULL
|
NULL
|
1
|
NULL
|
monitor_2
|
NULL
|
NULL
|
NULL
|
NULL
|
CaudeFileEoit000+ New chatQ SearchcustomizeChatsPr CaudeFileEoit000+ New chatQ SearchcustomizeChatsProjects88 ArtifactsStarredBulgarian citizenship application...Dawarich location tracking projecthecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter API...Screenpipe 14-day retention exp...neaalt nomepage reea overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso...Importing Google Timeline data t...chromecast remote volume buct...Screenpipe free version guideSelf-hosted LLM alternatives to .Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General niorm.ron realestRed dots on neck causesViewWindowHelp40 hal#Support Daily • in 3h 30m100% C8Wed 15 Apr 11:30:07ChatcoworkCodeLinux SQLite Ul for NAS vFor row counts + estimated size:SELECT'video_chunks' as tbl, COUNT(*) as rows FROM video_chunksUNION ALLSELECT 'audio_chunks', COUNT(*) FROM audio_chunksUNION ALLSELECT'frames', COUNT(*) FROM framesUNION ALL SELECT'ocr_text', COUNT(*) FROM ocr_textUNION ALL SELECT'audio_transcriptions', COUNT(*) FROM audio_transcriptionsUNION ALL SELECTelements",COUNT(*) FROM elementsUNION ALL SELECT"memortes,COUNT(*) FROM memoriesUNION ALL SELECT'meetings', COUNT(*) FROM meetingsUNION ALL SELECT'vi_events', COUNT(*) FROM ui_eventsUNION ALL SELECT'pipe_executions', COUNT(*) FROM pipe_executions;For actual byte size per table (SQLite page-level):SELECTpgsize * pageno / 1024 / 1024 as size_mbFROM dbstatWHERE aggregate = TRUEORDER BY pgsize * pageno DESC;Regarding retention - yes, you need a strategy. Screenpipe has a built-in retention setting(in its config) that deletes old video/audio files and their DB rows after N days. The problemfor your NAS sync architecture is:• If Screenpipe deletes rows locally, your NAS copy (from last night) still has them -good, that's your long-term archive• But file_path values in the NAS DB still point to the MacBook's local paths, which nolonger existThe approach we discussed previously (nightly full DB copy + media accumulating on NAS,paths rewritten) handles this correctly — the NAS DB becomes the source of truth forhistory. The local MacBook DB is just the live working set.Want me to draft the path-rewriting SQL and sync script based on what I can see of theschema here?Updated to 1.2581.0RelaunchLukas KovalikPro nianReply... Isonner40 vCaudameno can make mistakes, rlease double check resoolises....
|
NULL
|
3443116209343916424
|
NULL
|
visual_change
|
ocr
|
NULL
|
CaudeFileEoit000+ New chatQ SearchcustomizeChatsPr CaudeFileEoit000+ New chatQ SearchcustomizeChatsProjects88 ArtifactsStarredBulgarian citizenship application...Dawarich location tracking projecthecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter API...Screenpipe 14-day retention exp...neaalt nomepage reea overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso...Importing Google Timeline data t...chromecast remote volume buct...Screenpipe free version guideSelf-hosted LLM alternatives to .Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General niorm.ron realestRed dots on neck causesViewWindowHelp40 hal#Support Daily • in 3h 30m100% C8Wed 15 Apr 11:30:07ChatcoworkCodeLinux SQLite Ul for NAS vFor row counts + estimated size:SELECT'video_chunks' as tbl, COUNT(*) as rows FROM video_chunksUNION ALLSELECT 'audio_chunks', COUNT(*) FROM audio_chunksUNION ALLSELECT'frames', COUNT(*) FROM framesUNION ALL SELECT'ocr_text', COUNT(*) FROM ocr_textUNION ALL SELECT'audio_transcriptions', COUNT(*) FROM audio_transcriptionsUNION ALL SELECTelements",COUNT(*) FROM elementsUNION ALL SELECT"memortes,COUNT(*) FROM memoriesUNION ALL SELECT'meetings', COUNT(*) FROM meetingsUNION ALL SELECT'vi_events', COUNT(*) FROM ui_eventsUNION ALL SELECT'pipe_executions', COUNT(*) FROM pipe_executions;For actual byte size per table (SQLite page-level):SELECTpgsize * pageno / 1024 / 1024 as size_mbFROM dbstatWHERE aggregate = TRUEORDER BY pgsize * pageno DESC;Regarding retention - yes, you need a strategy. Screenpipe has a built-in retention setting(in its config) that deletes old video/audio files and their DB rows after N days. The problemfor your NAS sync architecture is:• If Screenpipe deletes rows locally, your NAS copy (from last night) still has them -good, that's your long-term archive• But file_path values in the NAS DB still point to the MacBook's local paths, which nolonger existThe approach we discussed previously (nightly full DB copy + media accumulating on NAS,paths rewritten) handles this correctly — the NAS DB becomes the source of truth forhistory. The local MacBook DB is just the live working set.Want me to draft the path-rewriting SQL and sync script based on what I can see of theschema here?Updated to 1.2581.0RelaunchLukas KovalikPro nianReply... Isonner40 vCaudameno can make mistakes, rlease double check resoolises....
|
20167
|
NULL
|
|
20170
|
434
|
19
|
2026-04-15T08:30:10.409380+00:00
|
/Users/lukas/.screenpipe/data/data/2026-04-15/1776 /Users/lukas/.screenpipe/data/data/2026-04-15/1776241810409_m2.jpg...
|
NULL
|
NULL
|
1
|
NULL
|
monitor_2
|
NULL
|
NULL
|
NULL
|
NULL
|
Caude000+ New chatQ SearchcustomizeFileFditViewWin Caude000+ New chatQ SearchcustomizeFileFditViewWindowHelp40 halSupport Daily • in 3 h 30 mA100% C.8Wed 15 Apr 11:30:10CnatCowork CodeLinux SQLite Ul for NAS vChatsProjects88 ArtifactsStarredBulgarian citizenship application..Dawarich location tracking projectHecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter API...Screenpipe 14-day retention exp...neaalt nomepage reed overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso...Importing Google Timeline data t...chromecast remote volume duet...Screenpipe free version guideSelf-hosted LLM alternatives to .Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General niorm.ron realestRed dots on neck causeslukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3~/.screenpipe/db.sqlite "SELECTpgsize * pageno / 1024 / 1024 as size_mbFROM dbstatWHERE aggregate = TRUEORDER BY pgsize * pageno DESC;"ocr text 64681806Show moreUpdated to 1.2581.0RelaunchReply...Sonnet 46Lukas KovalikPro nianClaudEIs.Arand can make mistakes. Please double-check responses....
|
NULL
|
4301241362568175108
|
NULL
|
visual_change
|
ocr
|
NULL
|
Caude000+ New chatQ SearchcustomizeFileFditViewWin Caude000+ New chatQ SearchcustomizeFileFditViewWindowHelp40 halSupport Daily • in 3 h 30 mA100% C.8Wed 15 Apr 11:30:10CnatCowork CodeLinux SQLite Ul for NAS vChatsProjects88 ArtifactsStarredBulgarian citizenship application..Dawarich location tracking projectHecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter API...Screenpipe 14-day retention exp...neaalt nomepage reed overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso...Importing Google Timeline data t...chromecast remote volume duet...Screenpipe free version guideSelf-hosted LLM alternatives to .Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General niorm.ron realestRed dots on neck causeslukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3~/.screenpipe/db.sqlite "SELECTpgsize * pageno / 1024 / 1024 as size_mbFROM dbstatWHERE aggregate = TRUEORDER BY pgsize * pageno DESC;"ocr text 64681806Show moreUpdated to 1.2581.0RelaunchReply...Sonnet 46Lukas KovalikPro nianClaudEIs.Arand can make mistakes. Please double-check responses....
|
NULL
|
NULL
|
|
20171
|
434
|
20
|
2026-04-15T08:30:22.539978+00:00
|
/Users/lukas/.screenpipe/data/data/2026-04-15/1776 /Users/lukas/.screenpipe/data/data/2026-04-15/1776241822539_m2.jpg...
|
NULL
|
NULL
|
1
|
NULL
|
monitor_2
|
NULL
|
NULL
|
NULL
|
NULL
|
CaudeFileEoit000+ New chatQ SearchcustomizeChatsPr CaudeFileEoit000+ New chatQ SearchcustomizeChatsProjects88 ArtifactsStarredBulgarian citizenship application..Dawarich location tracking projectHecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter API...Screenpipe 14-day retention exp...neaalt nomepage reea overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso...Importing Google Timeline data t...chromecast remote volume buct...Screenpipe free version guideSelf-hosted LLM alternatives to .Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General normarion redlestRed dots on neck causesViewWindowHelp40 hal#Support Daily • in 3h 30 mA100% C•8Wed 15 Apr 11:30:22ChatLoWOrkCodeLinux SQLite Ul for NAS vlukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3~/.screenpipe/db.sqlite "SELECTname!pgsize * pageno / 1024 / 1024 as size_mbFROM dbstatWHERE aggregate = TRUEORDER BY pgsize * pageno DESC,"oc Textio4Show moreGreat data. Here's what this tells us:Size breakdown (the values are actually bytes, not MB — the formula was wrong):RealsizeNotesocr_text~62 GB* Massive — text extracted trom every wrameframesN4S THFrame metadata + likely snapshot pathselements~8.6 GBFTS indexes-2.5 GB1.2M rows — Ul elements per frameSearch indexes for fboveEverything else is essentially empty (audio, transcriptions, memories, meetings — all 0 ornear-0).Row counts context:1225) deimens Powstor 20k tomes -on uctemente stroed rom me - this tsthe real storage killer• audio_transcriptions only 3 rows despite 90 audio chunks mic probably off orWhisper not runningKey insight for your NAS retention strategy:The bulk of the DBis ocr_text) +(elements . These are the most useful for search but alsothe most expensive. Your options:Option A - Copy everything (current plan) Fine if NAS has space. The DB is ~120+ GBuncompressed though, so nightly full copy gets heavy fast.Option B - Selective archive: drop elements on NASUpdated to 1.2581.0RelaunchLukas KovalikPro nian-- After copying to NAS, strip elements to save ~9GB per sync periodReply...sonnet 46 vClaudtro mrand can make mistakes. rlease double-cneck responses....
|
NULL
|
8384571075334243356
|
NULL
|
visual_change
|
ocr
|
NULL
|
CaudeFileEoit000+ New chatQ SearchcustomizeChatsPr CaudeFileEoit000+ New chatQ SearchcustomizeChatsProjects88 ArtifactsStarredBulgarian citizenship application..Dawarich location tracking projectHecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter API...Screenpipe 14-day retention exp...neaalt nomepage reea overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso...Importing Google Timeline data t...chromecast remote volume buct...Screenpipe free version guideSelf-hosted LLM alternatives to .Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General normarion redlestRed dots on neck causesViewWindowHelp40 hal#Support Daily • in 3h 30 mA100% C•8Wed 15 Apr 11:30:22ChatLoWOrkCodeLinux SQLite Ul for NAS vlukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3~/.screenpipe/db.sqlite "SELECTname!pgsize * pageno / 1024 / 1024 as size_mbFROM dbstatWHERE aggregate = TRUEORDER BY pgsize * pageno DESC,"oc Textio4Show moreGreat data. Here's what this tells us:Size breakdown (the values are actually bytes, not MB — the formula was wrong):RealsizeNotesocr_text~62 GB* Massive — text extracted trom every wrameframesN4S THFrame metadata + likely snapshot pathselements~8.6 GBFTS indexes-2.5 GB1.2M rows — Ul elements per frameSearch indexes for fboveEverything else is essentially empty (audio, transcriptions, memories, meetings — all 0 ornear-0).Row counts context:1225) deimens Powstor 20k tomes -on uctemente stroed rom me - this tsthe real storage killer• audio_transcriptions only 3 rows despite 90 audio chunks mic probably off orWhisper not runningKey insight for your NAS retention strategy:The bulk of the DBis ocr_text) +(elements . These are the most useful for search but alsothe most expensive. Your options:Option A - Copy everything (current plan) Fine if NAS has space. The DB is ~120+ GBuncompressed though, so nightly full copy gets heavy fast.Option B - Selective archive: drop elements on NASUpdated to 1.2581.0RelaunchLukas KovalikPro nian-- After copying to NAS, strip elements to save ~9GB per sync periodReply...sonnet 46 vClaudtro mrand can make mistakes. rlease double-cneck responses....
|
20170
|
NULL
|
|
20172
|
433
|
24
|
2026-04-15T08:30:37.413616+00:00
|
/Users/lukas/.screenpipe/data/data/2026-04-15/1776 /Users/lukas/.screenpipe/data/data/2026-04-15/1776241837413_m1.jpg...
|
NULL
|
NULL
|
1
|
NULL
|
monitor_1
|
NULL
|
NULL
|
NULL
|
NULL
|
iTerm2Shell Edit ViewSessionScriptsProfilesWindo iTerm2Shell Edit ViewSessionScriptsProfilesWindowHelp‹ >0 lolSupport Daily - in 3 h 30m(A100% C47 8 Wed 15 Apr 11:30:37-zsh-zshDOCKER₴81idx_memories_sourcel0memories_fts_datal0memories_fts_idx10memories_fts_docsizel0memories_fts_configl0frames_fts_configl0idx_memories_frame_idi0idx_frames_sync_idl0idx_ocr_text_sync_idl0idx_audio_transcriptions_sync_idl0DEV (-zsh)H82APP (-zsh)83ec2-user@ip-10-.. 884sqlite_autoindex_secrets_110Lukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "SELECTname,(SELECT COUNT(*) FROM sqlite_master WHERE type='table' AND name=m.name) as existsFROM sqlite_masterWHERE type='table'ORDER BY name;"Error: in prepare, near "exists": syntax errorite_master WHERE type='table' AND name=m.name) as exists FROM sqlite_master Werror here ---^lukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "SELECTUNTON deLL SunkS asutbl, chouVTC, OSNTC-) FROM ideo-ChunksUNION ALL SELECT 'frames', COUNT(*) FROM framesUNION ALL SELECT 'ocr_text', COUNT(*) FROM ocr_textUNION ALL SELECT 'audio_transcriptions', COUNT(*) FROM audio_transcriptionsUNION ALL SELECT 'elements',, COUNT(*) FROM elementsUNION ALL SELECT 'memories',, COUNT(* FROM memoriesUNION ALL SELECT 'meetings', COUNT(*) FROM meetingsUNION ALL SELECT 'ui_events', COUNT(*) FROM ui_eventsUNION ALL SELECT 'pipe_executions', COUNT(*) FROM pipe_executions;"video_chunks 1428audio_chunks 190frames|20163ocr_text|15011audio_transcriptionsl3elements/1222571memoriesl0meetings10ui_events126965pipe_executions 10lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $*5-zsh86-zshO ₴7.* Unable to a...O 88-zsh*9...
|
NULL
|
6262460884189600043
|
NULL
|
idle
|
ocr
|
NULL
|
iTerm2Shell Edit ViewSessionScriptsProfilesWindo iTerm2Shell Edit ViewSessionScriptsProfilesWindowHelp‹ >0 lolSupport Daily - in 3 h 30m(A100% C47 8 Wed 15 Apr 11:30:37-zsh-zshDOCKER₴81idx_memories_sourcel0memories_fts_datal0memories_fts_idx10memories_fts_docsizel0memories_fts_configl0frames_fts_configl0idx_memories_frame_idi0idx_frames_sync_idl0idx_ocr_text_sync_idl0idx_audio_transcriptions_sync_idl0DEV (-zsh)H82APP (-zsh)83ec2-user@ip-10-.. 884sqlite_autoindex_secrets_110Lukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "SELECTname,(SELECT COUNT(*) FROM sqlite_master WHERE type='table' AND name=m.name) as existsFROM sqlite_masterWHERE type='table'ORDER BY name;"Error: in prepare, near "exists": syntax errorite_master WHERE type='table' AND name=m.name) as exists FROM sqlite_master Werror here ---^lukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "SELECTUNTON deLL SunkS asutbl, chouVTC, OSNTC-) FROM ideo-ChunksUNION ALL SELECT 'frames', COUNT(*) FROM framesUNION ALL SELECT 'ocr_text', COUNT(*) FROM ocr_textUNION ALL SELECT 'audio_transcriptions', COUNT(*) FROM audio_transcriptionsUNION ALL SELECT 'elements',, COUNT(*) FROM elementsUNION ALL SELECT 'memories',, COUNT(* FROM memoriesUNION ALL SELECT 'meetings', COUNT(*) FROM meetingsUNION ALL SELECT 'ui_events', COUNT(*) FROM ui_eventsUNION ALL SELECT 'pipe_executions', COUNT(*) FROM pipe_executions;"video_chunks 1428audio_chunks 190frames|20163ocr_text|15011audio_transcriptionsl3elements/1222571memoriesl0meetings10ui_events126965pipe_executions 10lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $*5-zsh86-zshO ₴7.* Unable to a...O 88-zsh*9...
|
NULL
|
NULL
|
|
20173
|
434
|
21
|
2026-04-15T08:30:53.044184+00:00
|
/Users/lukas/.screenpipe/data/data/2026-04-15/1776 /Users/lukas/.screenpipe/data/data/2026-04-15/1776241853044_m2.jpg...
|
NULL
|
NULL
|
1
|
NULL
|
monitor_2
|
NULL
|
NULL
|
NULL
|
NULL
|
CaudeFileEoit000+ New chatQ SearchcustomizeChatsPr CaudeFileEoit000+ New chatQ SearchcustomizeChatsProjects88 ArtifactsStarredBulgarian citizenship application...Dawarich location tracking projectHecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter API...Screenpipe 14-day retention exp...neaalt nomepage reea overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso...Importing Google Timeline data t...chromecast remote volume buct...Screenpipe free version guideSelf-hosted LLM alternatives to .Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General normarion redlestRed dots on neck causesViewWindowHelp40 half Support Daily - in 3h 30mA100% C•8Wed 15 Apr 11:30:52ChatLoWOrkCodeLinux SQLite Ul for NAS vlukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3~/.screenpipe/db.sqlite "SELECTname!pgsize * pageno / 1024 / 1024 as size_mbFROM dbstatWHERE aggregate = TRUEORDER BY pgsize * pageno DESC,"oc rexto4Show moreGreat data. Here's what this tells us:Size breakdown (the values are actually bytes, not MB — the formula was wrong):RealsizeNotesocr_text~62 GB* Massive — text extracted trom every wrameframesN4S THFrame metadata + likely snapshot pathselements~8.6 GBFTS indexes-2.5 GB1.2M rows — Ul elements per frameSearch indexes for fboveEverything else is essentially empty (audio, transcriptions, memories, meetings — all 0 ornear-0).Row counts context:1225) deimens Powstor 20k tomes -on uctemente stroed rom me - this tsthe real storage killer• audio_transcriptions only 3 rows despite 90 audio chunks mic probably off orWhisper not runningKey insight for your NAS retention strategy:The bulk of the DB is (ocr_text) +(elements . These are the most useful for search but alsothe most expensive. Your options:Option A - Copy everything (current plan) Fine if NAS has space. The DB is ~120+ GBuncompressed though, so nightly full copy gets heavy fast.Option B - Selective archive: drop elements on NASUpdated to 1.2581.0RelaunchLukas KovalikPro nian-- After copying to NAS, strip elements to save ~9GB per sync periodReply...sonnet 46 vClaudtro mrand can make mistakes. rlease double-cneck responses....
|
NULL
|
3030314717397055249
|
NULL
|
idle
|
ocr
|
NULL
|
CaudeFileEoit000+ New chatQ SearchcustomizeChatsPr CaudeFileEoit000+ New chatQ SearchcustomizeChatsProjects88 ArtifactsStarredBulgarian citizenship application...Dawarich location tracking projectHecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter API...Screenpipe 14-day retention exp...neaalt nomepage reea overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso...Importing Google Timeline data t...chromecast remote volume buct...Screenpipe free version guideSelf-hosted LLM alternatives to .Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General normarion redlestRed dots on neck causesViewWindowHelp40 half Support Daily - in 3h 30mA100% C•8Wed 15 Apr 11:30:52ChatLoWOrkCodeLinux SQLite Ul for NAS vlukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3~/.screenpipe/db.sqlite "SELECTname!pgsize * pageno / 1024 / 1024 as size_mbFROM dbstatWHERE aggregate = TRUEORDER BY pgsize * pageno DESC,"oc rexto4Show moreGreat data. Here's what this tells us:Size breakdown (the values are actually bytes, not MB — the formula was wrong):RealsizeNotesocr_text~62 GB* Massive — text extracted trom every wrameframesN4S THFrame metadata + likely snapshot pathselements~8.6 GBFTS indexes-2.5 GB1.2M rows — Ul elements per frameSearch indexes for fboveEverything else is essentially empty (audio, transcriptions, memories, meetings — all 0 ornear-0).Row counts context:1225) deimens Powstor 20k tomes -on uctemente stroed rom me - this tsthe real storage killer• audio_transcriptions only 3 rows despite 90 audio chunks mic probably off orWhisper not runningKey insight for your NAS retention strategy:The bulk of the DB is (ocr_text) +(elements . These are the most useful for search but alsothe most expensive. Your options:Option A - Copy everything (current plan) Fine if NAS has space. The DB is ~120+ GBuncompressed though, so nightly full copy gets heavy fast.Option B - Selective archive: drop elements on NASUpdated to 1.2581.0RelaunchLukas KovalikPro nian-- After copying to NAS, strip elements to save ~9GB per sync periodReply...sonnet 46 vClaudtro mrand can make mistakes. rlease double-cneck responses....
|
NULL
|
NULL
|
|
20174
|
NULL
|
0
|
2026-04-15T08:31:07.867252+00:00
|
/Users/lukas/.screenpipe/data/data/2026-04-15/1776 /Users/lukas/.screenpipe/data/data/2026-04-15/1776241867867_m1.jpg...
|
NULL
|
NULL
|
1
|
NULL
|
monitor_1
|
NULL
|
NULL
|
NULL
|
NULL
|
iTerm2Shell Edit ViewSessionScriptsProfilesWindo iTerm2Shell Edit ViewSessionScriptsProfilesWindowHelp‹ >0 ll& Support Daily - in 3h 29m |100% C47 8 Wed 15 Apr 11:31:07-zsh-zshDOCKER₴81idx_memories_sourcel0memories_fts_datal0memories_fts_idx10memories_fts_docsizel0memories_fts_configl0frames_fts_configl0idx_memories_frame_idi0idx_frames_sync_idl0idx_ocr_text_sync_idl0idx_audio_transcriptions_sync_idl0DEV (-zsh)H82APP (-zsh)83ec2-user@ip-10-.. 884sqlite_autoindex_secrets_110Lukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "SELECTname,(SELECT COUNT(*) FROM sqlite_master WHERE type='table' AND name=m.name) as existsFROM sqlite_masterWHERE type='table'ORDER BY name;"Error: in prepare, near "exists": syntax errorite_master WHERE type='table' AND name=m.name) as exists FROM sqlite_master Werror here ---^lukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "SELECTUNTON deLL SunkS asutbl, chouVTC, OSNTC-) FROM ideo-ChunksUNION ALL SELECT 'frames', COUNT(*) FROM framesUNION ALL SELECT 'ocr_text', COUNT(*) FROM ocr_textUNION ALL SELECT 'audio_transcriptions', COUNT(*) FROM audio_transcriptionsUNION ALL SELECT 'elements',, COUNT(*) FROM elementsUNION ALL SELECT 'memories',, COUNT(* FROM memoriesUNION ALL SELECT 'meetings', COUNT(*) FROM meetingsUNION ALL SELECT 'ui_events', COUNT(*) FROM ui_eventsUNION ALL SELECT 'pipe_executions', COUNT(*) FROM pipe_executions;"video_chunks 1428audio_chunks 190frames|20163ocr_text|15011audio_transcriptionsl3elements/1222571memoriesl0meetings10ui_events126965pipe_executions 10lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $*5-zsh86-zshO ₴7.* Unable to a...O x8-zsh*9...
|
NULL
|
7919414780658092177
|
NULL
|
idle
|
ocr
|
NULL
|
iTerm2Shell Edit ViewSessionScriptsProfilesWindo iTerm2Shell Edit ViewSessionScriptsProfilesWindowHelp‹ >0 ll& Support Daily - in 3h 29m |100% C47 8 Wed 15 Apr 11:31:07-zsh-zshDOCKER₴81idx_memories_sourcel0memories_fts_datal0memories_fts_idx10memories_fts_docsizel0memories_fts_configl0frames_fts_configl0idx_memories_frame_idi0idx_frames_sync_idl0idx_ocr_text_sync_idl0idx_audio_transcriptions_sync_idl0DEV (-zsh)H82APP (-zsh)83ec2-user@ip-10-.. 884sqlite_autoindex_secrets_110Lukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "SELECTname,(SELECT COUNT(*) FROM sqlite_master WHERE type='table' AND name=m.name) as existsFROM sqlite_masterWHERE type='table'ORDER BY name;"Error: in prepare, near "exists": syntax errorite_master WHERE type='table' AND name=m.name) as exists FROM sqlite_master Werror here ---^lukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "SELECTUNTON deLL SunkS asutbl, chouVTC, OSNTC-) FROM ideo-ChunksUNION ALL SELECT 'frames', COUNT(*) FROM framesUNION ALL SELECT 'ocr_text', COUNT(*) FROM ocr_textUNION ALL SELECT 'audio_transcriptions', COUNT(*) FROM audio_transcriptionsUNION ALL SELECT 'elements',, COUNT(*) FROM elementsUNION ALL SELECT 'memories',, COUNT(* FROM memoriesUNION ALL SELECT 'meetings', COUNT(*) FROM meetingsUNION ALL SELECT 'ui_events', COUNT(*) FROM ui_eventsUNION ALL SELECT 'pipe_executions', COUNT(*) FROM pipe_executions;"video_chunks 1428audio_chunks 190frames|20163ocr_text|15011audio_transcriptionsl3elements/1222571memoriesl0meetings10ui_events126965pipe_executions 10lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $*5-zsh86-zshO ₴7.* Unable to a...O x8-zsh*9...
|
20172
|
NULL
|
|
20175
|
434
|
22
|
2026-04-15T08:31:20.157187+00:00
|
/Users/lukas/.screenpipe/data/data/2026-04-15/1776 /Users/lukas/.screenpipe/data/data/2026-04-15/1776241880157_m2.jpg...
|
NULL
|
NULL
|
1
|
NULL
|
monitor_2
|
NULL
|
NULL
|
NULL
|
NULL
|
CaudeFileEoit000+ New chatQ SearchcustomizeChatsPr CaudeFileEoit000+ New chatQ SearchcustomizeChatsProjects88 ArtifactsStarredBulgarian citizenship application...Dawarich location tracking projecthecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter API...Screenpipe 14-day retention exp...neaalt nomepage reea overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso...Importing Google Timeline data t...chromecast remote volume buct...Screenpipe free version guideSelf-hosted LLM alternatives to .Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General niorm.ron realestRed dots on neck causesViewWindowHelp40 hal#Support Daily • in 3h 29 m100% C8Wed 15 Apr 11:31:19Linux SQLite Ul for NAS vChatLoworkCodeFROM dbstatWHERE aggregate = TRUEORDER BY pgsize * pageno DESC;"Show morerear data. Heres whartnis tellsusSize breakdown (the values are actually bytes, not MB - the formula was wrong):aneKealsveNotesocr_text~62 GB€ Massive - text extracted from every frameframes~45 GBFrame metadata + likely snapshot pathselenens-8.6 GB1.2M rows — UI elements per framewo moexe~2.5 GBSearch indexes for aboveEverything else is essentially empty (audio, transcriptions, memories, meetings — all 0 ornear-0).Row counts context:• 428 video chunks, 20k frames roughly consistent (frames sampled from video)• 1,222,571 elements rows for 20k frames = ~60 UI elements detected per frame - this isthe real storage killer(audio_transcriptions only 3 rows despite 90 audio chunks → mic probably off orWhisper not runningUpdated to 1.2581.0RelaunchLukas KovalikPro nianKey insight for your NAS retention strategy:The bulk of the DB is (ocr_text) +(elements . These are the most useful for search but alsothe most expensive. Your options:Option A - Copy everything (current plan) Fine if NAS has space. The DB is ~120+ GBuncompressed though, so nightly full copy gets heavy fast.Option B - Selective archive: drop elements on NAS-- Aft&rcopving to NAS.strip elements to save ~9GB per sync periodDELETE FROM elements WHERE frame_id IN (SELECT id FROM frames WHERE timestamp ‹ datetime( 'now', '-30 days'));Inen vAcuom to reclaim spaceVALUUM;Reply...sonnet 46 vClaude-o Al and can make mistakes. Please double-check responses....
|
NULL
|
223887304515886763
|
NULL
|
visual_change
|
ocr
|
NULL
|
CaudeFileEoit000+ New chatQ SearchcustomizeChatsPr CaudeFileEoit000+ New chatQ SearchcustomizeChatsProjects88 ArtifactsStarredBulgarian citizenship application...Dawarich location tracking projecthecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter API...Screenpipe 14-day retention exp...neaalt nomepage reea overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso...Importing Google Timeline data t...chromecast remote volume buct...Screenpipe free version guideSelf-hosted LLM alternatives to .Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General niorm.ron realestRed dots on neck causesViewWindowHelp40 hal#Support Daily • in 3h 29 m100% C8Wed 15 Apr 11:31:19Linux SQLite Ul for NAS vChatLoworkCodeFROM dbstatWHERE aggregate = TRUEORDER BY pgsize * pageno DESC;"Show morerear data. Heres whartnis tellsusSize breakdown (the values are actually bytes, not MB - the formula was wrong):aneKealsveNotesocr_text~62 GB€ Massive - text extracted from every frameframes~45 GBFrame metadata + likely snapshot pathselenens-8.6 GB1.2M rows — UI elements per framewo moexe~2.5 GBSearch indexes for aboveEverything else is essentially empty (audio, transcriptions, memories, meetings — all 0 ornear-0).Row counts context:• 428 video chunks, 20k frames roughly consistent (frames sampled from video)• 1,222,571 elements rows for 20k frames = ~60 UI elements detected per frame - this isthe real storage killer(audio_transcriptions only 3 rows despite 90 audio chunks → mic probably off orWhisper not runningUpdated to 1.2581.0RelaunchLukas KovalikPro nianKey insight for your NAS retention strategy:The bulk of the DB is (ocr_text) +(elements . These are the most useful for search but alsothe most expensive. Your options:Option A - Copy everything (current plan) Fine if NAS has space. The DB is ~120+ GBuncompressed though, so nightly full copy gets heavy fast.Option B - Selective archive: drop elements on NAS-- Aft&rcopving to NAS.strip elements to save ~9GB per sync periodDELETE FROM elements WHERE frame_id IN (SELECT id FROM frames WHERE timestamp ‹ datetime( 'now', '-30 days'));Inen vAcuom to reclaim spaceVALUUM;Reply...sonnet 46 vClaude-o Al and can make mistakes. Please double-check responses....
|
20173
|
NULL
|
|
20176
|
NULL
|
0
|
2026-04-15T08:31:23.211651+00:00
|
/Users/lukas/.screenpipe/data/data/2026-04-15/1776 /Users/lukas/.screenpipe/data/data/2026-04-15/1776241883211_m2.jpg...
|
NULL
|
NULL
|
1
|
NULL
|
monitor_2
|
NULL
|
NULL
|
NULL
|
NULL
|
CaudeFileFdit000+ New chatQ SearchcustomizeChatsPr CaudeFileFdit000+ New chatQ SearchcustomizeChatsProjects88 ArtifactsStarredBulgarian citizenship application..Dawarich location tracking projectHecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter API...Screenpipe 14-day retention exp...neaalt nomepage reea overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso...Importing Google Timeline data t...chromecast remote volume buct...Screenpipe free version guideSelf-hosted LLM alternatives to .Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General normarion redlestRed dots on neck causesViewWindowHelp< 40 llf Support Daily - in 3h 29m100% C8 Wed 15 Apr 11:31:22Linux SQLite Ul for NAS vChatLoWOrkCodeTableReal sizeNotesocr cext~62 GB© Massive - text extracted from every frametrames-45 GBFrame metadata + likely snapshot pathselements~O0 TBMrows - ule enertsdertamems mdexes~2.5GBsearchmde estoraboveEverything else is essentially empty (audio, transcriptions, memories, meetings — all 0 ornear-O).kow counts context• 428 video chunks, 20k frames → roughly consistent (frames sampled from video)• 1,222,571 elements rows for 20k frames = ~60 UI elements detected per frame — this isthe real storage killer• audio_transcriptions only 3 rows despite 90 audio chunks → mic probably off orWhisper not runningKey insight for your NAS retention strategy:The bulk of the DB is ocr_text) + (elements . These are the most useful for search but alsothe most expensive. Your options:Option A - Copy everything (current plan) Fine if NAS has space. The DB is ~120+ GBuncompressed though, so nightly full copy gets heavy fast.Option B - Selective archive: drop elements on NAS-- After copying to NAS, strip elements to save -9GB per sync periodDELETE FROM elements WHERE frame id INSELECT id FROM frames WHERE timestamp ‹ datetime('now", '-30 days'));Then VACUUM to reclaim spaceVACUUM;Option C -- Incremental sync (better long-term) Instead of full DB copy, append only newrows since last sync using (rowid or timestamp . Much lighter.Recommended sync script skeleton:Updated to 1.2581.0RelaunchLukas KovalikPro nian#ornroasnNAS="/Volumes/screenpipe"# or your siLOCAL_DB="$HOME/.screenpipe/db.sqlite"Reply...sonnet 46 vClaudtro mrand can make mistakes. rlease double-cneck responses....
|
NULL
|
-1379327665059432960
|
NULL
|
visual_change
|
ocr
|
NULL
|
CaudeFileFdit000+ New chatQ SearchcustomizeChatsPr CaudeFileFdit000+ New chatQ SearchcustomizeChatsProjects88 ArtifactsStarredBulgarian citizenship application..Dawarich location tracking projectHecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter API...Screenpipe 14-day retention exp...neaalt nomepage reea overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso...Importing Google Timeline data t...chromecast remote volume buct...Screenpipe free version guideSelf-hosted LLM alternatives to .Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General normarion redlestRed dots on neck causesViewWindowHelp< 40 llf Support Daily - in 3h 29m100% C8 Wed 15 Apr 11:31:22Linux SQLite Ul for NAS vChatLoWOrkCodeTableReal sizeNotesocr cext~62 GB© Massive - text extracted from every frametrames-45 GBFrame metadata + likely snapshot pathselements~O0 TBMrows - ule enertsdertamems mdexes~2.5GBsearchmde estoraboveEverything else is essentially empty (audio, transcriptions, memories, meetings — all 0 ornear-O).kow counts context• 428 video chunks, 20k frames → roughly consistent (frames sampled from video)• 1,222,571 elements rows for 20k frames = ~60 UI elements detected per frame — this isthe real storage killer• audio_transcriptions only 3 rows despite 90 audio chunks → mic probably off orWhisper not runningKey insight for your NAS retention strategy:The bulk of the DB is ocr_text) + (elements . These are the most useful for search but alsothe most expensive. Your options:Option A - Copy everything (current plan) Fine if NAS has space. The DB is ~120+ GBuncompressed though, so nightly full copy gets heavy fast.Option B - Selective archive: drop elements on NAS-- After copying to NAS, strip elements to save -9GB per sync periodDELETE FROM elements WHERE frame id INSELECT id FROM frames WHERE timestamp ‹ datetime('now", '-30 days'));Then VACUUM to reclaim spaceVACUUM;Option C -- Incremental sync (better long-term) Instead of full DB copy, append only newrows since last sync using (rowid or timestamp . Much lighter.Recommended sync script skeleton:Updated to 1.2581.0RelaunchLukas KovalikPro nian#ornroasnNAS="/Volumes/screenpipe"# or your siLOCAL_DB="$HOME/.screenpipe/db.sqlite"Reply...sonnet 46 vClaudtro mrand can make mistakes. rlease double-cneck responses....
|
NULL
|
NULL
|
|
20177
|
435
|
0
|
2026-04-15T08:31:38.241083+00:00
|
/Users/lukas/.screenpipe/data/data/2026-04-15/1776 /Users/lukas/.screenpipe/data/data/2026-04-15/1776241898241_m1.jpg...
|
NULL
|
NULL
|
1
|
NULL
|
monitor_1
|
NULL
|
NULL
|
NULL
|
NULL
|
iTerm2Shell Edit ViewSessionScriptsProfilesWindo iTerm2Shell Edit ViewSessionScriptsProfilesWindowHelp‹ >0 lol& Support Daily - in 3h 29m |100% C47 8 Wed 15 Apr 11:31:37-zsh-zshDOCKER₴81idx_memories_sourcel0memories_fts_datal0memories_fts_idx10memories_fts_docsizel0memories_fts_configl0frames_fts_configl0idx_memories_frame_idi0idx_frames_sync_idl0idx_ocr_text_sync_idl0idx_audio_transcriptions_sync_idl0DEV (-zsh)$82APP (-zsh)83ec2-user@ip-10-.. 884sqlite_autoindex_secrets_110Lukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "SELECTname,(SELECT COUNT(*) FROM sqlite_master WHERE type='table' AND name=m.name) as existsFROM sqlite_masterWHERE type='table'ORDER BY name;"Error: in prepare, near "exists": syntax errorite_master WHERE type='table' AND name=m.name) as exists FROM sqlite_master Werror here ---^lukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "SELECTUNTON deLL SunkS asutbl, chouVTC, OSNTC-) FROM ideo-ChunksUNION ALL SELECT 'frames', COUNT(*) FROM framesUNION ALL SELECT 'ocr_text', COUNT(*) FROM ocr_textUNION ALL SELECT 'audio_transcriptions', COUNT(*) FROM audio_transcriptionsUNION ALL SELECT 'elements',, COUNT(*) FROM elementsUNION ALL SELECT 'memories',, COUNT(* FROM memoriesUNION ALL SELECT 'meetings', COUNT(*) FROM meetingsUNION ALL SELECT 'ui_events', COUNT(*) FROM ui_eventsUNION ALL SELECT 'pipe_executions', COUNT(*) FROM pipe_executions;"video_chunks 1428audio_chunks 190frames|20163ocr_text|15011audio_transcriptionsl3elements/1222571memoriesl0meetings10ui_events126965pipe_executions 10lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $*5-zsh86-zshO ₴7.* Unable to a...O x8-zsh1₴1|*9...
|
NULL
|
-5063688389916252066
|
NULL
|
idle
|
ocr
|
NULL
|
iTerm2Shell Edit ViewSessionScriptsProfilesWindo iTerm2Shell Edit ViewSessionScriptsProfilesWindowHelp‹ >0 lol& Support Daily - in 3h 29m |100% C47 8 Wed 15 Apr 11:31:37-zsh-zshDOCKER₴81idx_memories_sourcel0memories_fts_datal0memories_fts_idx10memories_fts_docsizel0memories_fts_configl0frames_fts_configl0idx_memories_frame_idi0idx_frames_sync_idl0idx_ocr_text_sync_idl0idx_audio_transcriptions_sync_idl0DEV (-zsh)$82APP (-zsh)83ec2-user@ip-10-.. 884sqlite_autoindex_secrets_110Lukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "SELECTname,(SELECT COUNT(*) FROM sqlite_master WHERE type='table' AND name=m.name) as existsFROM sqlite_masterWHERE type='table'ORDER BY name;"Error: in prepare, near "exists": syntax errorite_master WHERE type='table' AND name=m.name) as exists FROM sqlite_master Werror here ---^lukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "SELECTUNTON deLL SunkS asutbl, chouVTC, OSNTC-) FROM ideo-ChunksUNION ALL SELECT 'frames', COUNT(*) FROM framesUNION ALL SELECT 'ocr_text', COUNT(*) FROM ocr_textUNION ALL SELECT 'audio_transcriptions', COUNT(*) FROM audio_transcriptionsUNION ALL SELECT 'elements',, COUNT(*) FROM elementsUNION ALL SELECT 'memories',, COUNT(* FROM memoriesUNION ALL SELECT 'meetings', COUNT(*) FROM meetingsUNION ALL SELECT 'ui_events', COUNT(*) FROM ui_eventsUNION ALL SELECT 'pipe_executions', COUNT(*) FROM pipe_executions;"video_chunks 1428audio_chunks 190frames|20163ocr_text|15011audio_transcriptionsl3elements/1222571memoriesl0meetings10ui_events126965pipe_executions 10lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $*5-zsh86-zshO ₴7.* Unable to a...O x8-zsh1₴1|*9...
|
NULL
|
NULL
|
|
20178
|
436
|
0
|
2026-04-15T08:31:44.429850+00:00
|
/Users/lukas/.screenpipe/data/data/2026-04-15/1776 /Users/lukas/.screenpipe/data/data/2026-04-15/1776241904429_m2.jpg...
|
NULL
|
NULL
|
1
|
NULL
|
monitor_2
|
NULL
|
NULL
|
NULL
|
NULL
|
CaudeFileFdit000+ New chatQ SearchcustomizeChatsPr CaudeFileFdit000+ New chatQ SearchcustomizeChatsProjects88 ArtifactsStarredBulgarian citizenship application...Dawarich location tracking projectHecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter API...Screenpipe 14-day retention exp...neaalt nomepage reea overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso...Importing Google Timeline data t...chromecast remote volume buct...Screenpipe free version guideSelf-hosted LLM alternatives to .Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General niorm.ron realestRed dots on neck causesViewWindowHelp40 hal#Support Daily - in 3h 29m100% C8Wed 15 Apr 11:31:44ChatLOWOrkCodeLinux SQLite Ul for NAS vthe most expensive. Your options:Option A - Copy everything (current plan) Fine if NAS has space. The DB is ~120+ GBuncompressed though, so nightly full copy gets heavy fast.Option B — Selective archive: drop elements on NAS-- After copying to NAS, strip elements to save ~9GB per sync periodDELETE FROM elements WHERE frame_id IN (SELECT id FROM frames WHERE timestamp ‹ datetime('now', '-30 days')Then VACUUM to reclaim spaceVACUUM;Option C - Incremental sync (better long-term) Instead of full DB copy, append only newrows since last sync using (rowid or timestamp] Much lighter.Recommended sync script skeleton:bash#!/bin/bashNAS="/Volumes/screenpipe" # or your SMB mountLOCAL_DB="$HOME/.screenpipe/db.sqlite"LAST_SYNC_FILE="$NAS/.last_sync_frame_id"# Get last synced frame idLAST_ID=$(cat "$LAST_SYNC_FILE" 2>/dev/null || echo 0)# Export new frames + ocr_text since last sync to NAS DBsalite3 "SLOCAL DB" "ATTACH '$NAS/db_archive.sqlite' AS nas;INSERT OR IGNORE INTO nas.frames SELECT * FROM frames WHERE id > $LAST_ID;INSERT OR IGNORE INTO nas.ocr_text SELECT * FROM ocr_text WHERE frame_id > $LAST_IINSERT OR IGNORE INTO nas.video_chunks SELECT * FROM video_chunks;# save new nign waterharksqlite3 "$LOCAL_DB" "SELECT MAX(id) FROM frames;" > "$LAST_SYNC_FILE"Want me to build out the full script with video/audio file rsync + path rewriting included?Updated to 1.2581.0RelaunchLukas KovalikPro nianReply...sonner40 v...
|
NULL
|
-1013365083810192283
|
NULL
|
visual_change
|
ocr
|
NULL
|
CaudeFileFdit000+ New chatQ SearchcustomizeChatsPr CaudeFileFdit000+ New chatQ SearchcustomizeChatsProjects88 ArtifactsStarredBulgarian citizenship application...Dawarich location tracking projectHecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter API...Screenpipe 14-day retention exp...neaalt nomepage reea overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso...Importing Google Timeline data t...chromecast remote volume buct...Screenpipe free version guideSelf-hosted LLM alternatives to .Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General niorm.ron realestRed dots on neck causesViewWindowHelp40 hal#Support Daily - in 3h 29m100% C8Wed 15 Apr 11:31:44ChatLOWOrkCodeLinux SQLite Ul for NAS vthe most expensive. Your options:Option A - Copy everything (current plan) Fine if NAS has space. The DB is ~120+ GBuncompressed though, so nightly full copy gets heavy fast.Option B — Selective archive: drop elements on NAS-- After copying to NAS, strip elements to save ~9GB per sync periodDELETE FROM elements WHERE frame_id IN (SELECT id FROM frames WHERE timestamp ‹ datetime('now', '-30 days')Then VACUUM to reclaim spaceVACUUM;Option C - Incremental sync (better long-term) Instead of full DB copy, append only newrows since last sync using (rowid or timestamp] Much lighter.Recommended sync script skeleton:bash#!/bin/bashNAS="/Volumes/screenpipe" # or your SMB mountLOCAL_DB="$HOME/.screenpipe/db.sqlite"LAST_SYNC_FILE="$NAS/.last_sync_frame_id"# Get last synced frame idLAST_ID=$(cat "$LAST_SYNC_FILE" 2>/dev/null || echo 0)# Export new frames + ocr_text since last sync to NAS DBsalite3 "SLOCAL DB" "ATTACH '$NAS/db_archive.sqlite' AS nas;INSERT OR IGNORE INTO nas.frames SELECT * FROM frames WHERE id > $LAST_ID;INSERT OR IGNORE INTO nas.ocr_text SELECT * FROM ocr_text WHERE frame_id > $LAST_IINSERT OR IGNORE INTO nas.video_chunks SELECT * FROM video_chunks;# save new nign waterharksqlite3 "$LOCAL_DB" "SELECT MAX(id) FROM frames;" > "$LAST_SYNC_FILE"Want me to build out the full script with video/audio file rsync + path rewriting included?Updated to 1.2581.0RelaunchLukas KovalikPro nianReply...sonner40 v...
|
20176
|
NULL
|
|
20179
|
435
|
1
|
2026-04-15T08:31:44.966698+00:00
|
/Users/lukas/.screenpipe/data/data/2026-04-15/1776 /Users/lukas/.screenpipe/data/data/2026-04-15/1776241904966_m1.jpg...
|
NULL
|
NULL
|
1
|
NULL
|
monitor_1
|
NULL
|
NULL
|
NULL
|
NULL
|
iTerm2Shell Edit ViewSessionScriptsProfilesWindo iTerm2Shell Edit ViewSessionScriptsProfilesWindowHelp‹ >0 ll& Support Daily - in 3h 29m |100% C47 8 Wed 15 Apr 11:31:44-zsh-zshDOCKER₴81idx_memories_sourcel0memories_fts_datal0memories_fts_idx10memories_fts_docsizel0memories_fts_configl0frames_fts_configl0idx_memories_frame_idi0idx_frames_sync_idl0idx_ocr_text_sync_idl0idx_audio_transcriptions_sync_idl0DEV (-zsh)H82APP (-zsh)83ec2-user@ip-10-.. 884sqlite_autoindex_secrets_110Lukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "SELECTname,(SELECT COUNT(*) FROM sqlite_master WHERE type='table' AND name=m.name) as existsFROM sqlite_masterWHERE type='table'ORDER BY name;"Error: in prepare, near "exists": syntax errorite_master WHERE type='table' AND name=m.name) as exists FROM sqlite_master Werror here ---^lukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "SELECTUNTON deLL SunkS asutbl, chouVTC, OSNTC-) FROM ideo-ChunksUNION ALL SELECT 'frames', COUNT(*) FROM framesUNION ALL SELECT 'ocr_text', COUNT(*) FROM ocr_textUNION ALL SELECT 'audio_transcriptions', COUNT(*) FROM audio_transcriptionsUNION ALL SELECT 'elements',, COUNT(*) FROM elementsUNION ALL SELECT 'memories',, COUNT(* FROM memoriesUNION ALL SELECT 'meetings', COUNT(*) FROM meetingsUNION ALL SELECT 'ui_events', COUNT(*) FROM ui_eventsUNION ALL SELECT 'pipe_executions', COUNT(*) FROM pipe_executions;"video_chunks 1428audio_chunks 190frames|20163ocr_text|15011audio_transcriptionsl3elements/1222571memoriesl0meetings10ui_events126965pipe_executions 10lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $*5-zsh86-zshO ₴7.* Unable to a...O 88-zsh*9...
|
NULL
|
-7522888531660018424
|
NULL
|
click
|
ocr
|
NULL
|
iTerm2Shell Edit ViewSessionScriptsProfilesWindo iTerm2Shell Edit ViewSessionScriptsProfilesWindowHelp‹ >0 ll& Support Daily - in 3h 29m |100% C47 8 Wed 15 Apr 11:31:44-zsh-zshDOCKER₴81idx_memories_sourcel0memories_fts_datal0memories_fts_idx10memories_fts_docsizel0memories_fts_configl0frames_fts_configl0idx_memories_frame_idi0idx_frames_sync_idl0idx_ocr_text_sync_idl0idx_audio_transcriptions_sync_idl0DEV (-zsh)H82APP (-zsh)83ec2-user@ip-10-.. 884sqlite_autoindex_secrets_110Lukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "SELECTname,(SELECT COUNT(*) FROM sqlite_master WHERE type='table' AND name=m.name) as existsFROM sqlite_masterWHERE type='table'ORDER BY name;"Error: in prepare, near "exists": syntax errorite_master WHERE type='table' AND name=m.name) as exists FROM sqlite_master Werror here ---^lukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "SELECTUNTON deLL SunkS asutbl, chouVTC, OSNTC-) FROM ideo-ChunksUNION ALL SELECT 'frames', COUNT(*) FROM framesUNION ALL SELECT 'ocr_text', COUNT(*) FROM ocr_textUNION ALL SELECT 'audio_transcriptions', COUNT(*) FROM audio_transcriptionsUNION ALL SELECT 'elements',, COUNT(*) FROM elementsUNION ALL SELECT 'memories',, COUNT(* FROM memoriesUNION ALL SELECT 'meetings', COUNT(*) FROM meetingsUNION ALL SELECT 'ui_events', COUNT(*) FROM ui_eventsUNION ALL SELECT 'pipe_executions', COUNT(*) FROM pipe_executions;"video_chunks 1428audio_chunks 190frames|20163ocr_text|15011audio_transcriptionsl3elements/1222571memoriesl0meetings10ui_events126965pipe_executions 10lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $*5-zsh86-zshO ₴7.* Unable to a...O 88-zsh*9...
|
20177
|
NULL
|
|
20180
|
436
|
1
|
2026-04-15T08:31:47.481344+00:00
|
/Users/lukas/.screenpipe/data/data/2026-04-15/1776 /Users/lukas/.screenpipe/data/data/2026-04-15/1776241907481_m2.jpg...
|
NULL
|
NULL
|
1
|
NULL
|
monitor_2
|
NULL
|
NULL
|
NULL
|
NULL
|
CaudeFileFdit000+ New chatQ SearchcustomizeChatsPr CaudeFileFdit000+ New chatQ SearchcustomizeChatsProjects88 ArtifactsStarredBulgarian citizenship application...Dawarich location tracking projectHecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter API...Screenpipe 14-day retention exp...neaalt nomepage reea overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso...Importing Google Timeline data t...chromecast remote volume buct...Screenpipe free version guideSelf-hosted LLM alternatives to .Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General normarion redlestRed dots on neck causesViewWindowHelp. 40 ll#Support Daily - in 3h 29m100% C8Wed 15 Apr 11:31:47ChatLoWOrkCodeLinux SQLite Ul for NAS vFor row counts + estimated size:SELECT'video_chunks' as tbl, COUNT(*) as rows FROM video_chunksUNIUN ALL SELECI 'aUalo chunks', CuUnl(") FRoM audlo chunksUNION ALL SELECT 'frames', COUNT(*) FROM framesUINLUN ALL SELZUIE'ocr_text', COUNT(*) FROM ocr_textUNION ALL SELECT'audio_transcriptions', COUNT(*) FROM audio_transcriptionsUNION ALL SELECT'elements', COUNT(*) FROM elementsUNION ALL SELECT'memories',COUNT(*) FROM memoriesUNION ALL SELECT 'meetings',COUNT (*) FROM meetingsUNION ALL SELECT 'ui_events', COUNT(*) FROM vi_eventsUNION ALL SELECT 'pipe_executions', COUNT(*) FROM pipe_executions;For actual byte size per table (SQLite page-level):SELECTname,pgsize * pageno / 1024 / 1024 as size_mbFROM dbstatWHERE aggregate = TRUEORDER BY pgsize * pageno DESC;Regarding retention - yes, you need a strategy. Screenpipe has a built-in retention setting(in its config) that deletes old video/audio files and their DB rows after N days. The problemfor your NAS sync architecture is:• If Screenpipe deletes rows locally, your NAS copy (from last night) still has them -good, that's your long-term archive• But (file_path) values in the NAS DB still point to the MacBook's local paths, which nolonger existThe approach we discussed previously (nightly full DB copy + media accumulating on NAS,paths rewritten) handles this correctly - the NAS DB becomes the source of truth forhistory. The local MacBook DB is just the live working set.Want me to draft the path-rewriting SQL and sync script based on what I can see of theschema here?lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3~/.screenpipe/db.sqlite"SELECTMAMAUpdated to 1.2581.0RelaunchLukas KovalikPro nianReply...sonnet 46 vClaudtro mrand can make mistakes. rlease double-cneck responses....
|
NULL
|
-3608395344766256206
|
NULL
|
visual_change
|
ocr
|
NULL
|
CaudeFileFdit000+ New chatQ SearchcustomizeChatsPr CaudeFileFdit000+ New chatQ SearchcustomizeChatsProjects88 ArtifactsStarredBulgarian citizenship application...Dawarich location tracking projectHecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter API...Screenpipe 14-day retention exp...neaalt nomepage reea overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso...Importing Google Timeline data t...chromecast remote volume buct...Screenpipe free version guideSelf-hosted LLM alternatives to .Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General normarion redlestRed dots on neck causesViewWindowHelp. 40 ll#Support Daily - in 3h 29m100% C8Wed 15 Apr 11:31:47ChatLoWOrkCodeLinux SQLite Ul for NAS vFor row counts + estimated size:SELECT'video_chunks' as tbl, COUNT(*) as rows FROM video_chunksUNIUN ALL SELECI 'aUalo chunks', CuUnl(") FRoM audlo chunksUNION ALL SELECT 'frames', COUNT(*) FROM framesUINLUN ALL SELZUIE'ocr_text', COUNT(*) FROM ocr_textUNION ALL SELECT'audio_transcriptions', COUNT(*) FROM audio_transcriptionsUNION ALL SELECT'elements', COUNT(*) FROM elementsUNION ALL SELECT'memories',COUNT(*) FROM memoriesUNION ALL SELECT 'meetings',COUNT (*) FROM meetingsUNION ALL SELECT 'ui_events', COUNT(*) FROM vi_eventsUNION ALL SELECT 'pipe_executions', COUNT(*) FROM pipe_executions;For actual byte size per table (SQLite page-level):SELECTname,pgsize * pageno / 1024 / 1024 as size_mbFROM dbstatWHERE aggregate = TRUEORDER BY pgsize * pageno DESC;Regarding retention - yes, you need a strategy. Screenpipe has a built-in retention setting(in its config) that deletes old video/audio files and their DB rows after N days. The problemfor your NAS sync architecture is:• If Screenpipe deletes rows locally, your NAS copy (from last night) still has them -good, that's your long-term archive• But (file_path) values in the NAS DB still point to the MacBook's local paths, which nolonger existThe approach we discussed previously (nightly full DB copy + media accumulating on NAS,paths rewritten) handles this correctly - the NAS DB becomes the source of truth forhistory. The local MacBook DB is just the live working set.Want me to draft the path-rewriting SQL and sync script based on what I can see of theschema here?lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3~/.screenpipe/db.sqlite"SELECTMAMAUpdated to 1.2581.0RelaunchLukas KovalikPro nianReply...sonnet 46 vClaudtro mrand can make mistakes. rlease double-cneck responses....
|
NULL
|
NULL
|
|
20181
|
435
|
2
|
2026-04-15T08:31:50.456392+00:00
|
/Users/lukas/.screenpipe/data/data/2026-04-15/1776 /Users/lukas/.screenpipe/data/data/2026-04-15/1776241910456_m1.jpg...
|
NULL
|
NULL
|
1
|
NULL
|
monitor_1
|
NULL
|
NULL
|
NULL
|
NULL
|
iTerm2Shell Edit ViewSessionScriptsProfilesWindo iTerm2Shell Edit ViewSessionScriptsProfilesWindowHelp‹ >0 ll-zsh-zshDOCKER₴81idx_memories_sourcel0memories_fts_datal0memories_fts_idx10memories_fts_docsizel0memories_fts_configl0frames_fts_configl0idx_memories_frame_idi0idx_frames_sync_idl0idx_ocr_text_sync_idl0idx_audio_transcriptions_sync_idl0DEV (-zsh)H82APP (-zsh)83ec2-user@ip-10-.. 884sqlite_autoindex_secrets_110Lukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "SELECTname,(SELECT COUNT(*) FROM sqlite_master WHERE type='table' AND name=m.name) as existsFROM sqlite_masterWHERE type='table'ORDER BY name;"Error: in prepare, near "exists": syntax errorite_master WHERE type='table' AND name=m.name) as exists FROM sqlite_master Werror here ---^lukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "SELECTUNTON deLL SunkS asutbl, chouVTC, OSNTC-) FROM ideo-ChunksUNION ALL SELECT 'frames', COUNT(*) FROM framesUNION ALL SELECT 'ocr_text', COUNT(*) FROM ocr_textUNION ALL SELECT 'audio_transcriptions', COUNT(*) FROM audio_transcriptionsUNION ALL SELECT 'elements',, COUNT(*) FROM elementsUNION ALL SELECT 'memories',, COUNT(* FROM memoriesUNION ALL SELECT 'meetings', COUNT(*) FROM meetingsUNION ALL SELECT 'ui_events', COUNT(*) FROM ui_eventsUNION ALL SELECT 'pipe_executions', COUNT(*) FROM pipe_executions;"video_chunks 1428audio_chunks 190frames|20163ocr_text|15011audio_transcriptionsl3elements/1222571memoriesl0meetings10ui_events126965pipe_executions 10lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $*5-zsh& Support Daily - in 3h 29m |100% C47 8 Wed 15 Apr 11:31:49T₴1|86-zshO ₴7.* Unable to a...O 88-zsh*9...
|
NULL
|
7169838686063876519
|
NULL
|
click
|
ocr
|
NULL
|
iTerm2Shell Edit ViewSessionScriptsProfilesWindo iTerm2Shell Edit ViewSessionScriptsProfilesWindowHelp‹ >0 ll-zsh-zshDOCKER₴81idx_memories_sourcel0memories_fts_datal0memories_fts_idx10memories_fts_docsizel0memories_fts_configl0frames_fts_configl0idx_memories_frame_idi0idx_frames_sync_idl0idx_ocr_text_sync_idl0idx_audio_transcriptions_sync_idl0DEV (-zsh)H82APP (-zsh)83ec2-user@ip-10-.. 884sqlite_autoindex_secrets_110Lukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "SELECTname,(SELECT COUNT(*) FROM sqlite_master WHERE type='table' AND name=m.name) as existsFROM sqlite_masterWHERE type='table'ORDER BY name;"Error: in prepare, near "exists": syntax errorite_master WHERE type='table' AND name=m.name) as exists FROM sqlite_master Werror here ---^lukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "SELECTUNTON deLL SunkS asutbl, chouVTC, OSNTC-) FROM ideo-ChunksUNION ALL SELECT 'frames', COUNT(*) FROM framesUNION ALL SELECT 'ocr_text', COUNT(*) FROM ocr_textUNION ALL SELECT 'audio_transcriptions', COUNT(*) FROM audio_transcriptionsUNION ALL SELECT 'elements',, COUNT(*) FROM elementsUNION ALL SELECT 'memories',, COUNT(* FROM memoriesUNION ALL SELECT 'meetings', COUNT(*) FROM meetingsUNION ALL SELECT 'ui_events', COUNT(*) FROM ui_eventsUNION ALL SELECT 'pipe_executions', COUNT(*) FROM pipe_executions;"video_chunks 1428audio_chunks 190frames|20163ocr_text|15011audio_transcriptionsl3elements/1222571memoriesl0meetings10ui_events126965pipe_executions 10lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $*5-zsh& Support Daily - in 3h 29m |100% C47 8 Wed 15 Apr 11:31:49T₴1|86-zshO ₴7.* Unable to a...O 88-zsh*9...
|
NULL
|
NULL
|
|
20183
|
436
|
2
|
2026-04-15T08:31:50.443186+00:00
|
/Users/lukas/.screenpipe/data/data/2026-04-15/1776 /Users/lukas/.screenpipe/data/data/2026-04-15/1776241910443_m2.jpg...
|
NULL
|
NULL
|
1
|
NULL
|
monitor_2
|
NULL
|
NULL
|
NULL
|
NULL
|
CaudeFileEoit000+ New chatQ SearchcustomizeChatsPr CaudeFileEoit000+ New chatQ SearchcustomizeChatsProjects88 ArtifactsStarredBulgarian citizenship application..Dawarich location tracking projectHecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter API...Screenpipe 14-day retention exp...neaalt nomepage reea overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso...Importing Google Timeline data t...chromecast remote volume buct...Screenpipe free version guideSelf-hosted LLM alternatives to .Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General niorm.ron realestRed dots on neck causesViewWindowHelp40 half Support Daily - in 3h 29m100% C8Wed 15 Apr 11:31:50ChatLoWOrkCodeLinux SQLite Ul for NAS vpgsize * pageno / 1024 / 1024 as size_mbFROM dbstatWHERE aggregate = TRUEORDER BY pgsize * pageno DESC;"Show moreGreat data. Here's what this tells us:Size breakdown (the values are actually bytes, not MB — the formula was wrong):TableReal sizeNotesocr_text~OLUD*Massive - text extracted from everv frameframes~45 GBFrame metadata + likely snapshot pathselements~X6TR1.2M rows — UI elements per frameFTS indexesNSTRSearch indexes for aboveEverything else is essentially empty (audio, transcriptions, memories, meetings — all 0 ornear-0).Row counts context:• 428 video chunks, 20k frames → roughly consistent (frames sampled from video)• 1,222,571 elements rows for 20k frames = ~60 UI elements detected per frame - this isthe real storage killer• audio_transcriptions only 3 rows despite 90 audio chunks → mic probably off orWhisper not runningKey insight for your NAS retention strategy:The bulk of the DB is ocr_text) + (elements . These are the most useful for search but alsothe most expensive. Your options:Option A - Copy everything (current plan) Fine if NAS has space. The DB is ~120+ GBuncompressed though, so nightly full copy gets heavy fast.Option B - Selective archive: drop elements on NASUpdated to 1.2581.0RelaunchLukas KovalikPro nian-- After copying to NAS, strip elements to save ~9CB per sync periodDELETE FROM elements WHERE frame_id IN (SELECT id FROM frames WHERE timestamp < datetime('now', '-30 days'));Then VACUUM to reclaim spaceVACUUM;Reply...sonnet 46 vClaudtro mrand can make mistakes. rlease double-cneck responses....
|
NULL
|
1087499375861038246
|
NULL
|
click
|
ocr
|
NULL
|
CaudeFileEoit000+ New chatQ SearchcustomizeChatsPr CaudeFileEoit000+ New chatQ SearchcustomizeChatsProjects88 ArtifactsStarredBulgarian citizenship application..Dawarich location tracking projectHecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter API...Screenpipe 14-day retention exp...neaalt nomepage reea overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso...Importing Google Timeline data t...chromecast remote volume buct...Screenpipe free version guideSelf-hosted LLM alternatives to .Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General niorm.ron realestRed dots on neck causesViewWindowHelp40 half Support Daily - in 3h 29m100% C8Wed 15 Apr 11:31:50ChatLoWOrkCodeLinux SQLite Ul for NAS vpgsize * pageno / 1024 / 1024 as size_mbFROM dbstatWHERE aggregate = TRUEORDER BY pgsize * pageno DESC;"Show moreGreat data. Here's what this tells us:Size breakdown (the values are actually bytes, not MB — the formula was wrong):TableReal sizeNotesocr_text~OLUD*Massive - text extracted from everv frameframes~45 GBFrame metadata + likely snapshot pathselements~X6TR1.2M rows — UI elements per frameFTS indexesNSTRSearch indexes for aboveEverything else is essentially empty (audio, transcriptions, memories, meetings — all 0 ornear-0).Row counts context:• 428 video chunks, 20k frames → roughly consistent (frames sampled from video)• 1,222,571 elements rows for 20k frames = ~60 UI elements detected per frame - this isthe real storage killer• audio_transcriptions only 3 rows despite 90 audio chunks → mic probably off orWhisper not runningKey insight for your NAS retention strategy:The bulk of the DB is ocr_text) + (elements . These are the most useful for search but alsothe most expensive. Your options:Option A - Copy everything (current plan) Fine if NAS has space. The DB is ~120+ GBuncompressed though, so nightly full copy gets heavy fast.Option B - Selective archive: drop elements on NASUpdated to 1.2581.0RelaunchLukas KovalikPro nian-- After copying to NAS, strip elements to save ~9CB per sync periodDELETE FROM elements WHERE frame_id IN (SELECT id FROM frames WHERE timestamp < datetime('now', '-30 days'));Then VACUUM to reclaim spaceVACUUM;Reply...sonnet 46 vClaudtro mrand can make mistakes. rlease double-cneck responses....
|
20180
|
NULL
|
|
20187
|
435
|
6
|
2026-04-15T08:32:03.374795+00:00
|
/Users/lukas/.screenpipe/data/data/2026-04-15/1776 /Users/lukas/.screenpipe/data/data/2026-04-15/1776241923374_m1.jpg...
|
NULL
|
NULL
|
1
|
NULL
|
monitor_1
|
NULL
|
NULL
|
NULL
|
NULL
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp••-zshDOCKER₴81DEV (-zsh)182APP (-zsh)83ec2-user@ip-10-... 884-zshsqlite_autoindex_secrets_110lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "SELECTname,(SELECT COUNT(*) FROM salite_master WHERE type='table'AND name=m.name) as existssqlite_masterWHEREtype='table'ORDER BY name;"Error: in prepare,near "exists":syntax errorite_master WHERE type='table'AND name=m.name)as existsFROM sqlite_master Werror here-==Nlukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "SELECT"video_chunks'as tbl, COUNT(*) asrows FROM video_chunksUNION ALL SELECT 'audio_chunks'COUNT(*) FROMaudio_chunksUNION ALLSELECT 'frames'COUNT(*) FROM framesUNIONUNIONALL SELECT 'ocr_text', COUNT(*)FROM ocr_textALL SELECT 'audio_transcriptions'COUNT(*)FROM audio_transcriptionsUNION ALL SELECT 'elements', COUNT(*) FROM elementsUNION ALL SELECT 'memories'.UNZON ALL SELECT 'meetrnes , COUNT(*) FROM meetingsUNION ALL SELECT "ui_events', CONTT*) FROM meetings, COUNT(*) FROM ui_eventsUNION ALL SELECT 'pipe_executions', COUNT(*) FROM pipe_executions;"video_chunks|428audio_chunks190frames|20163ocr_text|15011audio_transcriptionsI3elements/1222571memorieslomeetingsl0ui_events126965pipe_executions10Lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe2.7G/Users/lukas/.screenpipelukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ |# Support Daily - in 3h 28 m100% (<47*5-zsh86-zshK- 87* Unable to a...88Wed 15 Apr 11:32:02-zshT81+...
|
NULL
|
-5207537332106049073
|
NULL
|
click
|
ocr
|
NULL
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp••-zshDOCKER₴81DEV (-zsh)182APP (-zsh)83ec2-user@ip-10-... 884-zshsqlite_autoindex_secrets_110lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "SELECTname,(SELECT COUNT(*) FROM salite_master WHERE type='table'AND name=m.name) as existssqlite_masterWHEREtype='table'ORDER BY name;"Error: in prepare,near "exists":syntax errorite_master WHERE type='table'AND name=m.name)as existsFROM sqlite_master Werror here-==Nlukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "SELECT"video_chunks'as tbl, COUNT(*) asrows FROM video_chunksUNION ALL SELECT 'audio_chunks'COUNT(*) FROMaudio_chunksUNION ALLSELECT 'frames'COUNT(*) FROM framesUNIONUNIONALL SELECT 'ocr_text', COUNT(*)FROM ocr_textALL SELECT 'audio_transcriptions'COUNT(*)FROM audio_transcriptionsUNION ALL SELECT 'elements', COUNT(*) FROM elementsUNION ALL SELECT 'memories'.UNZON ALL SELECT 'meetrnes , COUNT(*) FROM meetingsUNION ALL SELECT "ui_events', CONTT*) FROM meetings, COUNT(*) FROM ui_eventsUNION ALL SELECT 'pipe_executions', COUNT(*) FROM pipe_executions;"video_chunks|428audio_chunks190frames|20163ocr_text|15011audio_transcriptionsI3elements/1222571memorieslomeetingsl0ui_events126965pipe_executions10Lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe2.7G/Users/lukas/.screenpipelukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ |# Support Daily - in 3h 28 m100% (<47*5-zsh86-zshK- 87* Unable to a...88Wed 15 Apr 11:32:02-zshT81+...
|
NULL
|
NULL
|
|
20188
|
436
|
4
|
2026-04-15T08:32:03.397775+00:00
|
/Users/lukas/.screenpipe/data/data/2026-04-15/1776 /Users/lukas/.screenpipe/data/data/2026-04-15/1776241923397_m2.jpg...
|
NULL
|
NULL
|
1
|
NULL
|
monitor_2
|
NULL
|
NULL
|
NULL
|
NULL
|
caudeFileEditViewWindowHelp‹→0 hlSupport Daily • i caudeFileEditViewWindowHelp‹→0 hlSupport Daily • in 3h 28m100% CWed 15 Apr 11:32:02ChatLoWOrkCode+ New chatQ SearchcustomizeQ Chats6 Projects88 ArtifactsStarredBulgarian citizenship application..Dawarich location tracking projectHecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter API...Screenpipe 14-day retention exp...neaalt nomepage reea overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso...Importing Google Timeline data t...chromecast remote volume buct...Screenpipe free version guideSelf-hosted LLM alternatives to .Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General niorm.ron realestRed dots on neck causesLinux SQLite Ul for NAS vpgsize * pageno / 1024 / 1024 as size_mbFROM dbstatWHERE aggregate = TRUEORDER BY pgsize * pageno DESC;"Show moreGreat data. Here's what this tells us:Size breakdown (the values are actually bytes, not MB — the formula was wrong):Tableocr_textframeselementsFTS indexesReal size~OLUD~45 GB~X6TRNSTRNotes*Massive - text extracted from everv frameFrame metadata + likely snapshot paths1.2M rows — UI elements per frameSearch indexes for aboveEverything else is essentially empty (audio, transcriptions, memories, meetings — all 0 ornear-0).Row counts context:• 428 video chunks, 20k frames → roughly consistent (frames sampled from video)• 1,222,571 elements rows for 20k frames = ~60 UI elements detected per frame - this isthe real storage killer• audio_transcriptions only 3 rows despite 90 audio chunks → mic probably off orWhisper not runningKey insight for your NAS retention strategy:The bulk of the DB is ocr_text) + (elements . These are the most useful for search but alsothe most expensive. Your options:Option A - Copy everything (current plan) Fine if NAS has space. The DB is ~120+ GBuncompressed though, so nightly full copy gets heavy fast.Option B - Selective archive: drop elements on NASUpdated to 1.2581.0RelaunchLukas KovalikPro nian-- After copying to NAS, strip elements to save ~9CB per sync periodDELETE FROM elements WHERE frame_id IN (SELECT id FROM frames WHERE timestamp < datetime('now', '-30 days'));Then VACUUM to reclaim spaceVACUUM;Reply...sonnet 46 vClaudtro mrand can make mistakes. rlease double-cneck responses....
|
NULL
|
-3134202031071290468
|
NULL
|
click
|
ocr
|
NULL
|
caudeFileEditViewWindowHelp‹→0 hlSupport Daily • i caudeFileEditViewWindowHelp‹→0 hlSupport Daily • in 3h 28m100% CWed 15 Apr 11:32:02ChatLoWOrkCode+ New chatQ SearchcustomizeQ Chats6 Projects88 ArtifactsStarredBulgarian citizenship application..Dawarich location tracking projectHecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter API...Screenpipe 14-day retention exp...neaalt nomepage reea overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso...Importing Google Timeline data t...chromecast remote volume buct...Screenpipe free version guideSelf-hosted LLM alternatives to .Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General niorm.ron realestRed dots on neck causesLinux SQLite Ul for NAS vpgsize * pageno / 1024 / 1024 as size_mbFROM dbstatWHERE aggregate = TRUEORDER BY pgsize * pageno DESC;"Show moreGreat data. Here's what this tells us:Size breakdown (the values are actually bytes, not MB — the formula was wrong):Tableocr_textframeselementsFTS indexesReal size~OLUD~45 GB~X6TRNSTRNotes*Massive - text extracted from everv frameFrame metadata + likely snapshot paths1.2M rows — UI elements per frameSearch indexes for aboveEverything else is essentially empty (audio, transcriptions, memories, meetings — all 0 ornear-0).Row counts context:• 428 video chunks, 20k frames → roughly consistent (frames sampled from video)• 1,222,571 elements rows for 20k frames = ~60 UI elements detected per frame - this isthe real storage killer• audio_transcriptions only 3 rows despite 90 audio chunks → mic probably off orWhisper not runningKey insight for your NAS retention strategy:The bulk of the DB is ocr_text) + (elements . These are the most useful for search but alsothe most expensive. Your options:Option A - Copy everything (current plan) Fine if NAS has space. The DB is ~120+ GBuncompressed though, so nightly full copy gets heavy fast.Option B - Selective archive: drop elements on NASUpdated to 1.2581.0RelaunchLukas KovalikPro nian-- After copying to NAS, strip elements to save ~9CB per sync periodDELETE FROM elements WHERE frame_id IN (SELECT id FROM frames WHERE timestamp < datetime('now', '-30 days'));Then VACUUM to reclaim spaceVACUUM;Reply...sonnet 46 vClaudtro mrand can make mistakes. rlease double-cneck responses....
|
20186
|
NULL
|
|
20189
|
435
|
7
|
2026-04-15T08:32:05.012535+00:00
|
/Users/lukas/.screenpipe/data/data/2026-04-15/1776 /Users/lukas/.screenpipe/data/data/2026-04-15/1776241925012_m1.jpg...
|
NULL
|
NULL
|
1
|
NULL
|
monitor_1
|
NULL
|
NULL
|
NULL
|
NULL
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelpSupport Daily - in 3 h 28 m100% <478-zshWed 15 Apr 11:32:04T81DOCKER₴81DEV (-zsh)182APP (-zsh)83ec2-user@ip-10-.. 884-zshsqlite_autoindex_secrets_110lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "SELECTname,(SELECT COUNT(*) FROM salite_master WHERE type='table'AND name=m.name) as existsFROMsqlite_masterWHEREtype='table'ORDER BY name;"Error: in prepare,near"exists":syntax errorite_master WHERE type='table'AND name=m.name)as existsFROM sqlite_master Werror here-==Nlukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "SELECT"video_chunks'as tbl, COUNT(*) asrows FROM video_chunksUNION ALL SELECT 'audio_chunks'COUNT(*) FROM audio_chunksUNION ALLSELECT 'frames'COUNT(*) FROM framesUNIONUNIONALL SELECT 'ocr_text', COUNT(*)FROM ocr_textALL SELECT 'audio_transcriptions'COUNT(*)FROM audio_transcriptionsUNION ALL SELECT 'elements', COUNT(*) FROM elementsUNION ALL SELECT 'memories'.UNZON ALL SELECT 'meetrnes , COUNT(*) FROM meetingsUNION ALL SELECT "ui_events', CONTT*) FROM meetings, COUNT(*) FROM ui_eventsUNION ALL SELECT 'pipe_executions', COUNT(*) FROM pipe_executions;"video_chunks|428audio_chunks190frames|20163ocr_text|15011audio_transcriptionsI3elements/1222571memoriesl0meetingsl0ui_events126965pipe_executions10Lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe2.7G/Users/lukas/.screenpipeLukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ 0*5-zsh86-zshO 87* Unable to a...O 88-zsh...
|
NULL
|
2324685689823701180
|
NULL
|
visual_change
|
ocr
|
NULL
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelpSupport Daily - in 3 h 28 m100% <478-zshWed 15 Apr 11:32:04T81DOCKER₴81DEV (-zsh)182APP (-zsh)83ec2-user@ip-10-.. 884-zshsqlite_autoindex_secrets_110lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "SELECTname,(SELECT COUNT(*) FROM salite_master WHERE type='table'AND name=m.name) as existsFROMsqlite_masterWHEREtype='table'ORDER BY name;"Error: in prepare,near"exists":syntax errorite_master WHERE type='table'AND name=m.name)as existsFROM sqlite_master Werror here-==Nlukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "SELECT"video_chunks'as tbl, COUNT(*) asrows FROM video_chunksUNION ALL SELECT 'audio_chunks'COUNT(*) FROM audio_chunksUNION ALLSELECT 'frames'COUNT(*) FROM framesUNIONUNIONALL SELECT 'ocr_text', COUNT(*)FROM ocr_textALL SELECT 'audio_transcriptions'COUNT(*)FROM audio_transcriptionsUNION ALL SELECT 'elements', COUNT(*) FROM elementsUNION ALL SELECT 'memories'.UNZON ALL SELECT 'meetrnes , COUNT(*) FROM meetingsUNION ALL SELECT "ui_events', CONTT*) FROM meetings, COUNT(*) FROM ui_eventsUNION ALL SELECT 'pipe_executions', COUNT(*) FROM pipe_executions;"video_chunks|428audio_chunks190frames|20163ocr_text|15011audio_transcriptionsI3elements/1222571memoriesl0meetingsl0ui_events126965pipe_executions10Lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe2.7G/Users/lukas/.screenpipeLukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ 0*5-zsh86-zshO 87* Unable to a...O 88-zsh...
|
20187
|
NULL
|
|
20195
|
435
|
11
|
2026-04-15T08:32:24.871180+00:00
|
/Users/lukas/.screenpipe/data/data/2026-04-15/1776 /Users/lukas/.screenpipe/data/data/2026-04-15/1776241944871_m1.jpg...
|
NULL
|
NULL
|
1
|
NULL
|
monitor_1
|
NULL
|
NULL
|
NULL
|
NULL
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelplaol# Support Daily - in 3h 28 m100% (C47•-zshDOCKER₴81DEV (-zsh)₴82APP (-zsh)83ec2-user@ip-10-.. 884-zsh(SELECT COUNT(*)FROM sqlite_master WHERE type='table'ANDname=m.name) as existsFROM sqlite_masterWHERE type='table'ORDER BY name;"Error: in prepare, near"exists":syntaxerrorite_master WHERE type='table'AND name=m.name)as exists FROM sqlite_master Werror here---^lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "SELECT'video_chunks' as tbl, COUNT(*) as rows FROM video_chunksUNION ALL SELECT 'audio_chunks',COUNT(*) FROM audio_chunksUNION ALL SELECT 'frames', COUNT(*) FROM framesUNION ALL SELECT 'ocr_text', COUNT(*) FROM ocr_textUNION ALL SELECT 'audio_transcriptions', COUNT(*) FROM audio_transcriptionsUNION ALL SELECT 'elements', COUNT(*) FROM elementsUNION ALL SELECT 'memories', COUNT(*) FROM memoriesUNION ALL SELECT 'meetings'UNION ALL SELECTuteevents', COUNTC FROM ueteven, COUNT(*) FROM ui_eventsUNION ALL SELECT 'pipe_executions', COUNT(*) FROM pipe_executions;"video_chunks1428audio_chunks190frames|20163ocr_text|15011audio_transcriptionsI3elements/1222571memorieslomeetings10ui_events126965pipe_executionsl0lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe2.7G/Users/lukas/.screenpipelukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe/*4.0K/Users/lukas/.screenpipe/config.json1.3G/Users/lukas/.screenpipe/data1.4G/Users/lukas/.screenpipe/db.sqlite64K/Users/lukas/.screenpipe/db.sqlite-shm17M/Users/lukas/.screenpipe/db.sqlite-wal24K/Users/lukas/.screenpipe/pipes132K/Users/lukas/screenpipe/screenpipe.2026-04-09.0.10g96K/Users/Lukas/.screenpipe/screenpipe.2026-04-11.0.log72K/Users/lukas/.screenpipe/screenpipe.2026-04-12.0.10g72K/Users/lukas/.screenpipe/screenpipe.2026-04-13.0.10g160K/Users/lukas/.screenpipe/screenpipe.2026-04-14.0.10g64K/Users/lukas/.screenpipe/screenpipe.2026-04-15.0.10glukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $*5-zsh86-zshO ₴7.* Unable to a...88Wed 15 Apr 11:32:24-zshT81+...
|
NULL
|
-5573114895243774267
|
NULL
|
click
|
ocr
|
NULL
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelplaol# Support Daily - in 3h 28 m100% (C47•-zshDOCKER₴81DEV (-zsh)₴82APP (-zsh)83ec2-user@ip-10-.. 884-zsh(SELECT COUNT(*)FROM sqlite_master WHERE type='table'ANDname=m.name) as existsFROM sqlite_masterWHERE type='table'ORDER BY name;"Error: in prepare, near"exists":syntaxerrorite_master WHERE type='table'AND name=m.name)as exists FROM sqlite_master Werror here---^lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "SELECT'video_chunks' as tbl, COUNT(*) as rows FROM video_chunksUNION ALL SELECT 'audio_chunks',COUNT(*) FROM audio_chunksUNION ALL SELECT 'frames', COUNT(*) FROM framesUNION ALL SELECT 'ocr_text', COUNT(*) FROM ocr_textUNION ALL SELECT 'audio_transcriptions', COUNT(*) FROM audio_transcriptionsUNION ALL SELECT 'elements', COUNT(*) FROM elementsUNION ALL SELECT 'memories', COUNT(*) FROM memoriesUNION ALL SELECT 'meetings'UNION ALL SELECTuteevents', COUNTC FROM ueteven, COUNT(*) FROM ui_eventsUNION ALL SELECT 'pipe_executions', COUNT(*) FROM pipe_executions;"video_chunks1428audio_chunks190frames|20163ocr_text|15011audio_transcriptionsI3elements/1222571memorieslomeetings10ui_events126965pipe_executionsl0lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe2.7G/Users/lukas/.screenpipelukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe/*4.0K/Users/lukas/.screenpipe/config.json1.3G/Users/lukas/.screenpipe/data1.4G/Users/lukas/.screenpipe/db.sqlite64K/Users/lukas/.screenpipe/db.sqlite-shm17M/Users/lukas/.screenpipe/db.sqlite-wal24K/Users/lukas/.screenpipe/pipes132K/Users/lukas/screenpipe/screenpipe.2026-04-09.0.10g96K/Users/Lukas/.screenpipe/screenpipe.2026-04-11.0.log72K/Users/lukas/.screenpipe/screenpipe.2026-04-12.0.10g72K/Users/lukas/.screenpipe/screenpipe.2026-04-13.0.10g160K/Users/lukas/.screenpipe/screenpipe.2026-04-14.0.10g64K/Users/lukas/.screenpipe/screenpipe.2026-04-15.0.10glukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $*5-zsh86-zshO ₴7.* Unable to a...88Wed 15 Apr 11:32:24-zshT81+...
|
20193
|
NULL
|
|
20196
|
436
|
7
|
2026-04-15T08:32:24.871200+00:00
|
/Users/lukas/.screenpipe/data/data/2026-04-15/1776 /Users/lukas/.screenpipe/data/data/2026-04-15/1776241944871_m2.jpg...
|
NULL
|
NULL
|
1
|
NULL
|
monitor_2
|
NULL
|
NULL
|
NULL
|
NULL
|
caudeFileEditViewWindowHelp‹→0 hlSupport Daily - i caudeFileEditViewWindowHelp‹→0 hlSupport Daily - in 3h 28m100% CWed 15 Apr 11:32:24ChatcoworkCode+ New chatQ SearchcustomizeQ Chats6 Projects88 ArtifactsStarredBulgarian citizenship application...Dawarich location tracking projectHecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter APl ...Screenpipe 14-day retention exp...neaalt nomepage reed overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso...Importing Google Timeline data t...chromecast remote volume buct...Screenpipe free version guideSelf-hosted LLM alternatives to .Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General niormaron realestRed dots on neck causesLinux SQLite Ul for NAS vpgsize * pageno / 1024 / 1024 as size_mbFROM dbstatWHERE aggregate = TRUEORDER BY pgsize * pageno DESC;"Show moreGreat data. Here's what this tells us:Size breakdown (the values are actually bytes, not MB — the formula was wrong):TableReal sizeNotesocr_text~OLUD*Massive — text extracted from every frameframes~45 GBFrame metadata + likely snapshot pathselements~X.6CTR1.2M rows — UI elements per frameFTS indexesNSTRSearch indexes for aboveEverything else is essentially empty (audio, transcriptions, memories, meetings — all 0 ornear-0).Row counts context:• 428 video chunks, 20k frames → roughly consistent (frames sampled from video)• 1,222,571 elements rows for 20k frames = ~60 UI elements detected per frame - this isthe real storage killer• audio_transcriptions only 3 rows despite 90 audio chunks → mic probably off orWhisper not runningKey insight for your NAS retention strategy:The bulk of the DB is ocr_text) + (elements . These are the most useful for search but alsothe most expensive. Your options:Option A - Copy everything (current plan) Fine if NAS has space. The DB is ~120+ GBuncompressed though, so nightly full copy gets heavy fast.Option B - Selective archive: drop elements on NASUpdated to 1.2581.0RelaunchLukas KovalikPro nian-- After copying to NAS, strip elements to save ~9CB per sync periodDELETE FROM elements WHERE frame_id IN (SELECT id FROM frames WHERE timestampYatetime( 'now', '-30 days'));hen-Weulinuta roplarim chacebut the complete size is lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh~/.screenpipe2.7G /Users/lukas/.screenpipeSonnet 46 vclaude is Al and can make mistakes. rle...
|
NULL
|
-5748763978349219424
|
NULL
|
click
|
ocr
|
NULL
|
caudeFileEditViewWindowHelp‹→0 hlSupport Daily - i caudeFileEditViewWindowHelp‹→0 hlSupport Daily - in 3h 28m100% CWed 15 Apr 11:32:24ChatcoworkCode+ New chatQ SearchcustomizeQ Chats6 Projects88 ArtifactsStarredBulgarian citizenship application...Dawarich location tracking projectHecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter APl ...Screenpipe 14-day retention exp...neaalt nomepage reed overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso...Importing Google Timeline data t...chromecast remote volume buct...Screenpipe free version guideSelf-hosted LLM alternatives to .Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General niormaron realestRed dots on neck causesLinux SQLite Ul for NAS vpgsize * pageno / 1024 / 1024 as size_mbFROM dbstatWHERE aggregate = TRUEORDER BY pgsize * pageno DESC;"Show moreGreat data. Here's what this tells us:Size breakdown (the values are actually bytes, not MB — the formula was wrong):TableReal sizeNotesocr_text~OLUD*Massive — text extracted from every frameframes~45 GBFrame metadata + likely snapshot pathselements~X.6CTR1.2M rows — UI elements per frameFTS indexesNSTRSearch indexes for aboveEverything else is essentially empty (audio, transcriptions, memories, meetings — all 0 ornear-0).Row counts context:• 428 video chunks, 20k frames → roughly consistent (frames sampled from video)• 1,222,571 elements rows for 20k frames = ~60 UI elements detected per frame - this isthe real storage killer• audio_transcriptions only 3 rows despite 90 audio chunks → mic probably off orWhisper not runningKey insight for your NAS retention strategy:The bulk of the DB is ocr_text) + (elements . These are the most useful for search but alsothe most expensive. Your options:Option A - Copy everything (current plan) Fine if NAS has space. The DB is ~120+ GBuncompressed though, so nightly full copy gets heavy fast.Option B - Selective archive: drop elements on NASUpdated to 1.2581.0RelaunchLukas KovalikPro nian-- After copying to NAS, strip elements to save ~9CB per sync periodDELETE FROM elements WHERE frame_id IN (SELECT id FROM frames WHERE timestampYatetime( 'now', '-30 days'));hen-Weulinuta roplarim chacebut the complete size is lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh~/.screenpipe2.7G /Users/lukas/.screenpipeSonnet 46 vclaude is Al and can make mistakes. rle...
|
NULL
|
NULL
|
|
20197
|
435
|
12
|
2026-04-15T08:32:26.578541+00:00
|
/Users/lukas/.screenpipe/data/data/2026-04-15/1776 /Users/lukas/.screenpipe/data/data/2026-04-15/1776241946578_m1.jpg...
|
NULL
|
NULL
|
1
|
NULL
|
monitor_1
|
NULL
|
NULL
|
NULL
|
NULL
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp-zshlaal-zshSupport Daily • in 3 h 28 m100% <478Wed 15 Apr 11:32:26T81DOCKER₴81DEV (-zsh)₴82APP (-zsh)83ec2-user@ip-10-... 884-zsh(SELECT COUNT(*)FROM sqlite_master WHERE type='table'ANDname=m.name)as existsFROM sqlite_masterWHERE type='table'ORDER BY name;"Error: in prepare, near"exists":syntaxerrorite_master WHERE type='table'AND name=m. name)as exists FROM sqlite_master Werror here---^lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "SELECT'video_chunks' as tbl, COUNT(*) as rows FROM video_chunksUNION ALL SELECT 'audio_chunks',COUNT(*) FROM audio_chunksUNION ALL SELECT 'frames', COUNT(*) FROMframesUNION ALLSELECT 'ocr_text', COUNT(*) FROM ocr_textUNIONALL SELECT 'audio_transcriptions', COUNT(*) FROM audio_transcriptionsUNION ALL SELECT 'elements', COUNT(*) FROM elementsUNIONALL SELECT 'memories', COUNT(*) FROM memoriesUNION ALL SELECT 'meetings'UNIONALL SELECTuteevents', COUNTC FROM ueteven, COUNT(*) FROM ui_eventsUNION ALL SELECT 'pipe_executions', COUNT(*) FROM pipe_executions;"video_chunks1428audio_chunks190frames|20163ocr_text|15011audio_transcriptionsI3elements/1222571memoriesl0meetingsl0ui_events126965pipe_executionsl0lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe2.7G/Users/lukas/.screenpipelukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe/*4.0K/Users/lukas/.screenpipe/config.json1.3G/Users/lukas/.screenpipe/data1.4G/Users/lukas/.screenpipe/db.sqlite64K/Users/lukas/.screenpipe/db.sqlite-shm17M/Users/lukas/.screenpipe/db.sqlite-wal24K/Users/lukas/.screenpipe/pipes132K/Users/lukas/screenpipe/screenpipe.2026-04-09.0.10g96K/Users/Lukas/.screenpipe/screenpipe.2026-04-11.0.log72K/Users/lukas/.screenpipe/screenpipe.2026-04-12.0.10g72K/Users/lukas/.screenpipe/screenpipe.2026-04-13.0.10g160K/Users/lukas/.screenpipe/screenpipe.2026-04-14.0.10g64K/Users/lukas/.screenpipe/screenpipe.2026-04-15.0.10glukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $*586-zshX7* Unable to a...O 88-zsh...
|
NULL
|
-8874618517184863184
|
NULL
|
visual_change
|
ocr
|
NULL
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp-zshlaal-zshSupport Daily • in 3 h 28 m100% <478Wed 15 Apr 11:32:26T81DOCKER₴81DEV (-zsh)₴82APP (-zsh)83ec2-user@ip-10-... 884-zsh(SELECT COUNT(*)FROM sqlite_master WHERE type='table'ANDname=m.name)as existsFROM sqlite_masterWHERE type='table'ORDER BY name;"Error: in prepare, near"exists":syntaxerrorite_master WHERE type='table'AND name=m. name)as exists FROM sqlite_master Werror here---^lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "SELECT'video_chunks' as tbl, COUNT(*) as rows FROM video_chunksUNION ALL SELECT 'audio_chunks',COUNT(*) FROM audio_chunksUNION ALL SELECT 'frames', COUNT(*) FROMframesUNION ALLSELECT 'ocr_text', COUNT(*) FROM ocr_textUNIONALL SELECT 'audio_transcriptions', COUNT(*) FROM audio_transcriptionsUNION ALL SELECT 'elements', COUNT(*) FROM elementsUNIONALL SELECT 'memories', COUNT(*) FROM memoriesUNION ALL SELECT 'meetings'UNIONALL SELECTuteevents', COUNTC FROM ueteven, COUNT(*) FROM ui_eventsUNION ALL SELECT 'pipe_executions', COUNT(*) FROM pipe_executions;"video_chunks1428audio_chunks190frames|20163ocr_text|15011audio_transcriptionsI3elements/1222571memoriesl0meetingsl0ui_events126965pipe_executionsl0lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe2.7G/Users/lukas/.screenpipelukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe/*4.0K/Users/lukas/.screenpipe/config.json1.3G/Users/lukas/.screenpipe/data1.4G/Users/lukas/.screenpipe/db.sqlite64K/Users/lukas/.screenpipe/db.sqlite-shm17M/Users/lukas/.screenpipe/db.sqlite-wal24K/Users/lukas/.screenpipe/pipes132K/Users/lukas/screenpipe/screenpipe.2026-04-09.0.10g96K/Users/Lukas/.screenpipe/screenpipe.2026-04-11.0.log72K/Users/lukas/.screenpipe/screenpipe.2026-04-12.0.10g72K/Users/lukas/.screenpipe/screenpipe.2026-04-13.0.10g160K/Users/lukas/.screenpipe/screenpipe.2026-04-14.0.10g64K/Users/lukas/.screenpipe/screenpipe.2026-04-15.0.10glukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $*586-zshX7* Unable to a...O 88-zsh...
|
NULL
|
NULL
|
|
20198
|
436
|
8
|
2026-04-15T08:32:28.885747+00:00
|
/Users/lukas/.screenpipe/data/data/2026-04-15/1776 /Users/lukas/.screenpipe/data/data/2026-04-15/1776241948885_m2.jpg...
|
NULL
|
NULL
|
1
|
NULL
|
monitor_2
|
NULL
|
NULL
|
NULL
|
NULL
|
CaudeFileEoit000+ New chatQ SearchcustomizeChatsPr CaudeFileEoit000+ New chatQ SearchcustomizeChatsProjects88 ArtifactsStarredBulgarian citizenship application...Dawarich location tracking projectHecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter API...Screenpipe 14-day retention exp...neaalt nomepage reed overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso...Importing Google Timeline data t...chromecast remote volume duet...Screenpipe free version guideSelf-hosted LLM alternatives to .Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General niorm.ron realestRed dots on neck causesViewWindowHelp40 half Support Daily - in 3h 28mA100% C8Wed 15 Apr 11:32:28ChatcoworkCodeLinux SQLite Ul for NAS vpgsize * pageno / 1024 / 1024 as size_mbFROM dbstatWHERE aggregate = TRUEORDER BY pgsize * pageno DESC;"Show moreGreat data. Here's what this tells us:Size breakdown (the values are actually bytes, not MB — the formula was wrong):TableReal sizeNotesocr_text~OLUD* Massive — text extracted from everv frameframes~45 GBFrame metadata + likely snapshot pathselements~X6TR1.2M rows — UI elements per frameFTS indexesNSTRSearch indexes for aboveEverything else is essentially empty (audio, transcriptions, memories, meetings — all 0 ornear-0).Row counts context:• 428 video chunks, 20k frames → roughly consistent (frames sampled from video)• 1,222,571 elements rows for 20k frames = ~ 60 UI elements detected per frame - this isthe real storage killer• audio_transcriptions only 3 rows despite 90 audio chunks → mic probably off orWhisper not runningUpdated to 1.2581.0RelaunchLukas KovalikPro nianKey insight for your NAS retention strategy:but the complete size is lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh~/.screenpipe2.7G /Users/lukas/.screenpipelukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du-sh ~/.screenpipe/*4.0K /Users/lukas/.screenpipe/config.json1.3G /Users/lukas/.screenpipe/data1.4G /Users/lukas/.screenpipe/db.sqlite64K /Users/lukas/.screenpipe/db.sqlite-shm17M/Users/lukas/.screenpipe/db.sqlite-wal24K /Users/lukas/.screenpipe/pipes132K /Users/lukas/.screenpipe/screenpipe.2026-04-09.0.log96K /Users/lukas/.screenpipe/screenpipe.2026-04-11.0.log72K /Users/lukas/.screenpipe/screenpipe.2026-04-12.0.log72K /Users/lukas/.screenpipe/screenpipe.2026-04-13.0.log160K /Users/lukas/.screenpipe/screenpipe.2026-04-14.0.log64K /Users/lukas/.screenpipe/screenpipe.2026-04-15.0.loglukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe$Sonnet 46claude is Al and can make mistakes. rlease double-cneck responses...
|
NULL
|
1448116051624148271
|
NULL
|
visual_change
|
ocr
|
NULL
|
CaudeFileEoit000+ New chatQ SearchcustomizeChatsPr CaudeFileEoit000+ New chatQ SearchcustomizeChatsProjects88 ArtifactsStarredBulgarian citizenship application...Dawarich location tracking projectHecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter API...Screenpipe 14-day retention exp...neaalt nomepage reed overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso...Importing Google Timeline data t...chromecast remote volume duet...Screenpipe free version guideSelf-hosted LLM alternatives to .Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General niorm.ron realestRed dots on neck causesViewWindowHelp40 half Support Daily - in 3h 28mA100% C8Wed 15 Apr 11:32:28ChatcoworkCodeLinux SQLite Ul for NAS vpgsize * pageno / 1024 / 1024 as size_mbFROM dbstatWHERE aggregate = TRUEORDER BY pgsize * pageno DESC;"Show moreGreat data. Here's what this tells us:Size breakdown (the values are actually bytes, not MB — the formula was wrong):TableReal sizeNotesocr_text~OLUD* Massive — text extracted from everv frameframes~45 GBFrame metadata + likely snapshot pathselements~X6TR1.2M rows — UI elements per frameFTS indexesNSTRSearch indexes for aboveEverything else is essentially empty (audio, transcriptions, memories, meetings — all 0 ornear-0).Row counts context:• 428 video chunks, 20k frames → roughly consistent (frames sampled from video)• 1,222,571 elements rows for 20k frames = ~ 60 UI elements detected per frame - this isthe real storage killer• audio_transcriptions only 3 rows despite 90 audio chunks → mic probably off orWhisper not runningUpdated to 1.2581.0RelaunchLukas KovalikPro nianKey insight for your NAS retention strategy:but the complete size is lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh~/.screenpipe2.7G /Users/lukas/.screenpipelukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du-sh ~/.screenpipe/*4.0K /Users/lukas/.screenpipe/config.json1.3G /Users/lukas/.screenpipe/data1.4G /Users/lukas/.screenpipe/db.sqlite64K /Users/lukas/.screenpipe/db.sqlite-shm17M/Users/lukas/.screenpipe/db.sqlite-wal24K /Users/lukas/.screenpipe/pipes132K /Users/lukas/.screenpipe/screenpipe.2026-04-09.0.log96K /Users/lukas/.screenpipe/screenpipe.2026-04-11.0.log72K /Users/lukas/.screenpipe/screenpipe.2026-04-12.0.log72K /Users/lukas/.screenpipe/screenpipe.2026-04-13.0.log160K /Users/lukas/.screenpipe/screenpipe.2026-04-14.0.log64K /Users/lukas/.screenpipe/screenpipe.2026-04-15.0.loglukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe$Sonnet 46claude is Al and can make mistakes. rlease double-cneck responses...
|
20196
|
NULL
|
|
20199
|
435
|
13
|
2026-04-15T08:32:56.916628+00:00
|
/Users/lukas/.screenpipe/data/data/2026-04-15/1776 /Users/lukas/.screenpipe/data/data/2026-04-15/1776241976916_m1.jpg...
|
NULL
|
NULL
|
1
|
NULL
|
monitor_1
|
NULL
|
NULL
|
NULL
|
NULL
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp-zshlaal-zshSupport Daily - in 3h 28 m100% <478Wed 15 Apr 11:32:56T81DOCKER₴81DEV (-zsh)₴82APP (-zsh)83ec2-user@ip-10-.. 884-zsh(SELECT COUNT(*)FROM sqlite_master WHERE type='table'ANDname=m.name)as existsFROM sqlite_masterWHERE type='table'ORDER BY name;"Error: in prepare, near"exists":syntaxerrorite_master WHERE type='table'AND name=m. name)as exists FROM sqlite_master Werror here---^lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "SELECT'video_chunks' as tbl, COUNT(*) as rows FROM video_chunksUNION ALL SELECT 'audio_chunks',COUNT(*) FROM audio_chunksUNION ALL SELECT 'frames', COUNT(*) FROMframesUNION ALLSELECT 'ocr_text', COUNT(*) FROM ocr_textUNIONALL SELECT 'audio_transcriptions', COUNT(*) FROM audio_transcriptionsUNION ALL SELECT 'elements', COUNT(*) FROM elementsUNIONALL SELECT 'memories', COUNT(*) FROM memoriesUNION ALL SELECT 'meetings'UNIONALL SELECTuteevents', COUNTC FROM ueteven, COUNT(*) FROM ui_eventsUNION ALL SELECT 'pipe_executions', COUNT(*) FROM pipe_executions;"video_chunks1428audio_chunks190frames|20163ocr_text|15011audio_transcriptionsI3elements/1222571memoriesl0meetings10ui_events126965pipe_executionsl0lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe2.7G/Users/lukas/.screenpipelukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe/*4.0K/Users/lukas/.screenpipe/config.json1.3G/Users/lukas/.screenpipe/data1.4G/Users/lukas/.screenpipe/db.sqlite64K/Users/lukas/.screenpipe/db.sqlite-shm17M/Users/lukas/.screenpipe/db.sqlite-wal24K/Users/lukas/.screenpipe/pipes132K/Users/lukas/screenpipe/screenpipe.2026-04-09.0.10g96K/Users/Lukas/.screenpipe/screenpipe.2026-04-11.0.log72K/Users/lukas/.screenpipe/screenpipe.2026-04-12.0.10g72K/Users/lukas/.screenpipe/screenpipe.2026-04-13.0.10g160K/Users/lukas/.screenpipe/screenpipe.2026-04-14.0.10g64K/Users/lukas/.screenpipe/screenpipe.2026-04-15.0.10glukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $*5X86-zshO 87* Unable to a...O 88-zsh...
|
NULL
|
-126446532212069306
|
NULL
|
idle
|
ocr
|
NULL
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp-zshlaal-zshSupport Daily - in 3h 28 m100% <478Wed 15 Apr 11:32:56T81DOCKER₴81DEV (-zsh)₴82APP (-zsh)83ec2-user@ip-10-.. 884-zsh(SELECT COUNT(*)FROM sqlite_master WHERE type='table'ANDname=m.name)as existsFROM sqlite_masterWHERE type='table'ORDER BY name;"Error: in prepare, near"exists":syntaxerrorite_master WHERE type='table'AND name=m. name)as exists FROM sqlite_master Werror here---^lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "SELECT'video_chunks' as tbl, COUNT(*) as rows FROM video_chunksUNION ALL SELECT 'audio_chunks',COUNT(*) FROM audio_chunksUNION ALL SELECT 'frames', COUNT(*) FROMframesUNION ALLSELECT 'ocr_text', COUNT(*) FROM ocr_textUNIONALL SELECT 'audio_transcriptions', COUNT(*) FROM audio_transcriptionsUNION ALL SELECT 'elements', COUNT(*) FROM elementsUNIONALL SELECT 'memories', COUNT(*) FROM memoriesUNION ALL SELECT 'meetings'UNIONALL SELECTuteevents', COUNTC FROM ueteven, COUNT(*) FROM ui_eventsUNION ALL SELECT 'pipe_executions', COUNT(*) FROM pipe_executions;"video_chunks1428audio_chunks190frames|20163ocr_text|15011audio_transcriptionsI3elements/1222571memoriesl0meetings10ui_events126965pipe_executionsl0lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe2.7G/Users/lukas/.screenpipelukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe/*4.0K/Users/lukas/.screenpipe/config.json1.3G/Users/lukas/.screenpipe/data1.4G/Users/lukas/.screenpipe/db.sqlite64K/Users/lukas/.screenpipe/db.sqlite-shm17M/Users/lukas/.screenpipe/db.sqlite-wal24K/Users/lukas/.screenpipe/pipes132K/Users/lukas/screenpipe/screenpipe.2026-04-09.0.10g96K/Users/Lukas/.screenpipe/screenpipe.2026-04-11.0.log72K/Users/lukas/.screenpipe/screenpipe.2026-04-12.0.10g72K/Users/lukas/.screenpipe/screenpipe.2026-04-13.0.10g160K/Users/lukas/.screenpipe/screenpipe.2026-04-14.0.10g64K/Users/lukas/.screenpipe/screenpipe.2026-04-15.0.10glukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $*5X86-zshO 87* Unable to a...O 88-zsh...
|
20197
|
NULL
|
|
20200
|
436
|
9
|
2026-04-15T08:32:59.310255+00:00
|
/Users/lukas/.screenpipe/data/data/2026-04-15/1776 /Users/lukas/.screenpipe/data/data/2026-04-15/1776241979310_m2.jpg...
|
NULL
|
NULL
|
1
|
NULL
|
monitor_2
|
NULL
|
NULL
|
NULL
|
NULL
|
CaudeFileEoit000+ New chatQ SearchcustomizeChatsPr CaudeFileEoit000+ New chatQ SearchcustomizeChatsProjects88 ArtifactsStarredBulgarian citizenship application...Dawarich location tracking projectHecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter API...Screenpipe 14-day retention exp...neaalt nomepage reed overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso...Importing Google Timeline data t...chromecast remote volume buct...Screenpipe free version guideSelf-hosted LLM alternatives to .Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General normarion redlestRed dots on neck causesViewWindowHelp40 half Support Daily - in 3h 28mA100% C8Wed 15 Apr 11:32:58ChatcoworkCodeLinux SQLite Ul for NAS vpgsize * pageno / 1024 / 1024 as size_mbFROM dbstatWHERE aggregate = TRUEORDER BY pgsize * pageno DESC;"Show moreGreat data. Here's what this tells us:Size breakdown (the values are actually bytes, not MB — the formula was wrong):Tableocr_textframeselementsFTS indexesReal size~OLUD~45 GB~X6TRNSTRNotes*Massive — text extracted from every frameFrame metadata + likely snapshot paths1.2M rows — UI elements per frameSearch indexes for aboveEverything else is essentially empty (audio, transcriptions, memories, meetings — all 0 ornear-0).Row counts context:• 428 video chunks, 20k frames → roughly consistent (frames sampled from video)• 1,222,571 elements rows for 20k frames = ~ 60 UI elements detected per frame — this isthe real storage killer• audio_transcriptions only 3 rows despite 90 audio chunks → mic probably off orWhisper not runningKey insight for your NAS retention strategy:~/.screenpipe2.7G /Users/lukas/.screenpipelukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du-sh ~/.screenpipe/*4.0K /Users/lukas/.screenpipe/config.json1.3G /Users/lukas/.screenpipe/data1.4G /Users/lukas/.screenpipe/db.sqlite64K /Users/lukas/.screenpipe/db.sqlite-shm17M/Users/lukas/.screenpipe/db.sqlite-wal24K /Users/lukas/.screenpipe/pipes132K /Users/lukas/.screenpipe/screenpipe.2026-04-09.0.log96K /Users/lukas/.screenpipe/screenpipe.2026-04-11.0.log72K /Users/lukas/.screenpipe/screenpipe.2026-04-12.0.log72K /Users/lukas/.screenpipe/screenpipe.2026-04-13.0.log160K /Users/lukas/.screenpipe/screenpipe.2026-04-14.0.log64K /Users/lukas/.screenpipe/screenpipe.2026-04-15.0.loglukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ much less. What is theemerenceUpdated to 1.2581.0RelaunchLukas KovalikPro nianSonnet 46claude is Al and can make mistakes. rlease double-cneck responses....
|
NULL
|
9003060785526906022
|
NULL
|
idle
|
ocr
|
NULL
|
CaudeFileEoit000+ New chatQ SearchcustomizeChatsPr CaudeFileEoit000+ New chatQ SearchcustomizeChatsProjects88 ArtifactsStarredBulgarian citizenship application...Dawarich location tracking projectHecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter API...Screenpipe 14-day retention exp...neaalt nomepage reed overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso...Importing Google Timeline data t...chromecast remote volume buct...Screenpipe free version guideSelf-hosted LLM alternatives to .Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General normarion redlestRed dots on neck causesViewWindowHelp40 half Support Daily - in 3h 28mA100% C8Wed 15 Apr 11:32:58ChatcoworkCodeLinux SQLite Ul for NAS vpgsize * pageno / 1024 / 1024 as size_mbFROM dbstatWHERE aggregate = TRUEORDER BY pgsize * pageno DESC;"Show moreGreat data. Here's what this tells us:Size breakdown (the values are actually bytes, not MB — the formula was wrong):Tableocr_textframeselementsFTS indexesReal size~OLUD~45 GB~X6TRNSTRNotes*Massive — text extracted from every frameFrame metadata + likely snapshot paths1.2M rows — UI elements per frameSearch indexes for aboveEverything else is essentially empty (audio, transcriptions, memories, meetings — all 0 ornear-0).Row counts context:• 428 video chunks, 20k frames → roughly consistent (frames sampled from video)• 1,222,571 elements rows for 20k frames = ~ 60 UI elements detected per frame — this isthe real storage killer• audio_transcriptions only 3 rows despite 90 audio chunks → mic probably off orWhisper not runningKey insight for your NAS retention strategy:~/.screenpipe2.7G /Users/lukas/.screenpipelukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du-sh ~/.screenpipe/*4.0K /Users/lukas/.screenpipe/config.json1.3G /Users/lukas/.screenpipe/data1.4G /Users/lukas/.screenpipe/db.sqlite64K /Users/lukas/.screenpipe/db.sqlite-shm17M/Users/lukas/.screenpipe/db.sqlite-wal24K /Users/lukas/.screenpipe/pipes132K /Users/lukas/.screenpipe/screenpipe.2026-04-09.0.log96K /Users/lukas/.screenpipe/screenpipe.2026-04-11.0.log72K /Users/lukas/.screenpipe/screenpipe.2026-04-12.0.log72K /Users/lukas/.screenpipe/screenpipe.2026-04-13.0.log160K /Users/lukas/.screenpipe/screenpipe.2026-04-14.0.log64K /Users/lukas/.screenpipe/screenpipe.2026-04-15.0.loglukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ much less. What is theemerenceUpdated to 1.2581.0RelaunchLukas KovalikPro nianSonnet 46claude is Al and can make mistakes. rlease double-cneck responses....
|
NULL
|
NULL
|
|
20202
|
436
|
11
|
2026-04-15T08:33:11.221623+00:00
|
/Users/lukas/.screenpipe/data/data/2026-04-15/1776 /Users/lukas/.screenpipe/data/data/2026-04-15/1776241991221_m2.jpg...
|
NULL
|
NULL
|
1
|
NULL
|
monitor_2
|
NULL
|
NULL
|
NULL
|
NULL
|
+SackFileEditViewHistoryWindowHelpSearch Jiminny I +SackFileEditViewHistoryWindowHelpSearch Jiminny IncJiminny ...# releasesDMs= Unreads@ Threads6 HuddlesDrafts & sent8 Directories• Messages8 BookmarksAchivityEh External connectionsFiles# Starred& platform-inner-teamMore* Channels# ai-chapter# alerts# backend# confusion-clinia# curiosity_labiengineering# frontend# general# infra-changes# jiminny-bg# platform-tickets# product_launches# random# releases# sofia-office# support# thank-yous# the people of jimi...•- Direct messages3 Aneliva Angelova, .€. Vasil VasilevC. Steliyan Georgiev3 Adelina Petrova, Ili...P. Adelina Petrova /P. Galya Dimitrova E•. Nikolay Nikolov ®2 Galya Dimitrova, Ni...2 Galya Dimitrova, Ni...#: Apps6 Jira Cloud® ToastC FilesProject: appTag:When: 04/15/204V0J215.05View JobGITHUb APP 10:25AM4 new commits pushed to master by ilian-jiminny2970396a - SRD-6786 Added new throttling middleware for export link, increasedlimits for both link and export40213064 - Merge Dranch master into SKD-o/80-nx-rate-limits-on-exportabeyazor- Merge branch master Into skb-o/00-nx-rate-llmits-on-exportd89cef76 - Merge pull request #11956 from jiminny/SRD-6786-fix-rate-limits-on-expondjiminny/app | Added by GitHubGitHub APP 10:31 AM2 new commits pushed to master by des-db57a531e - JY-20255: Update QuickSearchltem to show activity type and durationbf72d5ff] - Merge pull request #11951 from jiminny/JY-20255-quick-search-show-duration-and-call-conference-type@jiminny/app |Added by GitHubCircleCl APP 10:51 AMDeployment Successful!Project: appWhen: 04/15/2026 0/:51:38Tag:View JobCircleCl APP 10:58 AMDeployment Successful!Project: appTag:When: 04/15/2026 07:58:28View JobCTEIh APP11-15AM7 new commits pushed to master by TodorStamatovJiminny1232603d - JY-19617: prevent memory overflow on Google API response floods081c5326 - JY-19617: add comment when we have API floodingc3baf84e - JY-19617: fix delta token bugd5e8b426 - JY-19617: fix new events logingC441205 -JY-1701 :1x commentonow morejiminny/app Added by GitHubMessage #releasesAa8 22QNewCc 4o ll O f SupportDaily- in 3h27m A 100% C 8 Wed 15 Apr 11:33:10chunks/tureContentQueryExportTABLE video_chunks(ITEGER PRIMARY KEY AUTOINCREMENT,_path TEXT NOT NULL,re_name TEXT NOT NULL DEFAULT ",id TEXT,ne_id TEXT,ed_at DATETIME,REAL NOT NULL DEFAULT 0.5,_blob_id TEXT DEFAULT NULLmnsath_namee_id_atblob_idxesdeo_chunks_cloud_blob_idleo_chunks_device_namedeo_chunks_device_name_idatabase browser vO.7.2, powered by Flask and Peewee. © 2026 Charles LeiferQueryAllow nullPrimary keyColumnscloud_blob_iddevice_name: devsce_naneUniqueSQLSQLSQLSQLActionsread-onlyread-onlyread-onlyread-onlyread-onlyread-onlyread-onlyread-onlyDrop?read-onivread-onlyread-only...
|
NULL
|
5554788402405891719
|
NULL
|
visual_change
|
ocr
|
NULL
|
+SackFileEditViewHistoryWindowHelpSearch Jiminny I +SackFileEditViewHistoryWindowHelpSearch Jiminny IncJiminny ...# releasesDMs= Unreads@ Threads6 HuddlesDrafts & sent8 Directories• Messages8 BookmarksAchivityEh External connectionsFiles# Starred& platform-inner-teamMore* Channels# ai-chapter# alerts# backend# confusion-clinia# curiosity_labiengineering# frontend# general# infra-changes# jiminny-bg# platform-tickets# product_launches# random# releases# sofia-office# support# thank-yous# the people of jimi...•- Direct messages3 Aneliva Angelova, .€. Vasil VasilevC. Steliyan Georgiev3 Adelina Petrova, Ili...P. Adelina Petrova /P. Galya Dimitrova E•. Nikolay Nikolov ®2 Galya Dimitrova, Ni...2 Galya Dimitrova, Ni...#: Apps6 Jira Cloud® ToastC FilesProject: appTag:When: 04/15/204V0J215.05View JobGITHUb APP 10:25AM4 new commits pushed to master by ilian-jiminny2970396a - SRD-6786 Added new throttling middleware for export link, increasedlimits for both link and export40213064 - Merge Dranch master into SKD-o/80-nx-rate-limits-on-exportabeyazor- Merge branch master Into skb-o/00-nx-rate-llmits-on-exportd89cef76 - Merge pull request #11956 from jiminny/SRD-6786-fix-rate-limits-on-expondjiminny/app | Added by GitHubGitHub APP 10:31 AM2 new commits pushed to master by des-db57a531e - JY-20255: Update QuickSearchltem to show activity type and durationbf72d5ff] - Merge pull request #11951 from jiminny/JY-20255-quick-search-show-duration-and-call-conference-type@jiminny/app |Added by GitHubCircleCl APP 10:51 AMDeployment Successful!Project: appWhen: 04/15/2026 0/:51:38Tag:View JobCircleCl APP 10:58 AMDeployment Successful!Project: appTag:When: 04/15/2026 07:58:28View JobCTEIh APP11-15AM7 new commits pushed to master by TodorStamatovJiminny1232603d - JY-19617: prevent memory overflow on Google API response floods081c5326 - JY-19617: add comment when we have API floodingc3baf84e - JY-19617: fix delta token bugd5e8b426 - JY-19617: fix new events logingC441205 -JY-1701 :1x commentonow morejiminny/app Added by GitHubMessage #releasesAa8 22QNewCc 4o ll O f SupportDaily- in 3h27m A 100% C 8 Wed 15 Apr 11:33:10chunks/tureContentQueryExportTABLE video_chunks(ITEGER PRIMARY KEY AUTOINCREMENT,_path TEXT NOT NULL,re_name TEXT NOT NULL DEFAULT ",id TEXT,ne_id TEXT,ed_at DATETIME,REAL NOT NULL DEFAULT 0.5,_blob_id TEXT DEFAULT NULLmnsath_namee_id_atblob_idxesdeo_chunks_cloud_blob_idleo_chunks_device_namedeo_chunks_device_name_idatabase browser vO.7.2, powered by Flask and Peewee. © 2026 Charles LeiferQueryAllow nullPrimary keyColumnscloud_blob_iddevice_name: devsce_naneUniqueSQLSQLSQLSQLActionsread-onlyread-onlyread-onlyread-onlyread-onlyread-onlyread-onlyread-onlyDrop?read-onivread-onlyread-only...
|
NULL
|
NULL
|
|
20203
|
436
|
12
|
2026-04-15T08:33:14.248819+00:00
|
/Users/lukas/.screenpipe/data/data/2026-04-15/1776 /Users/lukas/.screenpipe/data/data/2026-04-15/1776241994248_m2.jpg...
|
NULL
|
NULL
|
1
|
NULL
|
monitor_2
|
NULL
|
NULL
|
NULL
|
NULL
|
Caude000+ New chatQ SearchcustomizeFileEoitViewWin Caude000+ New chatQ SearchcustomizeFileEoitViewWindowHelp40 lal#Support Daily • in 3h 27m100% C8Wed 15 Apr 11:33:13ChatcoworkcodeLinux SQLite Ul for NAS vChatsProjects88 ArtifactsStarredBulgarian citizenship application...Dawarich location tracking projectHecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter API...Screenpipe 14-day retention exp...neaalt nomepage reea overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso...Importing Google Timeline data t...chromecast remote volume buct...Screenpipe free version guideSelf-hosted LLM alternatives to .Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General normarion redlestRed dots on neck causesbut the complete size is lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ du -sh ~/.screenpipe2.7G /Users/lukas/.screenpipelukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh~/.screenpipe/*4.0K /Users/lukas/.screenpipe/config.json1.3G /Users/lukas/.screenpipe/data1.4G /Users/lukas/.screenpipe/db.sqlite64Kineldb.salite-shmShow moreThe dbstat query returns page numbers, not sizes — the formula (pgsize * pageno iswrong. (pageno is the page's sequential number/position in the file,Updated to 1.2581.0RelaunchReply...sonner4.eLukas KovalikPro nianClaude is Al and can make mistakes. Please double-check responses....
|
NULL
|
-4124555864964888556
|
NULL
|
visual_change
|
ocr
|
NULL
|
Caude000+ New chatQ SearchcustomizeFileEoitViewWin Caude000+ New chatQ SearchcustomizeFileEoitViewWindowHelp40 lal#Support Daily • in 3h 27m100% C8Wed 15 Apr 11:33:13ChatcoworkcodeLinux SQLite Ul for NAS vChatsProjects88 ArtifactsStarredBulgarian citizenship application...Dawarich location tracking projectHecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter API...Screenpipe 14-day retention exp...neaalt nomepage reea overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso...Importing Google Timeline data t...chromecast remote volume buct...Screenpipe free version guideSelf-hosted LLM alternatives to .Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General normarion redlestRed dots on neck causesbut the complete size is lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ du -sh ~/.screenpipe2.7G /Users/lukas/.screenpipelukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh~/.screenpipe/*4.0K /Users/lukas/.screenpipe/config.json1.3G /Users/lukas/.screenpipe/data1.4G /Users/lukas/.screenpipe/db.sqlite64Kineldb.salite-shmShow moreThe dbstat query returns page numbers, not sizes — the formula (pgsize * pageno iswrong. (pageno is the page's sequential number/position in the file,Updated to 1.2581.0RelaunchReply...sonner4.eLukas KovalikPro nianClaude is Al and can make mistakes. Please double-check responses....
|
20202
|
NULL
|
|
20204
|
436
|
13
|
2026-04-15T08:33:17.235790+00:00
|
/Users/lukas/.screenpipe/data/data/2026-04-15/1776 /Users/lukas/.screenpipe/data/data/2026-04-15/1776241997235_m2.jpg...
|
NULL
|
NULL
|
1
|
NULL
|
monitor_2
|
NULL
|
NULL
|
NULL
|
NULL
|
CaudeFileEoit000+ New chatQ SearchcustomizeChatsPr CaudeFileEoit000+ New chatQ SearchcustomizeChatsProjects88 ArtifactsStarredBulgarian citizenship application..Dawarich location tracking projecthecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter API...Screenpipe 14-day retention exp...neaalt nomepage reed overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso...Importing Google Timeline data t...chromecast remote volume buct...Screenpipe free version guideSelf-hosted LLM alternatives to .Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General normarion redlestRed dots on neck causesViewWindowHelp40 lal#Support Daily • in 3 h 27 m100% C8Wed 15 Apr 11:33:16ChatcoworkCodeLinux SQLite Ul for NAS vbut the complete size is lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ du -sh ~/.screenpipe2.7G /Users/lukas/.screenpipelukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh~/.screenpipe/*4.0K /Users/lukas/.screenpipe/config.json1.3G/Users/lukas/.screenpipe/data1.4G /Users/lukas/.screenpipe/db.sqlite64KShow moreThe dbstat query returns page numbers, not sizes — the formula (pgsize * pageno iswrong. pageno is the page's sequential number/position in the file, not the count of pagesfor that table. So the numbers were garbage.The real sizes:db.sqlite) →1.4GB(data/ (MP4s + JPGs) →1.3 GB• Total → 2.7 GBCorrect way to get actual table sizes:SELECTMallle,SUM(pgsize) / 1024 / 1024 as size_mbFROM dbstatGROUP BY nameORDER BY SUM(pgsize) DESC;SUM(pgsize) aggregates the actual page sizes across all pages belonging to each table —that gives real bytes.Run that aUpdated to 1.2581.0RelaunchLukas KovalikPro nianReply...Sonnet 46 vClaude is Al and can make mistakes. Please double-check responses....
|
NULL
|
-8862803194895320513
|
NULL
|
visual_change
|
ocr
|
NULL
|
CaudeFileEoit000+ New chatQ SearchcustomizeChatsPr CaudeFileEoit000+ New chatQ SearchcustomizeChatsProjects88 ArtifactsStarredBulgarian citizenship application..Dawarich location tracking projecthecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter API...Screenpipe 14-day retention exp...neaalt nomepage reed overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso...Importing Google Timeline data t...chromecast remote volume buct...Screenpipe free version guideSelf-hosted LLM alternatives to .Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General normarion redlestRed dots on neck causesViewWindowHelp40 lal#Support Daily • in 3 h 27 m100% C8Wed 15 Apr 11:33:16ChatcoworkCodeLinux SQLite Ul for NAS vbut the complete size is lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ du -sh ~/.screenpipe2.7G /Users/lukas/.screenpipelukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh~/.screenpipe/*4.0K /Users/lukas/.screenpipe/config.json1.3G/Users/lukas/.screenpipe/data1.4G /Users/lukas/.screenpipe/db.sqlite64KShow moreThe dbstat query returns page numbers, not sizes — the formula (pgsize * pageno iswrong. pageno is the page's sequential number/position in the file, not the count of pagesfor that table. So the numbers were garbage.The real sizes:db.sqlite) →1.4GB(data/ (MP4s + JPGs) →1.3 GB• Total → 2.7 GBCorrect way to get actual table sizes:SELECTMallle,SUM(pgsize) / 1024 / 1024 as size_mbFROM dbstatGROUP BY nameORDER BY SUM(pgsize) DESC;SUM(pgsize) aggregates the actual page sizes across all pages belonging to each table —that gives real bytes.Run that aUpdated to 1.2581.0RelaunchLukas KovalikPro nianReply...Sonnet 46 vClaude is Al and can make mistakes. Please double-check responses....
|
NULL
|
NULL
|
|
20205
|
435
|
14
|
2026-04-15T08:33:27.356658+00:00
|
/Users/lukas/.screenpipe/data/data/2026-04-15/1776 /Users/lukas/.screenpipe/data/data/2026-04-15/1776242007356_m1.jpg...
|
NULL
|
NULL
|
1
|
NULL
|
monitor_1
|
NULL
|
NULL
|
NULL
|
NULL
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp• Support Daily • in 3 h 27 mA100% <47-zsh|8Wed 15 Apr 11:33:27181DOCKER₴81DEV (-zsh)₴82APP (-zsh)83ec2-user@ip-10-.. 884-zsh(SELECT COUNT(*)FROM sqlite_master WHERE type='table'ANDname=m.name)as existsFROM sqlite_masterWHERE type='table'ORDER BY name;"Error: in prepare, near"exists":syntaxerrorite_master WHERE type='table'AND name=m. name)as exists FROM sqlite_master Werror here---^lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "SELECT'video_chunks' as tbl, COUNT(*) as rows FROM video_chunksUNION ALL SELECT 'audio_chunks',COUNT(*) FROM audio_chunksUNION ALL SELECT 'frames', COUNT(*) FROMframesUNION ALLSELECT 'ocr_text', COUNT(*) FROM ocr_textUNIONALL SELECT 'audio_transcriptions', COUNT(*) FROM audio_transcriptionsUNION ALL SELECT 'elements', COUNT(*) FROM elementsUNIONALL SELECT 'memories', COUNT(*) FROM memoriesUNION ALL SELECT 'meetings'UNIONALL SELECTuteevents', COUNTC FROM ueteven, COUNT(*) FROM ui_eventsUNION ALL SELECT 'pipe_executions', COUNT(*) FROM pipe_executions;"video_chunks1428audio_chunks190frames|20163ocr_text|15011audio_transcriptionsI3elements/1222571memoriesl0meetings10ui_events126965pipe_executionsl0lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe2.7G/Users/lukas/.screenpipelukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe/*4.0K/Users/lukas/.screenpipe/config.json1.3G/Users/lukas/.screenpipe/data1.4G/Users/lukas/.screenpipe/db.sqlite64K/Users/lukas/.screenpipe/db.sqlite-shm17M/Users/lukas/.screenpipe/db.sqlite-wal24K/Users/lukas/.screenpipe/pipes132K/Users/lukas/screenpipe/screenpipe.2026-04-09.0.10g96K/Users/Lukas/.screenpipe/screenpipe.2026-04-11.0.log72K/Users/lukas/.screenpipe/screenpipe.2026-04-12.0.10g72K/Users/lukas/.screenpipe/screenpipe.2026-04-13.0.10g160K/Users/lukas/.screenpipe/screenpipe.2026-04-14.0.10g64K/Users/lukas/.screenpipe/screenpipe.2026-04-15.0.10glukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $*5-zsh86-zshO 87* Unable to a...O 88-zsh...
|
NULL
|
-405658077962363650
|
NULL
|
idle
|
ocr
|
NULL
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp• Support Daily • in 3 h 27 mA100% <47-zsh|8Wed 15 Apr 11:33:27181DOCKER₴81DEV (-zsh)₴82APP (-zsh)83ec2-user@ip-10-.. 884-zsh(SELECT COUNT(*)FROM sqlite_master WHERE type='table'ANDname=m.name)as existsFROM sqlite_masterWHERE type='table'ORDER BY name;"Error: in prepare, near"exists":syntaxerrorite_master WHERE type='table'AND name=m. name)as exists FROM sqlite_master Werror here---^lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "SELECT'video_chunks' as tbl, COUNT(*) as rows FROM video_chunksUNION ALL SELECT 'audio_chunks',COUNT(*) FROM audio_chunksUNION ALL SELECT 'frames', COUNT(*) FROMframesUNION ALLSELECT 'ocr_text', COUNT(*) FROM ocr_textUNIONALL SELECT 'audio_transcriptions', COUNT(*) FROM audio_transcriptionsUNION ALL SELECT 'elements', COUNT(*) FROM elementsUNIONALL SELECT 'memories', COUNT(*) FROM memoriesUNION ALL SELECT 'meetings'UNIONALL SELECTuteevents', COUNTC FROM ueteven, COUNT(*) FROM ui_eventsUNION ALL SELECT 'pipe_executions', COUNT(*) FROM pipe_executions;"video_chunks1428audio_chunks190frames|20163ocr_text|15011audio_transcriptionsI3elements/1222571memoriesl0meetings10ui_events126965pipe_executionsl0lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe2.7G/Users/lukas/.screenpipelukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe/*4.0K/Users/lukas/.screenpipe/config.json1.3G/Users/lukas/.screenpipe/data1.4G/Users/lukas/.screenpipe/db.sqlite64K/Users/lukas/.screenpipe/db.sqlite-shm17M/Users/lukas/.screenpipe/db.sqlite-wal24K/Users/lukas/.screenpipe/pipes132K/Users/lukas/screenpipe/screenpipe.2026-04-09.0.10g96K/Users/Lukas/.screenpipe/screenpipe.2026-04-11.0.log72K/Users/lukas/.screenpipe/screenpipe.2026-04-12.0.10g72K/Users/lukas/.screenpipe/screenpipe.2026-04-13.0.10g160K/Users/lukas/.screenpipe/screenpipe.2026-04-14.0.10g64K/Users/lukas/.screenpipe/screenpipe.2026-04-15.0.10glukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $*5-zsh86-zshO 87* Unable to a...O 88-zsh...
|
NULL
|
NULL
|
|
20206
|
435
|
15
|
2026-04-15T08:33:29.386344+00:00
|
/Users/lukas/.screenpipe/data/data/2026-04-15/1776 /Users/lukas/.screenpipe/data/data/2026-04-15/1776242009386_m1.jpg...
|
NULL
|
NULL
|
1
|
NULL
|
monitor_1
|
NULL
|
NULL
|
NULL
|
NULL
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp-zsh(wbl-zsh• Support Daily • in 3 h 27 mA100% <478Wed 15 Apr 11:33:29T81DOCKER₴81DEV (-zsh)₴82APP (-zsh)83ec2-user@ip-10-... 884-zsh(SELECT COUNT(*)FROM sqlite_master WHERE type='table'ANDname=m.name)as existsFROM sqlite_masterWHERE type='table'ORDER BY name;"Error: in prepare, near"exists":syntaxerrorite_master WHERE type='table'AND name=m. name)as exists FROM sqlite_master Werror here---^lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "SELECT'video_chunks' as tbl, COUNT(*) as rows FROM video_chunksUNION ALL SELECT 'audio_chunks',COUNT(*) FROM audio_chunksUNION ALL SELECT 'frames', COUNT(*) FROMframesUNION ALLSELECT 'ocr_text', COUNT(*) FROM ocr_textUNIONALL SELECT 'audio_transcriptions', COUNT(*) FROM audio_transcriptionsUNION ALL SELECT 'elements', COUNT(*) FROM elementsUNIONALL SELECT 'memories', COUNT(*) FROM memoriesUNION ALL SELECT 'meetings'UNIONALL SELECTuteevents', COUNTC FROM ueteven, COUNT(*) FROM ui_eventsUNION ALL SELECT 'pipe_executions', COUNT(*) FROM pipe_executions;"video_chunks1428audio_chunks190frames|20163ocr_text|15011audio_transcriptionsI3elements/1222571memoriesl0meetingsl0ui_events126965pipe_executionsl0lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe2.7G/Users/lukas/.screenpipelukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe/*4.0K/Users/lukas/.screenpipe/config.json1.3G/Users/lukas/.screenpipe/data1.4G/Users/lukas/.screenpipe/db.sqlite64K/Users/lukas/.screenpipe/db.sqlite-shm17M/Users/lukas/.screenpipe/db.sqlite-wal24K/Users/lukas/.screenpipe/pipes132K/Users/lukas/screenpipe/screenpipe.2026-04-09.0.10g96K/Users/Lukas/.screenpipe/screenpipe.2026-04-11.0.log72K/Users/lukas/.screenpipe/screenpipe.2026-04-12.0.10g72K/Users/lukas/.screenpipe/screenpipe.2026-04-13.0.10g160K/Users/lukas/.screenpipe/screenpipe.2026-04-14.0.10g64K/Users/lukas/.screenpipe/screenpipe.2026-04-15.0.10glukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $*586-zshO 87* Unable to a...O 88-zsh...
|
NULL
|
-3932033768913108178
|
NULL
|
click
|
ocr
|
NULL
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp-zsh(wbl-zsh• Support Daily • in 3 h 27 mA100% <478Wed 15 Apr 11:33:29T81DOCKER₴81DEV (-zsh)₴82APP (-zsh)83ec2-user@ip-10-... 884-zsh(SELECT COUNT(*)FROM sqlite_master WHERE type='table'ANDname=m.name)as existsFROM sqlite_masterWHERE type='table'ORDER BY name;"Error: in prepare, near"exists":syntaxerrorite_master WHERE type='table'AND name=m. name)as exists FROM sqlite_master Werror here---^lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "SELECT'video_chunks' as tbl, COUNT(*) as rows FROM video_chunksUNION ALL SELECT 'audio_chunks',COUNT(*) FROM audio_chunksUNION ALL SELECT 'frames', COUNT(*) FROMframesUNION ALLSELECT 'ocr_text', COUNT(*) FROM ocr_textUNIONALL SELECT 'audio_transcriptions', COUNT(*) FROM audio_transcriptionsUNION ALL SELECT 'elements', COUNT(*) FROM elementsUNIONALL SELECT 'memories', COUNT(*) FROM memoriesUNION ALL SELECT 'meetings'UNIONALL SELECTuteevents', COUNTC FROM ueteven, COUNT(*) FROM ui_eventsUNION ALL SELECT 'pipe_executions', COUNT(*) FROM pipe_executions;"video_chunks1428audio_chunks190frames|20163ocr_text|15011audio_transcriptionsI3elements/1222571memoriesl0meetingsl0ui_events126965pipe_executionsl0lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe2.7G/Users/lukas/.screenpipelukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe/*4.0K/Users/lukas/.screenpipe/config.json1.3G/Users/lukas/.screenpipe/data1.4G/Users/lukas/.screenpipe/db.sqlite64K/Users/lukas/.screenpipe/db.sqlite-shm17M/Users/lukas/.screenpipe/db.sqlite-wal24K/Users/lukas/.screenpipe/pipes132K/Users/lukas/screenpipe/screenpipe.2026-04-09.0.10g96K/Users/Lukas/.screenpipe/screenpipe.2026-04-11.0.log72K/Users/lukas/.screenpipe/screenpipe.2026-04-12.0.10g72K/Users/lukas/.screenpipe/screenpipe.2026-04-13.0.10g160K/Users/lukas/.screenpipe/screenpipe.2026-04-14.0.10g64K/Users/lukas/.screenpipe/screenpipe.2026-04-15.0.10glukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $*586-zshO 87* Unable to a...O 88-zsh...
|
20205
|
NULL
|
|
20207
|
436
|
14
|
2026-04-15T08:33:29.422221+00:00
|
/Users/lukas/.screenpipe/data/data/2026-04-15/1776 /Users/lukas/.screenpipe/data/data/2026-04-15/1776242009422_m2.jpg...
|
NULL
|
NULL
|
1
|
NULL
|
monitor_2
|
NULL
|
NULL
|
NULL
|
NULL
|
Caude000+ New chatQ SearchcustomizeChatsProjects88 Caude000+ New chatQ SearchcustomizeChatsProjects88 ArtifactsStarredBulgarian citizenship application..Dawarich location tracking projecthecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter API...Screenpipe 14-day retention exp...neaalt nomepage reed overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso...Importing Google Timeline data t...chromecast remote volume buct...Screenpipe free version guideSelf-hosted LLM alternatives to .Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General normarion redlestRed dots on neck causesFileEoitViewWindowHelp40 h o#Support Daily • in 3 h 27 m100% C.8Wed 15 Apr 11:33:29ChatcoworkCodeLinux SQLite Ul for NAS vbut the complete size is lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ du -sh ~/.screenpipe2.7G /Users/lukas/.screenpipelukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du-sh~/.screenpipe/*4.0K /Users/lukas/.screenpipe/config.json1.3G/users/lukas/.screenplpe/dala1.4G /Users/lukas/.screenpipe/db.sqlite04K)Show moreThe (dbstat query returns page numbers, not sizes — the formula (pgsize * pageno iswrong. (pageno is the page's sequential number/position in the file, not the count of pagesfor that table. So the numbers were garbage.The real sizes:• (db.sqlite →14GB(data/ (MP4s + JPGs) →1.3 GB• Total 2.7 GBCorrect way to get actual table sizes:SELECTname,SUM(pgsize) / 1024 / 1024 as size_mbFROM dbstatGROUP BY nameORDER BY SUM(pgsize) DESC;SUM(pgsize) aggregates the actual page sizes across all pages belonging to each table —that gives real bytes.Run that and you'll get accurate per-table MB numbers. My guess is ocr_text+ elements+ frames) will still dominate, just at a much more reasonable scale (probably 400-600 MBeach rather than 60 GB).Updated to 1.2581.0RelaunchLukas KovalikPro nianReply...Sonnet 46 vClaudSTs-APand can make mistakes. Please double-check responses....
|
NULL
|
3718204891784065917
|
NULL
|
click
|
ocr
|
NULL
|
Caude000+ New chatQ SearchcustomizeChatsProjects88 Caude000+ New chatQ SearchcustomizeChatsProjects88 ArtifactsStarredBulgarian citizenship application..Dawarich location tracking projecthecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter API...Screenpipe 14-day retention exp...neaalt nomepage reed overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso...Importing Google Timeline data t...chromecast remote volume buct...Screenpipe free version guideSelf-hosted LLM alternatives to .Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General normarion redlestRed dots on neck causesFileEoitViewWindowHelp40 h o#Support Daily • in 3 h 27 m100% C.8Wed 15 Apr 11:33:29ChatcoworkCodeLinux SQLite Ul for NAS vbut the complete size is lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ du -sh ~/.screenpipe2.7G /Users/lukas/.screenpipelukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du-sh~/.screenpipe/*4.0K /Users/lukas/.screenpipe/config.json1.3G/users/lukas/.screenplpe/dala1.4G /Users/lukas/.screenpipe/db.sqlite04K)Show moreThe (dbstat query returns page numbers, not sizes — the formula (pgsize * pageno iswrong. (pageno is the page's sequential number/position in the file, not the count of pagesfor that table. So the numbers were garbage.The real sizes:• (db.sqlite →14GB(data/ (MP4s + JPGs) →1.3 GB• Total 2.7 GBCorrect way to get actual table sizes:SELECTname,SUM(pgsize) / 1024 / 1024 as size_mbFROM dbstatGROUP BY nameORDER BY SUM(pgsize) DESC;SUM(pgsize) aggregates the actual page sizes across all pages belonging to each table —that gives real bytes.Run that and you'll get accurate per-table MB numbers. My guess is ocr_text+ elements+ frames) will still dominate, just at a much more reasonable scale (probably 400-600 MBeach rather than 60 GB).Updated to 1.2581.0RelaunchLukas KovalikPro nianReply...Sonnet 46 vClaudSTs-APand can make mistakes. Please double-check responses....
|
20204
|
NULL
|
|
20208
|
435
|
16
|
2026-04-15T08:33:31.678618+00:00
|
/Users/lukas/.screenpipe/data/data/2026-04-15/1776 /Users/lukas/.screenpipe/data/data/2026-04-15/1776242011678_m1.jpg...
|
NULL
|
NULL
|
1
|
NULL
|
monitor_1
|
NULL
|
NULL
|
NULL
|
NULL
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp-zsh(wbl-zsh• Support Daily • in 3 h 27 mA100% <478Wed 15 Apr 11:33:31181DOCKER₴81DEV (-zsh)₴82APP (-zsh)83ec2-user@ip-10-... 884-zsh(SELECT COUNT(*)FROM sqlite_master WHERE type='table'ANDname=m.name)as existsFROM sqlite_masterWHERE type='table'ORDER BY name;"Error: in prepare, near"exists":syntaxerrorite_master WHERE type='table'AND name=m. name)as exists FROM sqlite_master Werror here---^lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "SELECT'video_chunks' as tbl, COUNT(*) as rows FROM video_chunksUNION ALL SELECT 'audio_chunks',COUNT(*) FROM audio_chunksUNION ALL SELECT 'frames', COUNT(*) FROMframesUNION ALLSELECT 'ocr_text', COUNT(*) FROM ocr_textUNIONALL SELECT 'audio_transcriptions', COUNT(*) FROM audio_transcriptionsUNION ALL SELECT 'elements', COUNT(*) FROM elementsUNIONALL SELECT 'memories', COUNT(*) FROM memoriesUNION ALL SELECT 'meetings'UNIONALL SELECTuteevents', COUNTC FROM ueteven, COUNT(*) FROM ui_eventsUNION ALL SELECT 'pipe_executions', COUNT(*) FROM pipe_executions;"video_chunks1428audio_chunks190frames|20163ocr_text|15011audio_transcriptionsI3elements/1222571memoriesl0meetingsl0ui_events126965pipe_executionsl0lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe2.7G/Users/lukas/.screenpipelukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe/*4.0K/Users/lukas/.screenpipe/config.json1.3G/Users/lukas/.screenpipe/data1.4G/Users/lukas/.screenpipe/db.sqlite64K/Users/lukas/.screenpipe/db.sqlite-shm17M/Users/lukas/.screenpipe/db.sqlite-wal24K/Users/lukas/.screenpipe/pipes132K96K/Users/lukas/.screenpipe/screenpipe.2026-04-09.0.10g/Users/lukas/.screenpipe/screenpipe.2026-04-11.0.10g72K/Users/lukas/.screenpipe/screenpipe.2026-04-12.0.10g72K/Users/lukas/.screenpipe/screenpipe.2026-04-13.0.10g160K/Users/lukas/.screenpipe/screenpipe.2026-04-14.0.10g64K/Users/lukas/.screenpipe/screenpipe.2026-04-15.0.10glukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $*586-zshO ₴7.* Unable to a...О 88-zsh...
|
NULL
|
-3301774560856028273
|
NULL
|
click
|
ocr
|
NULL
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp-zsh(wbl-zsh• Support Daily • in 3 h 27 mA100% <478Wed 15 Apr 11:33:31181DOCKER₴81DEV (-zsh)₴82APP (-zsh)83ec2-user@ip-10-... 884-zsh(SELECT COUNT(*)FROM sqlite_master WHERE type='table'ANDname=m.name)as existsFROM sqlite_masterWHERE type='table'ORDER BY name;"Error: in prepare, near"exists":syntaxerrorite_master WHERE type='table'AND name=m. name)as exists FROM sqlite_master Werror here---^lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "SELECT'video_chunks' as tbl, COUNT(*) as rows FROM video_chunksUNION ALL SELECT 'audio_chunks',COUNT(*) FROM audio_chunksUNION ALL SELECT 'frames', COUNT(*) FROMframesUNION ALLSELECT 'ocr_text', COUNT(*) FROM ocr_textUNIONALL SELECT 'audio_transcriptions', COUNT(*) FROM audio_transcriptionsUNION ALL SELECT 'elements', COUNT(*) FROM elementsUNIONALL SELECT 'memories', COUNT(*) FROM memoriesUNION ALL SELECT 'meetings'UNIONALL SELECTuteevents', COUNTC FROM ueteven, COUNT(*) FROM ui_eventsUNION ALL SELECT 'pipe_executions', COUNT(*) FROM pipe_executions;"video_chunks1428audio_chunks190frames|20163ocr_text|15011audio_transcriptionsI3elements/1222571memoriesl0meetingsl0ui_events126965pipe_executionsl0lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe2.7G/Users/lukas/.screenpipelukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe/*4.0K/Users/lukas/.screenpipe/config.json1.3G/Users/lukas/.screenpipe/data1.4G/Users/lukas/.screenpipe/db.sqlite64K/Users/lukas/.screenpipe/db.sqlite-shm17M/Users/lukas/.screenpipe/db.sqlite-wal24K/Users/lukas/.screenpipe/pipes132K96K/Users/lukas/.screenpipe/screenpipe.2026-04-09.0.10g/Users/lukas/.screenpipe/screenpipe.2026-04-11.0.10g72K/Users/lukas/.screenpipe/screenpipe.2026-04-12.0.10g72K/Users/lukas/.screenpipe/screenpipe.2026-04-13.0.10g160K/Users/lukas/.screenpipe/screenpipe.2026-04-14.0.10g64K/Users/lukas/.screenpipe/screenpipe.2026-04-15.0.10glukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $*586-zshO ₴7.* Unable to a...О 88-zsh...
|
NULL
|
NULL
|
|
20209
|
436
|
15
|
2026-04-15T08:33:31.658451+00:00
|
/Users/lukas/.screenpipe/data/data/2026-04-15/1776 /Users/lukas/.screenpipe/data/data/2026-04-15/1776242011658_m2.jpg...
|
NULL
|
NULL
|
1
|
NULL
|
monitor_2
|
NULL
|
NULL
|
NULL
|
NULL
|
CaudeFileEoit000+ New chatQ SearchcustomizeChatsPr CaudeFileEoit000+ New chatQ SearchcustomizeChatsProjects88 ArtifactsStarredBulgarian citizenship application...Dawarich location tracking projectHecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter API...Screenpipe 14-day retention exp...neaalt nomepage reed overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso...Importing Google Timeline data t...chromecast remote volume buct...Screenpipe free version guideSelf-hosted LLM alternatives to .Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General normarion redlestRed dots on neck causesViewWindowHelp40 h o#Support Daily • in 3 h 27 m100% C8Wed 15 Apr 11:33:31ChatcoworkCodeLinux SQLite Ul for NAS vbut the complete size is lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ du -sh ~/.screenpipe2.7G /Users/lukas/.screenpipelukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh~/.screenpipe/*4.0K /Users/lukas/.screenpipe/config.json1.3G/users/lukas/.screenplpe/data1.4G /Users/lukas/.screenpipe/db.sqlite04K)Show moreThe (dbstat query returns page numbers, not sizes — the formula (pgsize * pageno) iswrong. (pageno is the page's sequential number/position in the file, not the count of pagesfor that table. So the numbers were garbage.The real sizes:• (db.sqlite →1.4GB(data/ (MP4s + JPGs) → 1.3 GB• Total 2.7 GBCorrect way to get actual table sizes:Reply ~SELECTnameSUM(pgsize) / 1024 / 1024 as size_mbPRUM dlos talGuur oy naneORDER BY SUM(pgsize) DESC;SUM(pgsize) aggregates the actual page sizes across all pages belonging to each table —that gives real bytes.Run that and you'll get accurate per-table MB numbers. My guess is ocr_text)+elements+ (frames) will still dominate, just at a much more reasonable scale (probably 400-600 MBeach rather than 60 GB).Updated to 1.2581.0RelaunchLukas KovalikPro nianReply...Sonnet 46 vclaude is Al and can make mistakes. rlease double-cneck responses....
|
NULL
|
-5435557294448046117
|
NULL
|
click
|
ocr
|
NULL
|
CaudeFileEoit000+ New chatQ SearchcustomizeChatsPr CaudeFileEoit000+ New chatQ SearchcustomizeChatsProjects88 ArtifactsStarredBulgarian citizenship application...Dawarich location tracking projectHecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter API...Screenpipe 14-day retention exp...neaalt nomepage reed overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso...Importing Google Timeline data t...chromecast remote volume buct...Screenpipe free version guideSelf-hosted LLM alternatives to .Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General normarion redlestRed dots on neck causesViewWindowHelp40 h o#Support Daily • in 3 h 27 m100% C8Wed 15 Apr 11:33:31ChatcoworkCodeLinux SQLite Ul for NAS vbut the complete size is lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ du -sh ~/.screenpipe2.7G /Users/lukas/.screenpipelukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh~/.screenpipe/*4.0K /Users/lukas/.screenpipe/config.json1.3G/users/lukas/.screenplpe/data1.4G /Users/lukas/.screenpipe/db.sqlite04K)Show moreThe (dbstat query returns page numbers, not sizes — the formula (pgsize * pageno) iswrong. (pageno is the page's sequential number/position in the file, not the count of pagesfor that table. So the numbers were garbage.The real sizes:• (db.sqlite →1.4GB(data/ (MP4s + JPGs) → 1.3 GB• Total 2.7 GBCorrect way to get actual table sizes:Reply ~SELECTnameSUM(pgsize) / 1024 / 1024 as size_mbPRUM dlos talGuur oy naneORDER BY SUM(pgsize) DESC;SUM(pgsize) aggregates the actual page sizes across all pages belonging to each table —that gives real bytes.Run that and you'll get accurate per-table MB numbers. My guess is ocr_text)+elements+ (frames) will still dominate, just at a much more reasonable scale (probably 400-600 MBeach rather than 60 GB).Updated to 1.2581.0RelaunchLukas KovalikPro nianReply...Sonnet 46 vclaude is Al and can make mistakes. rlease double-cneck responses....
|
NULL
|
NULL
|
|
20217
|
435
|
21
|
2026-04-15T08:34:16.814560+00:00
|
/Users/lukas/.screenpipe/data/data/2026-04-15/1776 /Users/lukas/.screenpipe/data/data/2026-04-15/1776242056814_m1.jpg...
|
NULL
|
NULL
|
1
|
NULL
|
monitor_1
|
NULL
|
NULL
|
NULL
|
NULL
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp‹ >0 lolSupport Daily - in 3h 26 mA100% (4 8 Wed 15 Apr 11:34:16DOCKER₴81DEV (-zsh)182APP (-zsh)83sqlite_autoindex_audio_tags_110sqlite_autoindex__sqlx_migrations_110secretsl0pipe_scheduler_statel0pipe_executions10memories_fts_idx|0memories_fts_docsizel0memories_fts_datal0memories_fts_configl0memoriesl0meetingsl0idx_vision_tags_vision_idl0idx_vision_tags_tag_idl0idx_video_chunks_cloud_blob_idl0idx_pipe_exec_runningl0idx_pipe_exec_name_timel0idx_pipe_exec_name_status10idx_ocr_text_sync_idl0idx_memories_sourcel0idx_memories_importancel0idx_memories_frame_idl0idx_memories_created_at10idx_meetings_start10idx_meetings_endI0idx_frames_sync_idl0idx_frames_cloud_blob_idl0idx_audio_transcriptions_transcriptioni0idx_audio_transcriptions_timestampl0idx_audio_transcriptions_sync_idl0idx_audio_transcriptions_lengthl0idx_audio_transcriptions_audio_chunk_id_timestamp10idx_audio_transcriptions_audio_chunk_idl0idx_audio_transcription_chunk_texti0idx_audio_tags_tag_idl0idx_audio_tags_audio_chunk_id10idx_audio_chunks_timestamp10frames_fts_configl0elements_fts_configl0audio_transcriptions_fts_idx10audio_transcriptions_fts_docsizel0audio_transcriptions_fts_datal0audio_transcriptions_fts_configl0audio_transcriptions10audio_tags10lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ec2-user@ip-10-.. 884-zsh-zsh18185-zsh86-zsh-$7* Unable to a...O 88-zsh...
|
NULL
|
803573250785281569
|
NULL
|
click
|
ocr
|
NULL
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp‹ >0 lolSupport Daily - in 3h 26 mA100% (4 8 Wed 15 Apr 11:34:16DOCKER₴81DEV (-zsh)182APP (-zsh)83sqlite_autoindex_audio_tags_110sqlite_autoindex__sqlx_migrations_110secretsl0pipe_scheduler_statel0pipe_executions10memories_fts_idx|0memories_fts_docsizel0memories_fts_datal0memories_fts_configl0memoriesl0meetingsl0idx_vision_tags_vision_idl0idx_vision_tags_tag_idl0idx_video_chunks_cloud_blob_idl0idx_pipe_exec_runningl0idx_pipe_exec_name_timel0idx_pipe_exec_name_status10idx_ocr_text_sync_idl0idx_memories_sourcel0idx_memories_importancel0idx_memories_frame_idl0idx_memories_created_at10idx_meetings_start10idx_meetings_endI0idx_frames_sync_idl0idx_frames_cloud_blob_idl0idx_audio_transcriptions_transcriptioni0idx_audio_transcriptions_timestampl0idx_audio_transcriptions_sync_idl0idx_audio_transcriptions_lengthl0idx_audio_transcriptions_audio_chunk_id_timestamp10idx_audio_transcriptions_audio_chunk_idl0idx_audio_transcription_chunk_texti0idx_audio_tags_tag_idl0idx_audio_tags_audio_chunk_id10idx_audio_chunks_timestamp10frames_fts_configl0elements_fts_configl0audio_transcriptions_fts_idx10audio_transcriptions_fts_docsizel0audio_transcriptions_fts_datal0audio_transcriptions_fts_configl0audio_transcriptions10audio_tags10lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ec2-user@ip-10-.. 884-zsh-zsh18185-zsh86-zsh-$7* Unable to a...O 88-zsh...
|
20215
|
NULL
|