|
caudeFileEditViewWindowHelp000boosteroid sull reco caudeFileEditViewWindowHelp000boosteroid sull recoraing despite ignored windows setting0, Chat+ New chat• Prolects@ Customizedu ArtifactsBulgarian citizenship application processDawarich location tracking projectBoosteroid still recording despite ignoreMissing JavaScript promise in authorizatunux solTeUnoriNAsClaude AP 500 internal server errorScreenpipe query capabilities and usageeoru comoat ol wunvac mimiano oiUnderstanaing openkouter ArlgalewaScreenpipe 14-day retention explainedReddit homepage feed overviewDocker container not visible in consoleDA Drowser kaM conr curationScreenpipe company backgroundDSK Bank Bulgaria secure investing explaoulle1n2 a como crensve oersonainemdImporting Google limeline data to owndenromacast remora volume hulttans not iScreenpipe free version guideSelf-hosted LLM alternatives to Claude Sscreenpipe database query setupRunning screenpipe for treewhat about first time ifchoose the oldest date willl that workGood question — let's check what the oldest date in your DB is:bashisqlite3 ~screenpipe/db.sqlite "SELECT date(MIN(timestamp) FROM frames:"Then the concern for nrst-time run on oldest date is: the archive.db doesn't exist yet, so theinit section needs to create all tables and indexes from scratch before inserting. That partshoula work nne since we use CREAlE lABLE 1r Nol ExIsis ana CREAIE INDEX IF NOTEXISTS.The only risk is if the oldest date has very few frames (Screenpipe just started that day) - butthat's not a problem, lust rewer rows.What's the oldest date?E ОUpdated to 1.3109.0Ke auncho aooyRelaunch…Lukas KovalkReply...Sonnet 40vClauae is Al ana can make mistakes. rlease double-cneck responses.libdA100% [z7Fri 17 Apr 18:05:56copyscreenpipe sync shsqlite3 "$DB SRC" <<< "$sql" &local pid=s!local spin=[PASSWORD] 1=0while klll -0 "sp1d" 2>/dev/null; do%-36s %S " "$label" "${spin[$i]}"printt "\ri=$(( (i + 1) % 10 ))sleed 0.2conewait "Spid'local dur=s(( $(date +%s) - start ))printf "r%-36s v %dm%02ds n" "Slabel" "$(( dur / 60)""$( dur % 60 )" tee -a "SLOG FILE"DAUT ARGUM-NII1T L"921:-5" = "today" J; therARGE DATTES date +%y-/m-/dxelif [ -n "$51:-3" 1: thenLARGEI DAIL-"S1"if ! "STARGET DATE" =- N[0-97347-0-91321-0-91 215 17: thenecho "ERROR: Invalid date format. Use YYYY-MM-DD, 'today', or no argument for vesterday."exit 1fielseTARGET DATE=S(date -v-1d +%Y-%m-%d)10gLog"Screenpipe sync starting for: $TARGET_DATE"LogFACrLLOhlstep "Preflight checks"if !-f"$DB SRC" : ther1og "ERROR: Source DB not found at SDB SRC"; exit 1orintt"%-Dos %s(%s)\n" "Source DB." "OK "S(du -sh "SDR SRC" | cut -f1)"if[! -d "$NAS MOUNT" 1: thenlog "ERROR: NAS not mounted at $NAS_MOUNT"; exit 1printf "%-20s %s\n" "NAS mount:" "OK$NAS MOUNT'if [-f "$NAS DB" ]: thenEXISTING=$(sqlite3 "SNAS DB" "SELECT COUNT(* FROM frames WHERE date timestamp = 'STARGET DATE':" 2>/dev/null echo "0")if "SEXISTING" -gt "0" ; thenlog "Date STARGET DATE already has SEXISTING frames in archive - skippingAX1T 1Oprintf "%-20s %s (%s)\n" "Archive DB:" "exists" "$(du -sh "$NAS_DB" | cut -f1)"elseprintf"%-20s %s\n" "Archive DB:" "will be created"100101102COUNT SOURCE ROWSstep "Counting source rows for STARGET DATE'...
|
NULL
|
NULL
|
NULL
|
|
caudeFieEditViewWindowHeloboosteroid sull recorain caudeFieEditViewWindowHeloboosteroid sull recoraing despite ignored windows settingg chat+ New chat• Projects@ Customizedu ArtifactsBulgarian citizenship application processDawarich location tracking projectBoosteroid still recording despite ignoreMissing JavaScript promise in authorizatunux solTeUnoriNAsClaude AP 500 internal server errorScreenpipe query capabilities and usageeoru comoat ol wunvac mimiano oiUnderstanaing openkouter ArlgalewaScreenpipe 14-day retention explainedReddit homepage feed overviewDocker container not visible in consoleDA Drowser kaM conr curationScreenpipe company backgroundDSK Bank Bulgaria secure investing explabu lon2 a como crensve oersonalnomeImporting Google limeline data to owndenromacast remora volume hulttans not iScreenpipe free version guideSelf-hosted LLM alternatives to Claude Sscreenpipe database query setupRunning screenpipe for treewhat about first time ifchoose the oldest date willl that workGood question — let's check what the oldest date in your DB is:bashisqlite3 ~screenpipe/db.sqlite "SELECT date(MIN(timestamp) FROM frames:"Then the concern for nrst-time run on oldest date is: the archive.db doesn't exist yet, so theinit section needs to create all tables and indexes from scratch before inserting. That partshoula work nne since we use CREAlE lABLE 1r Nol ExIsis ana CREAIE INDEX IF NOTEXISTS.The only risk is if the oldest date has very few frames (Screenpipe just started that day) - butthat's not a problem, lust rewer rows.What's the oldest date?E ОUpdated to 1.3109.0Ke auncho aooyRelaunch…Lukas kovalkReply...Sonnet 40vClauae is Al ana can make mistakes. rlease double-cneck responses.100% CFri 17 Apr 18:06:04copyscreenpipe sync shsqlite3 "$DB SRC" <<< "$sql" &local pid=s!local spin=[PASSWORD] 1=0while k1ll -0 "sp1d" 2>/dev/null; do%-36s %S " "$label" "${spin[$i]}"printt "\ri=$(( (i + 1) % 10 ))sleed 0.2aonewait "spid'local dur=s(( $(date +%s) - start ))printf "r%-36s v %dm%02ds n" "Slabel" "$(( dur / 60)""$( dur % 60 )" tee -a "SLOG FILE"DAUT ARGUMENIN1T L"921:-5" = "today" J; therARGE DATTES date +%y-/m-/dxelif [ -n "$51:-3" 1: thenLARGEI DAIL-"S1"if ! "STARGET DATE" =- N[0-97347-0-91321-0-91 215 17: thenecho "ERROR: Invalid date format. Use YYYY-MM-DD, 'today', or no argument for vesterday."exit 1fielseTARGET DATE=S(date -v-1d +%Y-%m-%d)LogLog"Screenpipe sync starting for: $TARGET_DATE"LogFACrLLOhlstep "Preflight checks"if !-f"$DB SRC" : ther1og "ERROR: Source DB not found at SDB SRC"; exit 1orintt"%-Dos%c(%s)\n" "Source DB:" "OK" "$(du -sh "$DB_SRC" | cut -f1)"if[! -d "$NAS MOUNT" 1: thenlog "ERROR: NAS not mounted at $NAS_MOUNT"; exit 1printf "%-20s %s\n" "NAS mount:" "OK$NAS MOUNT'if [-f "$NAS DB" ]: thenEXISTING=$(sqlite3 "SNAS DB" "SELECT COUNT(* FROM frames WHERE date timestamp = 'STARGET DATE':" 2>/dev/null echo "0")if "SEXISTING" -gt "0" ; thenlog "Date STARGET DATE already has SEXISTING frames in archive - skippingAX1T 1Oprintf"%-20s %s (%s)\n" "Archive DB:" "exists" "$(du -sh "$NAS_DB" | cut -f1)"elseprintf"%-20s %s\n" "Archive DB:" "will be created"100101102COUNT SOURCE ROWSstep "Counting source rows for STARGET DATE'...
|
NULL
|
NULL
|
NULL
|
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp‹$0Inh-zshDOCKER881DEV (docker)APP (-zsh)X3-zsh84-zshlukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $screenpipe_sync.shzsh: command notfound: screenpipe_sync.shlukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ ~/.screenpipe/screenpipe_sync.sh 2026-04-15OK: NASmountedОK:Source DBexists3.6G/Users/lukas/.screenpipe/db.sqliteОK:archive.dbexists199MVolumes/Test/screenpipe/archive.db6 tables2026-04-17 17:58:51][2026-04-17 17:58:51]Screenpipe sync starting for: 2026-04-15[2026-04-17 17:58:51]:====|=====© *5[+00m00s] • Preflight checksSource DB:OK(3.60)NAS mount:OK/Volumes/Test/screenpipe[2026-04-17 17:58:52] Date 2026-04-15 already has 12874 frames in archive - skippingukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ~/.screenpipe/screenpipe_sync.sh 2026-04-15OK: NAS mountedOK: Source DB exists3.6G/Users/lukas/.screenpipe/db.sqliteINFO: archive.dbdoesnot exist yet - will be created on first sync[2026-04-17 17:59:49]=======[2026-04-17 17:59:49]Screenpipe sync starting for: 2026-04-15[2026-04-17 17:59:49]:====[+00m00s] • Preflight checksSource DB:NAS mount:Archive DB:OKOK(3.6G)/Volumes/Test/screenpipewill be created[+00m00s] • Counting source rows for 2026-04-15frames:elements:ui_events:ocr_text:meetings:128748868761445311412[+00m01s] • Initialising tables, indexes, FTS[2026-04-17 17:59:50] Sync complete for 2026-04-15[2026-04-17 17:59:50]2026-04-09lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "SELECT date(MIN(timestamp)) FROM frames;"ukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ U* Review screenp...• X6ec2-user@ip-10-...• 87ec2-user@ip-10-...100% <478Fri 17 Apr 18:06:071*1• 88...
|
NULL
|
NULL
|
NULL
|
|
caudeFileEditViewWindowHelp000boosteroid sull reco caudeFileEditViewWindowHelp000boosteroid sull recoraing despite ignored windows setting0, Chat+ New chat• Prolects@ Customizeo0 ArtifactsBulgarian citizenship application processDawarich location tracking projectBoosteroid still recording despite ignoreMissing JavaScript promise in authorizatunux solTeUnoriNAsClaude AP 500 internal server errorScreenpipe query capabilities and usageeoru comoat ol wunvac mimiano oiUnderstanaing openkouter ArlgalewaScreenpipe 14-day retention explainedReddit homepage feed overviewDocker container not visible in consoleDA Drowser kAM conr ourationScreenpipe company backgroundDSK Bank Bulgaria secure investing explaoulle1n2 a como crensve oersonainemdImporting Google limeline data to owndenromacact remota volume nulttans not !Screenpipe free version guideSelf-hosted LLM alternatives to Claude Sscreenpipe database query setupRunning screenpipe for treelukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ salite3~screenpipe db.sqlite "SELECT date (MIN(timestamp)) FROM frames:"2026-04-09, but lets say i want to start since few days ago not the beginning.Wlll that workYes, completely - you can run it for any specinic date:bash~/. screenpipe/screenpipe sync.sh 2026-04-12~. screenpipe/screenpipe sync.sh 2026-04-13~. screenpipe/screenpipe sync.sh 2026-04-14~. screenpipe/screUpdated to 1.3109.0Ke auncho aooyRelaunch…Lukas kovalkReply...Sonnet 40Clavae is Al ana can make mistakes. rlease double-check responses.libdA100% [45Fri 17 Apr 18:06:55copyscreenpipe sync shsqlite3 "$DB SRC" <<< "$sql" &local pid=s!local spin=[PASSWORD] 1=0while klll -0 "sp1d" 2>/dev/null; do%-36s %S " "$label" "${spin[$i]}"printt "\ri=$(( (i + 1) % 10 ))sleed 0.2conewait "Spid'local dur=s(( $(date +%s) - start ))printf "r%-36s v %dm%02ds n" "Slabel" "$( dur / 60""$ dur % 60 )" tee -a "SLOG FILE"100101102DAUT ARGUMENIN1T L"921:-5" = "today" J; therARGE DATTES date +%y-/m-/dxelif [ -n "$51:-3" 1: thenLARGEI DAIL-"S1"if ! "STARGET DATE" =- N[0-97347-0-91321-0-91 215 17: thenecho "ERROR: Invalid date format. Use YYYY-MM-DD, 'today', or no argument for vesterday."exit 1fiplcoTARGET DATE=S(date -v-1d +%Y-%m-%d)LogLog"Screenpipe sync starting for: $TARGET_DATE"LogFACrLLOhlstep "Preflight checks"if !-f"$DB SRC" : ther1og "ERROR: Source DB not found at SDB SRC"; exit 1orintt"%-Dos%c(%s)\n" "Source DB." "OK™ "S(du -sh "SDR SRC" | cut -f1)"if[! -d "$NAS MOUNT" 1: thenlog "ERROR: NAS not mounted at $NAS_MOUNT"; exit 1printf "%-20s %s\n" "NAS mount:" "OK$NAS MOUNT'if [-f "$NAS DB" ]: thenEXISTING=$(sqlite3 "SNAS DB" "SELECT COUNT(* FROM frames WHERE date timestamp = 'STARGET DATE':" 2>/dev/null echo "0")if "SEXISTING" -gt "0" ; thenlog "Date STARGET DATE already has SEXISTING frames in archive - skippingAX1T 1Oprintf"%-20s %s (%s)\n" "Archive DB:" "exists" "$(du -sh "$NAS_DB" | cut -f1)"elseprintf"%-20s %s\n" "Archive DB:" "will be created"COUNT SOURCE ROWSstep "Counting source rows for STARGET DATE'...
|
NULL
|
NULL
|
NULL
|
|
ClaudeFileEditViewWindowHelp...Boosteroid still re ClaudeFileEditViewWindowHelp...Boosteroid still recording despite ignored windows setting0, Chat+ New chat5 Projectse Customize8u ArtifactsBulgarian citizenship application processDawarich location tracking projectBoosteroid still recording despite ignorecMissing JavaScript promise in authorizatLinux SQLite Ul for NASClaude API 500 internal server errorScreenpipe query capabilities and usageeoru comoat ol wunvac mimiano oiUnderstanaing openkouter Arl galewaScreenpipe 14-day retention explainedReddit homepage feed overviewDocker container not visible in consoleDA Drowser kAM con ourationScreenpipe company backgroundDSK Bank Bulgaria secure investing explaoulle1n2 a comolcrensve oersona nemeImporting Google Timeline data to Owntrenromacact ramota volume nulttons notiScreenpipe free version guideSelf-hosted LLM alternatives to Claude SScreenpipe database query setupRunning screenpipe for freelukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3~/.screenpipe/db.sqlite "SELECT date(MIN(timestamp)) FROM frames,"2026-04-09, but lets say i want to start since few days ago not the beginning.WIIl that workYes, completely - you can run it for any specific date:bash~/. screenpipe/screenpipe_sync.sh 2026-04-12~/. screenpipe/screenpipe_sync.sh 2026-04-13~/.screenpipe/screenpipe_sync.sh 2026-04-14~/.screenpipe/screenpipe_sync.sh 2026-04-15Each run is independent - it checks if that date already exists in archive.db and skips if so.First run creates the DB, subsequent runs just append.If you want to backfill a range in one go:oasnfor d in 2026-04-12 2026-04-13 2026-04-14 2026-04-15; do~/. screenpipe/screenpipe_sync.sh "$d"coneOr a date range loop:hashSTART="2026-04-12"END="2026-04-15"d="$START"while [[ "$d" <= "$END" ]]; do~/. screenpipe/screenpipe_sync.sh "$d"d=$(date -v+1d -jf "gY-%m-%d" "$d" +%Y-%m-%d)coneBut before any of that —*Updated to 1.3109.0Ke auncho aooyRelaunch^ LuKas KovallkReply...Sonnet 40Claude is Al and can make mistakes. Please double-check responses.libdA100% C•Fri 17 Apr 18:06:58CopyScreenpipe sync • SHsqlite3 "$DB_SRC" <<< "$sql" &local pid=$!local spin=[PASSWORD] 1=0while kill -0 "$pid" 2>/dev/null; doprintf "\r%-36s %s " "$label" "${spin[$1]}"i=$(( (1 + 1) % 10 ))sleep 0.2aonewait "Spid'local dur=$(( $(date +%) - start ))printf "\r%-36s v %dm%02ds\n" "$label" "$(( dur / 60 ))" "$(( dur % 60 ))" | tee -a "$LOG_FILE"DAUT ARGUMENINif [ "${1:-}" = "today" ]; thenARGE DATTES date +%y-/m-/dxelif [ -n "$51:-3" 1: thenLARGEI DAIL-"S1"if ! [[ "$TARGET_DATE" =~ ^[0-9]{43- [0-9]{23-[0-9](23$ ]]; thenecho "ERROR: Invalid date format. Use YYYY-MM-DD, 'today', or no argument for yesterday."exit 1fielseTARGET_DATE=$(date -v-1d +%Y-%m-%d)10g"Screenpipe sync starting for: $TARGET_DATE"1ogFRcrLiohlstep "Preflight checks"if [ ! -f "$DB_SRC" ]; then10g "ERROR: Source DB not found at $DB_SRC"; exit 1printf"%-Dos %s(%s) \n" "Source DB:" "OK" "$(du -sh "$DB_SRC" | cut -f1)"if[! -d "$NAS MOUNT" 1: then10g "ERROR: NAS not mounted at $NAS_MOUNT"; exit 1printf "%-20s %s\n" "NAS mount:" "OK$NAS_MOUNT"if [ -f "$NAS_DB" ]; thenEXISTING=$(sqlite3 "$NAS_DB" "SELECT COUNT(*) FROM frames WHERE date(timestamp) = '$TARGET_DATE';" 2>/dev/nu11 || echo "0")if [ "$EXISTING"-gt "0" ; then10g "Date STARGET_DATE already has $EXISTING frames in archive - skipping"exit oprintf "elseprintf"%-20s %s (%s)\n" "Archive DB:" "exists" "$(du -sh "$NAS_DB" | cut -f1)"%-20s %s\n" "Archive DB:" "will be created"100101102103COUNT SOURCE ROWSstep "Counting source rows for $TARGET_DATE"...
|
NULL
|
NULL
|
NULL
|
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp‹$0Inh-zshDOCKER881DEV (docker)APP (-zsh)X3lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $screenpipe_sync.shzsh: command notfound: screenpipe_sync.shlukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ ~/.screenpipe/screenpipe_sync.sh 2026-04-15OK: NASmountedОK:Source DBexists3.6G/Users/lukas/.screenpipe/db.sqliteOK:archive.dbexists199MVolumes/Test/screenpipe/archive.db6 tables2026-04-17 17:58:51][2026-04-17 17:58:51]Screenpipe sync starting for: 2026-04-15[2026-04-17 17:58:51]:====|=====-zsh84-zsh• ₴5* Review screenp...• X6[+00m00s] • Preflight checksSource DB:OK(3.60)NAS mount:OK/Volumes/Test/screenpipe[2026-04-17 17:58:52] Date 2026-04-15 already has 12874 frames in archive - skippingukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ~/.screenpipe/screenpipe_sync.sh 2026-04-15OK: NAS mountedOK: Source DB exists3.6G/Users/lukas/.screenpipe/db.sqliteINFO: archive.dbdoesnot exist yet - will be created on first sync[2026-04-17 17:59:49]=======[2026-04-17 17:59:49]Screenpipe sync starting for: 2026-04-15[2026-04-17 17:59:49]•====[+00m00s] • Preflight checksSource DB:NAS mount:Archive DB:OKOK(3.6G)/Volumes/Test/screenpipewill be created[+00m00s] • Counting source rows for 2026-04-15frames:elements:ui_events:ocr_text:meetings:128748868761445311412[+00m01s] • Initialising tables, indexes, FTS[2026-04-17 17:59:50] Sync complete for 2026-04-15[2026-04-17 17:59:50]2026-04-09lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "SELECT date(MIN(timestamp)) FROM frames;"ukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ Uec2-user@ip-10-...• 87100% <478Fri 17 Apr 18:08:08T*1ec2-user@ip-10-...• 88...
|
NULL
|
NULL
|
NULL
|
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp‹$0Inh-zshDOCKER- 881DEV (docker)APP (-zsh)X3lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $screenpipe_sync.shzsh: command notfound: screenpipe_sync.shlukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ ~/.screenpipe/screenpipe_sync.sh 2026-04-15OK: NASmountedОK:Source DBexists3.6G/Users/lukas/.screenpipe/db.sqliteOK:archive.dbexists199MVolumes/Test/screenpipe/archive.db6 tables2026-04-17 17:58:51][2026-04-17 17:58:51]Screenpipe sync starting for: 2026-04-15[2026-04-17 17:58:51]:====|=====-zsh84-zsh• ₴5* Review screenp...• X6[+00m00s] • Preflight checksSource DB:OK(3.60)NAS mount:OK/Volumes/Test/screenpipe[2026-04-17 17:58:52] Date 2026-04-15 already has 12874 frames in archive - skippingukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ~/.screenpipe/screenpipe_sync.sh 2026-04-15OK: NAS mountedOK: Source DB exists3.6G/Users/lukas/.screenpipe/db.sqliteINFO: archive.dbdoesnot exist yet - will be created on first sync[2026-04-17 17:59:49]=======[2026-04-17 17:59:49]Screenpipe sync starting for: 2026-04-15[2026-04-17 17:59:49]•====[+00m00s] • Preflight checksSource DB:NAS mount:Archive DB:OKOK(3.6G)/Volumes/Test/screenpipewill be created[+00m00s] • Counting source rows for 2026-04-15frames:elements:ui_events:ocr_text:meetings:128748868761445311412[+00m01s] • Initialising tables, indexes, FTS[2026-04-17 17:59:50] Sync complete for 2026-04-15[2026-04-17 17:59:50]lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3~/.screenpipe/db.sqlite "SELECT date(MIN(timestamp)) FROMframes;"2026-04-09ukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ 0ec2-user@ip-10-...• ₴7100% <478Fri 17 Apr 18:08:20T₴1ec2-user@ip-10-...O ₴8...
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp‹$0Inh-zshDOCKER881DEV (docker)APP (-zsh)X3lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $screenpipe_sync.shzsh: command notfound: screenpipe_sync.shlukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ ~/.screenpipe/screenpipe_sync.sh 2026-04-15OK: NASmountedОK:Source DBexists3.6G/Users/lukas/.screenpipe/db.sqliteOK:archive.dbexists199MVolumes/Test/screenpipe/archive.db6 tables2026-04-17 17:58:51][2026-04-17 17:58:51]Screenpipe sync starting for: 2026-04-15[2026-04-17 17:58:51]:====|=====-zsh84-zsh• ₴5* Review screenp...• X6[+00m00s] • Preflight checksSource DB:OK(3.60)NAS mount:OK/Volumes/Test/screenpipe[2026-04-17 17:58:52] Date 2026-04-15 already has 12874 frames in archive - skippingukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ~/.screenpipe/screenpipe_sync.sh 2026-04-15OK: NAS mountedOK: Source DB exists3.6G/Users/lukas/.screenpipe/db.sqliteINFO: archive.dbdoesnot exist yet - will be created on first sync[2026-04-17 17:59:49]=======[2026-04-17 17:59:49]Screenpipe sync starting for: 2026-04-15[2026-04-17 17:59:49]•====[+00m00s] • Preflight checksSource DB:NAS mount:Archive DB:OKOK(3.6G)/Volumes/Test/screenpipewill be created[+00m00s] • Counting source rows for 2026-04-15frames:elements:ui_events:ocr_text:meetings:128748868761445311412[+00m01s] • Initialising tables, indexes, FTS[2026-04-17 17:59:50] Sync complete for 2026-04-15[2026-04-17 17:59:50]lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3~/.screenpipe/db.sqlite "SELECT date(MIN(timestamp)) FROMframes;"2026-04-09ukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ 0ec2-user@ip-10-...• ₴7100% <478Fri 17 Apr 18:08:23T₴1ec2-user@ip-10-...O ₴8...
|
NULL
|
NULL
|
NULL
|
|
CodeFileEditCellectionViewRunTerminalWindowHelp< CodeFileEditCellectionViewRunTerminalWindowHelp< → Search• Restricted Mode is intended for safe code browsing. Trust this window to enable all features.ManageLearn moresscreenoipe svnc.sh Xusers / lukas / screenoloe$ screenpipe sync.shQ244245247249250252254256259268269271# step"Updating FTS indexes"# run_sqlite_heredoc "elements_fts" "* AUIACHII"SNAS UB'As nash# INSERT INTO nas. elements_fts(rowid, text, role)oclcll erioenlext erroleFROM nas.elements eJOIN nas. frames f ON e. frame_id = f.idWHEREdate t timestamo) = "STARGEII DAIE'AND e. text IS NOT NULL;* DElAch nas.* run salite heredoc "frames fts"# ATTACH 'SNAS_DB' AS nas;*INSCK INITOnas. Trames_tustrowia, Tult_text, app_name, Window_name, browser_urlsclccl 1d, Tull text app name, window name, browser uruTkuM nas. TlamesWHERE date(timestamp) = '$TARGET_DATE'AND full_text IS NOT NULL;# DETACH nas;- VERIFY# step "Verifying"# V_FRAMES=$(sqlite3#VELEMENISES saLItes# V_UI=$(sqlite3# V OCR=$(sqlite3# V_MEETINGS=$(sqlite3"$NAS_DB" "SELECT COUNT(*)FROM framesWHERE date(timestamp)= '$TARGET_DATE' ;")"SNAS DB" "SELEC COUNIK*-ROM e lementsWHERE frame id IN (SELECT id FROM frames WHERE date(timestamo) = '¢TARGET DATE'):")"$NAS_DB" "SELECT COUNT (*)FROM ui_events WHERE'$TARGET_DATE';")"$NAS_DB" "SELECT COUNT(*)Thum ocr LexLWHERE frame_id IN (SELECT id FROM frames WHERE date(timestamp) = '$TARGET_DATE') ; ")"$NAS_DB" "SELECT COUNT(*)FROM meetingsWHERE date(meeting_start)='$TARGET_DATE' ; ")checkor%AT"SOOTprintf "printf"got="$2""bexvecte"uher8-20s %s / $sE\n" "$label:" "Sgot" "$expected"%-205 %s / %5E MISMATCH\n" "Slabel:" "$got" "Sexpected"299# check "frames"check "elements"* cheen ud evellts# check "ocr_text"# check "meetings""$V_FRAMES""$SRC_FRAMES""$V_ELEMENTS" "$SRC_ELEMENTS""$V_UI""$SRC _UI""CV OOR""ESRC OOR""OVMEETIINGS" "OSRC MEETINGS# TOTAL_ELAPSED=$( ( $(date +%s) - SCRIPT_START ))# DB_SIZE=$(du -sh "$NAS_DB" | cut -f1)echo ™# Log "Archive DB size:SDB SHLAEM# log "Total time:SI 1 TOTAL ELAPSESoUISO AL CLAPSCD X00 1Sloo sync complete tor siakoEl balc"Log "=DOД0libdA100% CS•Fri 17 Apr 18:08:23TSDESIAHAa ab."1of1V=XLIR-TEHIE-ED1UZUEIЕЕЕ© You have Docker installed on your system. Do you want toinstall the recommended extensions from Microsoft for it?Show RecommendationsLn 298, Col 37Spaces: 2() Shell Script...
|
NULL
|
NULL
|
NULL
|
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp‹$0Inh-zshDOCKER881DEV (docker)APP (-zsh)X3lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $screenpipe_sync.shzsh: command notfound: screenpipe_sync.shlukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ ~/.screenpipe/screenpipe_sync.sh 2026-04-15OK: NASmountedОK:Source DBexists3.6G/Users/lukas/.screenpipe/db.sqliteОK:archive.dbexists199MVolumes/Test/screenpipe/archive.db6 tables2026-04-17 17:58:51][2026-04-17 17:58:51]Screenpipe sync starting for: 2026-04-15[2026-04-17 17:58:51]:====|=====-zsh84-zsh• ₴5* Review screenp...• X6[+00m00s] • Preflight checksSource DB:OK(3.60)NAS mount:OK/Volumes/Test/screenpipe[2026-04-17 17:58:52] Date 2026-04-15 already has 12874 frames in archive - skippingukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ~/.screenpipe/screenpipe_sync.sh 2026-04-15OK: NAS mountedOK: Source DB exists3.6G/Users/lukas/.screenpipe/db.sqliteINFO: archive.dbdoesnot exist yet - will be created on first sync[2026-04-17 17:59:49]=======[2026-04-17 17:59:49]Screenpipe sync starting for: 2026-04-15[2026-04-17 17:59:49]•====[+00m00s] • Preflight checksSource DB:NAS mount:Archive DB:OKOK(3.6G)/Volumes/Test/screenpipewill be created[+00m00s] • Counting source rows for 2026-04-15frames:elements:ui_events:ocr_text:meetings:128748868761445311412[+00m01s] • Initialising tables, indexes, FTS[2026-04-17 17:59:50] Sync complete for 2026-04-15[2026-04-17 17:59:50]lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3~/.screenpipe/db.sqlite "SELECT date(MIN(timestamp)) FROMframes;"2026-04-09ukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ 0ec2-user@ip-10-...• ₴7100% <478Fri 17 Apr 18:08:27T₴1ec2-user@ip-10-...O ₴8...
|
NULL
|
NULL
|
NULL
|
|
CodeFileEditSelectionViewRunTerminalWindowHelp000• CodeFileEditSelectionViewRunTerminalWindowHelp000• Restricted Mode is intended for safe code browsing. Trust this window to enable all features.ManageLearn moresscreenoipe svnc.sheusers / lukas / screenoloe$ screenpipe sync.sh244245247249250252254256FTS UPDATE# step "Updating FTS indexes"# run_sqlite_heredoc "elements_fts" "* AUIACHII"SNAS DB'As nash# INSERT INTO nas. elements_fts(rowid, text, role)oclcll erioenlext erroleFROM nas.elements eJOIN nas. frames f ON e. frame_id = f.idWHEREdate(f.timestamp) = '$TARGET_DATE'AND e. text IS NOT NULL;* DElAch nas.# run sqlite heredoc "frames_fts"# ATTACH 'SNAS_DB' AS nas;#INSCKI INITOnas. Trames_tustrowia, Tult_text, app_name, Window_name, browser_urlsclccl 1d, Tull text app name, window name, browser uruTkuM nas. TlamesWHERE date(timestamp) = '$TARGET_DATE'AND full_text IS NOT NULL;# DETACH nas;< → Search268269271# step "Verifying"# V_FRAMES=$(sqlite3#VELEMENISEs salltes# V_UI=$(sqlite3# V OCR=$(sqlite3# V_MEETINGS=$(sqlite3checkor%AT"SOOTprintf "printf""$NAS_DB" "SELECT COUNT(*)FROM frames"SNAS DB" "SELEC COUNI*-ROM e lements"$NAS_DB" "SELECT COUNT (*)FROM ui_events"$NAS_DB" "SELECT COUNT(*)Thum ocr LexL"$NAS_DB" "SELECT COUNT(*)FROM meetingsWHERE date(timestamp)= '$TARGET_DATE' ;")WHERE frame id IN (SELECT id FROM frames WHERE date(timestamo) = '¢TARGET DATE'):")'STARGET _DATE' ; ")WHERE frame_id IN (SELECT id FROM frames WHERE date(timestamp) = '$TARGET_DATE') ; ")WHERE date(meeting_start)='$TARGET_DATE' ; ")got="$2""bexvecte"uher8-20s %s / $sE\n" "$label:" "Sgot" "$expected"%-205 %s / %sE MISMATCH\n" "Slabel:" "$got" "Sexpected"295299# check "frames"check "elements"* cheen ud evellts# check "ocr_text"# check "meetings""$V_FRAMES""$SRC_FRAMES""$V_ELEMENTS" "$SRC_ELEMENTS""$V_UI""$SRC_UI""CV OOR""ESRC OOR""OYMEETIINES" "OSRE MEEUINGS"# TOTAL_ELAPSED=$( ( $(date +%s) - SCRIPT_START ))# DB_SIZE=$(du -sh "$NAS_DB" | cut -f1)echo ™log "Archive DB Size:SDBSIVAElog "Total time:S(( TOTAL_ELAPSED / 60 ))m$( ( TOTAL_ELAPSED & 60 ))s"loo sync complete tor siakoEl balc"Log "=@OДOlibdA100% CS•Fri 17 Apr 18:08:27IORSIAHAa ab." 1of1V=XILIR-TOEIE-T1UZUESCпURHREEIЕЕЕ® You have Docker installed on your system. Do you want toгosXinstall the recommended extensions from Microsoft for it?Show RecommendationsLn 298, Col 31Spaces: 2() Shell Script...
|
NULL
|
NULL
|
NULL
|
|
CodeFileEditSelectionViewRunTerminalWindowHelp< CodeFileEditSelectionViewRunTerminalWindowHelp< → | Search• Restricted Mode is intended for safe code browsing. Trust this window to enable all features.ManageLearn more$ screenpipe_sync.sh •Users › lukas › .screenpipe › $ screenpipe_sync.shQtl"oer="Tooav tenTARGET_DATE=$(date +%Y-&m-sd)elif I -n "${1:-}" ]; thenTARGEII DATFE"Cif ! II "$TARGET_DATE" =~ ^[0-9] {43- [0-9] (23-[0-9] {27$ 11; thenесло "сккок.Invalid date format. Use YYYY-MM-DD,'today', or no argument for yesterday."exit 1100102116117119123124125126128150152153154155157elseTARGEI DAIFESdate -V-d +%y-%m-%d)Loa"log "=log "Screenpipe sync starting for: $TARGET_DATE"# PREFLIGHTstep "Preflight checks"if [ ! -f "$DB_SRC" 1; thenlog "ERROR:Source DB not found at $DB_SRC"; exit 1printf "%-20S %S(&s)\n" "Source DB:" "0K™ "$(du -sh "$DB SRC" | cut -f1)"IT .-a"SNAS MOUNI Chenlog "ERROR: NAS not mounted at $NAS_MOUNT"; exit 1printf "8-20s &s\n" "NAS mount:" "OK $NAS_MOUNT"if [ -f "$NAS_DB" 1; thenSSTE S 1 9 CO* FRO Tranes WHERE date(tinestamp) = 'STARGETLDATE'* 20/dev/null ech ia)-gt "g" ]; thenexit oprintf "$-20s %s(&s)\n" "Archive DB:" "exists" "$(du -sh "SNAS_DB" | cut -f1)"printf "%-20s &s\n" "Archive DB:" "will be created"#E COUNT SOURCE ROWS Eseo "coununo sourceYOWS TOr TAKGEIDAIESRC_FRAMES=$(sqlite3"$DB_SRC""SELECT COUNT(*)FROM frames WHERE date(timestamp) = '$TARGET_DATE' ; *)CRCE FENIC-C Calites WODR CReN WeSISCTCOUNIseSRC_UI=$(sqlite3"$DB_SRC" "SELECT COUNT(*)ui_events WHERE date(timestamp) = 'STARGET_DATE' ;")SRI OcRersalnte."ODB SRON WSEIEE COUNIXFROMSRC_MEETINGS=$(sqlite3 "$DB_SRC""SELECT COUNT(*)FROMocr_text WHERE Trame_1d IN (SELECT 1d FROM Trames WHERE date(timestamp) = "STARGET_DATE");")meetings WHERE date(meeting_start) = '$TARGET_DATE' ;")printf "printf"printf "printf"printf "$-20s &5\n" "frames:"$-20s &s\n"$-20s&s\n"$-20s %5\n""SSRC FRAMES""$SRC_ELEMENTS""$SRC_OCR""$SRC_MEETINGS"if [ "$SRC_FRAMES"-eq "0" : therlog "No frames foundfor $TARGET_DATE f nothing to sync"; exit o# INIT TABLESstep "Initialisingtables, indexes, FTS"# run_sqlite_heredoc'creating tables" ""AGH TXsnas.NOTAS SELECT * FROMWHERE 0;#CKEATTABLHNOIexss nas e lementsAS SELECT * FROMmain.e lementsWHERE 0:# CREATETABLEIF NOTcss nas,u evenusAS SELECT * FROM# CREATETABLEEXISTS nas.ocr_textmain.ui_eventsWHERE 0;AS SELECT * FROMmain.ocr texuWHERE 0;# GREATETARIFTE NOTEXISTS nas.video_chunksSELECT * FROM main.video chunks WHERE 0:# CREATE TABLENTOTTFxtste nas meptinadAS SELECT *FROMmain.meetingsWHERE 0;*DElAcH nas.DOД0libdA100% CS•Fri 17 Apr 18:08:30TSDESIAHAa ab."1of1ILIR-TOEIE-T1UZUEIЕЕЕ© You have Docker installed on your system. Do you want toгosXinstall the recommended extensions from Microsoft for it?Show RecommendationsLn 293, Col 40Spaces: 2() Shell Script...
|
NULL
|
NULL
|
NULL
|
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp‹$0Inh-zshDOCKER- 881DEV (docker)APP (-zsh)X3lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $screenpipe_sync.shzsh: command notfound: screenpipe_sync.shlukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ ~/.screenpipe/screenpipe_sync.sh 2026-04-15OK: NASmountedОK:Source DBexists3.6G/Users/lukas/.screenpipe/db.sqliteОK:archive.dbexists199MVolumes/Test/screenpipe/archive.db6 tables2026-04-17 17:58:51][2026-04-17 17:58:51]Screenpipe sync starting for: 2026-04-15[2026-04-17 17:58:51]:====|=====-zsh84-zsh• ₴5* Review screenp...• X6[+00m00s] • Preflight checksSource DB:OK(3.60)NAS mount:OK/Volumes/Test/screenpipe[2026-04-17 17:58:52] Date 2026-04-15 already has 12874 frames in archive - skippingukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ~/.screenpipe/screenpipe_sync.sh 2026-04-15OK: NAS mountedOK: Source DB exists3.6G/Users/lukas/.screenpipe/db.sqliteINFO: archive.dbdoesnot exist yet - will be created on first sync[2026-04-17 17:59:49]=======[2026-04-17 17:59:49]Screenpipe sync starting for: 2026-04-15[2026-04-17 17:59:49]•====[+00m00s] • Preflight checksSource DB:NAS mount:Archive DB:OKOK(3.6G)/Volumes/Test/screenpipewill be created[+00m00s] • Counting source rows for 2026-04-15frames:elements:ui_events:ocr_text:meetings:128748868761445311412[+00m01s] • Initialising tables, indexes, FTS[2026-04-17 17:59:50] Sync complete for 2026-04-15[2026-04-17 17:59:50]lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3~/.screenpipe/db.sqlite "SELECT date(MIN(timestamp)) FROMframes;"2026-04-09ukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ 0ec2-user@ip-10-...• ₴7100% <478Fri 17 Apr 18:08:33T₴1ec2-user@ip-10-...O ₴8...
|
NULL
|
NULL
|
NULL
|
|
CodeFileEditSelectionViewRunTerminalWindowHelp< CodeFileEditSelectionViewRunTerminalWindowHelp< → | Search• Restricted Mode is intended for safe code browsing. Trust this window to enable all features.ManageLearn moresscreenoipe svnc.sheusers / lukas / screenoloes screenoloesync.snelse1001021041Us106107109110123124126129131136138154155161162166log "=================log "Screenpipe sync starting for: $TARGET_DATE"log# E PREFLIGHTstep "Preflight checks"if [ ! -f "$DB_SRC" ]; thenlog "ERROR:Source Di not tound at sdB Sko" exit 1printf "8-205 *55(%s)\n" "Source DB:" "OK" "$(du -sh "$DB_SRC" | cut -f1)"if [ ! -d "$NAS_MOUNT" 1; then1og "ERROR: NAS not mounted at $NAS_MOUNT"; exit 1printf "&-20s &s\n" "NAS mount:" "0K)$NAS_MOUNT"if [ -f "$NAS_DB" ]; thenEXISTING=$(sqlite3 "$NAS_DB" "SELECT COUNT(*) FROM frames WHERE date(timestamp) = 'STARGET_DATE';" 2>/dev/null || echo "9")if [ "$EXISTING"log-gt "g" 1; then"Date STARGET_DATE already has $EXISTING frames in archive - skipping"exit oprintf "printf"%-20s %s(%s)\n" "Archive DB:" "exists" "$(du -sh "SNAS_DB" | cut -f1)"%-20s &5\n" "Archive DB:" "will be created"# E COUNT SOURCE ROWSsueo countine sourcerows for $TARGET_DATE"SRC_FRAMES=$(sqlite3"$DB_SRC" "SELECT COUNT(*) FROM frames WHERE date(timestamp) = '$TARGET_DATE' ;")SRE EIEENEESIsOlIteS "ODB SRON "SELEO COUNIRXFRow e lements WhEke trame 10 INSEUEaiSRC_UI=$(sqlite3"$DB_SRC" "SELECT COUNT(*)1d FROM Trames WHERE date(timestamp) = "STARGET_DATE');")FROM ui_events WHERE date(timestamp) = 'STARGET_DATE'; ")SRC OCR=$(salite3DE SKC" "SELEL COUNSFKOMocr_text WHERE frame_id IN (SELECT id FROM frames WHERE date(timestamp) = 'STARGET_DATE' ) ;")SRC_MEETINGS=$(sqlite3 "$DB_SRC" "SELECT COUNT(*)FROM meetings WHERE date(meeting_start) = '$TARGET_DATE' ;")printf"printf "printf "printf "printf "%-20s %5\n""frames:""$SRC_FRAMES"8-205 &5\n""$SRC_ELEMENTS"%-20S%Sn""ui events:" "&SRC UT"$-20s %s\n" "ocr_text:"$-20s"$SRC_OCR"POS h"meetings:""$SRC_MEETINGS"if [ "$SRC_FRAMES"-eq "g" 1; thenlog "Noframesfound for $TARGET_DATE nothing to sync"; exit o# INIT TABLESstep "Initialising tables, indexes, FTS"#frun_sqlite _heredoc"creating tables" "*АTАCHICREATETABLE IF NOTEXISTS nas.framesAS SELECT * FROMmain. framesWHERE 0;* CKCAIL TABLE IFNOIEXISISnas.e lementsAs SELCCI * rRoMmain.elemencsWHERE 0:# CREATETABLEIF NOT EXISTS nas.ui_eventsSELECT * FROM main.ui_eventsWHERE 0;# CREATE TABLE IF NOTEXISTS nas.ocr_textAS SELECT * FROM main.ocr_textWHERE 0;# CREATF TABLEIF NOTEXISTS nas.video_chunks ASSELECT * FROM main.video_chunks WHERE 0;# CREATE TABLEIF NOTEXISTS nas.meetingsAS SELECT * FROM main.meetingsWHERE 0;* DE Auh nas+# run_sqlite_heredoc "creating indexes" "# ATTACH 'SNAS_DB'AS nas;STUREATI"INDEX IIF NOIExsis nas.1dx trames timestamoNOTEXISTS nas.idx_frames_app_name* CKCAIC INDEX IFcxisis nas.lax Trames window name# CREATE INDEXIF NOTEXISTS nas.idx_frames_video_chunk_idON trames (timestamp);ON frames (app_name);oN Trames window nameon Tranes viaeo chunk 10libdA100% CS•Fri 17 Apr 18:08:34TSDESIAHAa ab."1of11UZUEIЕЕЕ® You have Docker installed on your system. Do you want toгosXinstall the recommended extensions from Microsoft for it?Show RecommendationsLn 293, Col 40Spaces: 2() Shell Script...
|
NULL
|
NULL
|
NULL
|
|
CodeFileEditSelectionViewRunTerminalWindowHelp< CodeFileEditSelectionViewRunTerminalWindowHelp< → Search• Restricted Mode is intended for safe code browsing. Trust this window to enable all features.ManaeeLearn moresscreenoipe svnc.sheQUsers › lukas › .screenpipe > $ screenpipe sync.sh229AS nas;Jrock or ovoke Iro nas elenents231scLcL e.* rrom main.elements eJOIN main.frames f ON e.frame id = f.idWHERE datelt. timestanoy ='$TARGET _DATE';234DETACH nas;43/239240241243run_sqlite_heredoc "meetings ($SRC_MEETINGS rows)" "ATTACH '$NAS_DB' AS nas;INSERT OR IGNORE INTO nas.meetingsSELECT * FROM main.meetings WHERE date(meeting_start) ='STARGET_DATE':DETACH nas;# FTS UPDATEstep "Updating FTS248256253255256run sallte heredoc "elements tis""ATTACH '$NAS_DB' AS nas;arock no naselenenus tust rowlr text roleoclcel erlo ertext enroleFROM nas.elements eJOTN nas. frames + ON e frame 1d e f.1dWHERE date(f.timestamp) ='$TARGET_DATE'AND ertext is NOT NULLADETACH nas;258260262263run_sqlite_heredoc "frames_fts" "AACH"ONAS DR"As nas.INSERT INTO nas.frames_fts(rowid, full_text, app_name, window_name, browser_url)seceor Tull rext aoo namer wnoow naner orowser UrlFROM nas.framesWHERE date(timestamp) = '$TARGET_DATE'AND full_text IS NOT NULL;DETACH nas;267268269270273#E VERIFY |step "Verifying"FRAMES=S Isalite."SNAS DR" "SELEO COUNT*FROw framesWHERE date timestamo)= '$TARGET_DATE';")"SNAS_DB" "SELECT COUNT(*)frame_id IN (SELECT id FROM frames WHERE date(timestamp) = 'STARGET_DATE') ; ")vues, sculres"SNAS DB" "SELECT COUNT(*)TКOPIun evenus wrckr carel unestaioAKGE DATE""V_OCR=$(sqlite3V_MEETINGS=$(sqlite3"SNAS_DB" "SELECT COUNT(*)FROM ocr_text"SNAS DB" "SELECT COUNT(*)FROMWHERE frame_id IN (SELECT id FROM frames WHERE date(timestamp) = 'STARGET_DATE') : ")meecinasWHERE date(meeting_start)='$TARGET_DATE' ; ")check() (local label="$1" aot="¢)" exnected="$3"if [ "$got"printf"$expected" ]; thens-20s %s / %sE\n" "$label:" "$got" "$expected"elseprintf"s-As scscE MISMATCH\n" "$label:" "$got" "$expected"Sô3287291292293294298check "frames"check "elements"check "ui events""SV_FRAMES""$SRC_FRAMES""SV_ELEMENTS" "$SRC_ELEMENTS"WaSRe T"$SRC_OCR"check "meetinasISV MEFTINGS" "$SRC MEFTTNGS"TOTAL_ELAPSED=$( ( $(date +%s) - SCRIPT_START ))DB_SIZE=$(du -sh"SNAS_DB" | cut -f1)echo "!log "Archive DB size:SDB_SIZE"loo ""otal time:$( ( TOTAL_ELAPSED / 60 ))m$( ( TOTAL_ELAPSED & 60 )) s"Log "Sync complete for STARGET_DATE"loq "∞0A0libdA100% CS•Fri 17 Apr 18:08:36IORSIAHAa ab." ?of1V=XTIGIR-IEHIR-EID: IIEдокаяIEIELE© You have Docker installed on your system. Do you want toгosXinstall the recommended extensions from Microsoft for it?Show RecommendationsLn 294, Col 1Spaces: 2UTF-8() Shell Script...
|
NULL
|
NULL
|
NULL
|
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp‹$0Inh-zshDOCKER881DEV (docker)APP (-zsh)X3lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $screenpipe_sync.shzsh: command notfound: screenpipe_sync.shlukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ ~/.screenpipe/screenpipe_sync.sh 2026-04-15OK: NASmountedОK:Source DBexists3.6G/Users/lukas/.screenpipe/db.sqliteOK:archive.dbexists199MVolumes/Test/screenpipe/archive.db6 tables2026-04-17 17:58:51][2026-04-17 17:58:51]Screenpipe sync starting for: 2026-04-15[2026-04-17 17:58:51]:====|=====-zsh84-zsh• ₴5* Review screenp...• X6[+00m00s] • Preflight checksSource DB:OK(3.60)NAS mount:OK/Volumes/Test/screenpipe[2026-04-17 17:58:52] Date 2026-04-15 already has 12874 frames in archive - skippingukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ~/.screenpipe/screenpipe_sync.sh 2026-04-15OK: NAS mountedOK: Source DB exists3.6G/Users/lukas/.screenpipe/db.sqliteINFO: archive.dbdoesnot exist yet - will be created on first sync[2026-04-17 17:59:49]=======[2026-04-17 17:59:49]Screenpipe sync starting for: 2026-04-15[2026-04-17 17:59:49]•====[+00m00s] • Preflight checksSource DB:NAS mount:Archive DB:OKOK(3.6G)/Volumes/Test/screenpipewill be created[+00m00s] • Counting source rows for 2026-04-15frames:elements:ui_events:ocr_text:meetings:128748868761445311412[+00m01s] • Initialising tables, indexes, FTS[2026-04-17 17:59:50] Sync complete for 2026-04-15[2026-04-17 17:59:50]lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3~/.screenpipe/db.sqlite "SELECT date(MIN(timestamp)) FROMframes;"2026-04-09ukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ 0ec2-user@ip-10-...• ₴7100% <478Fri 17 Apr 18:08:37T₴1ec2-user@ip-10-...O ₴8...
|
NULL
|
NULL
|
NULL
|
|
CodeFileEditSelectionViewRunTerminalWindowHelp< CodeFileEditSelectionViewRunTerminalWindowHelp< → Search• Restricted Mode is intended for safe code browsing. Trust this window to enable all features.ManaeeLearn moresscreenoipe svnc.sheQUsers › lukas › .screenpipe > $ screenpipe sync.sh229AS nas;Jrock or oyoke Io nasrelenents231scLcL e.* rrom main.elements eJOIN main.frames f ON e.frame id = f.idWHERE datelt. timestanoy'$TARGET _DATE';234DETACH nas;43/239240241243248256253255256258260262263267268269270273run_sqlite_heredoc "meetings ($SRC_MEETINGS rows)" "ATTACH '$NAS_DB' AS nas;INSERT OR IGNORE INTO nas.meetingsSELECT * FROM main.meetings WHERE date(meeting_start) ='STARGET_DATE':DETACH nas;# FTS UPDATEstep "Updating FTSrun sallte heredoc "elements tis""ATTACH '$NAS_DB' AS nas;arock no naselenenus tust rowlr text roleoclcll erlo entext enroleFROM nas.elements eJOTN nas. frames + ON e frame 1d = f.1dWHERE date(f.timestamp) ='$TARGET_DATE'AND e,text Is NOT NULLADETACH nas;run_sqlite_heredoc "frames_fts" "AACH"ONAS DR"As nas.INSERT INTO nas.frames_fts(rowid, full_text, app_name, window_name, browser_url)occuor Tull text doo namer wnoow namer orowser UrtFROM nas.framesWHERE date(timestamp) = '$TARGET_DATE'AND full_text IS NOT NULL;DETACH nas;#E VERIFY |step "Verifying"FRAMES=S Isalite."SNAS DR" "SELEO COUNT*FROw framesWHERE date timestamo)= '$TARGET_DATE';")WHERE frame_id IN (SELECT id FROM frames WHERE date(timestamp) = 'STARGET_DATE') ;")vues, sculresV_OCR=$(sqlite3V_MEETINGS=$(sqlite3"SNAS DB" "SELECT COUNT(*)FKOHun evenus wrckr carel unestaioAKGE DATE"""SNAS_DB" "SELECT COUNT(*)FROM ocr_text"SNAS DB" "SELECT COUNT(*)FROMWHERE frame_id IN (SELECT id FROM frames WHERE date(timestamp) = 'STARGET_DATE' ) ; ")meecinasWHERE date(meeting_start)='$TARGET_DATE' ; ")check() {local label="$1" aot="¢)" exnected="$3"if [ "$got"printfprintf"s-20s %s / %sE\n" "$label:" "$got" "$expected"s-as sc &sE MISMATCH\n™ "$label:""$got" "$expected"287291292293294298check "frames"check "elements"check "ui_events"check "ocr_text"check "meetinas"SV_FRAMES""$SRC_FRAMES""SV_ELEMENTS" "$SRC_ELEMENTS"WaSRe T'$V_MEETINGS" "$SRC_MEETINGS"TOTAL_ELAPSED=$( ( $(date +%s) - SCRIPT_START ))DB_SIZE=$(du -sh "SNAS_DB" | cut -f1)echo ""log "Archive DB size:SDB_SIZE"loo ""otal time:Log "Sync complete for STARGET_DATE"loq "SI TOTAL ELAPSED 66 05 TOTAL ELAPSED % 60 27S'@0A0libdA100% CS•Fri 17 Apr 18:08:37TOHSIHAa ab *?of1V=XTIGIR-IEHIR-EID: IIEдокая© You have Docker installed on your system. Do you want toгosXinstall the recommended extensions from Microsoft for it?Show RecommendationsLn 294, Col 1Spaces: 2UTF-8() Shell Script...
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp‹$0Inh-zshDOCKER881DEV (docker)APP (-zsh)X3lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $screenpipe_sync.shzsh: command notfound: screenpipe_sync.shlukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ ~/.screenpipe/screenpipe_sync.sh 2026-04-15OK: NASmountedОK:Source DBexists3.6G/Users/lukas/.screenpipe/db.sqliteOK:archive.dbexists199MVolumes/Test/screenpipe/archive.db6 tables2026-04-17 17:58:51][2026-04-17 17:58:51]Screenpipe sync starting for: 2026-04-15[2026-04-17 17:58:51]:====|=====-zsh84-zsh• ₴5* Review screenp...• X6[+00m00s] • Preflight checksSource DB:OK(3.60)NAS mount:OK/Volumes/Test/screenpipe[2026-04-17 17:58:52] Date 2026-04-15 already has 12874 frames in archive - skippingukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ~/.screenpipe/screenpipe_sync.sh 2026-04-15OK: NAS mountedOK: Source DB exists3.6G/Users/lukas/.screenpipe/db.sqliteINFO: archive.dbdoesnot exist yet - will be created on first sync[2026-04-17 17:59:49]=======[2026-04-17 17:59:49]Screenpipe sync starting for: 2026-04-15[2026-04-17 17:59:49]•====[+00m00s] • Preflight checksSource DB:NAS mount:Archive DB:OKOK(3.6G)/Volumes/Test/screenpipewill be created[+00m00s] • Counting source rows for 2026-04-15frames:elements:ui_events:ocr_text:meetings:128748868761445311412[+00m01s] • Initialising tables, indexes, FTS[2026-04-17 17:59:50] Sync complete for 2026-04-15[2026-04-17 17:59:50]lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3~/.screenpipe/db.sqlite "SELECT date(MIN(timestamp)) FROMframes;"2026-04-09ukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ 0ec2-user@ip-10-...• ₴7100% <478Fri 17 Apr 18:08:50T₴1ec2-user@ip-10-...O ₴8...
|
NULL
|
NULL
|
NULL
|
|
CodeFileEditSelectionViewRunTerminalWindowHelp000• CodeFileEditSelectionViewRunTerminalWindowHelp000• Restricted Mode is intended for safe code browsing. Trust this window to enable all features.$ screenpipe_sync.sh •< → SearchManaeeLearn moreusers / lukas116117118120141mount:" "OK$NAS_MOUNT"123[ -f "$NAS_DB" ]; thenEXISTING=$(sqlite3 "$NAS_DB" "SELECT COUNT(*) FROM frames WHERE date(timestamp) = 'STARGET_DATE' ;" 2»/dev/null || echo "®")-L" mei1og "Date $TARGET_DATE already has $EXISTING frames in archive l skipping"exit oprintf"%-20s %s(%5)\n" "Archive DB:" "exists" "$(du -sh "$NAS_DB" | cut -f1)"velseprintf"s-20s &s\n" "Archive DB:" "will be created"140127128# COUNT SOURCE ROWS !step "Counting source rows for $TARGET_DATE"SKL FRAMbsSS sOUresDE SKC" "SELEL COUNSrhom tranes woke oatemnestand =' AKGEDAIEh132SRC_ELEMENTS=$(sqlite3 "$DB_SRC" "SELECT COUNT(*)FROM elements WHERE frame_id IN (SELECT id FROM frames WHERE date(timestamp) = '$TARGET_DATE') : ")SKl Ul-s SolIres135SRC_OCR=$(sqlite3"$DB_SRC" "SELECT COUNT(*)Tkom un evenus Wickc odle Limestallo = SlAnocl vAIc"$DB_SRC" "SELECT COUNT(*)FROM ocr_text WHERE frame_id IN (SELECT id FROM frames WHERE date(timestamp) = 'STARGET_DATE') ; ")SRC_MEETINGS=$(sqlite3 "$DB_SRC" "SELECT COUNT(*) FROM meetings WHERE date(meeting_start) = '$TARGET_DATE' ;")printf "%-20s %s\n" "frames:""$SRC_FRAMES"printf "8-20s %s\n" "elements:""$SRC ELEMENTS"printf "$-20s %s\n" "ui_events:" "$SRC_UI"140printf"%-20s %5\n"oer cext.""$SRC_OCR"printf "%-20s %s\n" "meetings:" "$SRC_MEETINGS"142144VIT "ASRE FRAMES"-eq "0" 1; therlog "No frames foundfor $TARGET_DATE I nothing to sync"; exit o140146INIT TABLESstep "Initialisingtables, indexes, FIS"15215415615/159un_squite heredoc "creating tables" "ATTACH '$NAS_DB'AS nas;CREATE TABLE IF NOT EXISTS nas. framesAS SELECT * FROM main. framesWHERE 0;REATS TARIE TE NOT SxTCTS nac elllemantcAS SELECT * FROM main.elementsWHERS GCREATE TABLEIF NOTEXISTS nas.ui_eventsAS SELECT * FROM main.ui_eventsWHERE 0;CREATE TABLEIr NOTexiss nas ocr textAS SELEC * FROM main,ocr textNHERE OCREATE TABLE IF NOT EXISTS nas. video_chunksAS SELECT * FROM main.video_chunks WHERE 0;CKCAIL TADLE Ir NUI CxIsIs nas.meecinosAS SELECT * FROM main.meetinaswhitktbDETACH nas;1611631641661681by170173175176run_sqlite_heredoc"creating indexes" "ALTITACHINAS DOTCREATE INDEX IF NOT EXISTS nas.idx_frames_timestampON frames (timestamp) ;CREATE INDEX IF NOTEXISTS nas.idx frames app nameON frames(app name):CREATE INDEXIF NOT EXISTS nas. idx_frames_window_nameON frames(window_name);CREATE INDEX IF NOTEXISTS nas.idx_frames_video_chunk_idON frames(video_chunk_id);OREATENDEXNOIEXISSnas 1ox elements trame 10CREATECKCAILINDEXIFNOTON e lements(trame_1d):EXISTSnas. idx_elements_frame_src_role ON elements(frame_id, source, role) WHERE text IS NOT NULL;INDEX IrCXISISnas.lox ul events clnestaneun ul events cimescamphCREATE INDEX IF NOT EXISTS nas.idx_ui_events_app_nameON ui_events(app_name);CREATE INDEX IF NOT EXISTS nas.idx_ui_events_frame_idON ui_events(frame_id);CREATEINDEX IF NOT EXISTS nas.idx_ocr_text_frame_idON ocr_text(frame_id):CREATE INDEX IFNOTEXISTS nas.idx_meetings_startON meetings(meeting_start);CKCAIE INDEXnasmox voeo chunks cevceon Video_chunks(device_name),DETACH nas;178run_sqlite_heredoc "creating FTS tables" "AACHONAS DRTAs nas.• CREATE VIRTUAL TABLE IF NOT EXISTS nas.elements_fts USING fts5(LextTrame 10 UNINDEXCU,content='elements', content_rowid='id',tokenize='unicode61'182183184185V CREATE VIRTUAL TABLE IF NOT EXISTS nas.frames_fts USING fts5(app_name, window_name, browser_url,1O UNIINDEXEDR@0A0libdA100% CS•Fri 17 Apr 18:08:51IORSIAHAa ab." ?of1V=XTIGIR-IEHIR-EID: IIEIEIELE© You have Docker installed on your system. Do you want toгosXinstall the recommended extensions from Microsoft for it?Show RecommendationsLn 278, Col 42Spaces: 2() Shell Script...
|
NULL
|
NULL
|
NULL
|
|
CodeFileEditSelectionViewRunTerminalWindowHelp000• CodeFileEditSelectionViewRunTerminalWindowHelp000• Restricted Mode is intended for safe code browsing. Trust this window to enable all features.$ screenpipe_sync.sh •< → SearchManaeeLearn moreusers / luka116117118120121122123127132135140142144145LO415415615/1611631641661681by1701731781o1182183185mount:" "OK$NAS_MOUNT"1T L-T "$NAS_DB" J; thenEXISTING=$(sqlite3 "$NAS_DB" "SELECT COUNT(*) FROM frames WHERE date(timestamp) = 'STARGET_DATE' ;" 2>/dev/null || echo "Q")-L" mei1og "Date $TARGET_DATE already has $EXISTING frames in archive l skipping"exit oprintf "%-20s %s(%5)\n" "Archive DB:" "exists" "$(du -sh "$NAS_DB" | cut -f1)"elseprintf"s-20s &s\n" "Archive DB:" "will be created"# COUNT SOURCE ROWS !step "Counting source rows for $TARGET_DATE"SKL FRAMbsSS sOUresDb SKC" "SELEL COUNsrhom tranes woke oarelmnestand =' AKGeDAIEhSRC_ELEMENTS=$(sqlite3 "$DB_SRC" "SELECT COUNT(*)FROM elements WHERE frame_id IN (SELECT id FROM frames WHERE date(timestamp) = '$TARGET_DATE' ) ; ")SKl Ul=s SolIresSRC_OCR=$(sqlite3"$DB_SRC" "SELECT COUNT(*)FROM ui events WHERE date(timestamp = 'STARGET DATE'•")"$DB_SRC" "SELECT COUNT(*)FROM ocr_text WHERE frame_id IN (SELECT id FROM frames WHERE date(timestamp) = '$TARGET_DATE'); ")SRC_MEETINGS=$(sqlite3 "$DB_SRC" "SELECT COUNT(*)FROM meetings WHERE date(meeting_start) = '$TARGET_DATE' ;")printf "printf "printf "printf"printf "%-20s %s\n" "frames:""$SRC_FRAMES"8-20s &s\n" "elements:""$SRC ELEMENTS"$-20s %s\n" "ui_events:" "$SRC_UI"%-20s %5\n"oer cext.""$SRC_OCR"%-20s &s\n" "meetings:" "$SRC_MEETINGS"1T "SSRE FRAMES"-eq "0" 1; therlog "No frames foundfor $TARGET_DATE I nothing to sync"; exit oINIT TABLES*tep "Tnitalising tables, indexes, FTs"soure neredo"creating tables" "ATTACH '$NAS_DB'AS nas;CREATE TABLE IF NOTEXISTS nas.framesAS SELECT * FROM main. framesWHERE 0;CREATE TABLE IF NOT EXISTS nas.elementsAS SELECT * FROM main.elementsWHERS GCREATE TABLEIF NOTEXISTS nas.ui_eventsAS SELECT * FROM main.ui_eventsWHERE 0;CREATE TABLEIr NOTexiss nas ocr textAS SELEC * FRoM main,ocr textWHERECREATE TABLE IF NOT EXISTS nas.video_chunksAS SELECT * FROM main.video_chunks WHERE 0;CKCAIL TADLE Ir NUI CxIsIs nas.meecinosAS SELECT * FROM main.meetingswhitktbDETACH nas;run_sqlite_heredoc"creating indexes" "AITIACHONAS DOCREATEINDEX IF NOT EXISTS nas.idx_frames_timestampON frames (timestamp) ;CREATE INDEX IF NOTEXISTS nas.idx frames app nameON frames(app name):CREATE INDEX IF NOT EXISTS nas.idx_frames window_nameON frames (window_name);CREATE INDEX IF NOTEXISTS nas.idx_frames_video_chunk_idON frames(video_chunk_id);OREATENDEXNOIEXISSnas 1ox elements trame 10CREATECKCAILINDEXON e lements(trame_1d):IF NOTEXISTS nas.idx_elements_frame_src_role ON elements(frame_id, source, role) WHERE text IS NOT NULL;• INDEX 1rNOTCXISISnas.lox ul events clnestaneun ul events cimescamphCREATE INDEX IF NOT EXISTS nas.idx_ui_events_app_nameON ui_events(app_name);CREATE INDEX IF NOT EXISTS nas.idx_ui_events_frame_idON ui_events(frame_id);CREATEINDEX IF NOT EXISTS nas.idx_ocr_text_frame_idON ocr_text(frame_id):CREATE INDEX IF NOTEXISTS nas.idx_meetings_startON meetings(meeting_start);CKCAIE INOEX IrNONrxss nascox voeo chunks cevceon Video_chunks(device_name),DETACH nas;run_sqlite_heredoc "creating FTS tables" "AACHONAS DHTAs nas.CREATE VIRTUAL TABLE IF NOT EXISTS nas.elements_fts USING fts5(Lextrole,Trame 10 UNINDEXCU,content='elements', content_rowid='id',tokenize='unicode61'CREATE VIRTUAL TABLE IF NOT EXISTS nas.frames_fts USING fts5(app_name, window_name, browser_url,1O UNIINDEXEDR@0A0libdA100% CS•Fri 17 Apr 18:08:52IORSIAHAa ab." ?of1V=XIDR-IBHIREIEIELE© You have Docker installed on your system. Do you want toгosXinstall the recommended extensions from Microsoft for it?Show RecommendationsLn 150, Col 1Spaces: 2() Shell Script...
|
NULL
|
NULL
|
NULL
|
|
CodeFileEditSelectionViewRunTerminalWindowHelp000• CodeFileEditSelectionViewRunTerminalWindowHelp000• Restricted Mode is intended for safe code browsing. Trust this window to enable all features.$ screenpipe_sync.sh •< → | SearchManaeeLearn moreusers / lukas / screenoloe,s screenoloesync.sn235236430240242244245246247249400251252254256261263264266268271282283285287290292294295299run_sqlite _heredoc "meetings ($SRC_MEETINGS rows)" "AITACH SNAS DD AS nas-INSERT OR IGNORE INTO nas.meetingsSELECT * FROM main.meetings WHERE date(meeting_start) = 'STARGET_DATE';DETACH nas;# E FTS UPDATEstep "Updating FTS indexes"run_sqlite_heredoc "elements_fts" "AACHONAS DHTAs nas.INSERT INTO nas.elements_fts(rowid, text, role)sclcl e.la.e.text e.roleFROM nas.elements eJOIN nas.frames f ON e.frame_id = f.idWHERE date(f.timestamp) = 'STARGET DATE'AND e.text IS NOT NULL;DElACh nas:run_sqlite_heredoc "frames_fts" "ATTACH '$NAS_DB' AS nas;INSERT INTO nas.frames_fts(rowid, full_text, app_name, window_name, browser_url)SELECT id, full_text, app_name, window_name, browser_urlrkomnas,tranesWHERE date(timestamp) ='$TARGET_DATE'AND full_text IS NOT NULL;DETACH nas;# VERIFYsueo verityino"V_FRAMES=$(sqlite3"SNAS_DB" "SELECT COUNT(*)FROM framesWHERE date(timestamp)= '$TARGET_DATE'; ")NEuEmEnires sallntes"SNAS DE" WSELEOI COUNIRFROM elementsWHERE Trame_1d IN (SELECT 1d FROM Trames WHERE date(timestamp) = 'STARGET_DATE');)V_UI=$(sqLite3FROM ui_events WHERE date(timestamp)= '$TARGET_DATE' ; ")vucres, soures"SNAS DE "OCLELI COUNITКOPIWHERE frame_id IN (SELECT id FROM frames WHERE date(timestamp) = 'STARGET_DATE' ) : *)V_MEETINGS=$(sqlite3"SNAS_DB" "SELECT COUNT(*)FROM meetingsWHERE date(meeting_start)= '$TARGET_DATE' ; ")check(){local label="$1"got="$2" expected="$3"1t "500t""sexpected'printf "%-20s %sf&sE\n" "$label:" "$got" "$expected"printf "$-20s %5 / %sE MISMATCH\n" "$label:" "$got" "$expected"check "frames"""SU TKArLS""SRC FRAMES"check "elements""SV_ELEMENTS" "$SRC_ELEMENTS"check "ui_events"SVUL"boKL ULcheck "ocr_text"check "meetings""SV_OCR""$SRC_OCR""$V_MEETINGS" "$SRC_MEETINGS"TOTAL_ELAPSED=$( ( $(date +%s) - SCRIPT_START ))DB SILE=SQU -Sn "SNAS UD CUT -TL)echo "'log "Archive DB size:$DB_SIZE"log "Total time:$(( TOTAL_ELAPSED / 60 ))m$( ( TOTAL_ELAPSED & 60 ))s"loo "Sync complete for SIARGE DAIE"logSô3@OДOlibdA100% CS•Fri 17 Apr 18:09:10TOHSIHAa ab *?of1V=XIEIELE® You have Docker installed on your system. Do you want toгosXinstall the recommended extensions from Microsoft for it?Show RecommendationsLn 150, Col 1Spaces: 2() Shell Script...
|
NULL
|
NULL
|
NULL
|
|
Notion calendarEditViewWindowHelp000April 2026 wee Notion calendarEditViewWindowHelp000April 2026 week 16Mon 13Chloe Cross Parental Leave - 256 days)Ivelina Hristova (Parental Leave - 184 days)Andrea Zlatanova (Parental Leave - 189 days)Lauren muason Plu- zaaysEaster MondayGalya Dimitrova (PTO - 2 days)03:0006:0007:0008:00Daily - Platform 09:4510:0011:0012:0013:0015:00Oronaration for Retinementsupport vally 1o.ou17:0018:09)20:0021:0022:00lue 14Nikolay Nikolov (PTO - 1 day)Daily - Platform 09:45Il Support Daily 15:00Retro - Platformwea lsInu loFri (17satlolibdA100% C•WeekVFri 17 Apr 18:09:28Todaysun lyJames Granam ro- scaysLukas Kovalik (PTO - 1 day)(Todor Stamatov (PTO - 0.5 days)Daily - Platform 09:45[Platform] Planning I Session x Mid sprint checkan.19:90.Daily - Platform 09:45Backend Chapteri Support Daily. 15.00support valy 1b.00....
|
NULL
|
NULL
|
NULL
|
|
CodeFileEditSelectionViewRunTerminalWindowHelp000• CodeFileEditSelectionViewRunTerminalWindowHelp000• Restricted Mode is intended for safe code browsing. Trust this window to enable all features.$ screenpipe_sync.sh X< → | SearchManaeeLearn moreusers / lukas / screenoloe,s screenoloesync.snQ235236430239240242244449246247249400251252254256261263266268271273282283285287288290292294295299run_sqlite _heredoc "meetings ($SRC_MEETINGS rows)" "AITACH SNAS DD AS nas-INSERT OR IGNORE INTO nas.meetingsSELECT * FROM main.meetings WHERE date(meeting_start) = 'STARGET_DATE';DETACH nas;# E FTS UPDATEstep "Updating FTS indexes"run_sqlite_heredoc "elements_fts" "AACHONAS DHTas nas.INSERT INTO nas.elements_fts(rowid, text, role)sclcl e.la.e.text e.roleFROM nas.elements eJOIN nas.frames f ON e.frame_id = f.idWHERE date(f.timestamp) = 'STARGET DATE'AND e.text IS NOT NULL;DElACh nas:run_sqlite_heredoc "frames_fts" "ATTACH '$NAS_DB' AS nas;INSERT INTO nas.frames_fts(rowid, full_text, app_name, window_name, browser_url)SELECT id, full_text, app_name, window_name, browser_urlrkomnas,tranesWHERE date(timestamp) ='$TARGET_DATE'AND full_text IS NOT NULL;DETACH nas;# VERIFYstep "Verifying"V_FRAMES=$(sqlite3"SNAS_DB" "SELECT COUNT(*) FROM framesWHERE date(timestamp)= '$TARGET_DATE'; ")NEuEmEnires sallntes"SNAS DE" WSELEOI COUNIRFROM elementsWHERE Trame_1d IN (SELECT 1d FROM Trames WHERE date(timestamp) = 'STARGET_DATE');)V_UI=$(sqLite3FROM ui_events WHERE date(timestamp)= '$TARGET_DATE' ; ")vucres, soures"SNAS DE "OCLELI COUNITКOPIWHERE frame_id IN (SELECT id FROM frames WHERE date(timestamp) = 'STARGET_DATE' ) : *)V_MEETINGS=$(sqlite3"SNAS_DB" "SELECT COUNT(*)FROM meetingsWHERE date(meeting_start)= '$TARGET_DATE' ; ")check() {local label="$1"got="$2" expected="$3"1t "500t""sexpected'thenprintf "%-20s %s / %5E\n" "$label:" "$got" "$expected"printf"$-20s %5 / %sE MISMATCH\n" "$label:" "$got" "$expected"check "frames"""SU TKArLS"check "elements""$SRC_FRAMES""SV_ELEMENTS" "$SRC_ELEMENTS"check "ui_events"SVUL"boKL ULcheck "ocr_text"check "meetings""SV_OCR""$SRC_OCR""$V_MEETINGS" "$SRC_MEETINGS"TOTAL_ELAPSED=$( ( $(date +%s) - SCRIPT_START ))DB SILE=SQU -Sn "SNAS UD CUT -TL)echo "'log "Archive DB size:$DB_SIZE"log "Total time:$(( TOTAL_ELAPSED / 60 ))m$( ( TOTAL_ELAPSED & 60 ))s"loo "Sync complete for SIARGE DAIE"log@OДOlibdA100% CS•Fri 17 Apr 18:09:37IORSIAHAa ab *?of1V=XIEIELE® You have Docker installed on your system. Do you want toгosXinstall the recommended extensions from Microsoft for it?Show RecommendationsLn 150, Col 1Spaces: 2() Shell Script...
|
NULL
|
NULL
|
NULL
|
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp‹$0Inh-zshDOCKER881DEV (docker)APP (-zsh)X3lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $screenpipe_sync.shzsh: command notfound: screenpipe_sync.shlukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ ~/.screenpipe/screenpipe_sync.sh 2026-04-15OK: NASmountedОK:Source DBexists3.6G/Users/lukas/.screenpipe/db.sqliteOK:archive.dbexists199MVolumes/Test/screenpipe/archive.db6 tables2026-04-17 17:58:51][2026-04-17 17:58:51]Screenpipe sync starting for: 2026-04-15[2026-04-17 17:58:51]:====|=====-zsh84-zsh• ₴5* Review screenp...• X6[+00m00s] • Preflight checksSource DB:OK(3.60)NAS mount:OK/Volumes/Test/screenpipe[2026-04-17 17:58:52] Date 2026-04-15 already has 12874 frames in archive - skippingukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ~/.screenpipe/screenpipe_sync.sh 2026-04-15OK: NAS mountedOK: Source DB exists3.6G/Users/lukas/.screenpipe/db.sqliteINFO: archive.dbdoesnot exist yet - will be created on first sync[2026-04-17 17:59:49]=======[2026-04-17 17:59:49]Screenpipe sync starting for: 2026-04-15[2026-04-17 17:59:49]•====[+00m00s] • Preflight checksSource DB:NAS mount:Archive DB:OKOK(3.6G)/Volumes/Test/screenpipewill be created[+00m00s] • Counting source rows for 2026-04-15frames:elements:ui_events:ocr_text:meetings:128748868761445311412[+00m01s] • Initialising tables, indexes, FTS[2026-04-17 17:59:50] Sync complete for 2026-04-15[2026-04-17 17:59:50]lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3~/.screenpipe/db.sqlite "SELECT date(MIN(timestamp)) FROMframes;"2026-04-09ukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ~/.screenpipe/screenpipe_sync.sh 2026-04-14|ec2-user@ip-10-...• ₴7100% <478Fri 17 Apr 18:09:38T₴1ec2-user@ip-10-...O ₴8...
|
NULL
|
NULL
|
NULL
|
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelpsqlite3X4‹ 40100% <7*Fri 17 Apr 18:11:281881* Review screenp...• ₴6ec2-user@ip-10-...• ₴7ec2-user@ip-10-...• ₴8DOCKER7,- 281NAS mount:Archive DB:DEV (docker)OKAPP (-zsh)|/Volumes/Test/screenpipewill be created*3sqlite3-zsh• ₴5[+00m00s] • Counting source rows for 2026-04-15frames:elements:ui_events:ocr_text:meetings:1287488687614453114120[+00m01s] • Initialising tables, indexes, FTS[2026-04-1717:59:50]Sync complete for 2026-04-15[2026-04-17 17:59:50]ukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3~/.screenpipe/db.sqlite "SELECT date(MIN(timestamp)) FROM frames;"2026-04-09lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ~/.screenpipe/screenpipe_sync.sh 2026-04-14OK: NAS mountedOK: Source DB exists3.6G/Users/lukas/.screenpipe/db.sqliteINFO: archive.db does not exist yet - will be created on first sync[2026-04-17 18:09:41]=====[2026-04-17 18:09:41]Screenpipe sync starting for: 2026-04-14[2026-04-17 18:09:41][+00m00s] • Preflight checksSource DB:NAS mount:Archive DB:OKOK(3.6G)/Volumes/Test/screenpipewill be created[+00m00s] • Counting source rows for 2026-04-14frames:elements:ui_events:ocr_text:meetings:107336959691054282060[+00m00s] • Initialising tables, indexes, FTScreating tablescreating indexescreating FTS tables• 0m02s• 0m03s• 0m01s[+00m06s] • Syncing data for 2026-04-14video_chunksframes (10733 rows)• Om01s...
|
NULL
|
NULL
|
NULL
|
|
codeSelectionRunHelol< → | Search• Restricted M codeSelectionRunHelol< → | Search• Restricted Mode is intended for safe code browsing. Trust this window to enable all features.ManageLearn more$ screenpipe_sync.sh xUsers › lukas › .screenpipe › $ screenpipe_sync.shQI-n"${1:-}" ]; thenTANUCIDHIE-DL"$TARGET_DATE" =~ ^[0-9]<4}-[0-9](2}-[0-9](2)$ 11; thenecho "ERROR: Invalid date format. Use YMYY-MM-DD,'today', or no argument for yesterday."exlr1001021031051071201251271291311391431511531531571581l641TARGET_DATE=$(date -v-1d +%Y-Sm-%d)loglog "Screenpipe sync starting for: $TARGET_DATE"PREFLIGHTstep "Preflightchecks"if [! -f "$DB_SRC" ]; thenloo "Ehhon.Source DB not found at $DB_SRC"; exit 1printf "%-20s %s(%5)\n" "Source DB:" "0K" "$(du -sh "$DB_SRC" | cut -f1)"if [ ! -d "$NAS_MOUNT" 1; thenlog "ERROR: NAS not mounted at $NAS MOUNT": exit 1printf "%-20s &5\n" "NAS mount:" "OK $NAS_MOUNT"if [ -f "$NAS_DB" 1; thenEXISTING=$(sqlite3 "$NAS_DB" "SELECT COUNT(*) FROM frames WHERE date(timestamp) = 'STARGET_DATE'; " 2>/dev/null || echo "®")if [ "$EXISTING" -gt "g" 1; thenLog "Date STARGET_ DATE already has $EXISTING frames in archive B skipping"exit oprintf"elseprintf"%-Us %51(&s)\n" "Archive DB:" "exists" "$(du -sh "$NAS_DB" | cut -f1)"%-20s %5\n" "Archive DB:" "will be created"* E COUNT SOURCE ROWSstep "Counting source rows for STARGET DATE"SRC_FRAMES=$(sqlite3"$DB_SRC" "SELECT COUNT(*)FROM frames WHERE date(timestamp) = '$TARGET_DATE' ;")SRC_ELEMENTS=$(sqlite3"$DB_SRC" "SELECT COUNT(*)ГКОМelements WHERE frame_id IN (SELECT id FROM frames WHERE date(timestamp) = 'STARGET_DATE') ; ")SRC_UI=$(sqlite3"$DB_SRC" "SELECT COUNT(*)FROM ui_events WHERE date(timestamp) = '$TARGET_DATE' ;")SRC_OCR=$(sqlite3"$DB_SRC" "SELECT COUNT(*)FROMocr_text WHERE frame_id IN (SELECT id FROM frames WHERE date(timestamp) = '$TARGET_DATE'); ")SRE MERINGESISOlTteS "ODB SRON "SELEO COUNIRXFROMImeetings WHERE date(meeting_start) ='$TARGET_DATE' ;")printf "printf "printf "printf "printf "$-20s %5\n" "frames:"$-20s %5\n" "elements:"%-20s &5\n"%-20s %5\n"8-20s &s\n""meetings:""$SRC_FRAMES""$SRC_ELEMENTS""$SRC_UI"ICCRE OERY"$SRC_MEETINGS"if [ "$SRC_FRAMES""g" 1; thenlog "No framesfoundfor $TARGET_DATE nothing tosync exitoINIT TABLESstep"Initialisingtables, indexes, FTS"AITAUN SNAS UDnas.RETS TARIE TE NOT SxTCTC nas. FramacAS SELECT * FROM main. framesWHERE 0:CREATE TABLEIF NOTEXISTS nas.elementsAS SELECT *FROM main.elementsWHERE 0;CREATIEIABLETr NOTI-xrss nas.ul eventsASSELEOX-RoM ma1n.u1 eventsNHERECREATEIF NOT EXISTS nas.ocr_textSELECT * FROMWHERE 0;CKCAIL TADLE INNOTcxisis nas.viaeo chunksAs SclELl *rKOмmain. video chunksWHERE 0:CREATE TABLEIF NOTEXISTS nas.meetingsAS SELECT * FROM main.meetingsDETACH nas;WHERE@0A0100% CFri 17 Apr 18:11:28O8TSDESIAHAa ab." ?of1V=XIR-TEHIR-EII0: 1E© You have Docker installed on your system. Do you want toinstall the recommended extensions from Microsoft for it?Show RecommendationsLn 290, Col 48Spaces: 2() Shell Script...
|
NULL
|
NULL
|
NULL
|
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp‹$0Inh17100% <47sqlite3DOCKERS981NAS mount:Archive DB:DEV (docker)OKAPP (-zsh)|/Volumes/Test/screenpipewill be created*3sqlite3-zsh• ₴5[+00m00s] • Counting source rows for 2026-04-15frames:elements:ui_events:ocr_text:meetings:1287488687614453114120[+00m01s] • Initialising tables, indexes, FTS[2026-04-1717:59:50]Sync complete for 2026-04-15[2026-04-17 17:59:50]ukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3~/.screenpipe/db.sqlite "SELECT date(MIN(timestamp)) FROM frames;"2026-04-09lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ~/.screenpipe/screenpipe_sync.sh 2026-04-14OK: NAS mountedOK: Source DB exists3.6G/Users/lukas/.screenpipe/db.sqliteINFO: archive.db does not exist yet - will be created on first sync[2026-04-17 18:09:41]=====[2026-04-17 18:09:41]Screenpipe sync starting for: 2026-04-14[2026-04-17 18:09:41][+00m00s] • Preflight checksSource DB:NAS mount:Archive DB:OKOK(3.6G)/Volumes/Test/screenpipewill be created[+00m00s] • Counting source rows for 2026-04-14frames:elements:ui_events:ocr_text:meetings:107336959691054282060[+00m00s] • Initialising tables, indexes, FTScreating tablescreating indexescreating FTS tables• Om02s• 0m03s• 0m01s[+00m06s] • Syncing data for 2026-04-14video_chunksframes (10733 rows)• 0m01s* Review screenp...• ₴6ec2-user@ip-10-...• ₴78Fri 17 Apr 18:11:281₴81ec2-user@ip-10-...• 88...
|
NULL
|
NULL
|
NULL
|
|
CodeFileEditSelectionViewRunTerminalWindowHelp000• CodeFileEditSelectionViewRunTerminalWindowHelp000• Restricted Mode is intended for safe code browsing. Trust this window to enable all features.ManageLearn more$ screenpipe_sync.sh xQUsers › lukas › .screenpipe › $ screenpipe_sync.shI-nlen tneiIANUCIDHIL- DL"$TARGET_DATE" =~ ^[0-9]<4}-[0-9](2}-[0-9](2)$ 11; thenecho "ERROR: Invalid date format. Use YMYY-MM-DD,'today', or no argument for yesterday."exlr< → | Search100102103105107120129131139141153155157158160TARGET_DATE=$(date -v-1d +%Y-gm-%d)loglog "Screenpipe sync starting for: $TARGET_DATE"PREFLIGHTstep'"Preflightchecks"if [! -f "$DB_SRC" ]; thenloo "Ehhon.Source DB not found at SDB SRC": exit 1printf "%-20s %s(%5)\n" "Source DB:" "0K" "$(du -sh "$DB_SRC" | cut -f1)"if [ ! -d "$NAS_MOUNT" 1; thenlog "ERROR: NAS not mounted at $NAS MOUNT": exit 1printf "%-20s &5\n" "NAS mount:" "OK $NAS_MOUNT"if [ -f "$NAS_DB" 1; thenexis iinesssolltes"SNAS_DB" "SELECT COUNT(*) FROM frames WHERE date(timestamp) = 'STARGET_DATE';" 2>/dev/null || echo "g"›if [ "$EXISTING" -gt "g" 1; thenLog "Date STARGET DATE already has $EXISTING frames in archive B skipping"exit oprintf"elseprintf"%-us &s(&s)\n" "Archive DB:" "exists" "$(du -sh "$NAS_DB" | cut -f1)"%-20s %5\n" "Archive DB:" "will be created"* COUNT SOURCE ROWSstep"Counting source rowsfor $TARGET_DATE"SRC_FRAMES=$(sqlite3"$DB_SRC" "SELECT COUNT(*)FROM frames WHERE date(timestamp) = '$TARGET_DATE' ;")SRC_ELEMENTS=$(sqlite3 "$DB_SRC" "SELECT COUNT(*)ГКОМSRC_UI=$(sqlite3"$DB SRC" "SELECT COUNT(*)FROM ui_events WHERE date(timestamp) = '$TARGET_DATE' ;")SRC_OCR=$(sqlite3"$DB_SRC" "SELECT COUNT(*)FROMocr_text WHERE frame_id IN (SELECT id FROM frames WHERE date(timestamp) = '$TARGET_DATE' ) ; ")SRE_MEETINGS=$(squ1tes "$DB_SRC" "SELECT COUNT(*)FROMImeetings WHERE date(meeting_start) ='$TARGET_DATE' ;")printf "printf "printf "printf "printf "&-20s &s\n" "frames:"$-20s %5\n" "elements:""$SRC_FRAMES"%-20s &5\n""$SRC_ELEMENTS""ui_events:""$SRC_UI"%-20s %5\n""ocr_ text:"ICCRE OERY8-20s &s\n""meetings:""$SRC_MEETINGS"T IOSKE TKAMES"g" 1; thenloo "No Tramesfoundfor $TARGET_DATE nothing tosync exit oINIT TABLESstep"Initialisingtables, indexes, FTS"AITAUN NAS UDnas.RETS TARIE TE NOT SxTCTC nas. FramacAS SELECT * FROM main.framesWHERE 0:CREATE TABLEIF NOTEXISTS nas.elementsAS SELECT * FROM main.elementsWHERE 0;CREATIEIABLETr NOTI-xrss nas.ul eventsASSELEOX-RoM ma1n.u1 eventsNHERECREATEIF NOTEXISTS nas.ocr_textSELECT * FROMmain.ocr_textWHERE 0;CKCAIL TADLE IF NOUcxisis nas.viaeo chunksAs SclELl *rKOмmain. video chunksWHERE 0:CREATE TABLEIF NOTEXISTS nas.meetingsSELECT * FROM main.meetingsDETACH nas;WHEREDOД0libdA100% CS•Fri 17 Apr 18:11:29TSDESIAHAa ab." ?of1TIGIR-IEHIR-EID: IIEдокаяIEIELE® You have Docker installed on your system. Do you want to Xinstall the recommended extensions from Microsoft for it?Show RecommendationsLn 129, Col 7Spaces: 2() Shell Script...
|
NULL
|
NULL
|
NULL
|
|
CodeFileEditSelectionViewRunTerminalWindowHelp000• CodeFileEditSelectionViewRunTerminalWindowHelp000• Restricted Mode is intended for safe code browsing. Trust this window to enable all features.ManageLearn more$ screenpipe_sync.sh xQUsers › lukas › .screenpipe › $ screenpipe_sync.shI-n"${1:-7" 1;TnenTANUCIDHIL-DL"$TARGET_DATE" =~ ^[0-9]<4}-[0-9](2}-[0-9](2)$ 11; thenecho "ERROR: Invalid date format. Use YMYY-MM-DD,'today', or no argument for yesterday."exlr< → | Search100102103105107120122123127129131139148153153157158TARGET_DATE=$(date -v-1d +%Y-Sm-%d)loglog "Screenpipe sync starting for: $TARGET_DATE"PREFLIGHTstep'"Preflightchecks"if [! -f "$DB_SRC" ]; thenLo0 скhUK.Source DB not found at $DB SRC": exit 1printf "%-20s %s(%5)\n" "Source DB:" "0K" "$(du -sh "$DB_SRC" | cut -f1)"if [ ! -d "$NAS_MOUNT" 1; thenlog "ERROR: NAS not mounted at $NAS MOUNT": exit 1printf "%-20s &5\n" "NAS mount:" "OK $NAS_MOUNT"if [ -f "$NAS_DB" 1; thenexis iinesssolltes"SNAS_DB" "SELECT COUNT(*) FROM frames WHERE date(timestamp) = 'STARGET_DATE';" 2>/dev/null || echo "g")if [ "$EXISTING" -gt "g" 1; thenLog "Date STARGET_ DATE already has $EXISTING frames in archive B skipping"exit oprintf"elseprintf"%-Us %51(&s)\n" "Archive DB:" "exists" "$(du -sh "$NAS_DB" | cut -f1)"%-20s %5\n" "Archive DB:" "will be created"COUNT SOURCE ROWS*te "couneing source rOws fof STANGET DATE"SRC_FRAMES=$(sqlite3"$DB_SRC" "SELECT COUNT(*)FROM frames WHERE date(timestamp) = '$TARGET_DATE' ;")SRC_ELEMENTS=$(sqlite3 "$DB_SRC""SELECT COUNT(*)ГКОМelements WHERE frame_id IN (SELECT id FROM frames WHERE date(timestamp) = 'STARGET_DATE') ; ")SRC_UI=$(sqlite3"$DB_SRC" "SELECT COUNT(*)FROM ui events WHERE date(timestamp) = 'STARGET DATE';")SRC_OCR=$(sqlite3"$DB_SRC" "SELECT COUNT(*)FROMocr_text WHERE frame_id IN (SELECT id FROM frames WHERE date(timestamp) = '$TARGET_DATE'); ")SRE MERINGESISOlTteS "ODB SRON "SELEO COUNIRXFROMImeetings WHERE date(meeting_start) ='$TARGET_DATE' ;")printf "printf "printf "printf "printf "$-20s %5\n" "frames:"$-20s %5\n" "elements:"%-20s &5\n"%-20s %5\n"8-20s &s\n""meetings:""$SRC_FRAMES""$SRC_ELEMENTS""$SRC UI"ICCRE OERY"$SRC_MEETINGS"if [ "$SRC_FRAMES""g" 1; thenlog "No framesfoundfor $TARGET_DATE nothing tosync exit oINIT TABLESstep"Initialisingtables, indexes, FTS"ATTACH '$NAS_DB'nas,RETS TARIE TE NOT SxTCTC nas. FramacAS SELECT * FROM main.framesWHERS GCREATE TABLEIF NOTEXISTS nas.elementsAS SELECT *FROM main.elementsWHERE 0;CREATIEITr NOTI-xrss nas.ul eventsASSELHO*-RoM ma1n.u1 eventsWHERECREATEIF NOT EXISTS nas.ocr_textSELECT * FROMWHERE 0;CKCAIL TADLE INNOTcxisis nas.viaeo chunksAs SclEl * rкомmain.video chunksWHERE 0:CREATE TABLEIF NOT EXISTS nas.meetingsAS SELECT * FROM main.meetingsDETACH nas;WHEREDOД0libdA100% CS•Fri 17 Apr 18:11:3208TSDESIAHAa ab." ?of1TIGIR-IEHIR-EID: IIEIEIELE© You have Docker installed on your system. Do you want toinstall the recommended extensions from Microsoft for it?Show RecommendationsLn 129, Col 31 (25 selected)Spaces: 2() Shell Script...
|
NULL
|
NULL
|
NULL
|
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp‹$0Inh17100% <47sqlite3DOCKER• ₴1NAS mount:Archive DB:DEV (docker)OKAPP (-zsh)|/Volumes/Test/screenpipewill be created*3sqlite3-zsh• ₴5[+00m00s] • Counting source rows for 2026-04-15frames:elements:ui_events:ocr_text:meetings:1287488687614453114120[+00m01s] • Initialising tables, indexes, FTS[2026-04-1717:59:50]Sync complete for 2026-04-15[2026-04-17 17:59:50]ukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3~/.screenpipe/db.sqlite "SELECT date(MIN(timestamp)) FROM frames;"2026-04-09lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ~/.screenpipe/screenpipe_sync.sh 2026-04-14OK: NASmountedOK: Source DB exists3.6G/Users/lukas/.screenpipe/db.sqliteINFO: archive.db does not exist yet - will be created on first sync[2026-04-17 18:09:41]=====[2026-04-17 18:09:41]Screenpipe sync starting for: 2026-04-14[2026-04-17 18:09:41][+00m00s] • Preflight checksSource DB:NAS mount:Archive DB:OKOK(3.6G)/Volumes/Test/screenpipewill be created[+00m00s] • Counting source rows for 2026-04-14frames:elements:ui_events:ocr_text:meetings:107336959691054282060[+00m00s] • Initialising tables, indexes, FTScreating tablescreating indexescreating FTS tables• Om02s• 0m03s• 0m01s[+00m06s] • Syncing data for 2026-04-14video_chunksframes (10733 rows)• Om01s* Review screenp...• ₴6ec2-user@ip-10-...• 878Fri 17 Apr 18:11:59181ec2-user@ip-10-...• 88...
|
NULL
|
NULL
|
NULL
|
|
CodeFileEditSelectionViewRunTerminalWindowHelp000• CodeFileEditSelectionViewRunTerminalWindowHelp000• Restricted Mode is intended for safe code browsing. Trust this window to enable all features.ManageLearn more$ screenpipe_sync.sh xQUsers › lukas › .screenpipe › $ screenpipe_sync.shI-n"${1:-7" 1;TnenTANUCIDHIE-DL"$TARGET_DATE" =~ ^[0-9]<4}-[0-9](2}-[0-9](2)$ 11; thenecho "ERROR: Invalid date format. Use YMYY-MM-DD,'today', or no argument for yesterday."exlr< → | Search10010210310510711C120129131141150153155157158160TARGET_DATE=$(date -v-1d +%Y-Sm-%d)loglog "Screenpipe sync starting for: $TARGET_DATE"PREFLIGHTstep'"Preflightchecks"if [! -f "$DB_SRC" ]; thenloo "Ehhon.Source DB not found at $DB SRC": exit 1printf "%-20s %s(%5)\n" "Source DB:" "0K" "$(du -sh "$DB_SRC" | cut -f1)"if [ ! -d "$NAS_MOUNT" 1; thenlog "ERROR: NAS not mounted at $NAS MOUNT": exit 1printf "%-20s &5\n" "NAS mount:" "OK $NAS_MOUNT"if [ -f "$NAS_DB" 1; thenexis iinesssolltes"SNAS_DB" "SELECT COUNT(*) FROM frames WHERE date(timestamp) = 'STARGET_DATE';" 2>/dev/null || echo "g")if [ "$EXISTING" -gt "g" 1; thenLog "Date STARGET_ DATE already has $EXISTING frames in archive B skipping"exit oprintf"elseprintf"%-us %ST(&s)\n" "Archive DB:" "exists" "$(du -sh "$NAS_DB" | cut -f1)"%-20s %5\n" "Archive DB:" "will be created"COUNT SOURCE ROWSstep "Counting source rows for $TARGET DATE"SRC_FRAMES=$(sqlite3"$DB_SRC" "SELECT COUNT(*)FROM frames WHERE date(timestamp) = '$TARGET_DATE' ;")SRC_ELEMENTS=$(sqlite3 "$DB_SRC" "SELECT COUNT(*)ГКОМelements WHERE frame_id IN (SELECT id FROM frames WHERE date(timestamp) = 'STARGET_DATE' ) ; ")SRC_UI=$(sqlite3"$DB_SRC" "SELECT COUNT(*)FROM ui_events WHERE date(timestamp) = '$TARGET_DATE' ;")SRC_OCR=$(sqlite3"$DB_SRC" "SELECT COUNT(*)FROMocr_text WHERE frame_id IN (SELECT id FROM frames WHERE date(timestamp) = '$TARGET_DATE' ) ; ")SRE_MEETINGS=$(squ1tes "$DB_SRC" "SELECT COUNT(*)FROMImeetings WHERE date(meeting_start) ='$TARGET_DATE' ;")printf "printf "printf "printf "printf "$-20s %5\n" "frames:"$-20s %5\n" "elements:""$SRC_FRAMES"%-20s &5\n""$SRC_ELEMENTS""ui_events:""$SRC_UI"%-20s %5\n""ocr_ text:"ICCRE OGRI8-20s &s\n""meetings:""$SRC_MEETINGS"T IOSKE TKAMES"g" 1; thenloo "No Tramesfoundfor $TARGET_DATE nothing tosync exito*EINIT TABLESstep"Initialisingtables, indexes, FTS"AITAUN SNAS UDnas.RETS TARIE TE NOT SxTCTC nas. FramacAS SELECT * FROM main.framesWHERE 0:CREATE TABLEIF NOTEXISTS nas.elementsAS SELECT * FROM main.elementsWHERE 0;CREATIEIABLETr NOTI-xrss nas.ul eventsASSELEOX-RoM ma1n.u1 eventsNHERECREATEIF NOTEXISTS nas.ocr_textSELECT * FROMmain.ocr_textWHERE 0;CKCAIL TADLE IF NOUnas.viaeo chunksAs SclELl *rKOмmain. video chunkswricktCREATE TABLEIF NOTEXISTS nas.meetingsSELECT * FROM main.meetingsDETACH nas;WHEREDOД0libdA100% CS•Fri 17 Apr 18:12:0208TSDESIAHAa ab." ?of1TIGIR-IEHIR-EID: IIEIEIELE© You have Docker installed on your system. Do you want toinstall the recommended extensions from Microsoft for it?Show RecommendationsLn 129, Col 31 (25 selected)Spaces: 2() Shell Script...
|
NULL
|
NULL
|
NULL
|
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp‹$0Inh17100% <47sqlite3DOCKER2881NAS mount:Archive DB:DEV (docker)OKAPP (-zsh)|/Volumes/Test/screenpipewill be created*3sqlite3-zsh• ₴5[+00m00s] • Counting source rows for 2026-04-15frames:elements:ui_events:ocr_text:meetings:1287488687614453114120[+00m01s] • Initialising tables, indexes, FTS[2026-04-1717:59:50]Sync complete for 2026-04-15[2026-04-17 17:59:50]ukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3~/.screenpipe/db.sqlite "SELECT date(MIN(timestamp)) FROM frames;"2026-04-09lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ~/.screenpipe/screenpipe_sync.sh 2026-04-14OK: NAS mountedOK: Source DB exists3.6G/Users/lukas/.screenpipe/db.sqliteINFO: archive.db does not exist yet - will be created on first sync[2026-04-17 18:09:41]=====[2026-04-17 18:09:41]Screenpipe sync starting for: 2026-04-14[2026-04-17 18:09:41][+00m00s] • Preflight checksSource DB:NAS mount:Archive DB:OKOK(3.6G)/Volumes/Test/screenpipewill be created[+00m00s] • Counting source rows for 2026-04-14frames:elements:ui_events:ocr_text:meetings:107336959691054282060[+00m00s] • Initialising tables, indexes, FTScreating tablescreating indexescreating FTS tables• Om02s• 0m03s• 0m01s[+00m06s] • Syncing data for 2026-04-14video_chunksframes (10733 rows)• 0m01s* Review screenp...• ₴6ec2-user@ip-10-...• ₴78Fri 17 Apr 18:12:291₴81ec2-user@ip-10-...• 88...
|
NULL
|
NULL
|
NULL
|
|
CodeFileEditCellectionViewRunTerminalWindowHelp< CodeFileEditCellectionViewRunTerminalWindowHelp< → | Search• Restricted Mode is intended for safe code browsing. Trust this window to enable all features.ManageLearn More$ screenpipe_sync.sh XUsers › lukas › .screenpipe › $ screenpipe_sync.shQ129step "Counting source rows forf $TARGET_DATE"131SRC_FRAMES=$(sqlite3"$DB_SRC" "SELECT COUNT(*)FROM frames WHERE date(timestamp) = '$TARGET_DATE' ;")SRC_ELEMENTS=$(sqlite3 "$DB_SRC"oclEe LUUNIk134SRC_UI=$(sqlite3FROM elements WHERE frame_id IN (SELECT id FROM frames WHERE date(timestamp) = 'STARGET_DATE') ;")"$DB_SRC" "SELECT COUNT(*)FROM ui_events WHERE date(timestamp) ='STARGET _DATE';")SRC_OCR=$(sqlite3"$DB_SRC" "SELECT COUNT(*)FROM ocr_text WHERE frame_id IN (SELECT id FROM frames WHERE date(timestamp) = 'STARGET_DATE') : ")SRE MERINGESIsalTteS "ODB SRON WSEUEEICOUNIR жFROMIneetings WHERE date(meeting_start) ='$TARGET_DATE';")13/13813914014114314414615331541551o0157158160162163164165167100169170172177183Sô3193194196198printf "printf "printf "printf "printf "%-20s &s\n" "frames:""$SRC_FRAMES"$-20s %5\n" "elements:"%-20s %5\n""ui_events:""$SRC_ELEMENTS"%-20s %5\n""ocr_text:""$SRC_UI""SSRC OOR'8-205 &5\n""meetings:""$SRC_MEETINGS"if [ "$SRC_FRAMES"."O" 1, therlog "No frames foundfor $TARGET DATE & nothing to sync"; exit o# EINIIT TABUESstep "Initialisingtables, indexes, FTS"run_sqlite_heredoc "creating tables" "AlTACn NAS UbAS nas;CrEATE TABLE TF NOT EXISTS nas. framesAS SELECT * FROM main. framesCREATE TABLENOTWHERE 0:EXISTS nas.elementsAS SELECT *!FROM main.eLementsWHERECREATE TABLE IF NOT ExISTS nas,u1 eventsAS SELEC * FROM mainul eventsWHERE OCREATETABLEIF NOTEXISTS nas.ocr_textAS SELECT * FROM main.ocr_textWHERE 0;CKCAIL TADLCIr NUIEXISTS nas.video chunks AS SELECT * FROM main.video chunks WHERE 0:CREATE TABLEIF NOT EXISTS nas.meetingsAS SELECT * FROM main.meetingsWHERE 0;DETACH nas;run salite heredoc "creating indexes" "ATTACH '$NAS_DB'AS nas;CREATE INDEX IF NOTEXISTS nas.idx_frames_timestampON frames (timestamp);CREATE INDEX IF NOT EXISTS nas.idx_frames_app_nameON frames (app_name);CREATE INDEX IF NOTEXISTS nas.idx_frames_window_nameON frames (window_name);OREATEINDEX 1FNOTIEXISSnas. 1dx trames video chunk 10CREATEtrames (video_chunk_1d);INDEX IF NOTEXISTSnas.idx_elements_frame_idON elements(frame_id);CKCAIL INDEX Ir NOIcxisis nas.lox elements Trane src role un elements Trane 1a source.role) WHERE text IS NOT NULL;CREATE INDEX IF NOT EXISTS nas.idx_ui_events_timestampON ui_events(timestamp);CREATE INDEX IF NOT EXISTS nas.idx_ui_events_app_nameON ui_events(app_name);CREATEINDEX IF NOT EXISTS nas.idx_ui_events_frame_ioON ui_events(frame_id):CREATEINDEXIFNOTEXISTS nas.idx_ocr_text_frame_idON ocr_text(frame_id);CKEAIEINDEXonneemnos neenno startCREATE INDEXIF NOT EXISTS nas.idx_video_chunks_deviceuN viaeo chunks device namehUclaen nasrun_sqlite_heredoc "creating FTS tables" "ATTACH '$NAS_DB' AS nas;CKCAIL VIKIUAL lADLE Ir NUI CxIsIs nas.elements TuS USING TLSOtext, role,Trame 10 UNINUCACDcontent- elenentscontent_rowid='id',tokenize='unicode61'CREATE VIRTUAL TABLE IF NOT EXISTS nas. frames_fts USING fts5(app_name, window_name, browser_url,1d UNIINDEXED.DETACH nas;#] SYNC DATAsteo "snalne Dara Tor SAKGeDAICrun_sqlite_heredoc "video_chunks" "AACH"sNAs DR' AS nas.INSERT OR IGNORE INTO nas.video_chunksSEE * FROMWHERE id IN (SELECT DISTINCT video_chunk_id FROM main.frames@0A0libdA100% CS•Fri 17 Apr 18:12:33TOHSIHAa ab." ?of1V=XTIGIR-IEHIR-EID: IIEIEIELE© You have Docker installed on your system. Do you want toinstall the recommended extensions from Microsoft for it?Show RecommendationsLn 129, Col 31 (25 selected)Spaces: 2() Shell Script...
|
NULL
|
NULL
|
NULL
|
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp‹$0Inh17100% <47sqlite3DOCKER2881NAS mount:Archive DB:DEV (docker)OKAPP (-zsh)|/Volumes/Test/screenpipewill be created*3sqlite3-zsh• ₴5[+00m00s] • Counting source rows for 2026-04-15frames:elements:ui_events:ocr_text:meetings:1287488687614453114120[+00m01s] • Initialising tables, indexes, FTS[2026-04-1717:59:50]Sync complete for 2026-04-15[2026-04-17 17:59:50]ukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3~/.screenpipe/db.sqlite "SELECT date(MIN(timestamp)) FROM frames;"2026-04-09lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ~/.screenpipe/screenpipe_sync.sh 2026-04-14OK: NAS mountedOK: Source DB exists3.6G/Users/lukas/.screenpipe/db.sqliteINFO: archive.db does not exist yet - will be created on first sync[2026-04-17 18:09:41]=====[2026-04-17 18:09:41]Screenpipe sync starting for: 2026-04-14[2026-04-17 18:09:41][+00m00s] • Preflight checksSource DB:NAS mount:Archive DB:OKOK(3.6G)/Volumes/Test/screenpipewill be created[+00m00s] • Counting source rows for 2026-04-14frames:elements:ui_events:ocr_text:meetings:107336959691054282060[+00m00s] • Initialising tables, indexes, FTScreating tablescreating indexescreating FTS tables• 0m02s• 0m03s• 0m01s[+00m06s] • Syncing data for 2026-04-14video_chunksframes (10733 rows)• 0m01s* Review screenp...• ₴6ec2-user@ip-10-...• ₴78Fri 17 Apr 18:12:591₴81ec2-user@ip-10-...• 88...
|
NULL
|
NULL
|
NULL
|
|
CodeFileEditSelectionViewRunTerminalWindowHelp< CodeFileEditSelectionViewRunTerminalWindowHelp< → | SearchQRestricted Mode is intended for safe code browsing. Trust this window to enable all features.ManageLearn Moresscreenoipe svnc.shXusers / lukas / screenoloe,s screenoloe sync.snSRe EUEENEESIsalntes "aDB SRe"SELECT COUNT(*) FROM elements WHERE frame_id IN (SELECT id FROM frames WHERE date(timestamp) = '$TARGET_DATE');")SRC_UI=$(sqlite3"$DB_SRC" "SELECT COUNT(*)FROM ui_events WHERE date(timestamp) = 'STARGET_DATE'; ")1341135130sk ouerstute.bo She" "ELEL LOUNsFКOMocr text WHERE frame id IN (SELECT id FROM frames WHERE date(timestamo) = 'STARGET DATE'):")SRC_MEETINGS=$(sqlite3 "$DB_SRC""SELECT COUNT(*)FROMmeetings WHERE date(meeting_start) = '$TARGET_DATE' ;")138140141142143145147150152154155156157159160162166169171114174179181183184190191193195197198200printf "printfprintt"printf "printf "%-20s %5\n" "frames:""$SRC_FRAMES"8-205 &5\n""$SRC_ELEMENTS"&-20s &s\n" "ui events:" "$SRC UT"$-20s %5\n"$-20s"$SRC_MEETINGS"if [ "$SRC_FRAMES"-eq "g" 1; thenlog "Noframesfound for $TARGET_DATE nothing to sync"; exit o- INLI TABLESstep "Initialising tables, indexes, FTS"run_sqlite_heredoc"creating tables" "AIUIACH"GNAS DBCREATETABLEIF NOT EXISTS nas. framesAS SELECT * FROM main. framesWHERE 0;CREATE TABLE IFnul cxisis nas.elementsAS SCLE * ГКОМmain.e lementsWHERE 0:CREATE TABLEIF NOT EXISTS nas.ui_eventsAS SELECT * FROM main.ui_eventsWHERE 0;CREATE TABLE IF NOT EXISTS nas.ocr_textAS SELECT * FROM main.ocr_textWHERE 0;CREATE TABLEIF NOT EXISTS nas.video_chunks AS SELECT * FROM main.video_chunks WHERE 0;CREATE TABLE IF NOT EXISTS nas.meetingsAS SELECT * FROM main.meetingsWHERE 0;DeAcnnashrun_sqlite_heredoc "creating indexes" "ATTACH '$NAS_DB'AS nas;CREATIEIJINDEX TF NOTI-xrss nas.1dx trames timestamiON frames(timestamp);CREATEINDEXCKCAILIFNOTEXISTSnas. idx_frames_app_nameONframes (app_name);INDEx IrNUICXISISnas.lox Tranes window nameON frames (window name):CREATEINDEXNOTEXISTS nas.idx_frames_video_chunk_idON frames(video_chunk_id);CREATE INDEX IFCREATEINDEXNOTEXISTS nas.idx_elements_frame_idON elements (frame_id);IF NOT EXISTS nas.idx_elements_frame_src_role ON elements(frame_id, source, role) WHERE text IS NOT NULL;CREATE INDEXIFNOTEXISTS nas. idx_ui_events_timestampON ui_events(timestamp);OREATEINDEXEXISSas, 1ox ul events avo nameON ul_events(app_name);CREATEINDEXIF NOTEXISTS nas.idx_ui_events_frame_idON ui_events(frame_id);CREATE INDEX IF NOTcalols nas.lox ocr cext Tlale 10ON ocr text(frame id:CREATE INDEX IF NOT EXISTS nas.idx_meetings_startON meetings(meeting_start);CREATE INDEX IF NOT EXISTS nas.idx_video_chunks_deviceON video_chunks(device_name);DETACH nas;rungsqulte_neredoc "creating FTS tables" "AlTAUn NAS UDAS nas;CREATE VIRTUAL TABLE IF NOT EXISTS nas.elements fts USING fts50text, role,frame_id UNINDEXED,contente' elements' content rowld='1d', tokenizes'unicodeoilCREATE VIRTUAL TABLE IF NOT EXISTS nas.frames_fts USING fts5(Tule cextapp nametokenize='unicode61'id UNINDEXED,DETACH nas;- SYNC DATA Hstep*"Syncing data for $TARGET_DATE"run soliteATTACH "$NAS_DB'AS nas;INSCKI UK IGNOrE INIU nas.video chunksSELECT * FROM main.video_chunksWHERE id IN (SELECT DISTINCT video_chunk_id FROM main.framesWHERE date(timestamp) ='$TARGET_DATE'AND video_chunk_id IS NOT NULLSô3libdA100% CS•Fri 17 Apr 18:13:03TOHSIHAa ab *?of1V=XTIGIR-IEHIR-EID: IIEIEIELE© You have Docker installed on your system. Do you want toinstall the recommended extensions from Microsoft for it?Show RecommendationsLn 129, Col 31 (25 selected)Spaces: 2() Shell Script...
|
NULL
|
NULL
|
NULL
|
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp‹$0Inh17100% <47sqlite3DOCKERS981NAS mount:Archive DB:DEV (docker)OKAPP (-zsh)|/Volumes/Test/screenpipewill be created*3sqlite3-zsh• ₴5[+00m00s] • Counting source rows for 2026-04-15frames:elements:ui_events:ocr_text:meetings:1287488687614453114120[+00m01s] • Initialising tables, indexes, FTS[2026-04-1717:59:50]Sync complete for 2026-04-15[2026-04-17 17:59:50]ukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3~/.screenpipe/db.sqlite "SELECT date(MIN(timestamp)) FROM frames;"2026-04-09lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ~/.screenpipe/screenpipe_sync.sh 2026-04-14OK: NAS mountedOK: Source DB exists3.6G/Users/lukas/.screenpipe/db.sqliteINFO: archive.db does not exist yet - will be created on first sync[2026-04-17 18:09:41]=====[2026-04-17 18:09:41]Screenpipe sync starting for: 2026-04-14[2026-04-17 18:09:41][+00m00s] • Preflight checksSource DB:NAS mount:Archive DB:OKOK(3.6G)/Volumes/Test/screenpipewill be created[+00m00s] • Counting source rows for 2026-04-14frames:elements:ui_events:ocr_text:meetings:107336959691054282060[+00m00s] • Initialising tables, indexes, FTScreating tablescreating indexescreating FTS tables• Om02s• 0m03s• 0m01s[+00m06s] • Syncing data for 2026-04-14video_chunksframes (10733 rows)• 0m01s* Review screenp...• ₴6ec2-user@ip-10-...• ₴78Fri 17 Apr 18:13:301₴81ec2-user@ip-10-...• 88...
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp‹$0Inh17100% <47sqlite3DOCKERNAS mount:Archive DB:DEV (docker)OKAPP (-zsh)|/Volumes/Test/screenpipewill be created*3sqlite3-zsh• ₴5[+00m00s] • Counting source rows for 2026-04-15frames:elements:ui_events:ocr_text:meetings:1287488687614453114120[+00m01s] • Initialising tables, indexes, FTS[2026-04-1717:59:50]Sync complete for 2026-04-15[2026-04-17 17:59:50]ukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3~/.screenpipe/db.sqlite "SELECT date(MIN(timestamp)) FROM frames;"2026-04-09lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ~/.screenpipe/screenpipe_sync.sh 2026-04-14OK: NAS mountedOK: Source DB exists3.6G/Users/lukas/.screenpipe/db.sqliteINFO: archive.db does not exist yet - will be created on first sync[2026-04-17 18:09:41]=====[2026-04-17 18:09:41]Screenpipe sync starting for: 2026-04-14[2026-04-17 18:09:41][+00m00s] • Preflight checksSource DB:NAS mount:Archive DB:OKOK(3.6G)/Volumes/Test/screenpipewill be created[+00m00s] • Counting source rows for 2026-04-14frames:elements:ui_events:ocr_text:meetings:107336959691054282060[+00m00s] • Initialising tables, indexes, FTScreating tablescreating indexescreating FTS tables• 0m02s• 0m03s• 0m01s[+00m06s] • Syncing data for 2026-04-14video_chunksframes (10733 rows)• 0m01s* Review screenp...• ₴6ec2-user@ip-10-...• ₴78Fri 17 Apr 18:13:411₴81ec2-user@ip-10-...O ₴8...
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp‹$0Inh17100% <47sqlite3DOCKERNAS mount:Archive DB:DEV (docker)OKAPP (-zsh)|/Volumes/Test/screenpipewill be created*3sqlite3-zsh• ₴5[+00m00s] • Counting source rows for 2026-04-15frames:elements:ui_events:ocr_text:meetings:1287488687614453114120[+00m01s] • Initialising tables, indexes, FTS[2026-04-1717:59:50]Sync complete for 2026-04-15[2026-04-17 17:59:50]ukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3~/.screenpipe/db.sqlite "SELECT date(MIN(timestamp)) FROM frames;"2026-04-09lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ~/.screenpipe/screenpipe_sync.sh 2026-04-14OK: NAS mountedOK: Source DB exists3.6G/Users/lukas/.screenpipe/db.sqliteINFO: archive.db does not exist yet - will be created on first sync[2026-04-17 18:09:41]=====[2026-04-17 18:09:41]Screenpipe sync starting for: 2026-04-14[2026-04-17 18:09:41][+00m00s] • Preflight checksSource DB:NAS mount:Archive DB:OKOK(3.6G)/Volumes/Test/screenpipewill be created[+00m00s] • Counting source rows for 2026-04-14frames:elements:ui_events:ocr_text:meetings:107336959691054282060[+00m00s] • Initialising tables, indexes, FTScreating tablescreating indexescreating FTS tables• 0m02s• 0m03s• 0m01s[+00m06s] • Syncing data for 2026-04-14video_chunksframes (10733 rows)• 0m01s* Review screenp...• ₴6ec2-user@ip-10-...• ₴78Fri 17 Apr 18:13:52181ec2-user@ip-10-...• 88...
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp‹$0Inh17100% <47sqlite3DOCKERS- 981NAS mount:Archive DB:DEV (docker)OKAPP (-zsh)|/Volumes/Test/screenpipewill be created*3sqlite3-zsh• ₴5[+00m00s] • Counting source rows for 2026-04-15frames:elements:ui_events:ocr_text:meetings:1287488687614453114120[+00m01s] • Initialising tables, indexes, FTS[2026-04-1717:59:50]Sync complete for 2026-04-15[2026-04-17 17:59:50]ukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3~/.screenpipe/db.sqlite "SELECT date(MIN(timestamp)) FROM frames;"2026-04-09lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ~/.screenpipe/screenpipe_sync.sh 2026-04-14OK: NAS mountedOK: Source DB exists3.6G/Users/lukas/.screenpipe/db.sqliteINFO: archive.db does not exist yet - will be created on first sync[2026-04-17 18:09:41]=====[2026-04-17 18:09:41]Screenpipe sync starting for: 2026-04-14[2026-04-17 18:09:41][+00m00s] • Preflight checksSource DB:NAS mount:Archive DB:OKOK(3.6G)/Volumes/Test/screenpipewill be created[+00m00s] • Counting source rows for 2026-04-14frames:elements:ui_events:ocr_text:meetings:107336959691054282060[+00m00s] • Initialising tables, indexes, FTScreating tablescreating indexescreating FTS tables• Om02s• 0m03s• 0m01s[+00m06s] • Syncing data for 2026-04-14video_chunksframes (10733 rows)• Om01s* Review screenp...• ₴6ec2-user@ip-10-...• ₴78Fri 17 Apr 18:13:57181ec2-user@ip-10-...• 88...
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
MusicFileEditSongView•ControlsAccountWindowx;Help0 MusicFileEditSongView•ControlsAccountWindowx;Help0:08Q SearchApple Music• Home((**) RadioLibrary• Recently AddedA Artists•Albumsj SongsStore* iTunes StorePlaylists888 All PlaylistsEf Internet Songs2025start machineChatLLM Teams TTS2024output 2ffc1839a-520f-4619-8c06-3fc496622364lalol100% <478Fri 17 Apr 18:14:34start machine •••-0:03Recently AddedQCall to Robinson Crusoe Nov 2220246e5cbce9-0b1e-4556-ae01-10b2e491ee17105f8bc8-d065-4fdd-abf6-27d8afad9513ed9e817e-f202-4d5f-b8b3-92a19fde8535...
|
NULL
|
NULL
|
NULL
|
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelpsqlite3>0 lbl100% <478Fri 17 Apr 18:14:361₴81* Review screenp...• ₴6ec2-user@ip-10-...• ₴7ec2-user@ip-10-...• 88DOCKER881NAS mount:Archive DB:DEV (docker)OKAPP (-zsh)|/Volumes/Test/screenpipewill be created*3sqlite3-zsh• ₴5[+00m00s] • Counting source rows for 2026-04-15frames:elements:ui_events:ocr_text:meetings:1287488687614453114120[+00m01s] • Initialising tables, indexes, FTS[2026-04-1717:59:50]Sync complete for 2026-04-15[2026-04-17 17:59:50]ukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3~/.screenpipe/db.sqlite "SELECT date(MIN(timestamp)) FROM frames;"2026-04-09lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ~/.screenpipe/screenpipe_sync.sh 2026-04-14OK: NAS mountedOK: Source DB exists3.6G/Users/lukas/.screenpipe/db.sqliteINFO: archive.db does not exist yet - will be created on first sync[2026-04-17 18:09:41]=====[2026-04-17 18:09:41]Screenpipe sync starting for: 2026-04-14[2026-04-17 18:09:41][+00m00s] • Preflight checksSource DB:NAS mount:Archive DB:OKOK(3.6G)/Volumes/Test/screenpipewill be created[+00m00s] • Counting source rows for 2026-04-14frames:elements:ui_events:ocr_text:meetings:107336959691054282060[+00m00s] • Initialising tables, indexes, FTScreating tablescreating indexescreating FTS tables• Om02s• 0m03s• 0m01s[+00m06s] • Syncing data for 2026-04-14video_chunksframes (10733 rows)• Om01s...
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp‹$0Inh17100% <47sqlite3DOCKER- 881NAS mount:Archive DB:DEV (docker)OKAPP (-zsh)|/Volumes/Test/screenpipewill be created*3sqlite3-zsh• ₴5[+00m00s] • Counting source rows for 2026-04-15frames:elements:ui_events:ocr_text:meetings:1287488687614453114120[+00m01s] • Initialising tables, indexes, FTS[2026-04-1717:59:50]Sync complete for 2026-04-15[2026-04-17 17:59:50]ukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3~/.screenpipe/db.sqlite "SELECT date(MIN(timestamp)) FROM frames;"2026-04-09lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ~/.screenpipe/screenpipe_sync.sh 2026-04-14OK: NAS mountedOK: Source DB exists3.6G/Users/lukas/.screenpipe/db.sqliteINFO: archive.db does not exist yet - will be created on first sync[2026-04-17 18:09:41]=====[2026-04-17 18:09:41]Screenpipe sync starting for: 2026-04-14[2026-04-17 18:09:41][+00m00s] • Preflight checksSource DB:NAS mount:Archive DB:OKOK(3.6G)/Volumes/Test/screenpipewill be created[+00m00s] • Counting source rows for 2026-04-14frames:elements:ui_events:ocr_text:meetings:107336959691054282060[+00m00s] • Initialising tables, indexes, FTScreating tablescreating indexescreating FTS tables• Om02s• 0m03s• 0m01s[+00m06s] • Syncing data for 2026-04-14video_chunksframes (10733 rows)• Om01s* Review screenp...• ₴6ec2-user@ip-10-...• ₴78Fri 17 Apr 18:15:071₴81ec2-user@ip-10-...O ₴8...
|
NULL
|
NULL
|
NULL
|