|
27856
|
Last login: Tue May 12 20:12:05 on ttys007
Poetry Last login: Tue May 12 20:12:05 on ttys007
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/jiminny/app (JY-20725-handle-HS-search-rate-limit) $ alias
addssh='ssh-add ~/.ssh/*'
app='cd ~/jiminny/app'
cnt='docker exec -ti $(docker ps | grep worker | awk '\''{print $1}'\'') /bin/bash -c "cd /home/jiminny && bash"'
co='git checkout'
cov='./vendor/bin/phpunit tests/Unit --coverage-html=build/coverage'
csfix='make cs-fix'
dev='docker exec -ti $(docker ps -q --filter "name=docker_lamp_1") /bin/bash'
eu='ssh lukas@jiminny-eu-bastion -D [IP_ADDRESS]:7073 -L 7532:db:3306'
eues='ssh ubuntu@jiminny-eu-ecs1 -L 7960:vpc-activities7-e7pfbl7wojjjnvp7olfpudrgke.eu-west-1.es.amazonaws.com:80'
ext='nvm use 20 && cd ~/jiminny/extension-app && yarn build:dev && yarn preview'
fe='yarn && nvm use 24 && cd ~/jiminny/app/front-end && yarn build:watch'
fe3='cd ~/jiminny/app/front-end-vue3 && yarn build:watch:production'
gbr='git branch --sort=-committerdate'
gcb='git branch --show-current | pbcopy'
gs='git status'
hhh=history
hhs='history 0 | grep '
install_nano='apt-get update & apt-get install nano'
kar='cp -f ~/DEV/settings/goku-karabiner-settings/karabiner.edn ~/.config/karabiner.edn && goku'
ll='ls -la --color=tty'
lock='kill %1 2>/dev/null; sleep 1 && pmset displaysleepnow'
nas='ssh Adm1n@[IP_ADDRESS] -p22'
poetryshell='eval ""'
prod='ssh lukas@jiminny-prod-bastion -D [IP_ADDRESS]:7072 -L 7632:db:3306'
prodes='ssh ubuntu@jiminny-prod-ecs1 -L 7970:vpc-activities7-3o2zlrelmga5qicf2yxxwtx6bi.us-east-2.es.amazonaws.com:80'
prophet='cd ~/jiminny/app'
prophetdown='aws-vault exec staging -- bash -c "env | grep AWS_ > aws-creds.env && docker compose -f docker-compose.yml -f docker-compose.dev.yml down"'
prophetup='aws-vault exec staging -- bash -c "env | grep AWS_ > aws-creds.env && docker compose -f docker-compose.yml -f docker-compose.dev.yml up --build"'
qa='ssh lukas@jiminny-qa-bastion -D [IP_ADDRESS]:7074 -L 7432:db:3306'
qaes='ssh ubuntu@jiminny-qa-ecs1 -L 7950:vpc-activities7-s5zchrs4xqcnav3rjzmxgxvfvq.us-east-2.es.amazonaws.com:80'
qai='ssh lukas@jiminny-qai-bastion -D [IP_ADDRESS]:7075 -L 7777:jiminny-db-qai.c3uemcm84st0.us-east-2.rds.amazonaws.com:3306'
rmbc='rm -rf bootstrap/cache/*.php'
run-help=man
sp-db='sqlite3 ~/.screenpipe/db.sqlite '
sp-start='npx screenpipe@latest record --disable-audio --ignored-windows "Boosteroid"'
sp-status='curl -s [URL_WITH_CREDENTIALS] -D [IP_ADDRESS]:7071 -L 7732:db:3306'
stges='ssh ubuntu@jiminny-stage-ecs1 -L 7980:vpc-activities7-tgeodjeaugnaiigqgdcjjkrrj4.us-east-2.es.amazonaws.com:80'
veu='ssh jiminny-eu-ecs1'
veu10='ssh jiminny-eu-ecs10'
veu11='ssh jiminny-eu-ecs11'
veu12='ssh jiminny-eu-ecs12'
veu2='ssh jiminny-eu-ecs2'
veu3='ssh jiminny-eu-ecs3'
veu4='ssh jiminny-eu-ecs4'
veu5='ssh jiminny-eu-ecs5'
veu6='ssh jiminny-eu-ecs6'
veu7='ssh jiminny-eu-ecs7'
veu8='ssh jiminny-eu-ecs8'
veu9='ssh jiminny-eu-ecs9'
vprod='ssh jiminny-prod-ecs1'
vprod10='ssh jiminny-prod-ecs10'
vprod11='ssh jiminny-prod-ecs11'
vprod12='ssh jiminny-prod-ecs12'
vprod2='ssh jiminny-prod-ecs2'
vprod3='ssh jiminny-prod-ecs3'
vprod4='ssh jiminny-prod-ecs4'
vprod5='ssh jiminny-prod-ecs5'
vprod6='ssh jiminny-prod-ecs6'
vprod7='ssh jiminny-prod-ecs7'
vprod8='ssh jiminny-prod-ecs8'
vprod9='ssh jiminny-prod-ecs9'
vqa='ssh jiminny-qa-ecs1'
vqa2='ssh jiminny-qa-ecs2'
vqai='ssh jiminny-qai-ecs1'
vqai2='ssh jiminny-qai-ecs2'
vstage='ssh ec2-user@jiminny-subenv-worker-app0'
vstg='ssh jiminny-stage-ecs1'
vstg2='ssh ubuntu@jiminny-stage-ecs2'
which-command=whence
work='cd ~/jiminny/infrastructure/dev/docker && docker compose up'
workoff='kill %1'
workon='caffeinate -d & echo "Display sleep disabled (PID $!)"'
xd='make docker-xdebug-disable'
xe='make docker-xdebug-enable'
zp='nano ~/.zprofile'
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/jiminny/app (JY-20725-handle-HS-search-rate-limit) $ alias sp-start
sp-start='npx screenpipe@latest record --disable-audio --ignored-windows "Boosteroid"'
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/jiminny/app (JY-20725-handle-HS-search-rate-limit) $ npx screenpipe@latest record
detected hardware tier: Mid
warning: parakeet is not supported on this platform, using whisper-tiny instead
2026-05-12T20:21:45.398887Z INFO screenpipe_engine::auth_key: api auth: key resolved via secret store
checking permissions...
screen recording: ok
microphone: ok
accessibility: ok
2026-05-12T20:21:45.478552Z INFO screenpipe_screen::monitor::macos_version: Detected macOS version: 14.6
2026-05-12T20:21:45.961197Z INFO screenpipe_engine::sleep_monitor: Starting macOS sleep/wake monitor
2026-05-12T20:21:45.962702Z INFO screenpipe_engine::sleep_monitor: Screen lock/unlock observers registered (CFNotificationCenter)
2026-05-12T20:21:45.963075Z INFO screenpipe_engine::sleep_monitor: Display reconfiguration watcher registered (CGDisplayRegisterReconfigurationCallback)
2026-05-12T20:21:45.981408Z INFO screenpipe_engine::permission_monitor: permission monitor started screen=true mic=true accessibility=true keychain=true
2026-05-12T20:21:45.981466Z INFO screenpipe: meeting detector enabled — independent of transcription mode
2026-05-12T20:21:46.341545Z INFO screenpipe_engine::power::manager: power manager started (poll interval: 10s)
2026-05-12T20:21:46.341573Z INFO screenpipe_engine::snapshot_compaction: snapshot compaction worker started (min_age=600s, poll=300s)
2026-05-12T20:21:46.341617Z INFO screenpipe: API server listening on [IP_ADDRESS]:3030 (localhost only)
2026-05-12T20:21:46.341707Z INFO screenpipe: API auth enabled — run `screenpipe auth token` to view your key
2026-05-12T20:21:46.341709Z INFO screenpipe_engine::vision_manager::manager: Starting VisionManager
2026-05-12T20:21:46.344654Z INFO screenpipe_core::pipes: loaded pipe: day-recap
2026-05-12T20:21:46.344960Z INFO screenpipe_core::pipes: loaded pipe: standup-update
2026-05-12T20:21:46.345493Z INFO screenpipe_core::pipes: loaded pipe: ai-habits
2026-05-12T20:21:46.345597Z INFO screenpipe_core::pipes: loaded pipe: time-breakdown
2026-05-12T20:21:46.345692Z INFO screenpipe_core::pipes: loaded pipe: video-export
2026-05-12T20:21:46.345776Z INFO screenpipe_core::pipes: loaded pipe: meeting-summary
2026-05-12T20:21:46.345793Z INFO screenpipe_core::pipes: loaded 6 pipes from "/Users/lukas/.screenpipe/pipes"
_
__________________ ___ ____ ____ (_____ ___
/ ___/ ___/ ___/ _ \/ _ \/ __ \ / __ \/ / __ \/ _ \
(__ / /__/ / / __/ __/ / / / / /_/ / / /_/ / __/
/____/\___/_/ \___/\___/_/ /_/ / .___/_/ .___/\___/
/_/ /_/
power AI by everything you've seen, said or heard
open source | runs locally | developer friendly
┌────────────────────────┬────────────────────────────────────┐
│ setting │ value │
2026-05-12T20:21:46.346765Z INFO screenpipe_core::pipes: pipe scheduler started (generation 2)
├────────────────────────┼────────────────────────────────────┤
│ audio chunk duration │ 30 seconds │
│ port │ 3030 │
│ audio disabled │ false │
│ vision disabled │ false │
│ pause on DRM content │ false │
│ audio engine │ Parakeet │
│ vad engine │ Silero │
│ data directory │ /Users/lukas/.screenpipe │
│ debug mode │ false │
│ telemetry │ true │
│ use pii removal │ true │
│ use all monitors │ true │
│ ignored windows │ [] │
│ included windows │ [] │
│ cloud sync │ disabled │
│ auto-destruct pid │ 0 │
│ deepgram key │ not set │
│ api auth │ enabled │
│ encrypt secrets │ disabled │
│ retention days │ 14 │
│ retention mode │ media-only (keep transcripts) │
├────────────────────────┼────────────────────────────────────┤
│ languages │ │
│ │ all languages │
├────────────────────────┼────────────────────────────────────┤
│ monitors │ │
│ │ id: 1 │
│ │ id: 2 │
├────────────────────────┼────────────────────────────────────┤
│ audio devices │ │
│ │ MacBook Pro Microphone (input) │
│ │ System Audio (output) │
└────────────────────────┴────────────────────────────────────┘
you are using local processing. all your data stays on your computer.
warning: telemetry is enabled. only error-level data will be sent.
to disable, use the --disable-telemetry flag.
check latest changes here: https://github.com/screenpipe/screenpipe/releases
2026-05-12T20:21:46.347267Z INFO screenpipe: starting UI event capture
2026-05-12T20:21:46.350328Z WARN screenpipe: pi agent install failed: bun not found — install from https://bun.sh
2026-05-12T20:21:46.352991Z INFO screenpipe_engine::power::manager: initial power profile: Performance (on_ac=true, battery=Some(100))
2026-05-12T20:21:46.361986Z INFO screenpipe_engine::ui_recorder: Starting UI event capture
2026-05-12T20:21:46.376957Z INFO screenpipe_engine::ui_recorder: UI recording session started: 69f81847-1591-4a57-bb71-9577ac093c20
2026-05-12T20:21:46.376956Z INFO screenpipe_engine::hot_frame_cache: hot_frame_cache: warming from DB (2026-05-11 17:21:46.376953 UTC to 2026-05-12 17:21:46.376953 UTC)
2026-05-12T20:21:46.376981Z INFO screenpipe_engine::calendar_speaker_id: speaker identification: started (user_name=<not set>)
2026-05-12T20:21:46.377744Z INFO screenpipe_engine::meeting_detector: meeting v2: closed 1 orphaned meeting(s)
2026-05-12T20:21:46.377759Z INFO screenpipe_engine::meeting_detector: meeting v2: detection loop started (base_interval=5s, profiles=12)
2026-05-12T20:21:46.384999Z INFO screenpipe_engine::server: Server listening on [IP_ADDRESS]:3030
2026-05-12T20:21:46.392589Z INFO screenpipe_connect::mdns: mdns: advertising screenpipe on port 3030
2026-05-12T20:21:46.446973Z INFO screenpipe_engine::vision_manager::manager: Starting vision recording for monitor 1 (1440x900)
2026-05-12T20:21:46.447002Z INFO screenpipe_engine::vision_manager::manager: Starting event-driven capture for monitor 1 (device: monitor_1)
2026-05-12T20:21:46.447027Z INFO screenpipe_engine::event_driven_capture: event-driven capture started for monitor 1 (device: monitor_1)
2026-05-12T20:21:46.480758Z INFO screenpipe_engine::vision_manager::manager: Starting vision recording for monitor 2 (3008x1253)
2026-05-12T20:21:46.480798Z INFO screenpipe_engine::vision_manager::manager: Starting event-driven capture for monitor 2 (device: monitor_2)
2026-05-12T20:21:46.480808Z INFO screenpipe_engine::vision_manager::manager: VisionManager started with 2/2 monitor(s)
2026-05-12T20:21:46.480817Z INFO screenpipe_engine::vision_manager::monitor_watcher: Starting monitor watcher (event-driven via CGDisplayRegisterReconfigurationCallback, 60s backstop poll)
2026-05-12T20:21:46.480829Z INFO screenpipe_engine::event_driven_capture: event-driven capture started for monitor 2 (device: monitor_2)
2026-05-12T20:21:47.042226Z INFO sck_rs::stream_manager: persistent SCK stream started for display 1 (1440x900, 2fps, 0 excluded)
2026-05-12T20:21:47.113121Z INFO sck_rs::stream_manager: persistent SCK stream started for display 2 (3008x1253, 2fps, 0 excluded)
2026-05-12T20:21:48.957407Z WARN sqlx::query: summary="SELECT f.id, f.timestamp, f.offset_index, …" db.statement="\n\nSELECT\n f.id,\n f.timestamp,\n f.offset_index,\n COALESCE(\n SUBSTR(f.full_text, 1, 200),\n SUBSTR(f.accessibility_text, 1, 200),\n (\n SELECT\n SUBSTR(ot.text, 1, 200)\n FROM\n ocr_text ot\n WHERE\n ot.frame_id = f.id\n LIMIT\n 1\n )\n ) as text,\n COALESCE(\n f.app_name,\n (\n SELECT\n ot.app_name\n FROM\n ocr_text ot\n WHERE\n ot.frame_id = f.id\n LIMIT\n 1\n )\n ) as app_name,\n COALESCE(\n f.window_name,\n (\n SELECT\n ot.window_name\n FROM\n ocr_text ot\n WHERE\n ot.frame_id = f.id\n LIMIT\n 1\n )\n ) as window_name,\n COALESCE(vc.device_name, f.device_name) as screen_device,\n COALESCE(vc.file_path, f.snapshot_path) as video_path,\n COALESCE(vc.fps, 0.033) as chunk_fps,\n f.browser_url,\n f.machine_id\nFROM\n frames f\n LEFT JOIN video_chunks vc ON f.video_chunk_id = vc.id\nWHERE\n f.timestamp >= ?1\n AND f.timestamp <= ?2\n AND COALESCE(vc.file_path, f.snapshot_path, '') NOT LIKE 'cloud://%'\nORDER BY\n f.timestamp DESC,\n f.offset_index DESC\nLIMIT\n 10000\n" rows_affected=0 rows_returned=6658 elapsed=2.5797255s
2026-05-12T20:21:48.975091Z INFO screenpipe_engine::hot_frame_cache: hot_frame_cache: warmed with 6658 frame entries, coverage from 2026-05-11 17:21:46.376953 UTC
2026-05-12T20:21:49.028419Z WARN sqlx::query: summary="PRAGMA wal_checkpoint(TRUNCATE)" db.statement="" rows_affected=0 rows_returned=1 elapsed=2.650124208s
2026-05-12T20:21:49.075495Z WARN sqlx::query: summary="BEGIN IMMEDIATE" db.statement="" rows_affected=1 rows_returned=0 elapsed=1.93116725s
2026-05-12T20:21:49.083715Z INFO screenpipe_engine::event_driven_capture: startup capture for monitor 1: frame_id=27853, dur=1987ms
2026-05-12T20:21:49.096129Z INFO screenpipe_engine::event_driven_capture: startup capture for monitor 2: frame_id=27854, dur=1926ms
2026-05-12T20:21:56.351661Z INFO screenpipe_audio::transcription::engine: whisper model available: "/Users/lukas/.cache/huggingface/hub/models--ggerganov--whisper.cpp/snapshots/5359861c739e955e79d9a303bcbc70fb988958b1/ggml-tiny.bin"
2026-05-12T20:21:56.351809Z INFO screenpipe_audio::transcription::whisper::model: whisper context: gpu acceleration enabled (Metal on macOS, Vulkan on Windows)
2026-05-12T20:21:56.351831Z INFO screenpipe_audio::transcription::engine: loading whisper model with GPU acceleration...
whisper_init_from_file_with_params_no_state: loading model from '/Users/lukas/.cache/huggingface/hub/models--ggerganov--whisper.cpp/snapshots/5359861c739e955e79d9a303bcbc70fb988958b1/ggml-tiny.bin'
whisper_init_with_params_no_state: use gpu = 1
whisper_init_with_params_no_state: flash attn = 0
whisper_init_with_params_no_state: gpu_device = 0
whisper_init_with_params_no_state: dtw = 0
ggml_metal_device_init: tensor API disabled for pre-M5 and pre-A19 devices
ggml_metal_library_init: using embedded metal library
ggml_metal_library_init: loaded in 0.048 sec
ggml_metal_rsets_init: creating a residency set collection (keep_alive = 180 s)
ggml_metal_device_init: GPU name: Apple M1
ggml_metal_device_init: GPU family: MTLGPUFamilyApple7 (1007)
ggml_metal_device_init: GPU family: MTLGPUFamilyCommon3 (3003)
ggml_metal_device_init: GPU family: MTLGPUFamilyMetal3 (5001)
ggml_metal_device_init: simdgroup reduction = true
ggml_metal_device_init: simdgroup matrix mul. = true
ggml_metal_device_init: has unified memory = true
ggml_metal_device_init: has bfloat = true
ggml_metal_device_init: has tensor = false
ggml_metal_device_init: use residency sets = true
ggml_metal_device_init: use shared buffers = true
ggml_metal_device_init: recommendedMaxWorkingSetSize = 11453.25 MB
whisper_init_with_params_no_state: devices = 3
whisper_init_with_params_no_state: backends = 3
whisper_model_load: loading model
whisper_model_load: n_vocab = 51865
whisper_model_load: n_audio_ctx = 1500
whisper_model_load: n_audio_state = 384
whisper_model_load: n_audio_head = 6
whisper_model_load: n_audio_layer = 4
whisper_model_load: n_text_ctx = 448
whisper_model_load: n_text_state = 384
whisper_model_load: n_text_head = 6
whisper_model_load: n_text_layer = 4
whisper_model_load: n_mels = 80
whisper_model_load: ftype = 1
whisper_model_load: qntvr = 0
whisper_model_load: type = 1 (tiny)
whisper_model_load: adding 1608 extra tokens
whisper_model_load: n_langs = 99
whisper_model_load: Metal total size = 77.11 MB
whisper_model_load: model size = 77.11 MB
2026-05-12T20:21:56.494683Z INFO screenpipe_audio::transcription::engine: whisper model loaded successfully
whisper_backend_init_gpu: device 0: Metal (type: 1)
whisper_backend_init_gpu: found GPU device 0: Metal (type: 1, cnt: 0)
whisper_backend_init_gpu: using Metal backend
ggml_metal_init: allocating
ggml_metal_init: found device: Apple M1
ggml_metal_init: picking default device: Apple M1
ggml_metal_init: use fusion = true
ggml_metal_init: use concurrency = true
ggml_metal_init: use graph optimize = true
whisper_backend_init: using BLAS backend
whisper_init_state: kv self size = 3.15 MB
whisper_init_state: kv cross size = 9.44 MB
whisper_init_state: kv pad size = 2.36 MB
whisper_init_state: compute buffer (conv) = 14.17 MB
whisper_init_state: compute buffer (encode) = 65.96 MB
whisper_init_state: compute buffer (cross) = 8.50 MB
whisper_init_state: compute buffer (decode) = 96.83 MB
2026-05-12T20:21:56.498994Z INFO screenpipe_audio::audio_manager::manager: transcription session created (will be reused across segments)
2026-05-12T20:21:56.504078Z INFO screenpipe_audio::audio_manager::manager: seeded 15 speakers (named + unnamed) from DB into embedding manager
2026-05-12T20:21:56.504173Z INFO screenpipe_audio::audio_manager::manager: audio manager started
2026-05-12T20:21:56.504204Z INFO screenpipe_audio::audio_manager::manager: calendar-assisted speaker diarization: listening for meeting events
2026-05-12T20:21:56.672290Z INFO screenpipe_audio::device::device_manager: starting recording for device: MacBook Pro Microphone (input)
2026-05-12T20:21:56.711133Z INFO screenpipe_audio::device::device_manager: starting recording for device: System Audio (output)
2026-05-12T20:21:56.711199Z INFO screenpipe_audio::core::run_record_and_transcribe: starting continuous recording for System Audio (output) (unknown / 30s segments)
2026-05-12T20:21:56.711205Z INFO screenpipe_audio::core::run_record_and_transcribe: starting continuous recording for MacBook Pro Microphone (input) (wired / 30s segments)
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (screenpipe")
Close Tab
-zsh
Close Tab
⌥⌘1
APP (screenpipe")...
|
iTerm2
|
APP (screenpipe")
|
NULL
|
27856
|
|
27857
|
Last login: Tue May 12 20:12:05 on ttys007
Poetry Last login: Tue May 12 20:12:05 on ttys007
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/jiminny/app (JY-20725-handle-HS-search-rate-limit) $ open ~/.screenpipe
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/jiminny/app (JY-20725-handle-HS-search-rate-limit) $ cd ~/.screenpipe
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ll
total 8720288
drwxr-xr-x 21 lukas staff 672 12 May 09:21 .
drwx------+ 96 lukas staff 3072 12 May 20:12 ..
-rw-r--r--@ 1 lukas staff 6148 12 May 20:14 .DS_Store
-rw-r--r--@ 1 lukas staff 37 11 May 20:54 .sync_install_id
-rw-r--r-- 1 lukas staff 0 10 May 14:43 clipboard-disabled-after-crash
drwxr-xr-x 3660 lukas staff 117120 12 May 17:41 data
-rw-r--r--@ 1 lukas staff 4457357312 12 May 17:41 db.sqlite
-rw-r--r-- 1 lukas staff 65536 12 May 09:26 db.sqlite-shm
-rw-r--r-- 1 lukas staff 5001712 12 May 17:41 db.sqlite-wal
drwxr-xr-x 9 lukas staff 288 10 May 11:39 pipes
-rw-r--r-- 1 lukas staff 28408 6 May 21:02 screenpipe.2026-05-06.0.log
-rw-r--r-- 1 lukas staff 566164 7 May 21:50 screenpipe.2026-05-07.0.log
-rw-r--r-- 1 lukas staff 382102 8 May 22:20 screenpipe.2026-05-08.0.log
-rw-r--r-- 1 lukas staff 167023 9 May 23:04 screenpipe.2026-05-09.0.log
-rw-r--r-- 1 lukas staff 88266 10 May 23:51 screenpipe.2026-05-10.0.log
-rw-r--r-- 1 lukas staff 528943 11 May 22:54 screenpipe.2026-05-11.0.log
-rw-r--r-- 1 lukas staff 245484 12 May 17:39 screenpipe.2026-05-12.0.log
-rwxr-xr-x@ 1 lukas staff 32005 11 May 20:54 screenpipe_sync.sh
-rwxr-xr-x@ 1 lukas staff 14994 6 May 20:26 screenpipe_sync.sh.bak
-rwxr-xr-x@ 1 lukas staff 21485 10 May 13:34 screenpipe_sync.sh.bak2
-rw-r--r--@ 1 lukas staff 8541 11 May 20:54 sync.log
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ cat screenpipe_sync.sh | pbcopy
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ~/.screenpipe/screenpipe_sync.sh 2026-05-11
[2026-05-12 20:19:37] ========================================
[2026-05-12 20:19:37] Screenpipe sync starting for: 2026-05-11
[2026-05-12 20:19:37] install_id: 2ff6574c-4272-4dbf-a20b-434b024c65fb
[2026-05-12 20:19:37] ========================================
[+00m00s] ▶ Preflight checks
Source DB: OK (4.2G)
NAS mount: OK /Volumes/screenpipe
Archive DB: will be created
Frame data dir: OK (283 files, 318M)
Audio files: OK (2507 files, 267M)
[+00m00s] ▶ Counting source rows for 2026-05-11
frames: 6857
elements: 672129
ui_events: 7063
ocr_text: 2332
meetings: 1
audio_chunks: 2507
audio_transcriptions: 226
audio_tags: 0
speakers: 15 (all-time)
speaker_embeddings: 58 (all-time)
[+00m01s] ▶ Initialising tables (CREATE IF NOT EXISTS)
creating vision tables ✓ 0m00s
creating audio tables ✓ 0m01s
Error: in prepare, no such column: id
S idx_ocr_text_install_pk ON ocr_text(install_id, id);
error here ---^
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (screenpipe")
Close Tab
-zsh
Close Tab
⌥⌘1
-zsh...
|
iTerm2
|
-zsh
|
NULL
|
27857
|
|
27858
|
Last login: Tue May 12 20:12:05 on ttys007
Poetry Last login: Tue May 12 20:12:05 on ttys007
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/jiminny/app (JY-20725-handle-HS-search-rate-limit) $ open ~/.screenpipe
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/jiminny/app (JY-20725-handle-HS-search-rate-limit) $ cd ~/.screenpipe
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ll
total 8720288
drwxr-xr-x 21 lukas staff 672 12 May 09:21 .
drwx------+ 96 lukas staff 3072 12 May 20:12 ..
-rw-r--r--@ 1 lukas staff 6148 12 May 20:14 .DS_Store
-rw-r--r--@ 1 lukas staff 37 11 May 20:54 .sync_install_id
-rw-r--r-- 1 lukas staff 0 10 May 14:43 clipboard-disabled-after-crash
drwxr-xr-x 3660 lukas staff 117120 12 May 17:41 data
-rw-r--r--@ 1 lukas staff 4457357312 12 May 17:41 db.sqlite
-rw-r--r-- 1 lukas staff 65536 12 May 09:26 db.sqlite-shm
-rw-r--r-- 1 lukas staff 5001712 12 May 17:41 db.sqlite-wal
drwxr-xr-x 9 lukas staff 288 10 May 11:39 pipes
-rw-r--r-- 1 lukas staff 28408 6 May 21:02 screenpipe.2026-05-06.0.log
-rw-r--r-- 1 lukas staff 566164 7 May 21:50 screenpipe.2026-05-07.0.log
-rw-r--r-- 1 lukas staff 382102 8 May 22:20 screenpipe.2026-05-08.0.log
-rw-r--r-- 1 lukas staff 167023 9 May 23:04 screenpipe.2026-05-09.0.log
-rw-r--r-- 1 lukas staff 88266 10 May 23:51 screenpipe.2026-05-10.0.log
-rw-r--r-- 1 lukas staff 528943 11 May 22:54 screenpipe.2026-05-11.0.log
-rw-r--r-- 1 lukas staff 245484 12 May 17:39 screenpipe.2026-05-12.0.log
-rwxr-xr-x@ 1 lukas staff 32005 11 May 20:54 screenpipe_sync.sh
-rwxr-xr-x@ 1 lukas staff 14994 6 May 20:26 screenpipe_sync.sh.bak
-rwxr-xr-x@ 1 lukas staff 21485 10 May 13:34 screenpipe_sync.sh.bak2
-rw-r--r--@ 1 lukas staff 8541 11 May 20:54 sync.log
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ cat screenpipe_sync.sh | pbcopy
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ~/.screenpipe/screenpipe_sync.sh 2026-05-11
[2026-05-12 20:19:37] ========================================
[2026-05-12 20:19:37] Screenpipe sync starting for: 2026-05-11
[2026-05-12 20:19:37] install_id: 2ff6574c-4272-4dbf-a20b-434b024c65fb
[2026-05-12 20:19:37] ========================================
[+00m00s] ▶ Preflight checks
Source DB: OK (4.2G)
NAS mount: OK /Volumes/screenpipe
Archive DB: will be created
Frame data dir: OK (283 files, 318M)
Audio files: OK (2507 files, 267M)
[+00m00s] ▶ Counting source rows for 2026-05-11
frames: 6857
elements: 672129
ui_events: 7063
ocr_text: 2332
meetings: 1
audio_chunks: 2507
audio_transcriptions: 226
audio_tags: 0
speakers: 15 (all-time)
speaker_embeddings: 58 (all-time)
[+00m01s] ▶ Initialising tables (CREATE IF NOT EXISTS)
creating vision tables ✓ 0m00s
creating audio tables ✓ 0m01s
Error: in prepare, no such column: id
S idx_ocr_text_install_pk ON ocr_text(install_id, id);
error here ---^
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (screenpipe")
Close Tab
-zsh
Close Tab
⌥⌘1
-zsh...
|
iTerm2
|
-zsh
|
NULL
|
27858
|
|
27860
|
Last login: Tue May 12 20:12:05 on ttys007
Poetry Last login: Tue May 12 20:12:05 on ttys007
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/jiminny/app (JY-20725-handle-HS-search-rate-limit) $ open ~/.screenpipe
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/jiminny/app (JY-20725-handle-HS-search-rate-limit) $ cd ~/.screenpipe
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ll
total 8720288
drwxr-xr-x 21 lukas staff 672 12 May 09:21 .
drwx------+ 96 lukas staff 3072 12 May 20:12 ..
-rw-r--r--@ 1 lukas staff 6148 12 May 20:14 .DS_Store
-rw-r--r--@ 1 lukas staff 37 11 May 20:54 .sync_install_id
-rw-r--r-- 1 lukas staff 0 10 May 14:43 clipboard-disabled-after-crash
drwxr-xr-x 3660 lukas staff 117120 12 May 17:41 data
-rw-r--r--@ 1 lukas staff 4457357312 12 May 17:41 db.sqlite
-rw-r--r-- 1 lukas staff 65536 12 May 09:26 db.sqlite-shm
-rw-r--r-- 1 lukas staff 5001712 12 May 17:41 db.sqlite-wal
drwxr-xr-x 9 lukas staff 288 10 May 11:39 pipes
-rw-r--r-- 1 lukas staff 28408 6 May 21:02 screenpipe.2026-05-06.0.log
-rw-r--r-- 1 lukas staff 566164 7 May 21:50 screenpipe.2026-05-07.0.log
-rw-r--r-- 1 lukas staff 382102 8 May 22:20 screenpipe.2026-05-08.0.log
-rw-r--r-- 1 lukas staff 167023 9 May 23:04 screenpipe.2026-05-09.0.log
-rw-r--r-- 1 lukas staff 88266 10 May 23:51 screenpipe.2026-05-10.0.log
-rw-r--r-- 1 lukas staff 528943 11 May 22:54 screenpipe.2026-05-11.0.log
-rw-r--r-- 1 lukas staff 245484 12 May 17:39 screenpipe.2026-05-12.0.log
-rwxr-xr-x@ 1 lukas staff 32005 11 May 20:54 screenpipe_sync.sh
-rwxr-xr-x@ 1 lukas staff 14994 6 May 20:26 screenpipe_sync.sh.bak
-rwxr-xr-x@ 1 lukas staff 21485 10 May 13:34 screenpipe_sync.sh.bak2
-rw-r--r--@ 1 lukas staff 8541 11 May 20:54 sync.log
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ cat screenpipe_sync.sh | pbcopy
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ~/.screenpipe/screenpipe_sync.sh 2026-05-11
[2026-05-12 20:19:37] ========================================
[2026-05-12 20:19:37] Screenpipe sync starting for: 2026-05-11
[2026-05-12 20:19:37] install_id: 2ff6574c-4272-4dbf-a20b-434b024c65fb
[2026-05-12 20:19:37] ========================================
[+00m00s] ▶ Preflight checks
Source DB: OK (4.2G)
NAS mount: OK /Volumes/screenpipe
Archive DB: will be created
Frame data dir: OK (283 files, 318M)
Audio files: OK (2507 files, 267M)
[+00m00s] ▶ Counting source rows for 2026-05-11
frames: 6857
elements: 672129
ui_events: 7063
ocr_text: 2332
meetings: 1
audio_chunks: 2507
audio_transcriptions: 226
audio_tags: 0
speakers: 15 (all-time)
speaker_embeddings: 58 (all-time)
[+00m01s] ▶ Initialising tables (CREATE IF NOT EXISTS)
creating vision tables ✓ 0m00s
creating audio tables ✓ 0m01s
Error: in prepare, no such column: id
S idx_ocr_text_install_pk ON ocr_text(install_id, id);
error here ---^
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "PRAGMA table_info(ocr_text);"
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (screenpipe")
Close Tab
-zsh
Close Tab
⌥⌘1
-zsh...
|
iTerm2
|
-zsh
|
NULL
|
27860
|
|
27861
|
Last login: Tue May 12 20:12:05 on ttys007
Poetry Last login: Tue May 12 20:12:05 on ttys007
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/jiminny/app (JY-20725-handle-HS-search-rate-limit) $ open ~/.screenpipe
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/jiminny/app (JY-20725-handle-HS-search-rate-limit) $ cd ~/.screenpipe
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ll
total 8720288
drwxr-xr-x 21 lukas staff 672 12 May 09:21 .
drwx------+ 96 lukas staff 3072 12 May 20:12 ..
-rw-r--r--@ 1 lukas staff 6148 12 May 20:14 .DS_Store
-rw-r--r--@ 1 lukas staff 37 11 May 20:54 .sync_install_id
-rw-r--r-- 1 lukas staff 0 10 May 14:43 clipboard-disabled-after-crash
drwxr-xr-x 3660 lukas staff 117120 12 May 17:41 data
-rw-r--r--@ 1 lukas staff 4457357312 12 May 17:41 db.sqlite
-rw-r--r-- 1 lukas staff 65536 12 May 09:26 db.sqlite-shm
-rw-r--r-- 1 lukas staff 5001712 12 May 17:41 db.sqlite-wal
drwxr-xr-x 9 lukas staff 288 10 May 11:39 pipes
-rw-r--r-- 1 lukas staff 28408 6 May 21:02 screenpipe.2026-05-06.0.log
-rw-r--r-- 1 lukas staff 566164 7 May 21:50 screenpipe.2026-05-07.0.log
-rw-r--r-- 1 lukas staff 382102 8 May 22:20 screenpipe.2026-05-08.0.log
-rw-r--r-- 1 lukas staff 167023 9 May 23:04 screenpipe.2026-05-09.0.log
-rw-r--r-- 1 lukas staff 88266 10 May 23:51 screenpipe.2026-05-10.0.log
-rw-r--r-- 1 lukas staff 528943 11 May 22:54 screenpipe.2026-05-11.0.log
-rw-r--r-- 1 lukas staff 245484 12 May 17:39 screenpipe.2026-05-12.0.log
-rwxr-xr-x@ 1 lukas staff 32005 11 May 20:54 screenpipe_sync.sh
-rwxr-xr-x@ 1 lukas staff 14994 6 May 20:26 screenpipe_sync.sh.bak
-rwxr-xr-x@ 1 lukas staff 21485 10 May 13:34 screenpipe_sync.sh.bak2
-rw-r--r--@ 1 lukas staff 8541 11 May 20:54 sync.log
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ cat screenpipe_sync.sh | pbcopy
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ~/.screenpipe/screenpipe_sync.sh 2026-05-11
[2026-05-12 20:19:37] ========================================
[2026-05-12 20:19:37] Screenpipe sync starting for: 2026-05-11
[2026-05-12 20:19:37] install_id: 2ff6574c-4272-4dbf-a20b-434b024c65fb
[2026-05-12 20:19:37] ========================================
[+00m00s] ▶ Preflight checks
Source DB: OK (4.2G)
NAS mount: OK /Volumes/screenpipe
Archive DB: will be created
Frame data dir: OK (283 files, 318M)
Audio files: OK (2507 files, 267M)
[+00m00s] ▶ Counting source rows for 2026-05-11
frames: 6857
elements: 672129
ui_events: 7063
ocr_text: 2332
meetings: 1
audio_chunks: 2507
audio_transcriptions: 226
audio_tags: 0
speakers: 15 (all-time)
speaker_embeddings: 58 (all-time)
[+00m01s] ▶ Initialising tables (CREATE IF NOT EXISTS)
creating vision tables ✓ 0m00s
creating audio tables ✓ 0m01s
Error: in prepare, no such column: id
S idx_ocr_text_install_pk ON ocr_text(install_id, id);
error here ---^
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "PRAGMA table_info(ocr_text);"
0|frame_id|INTEGER|1||0
1|text|TEXT|1||0
2|text_json|TEXT|0||0
3|app_name|TEXT|1|''|0
4|ocr_engine|TEXT|1|'unknown'|0
5|window_name|TEXT|0||0
6|focused|BOOLEAN|0|FALSE|0
7|text_length|INTEGER|0||0
8|sync_id|TEXT|0||0
9|synced_at|DATETIME|0||0
10|redacted_at|INTEGER|0||0
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (screenpipe")
Close Tab
-zsh
Close Tab
⌥⌘1
-zsh...
|
iTerm2
|
-zsh
|
NULL
|
27861
|
|
27862
|
Last login: Tue May 12 20:12:05 on ttys007
Poetry Last login: Tue May 12 20:12:05 on ttys007
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/jiminny/app (JY-20725-handle-HS-search-rate-limit) $ open ~/.screenpipe
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/jiminny/app (JY-20725-handle-HS-search-rate-limit) $ cd ~/.screenpipe
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ll
total 8720288
drwxr-xr-x 21 lukas staff 672 12 May 09:21 .
drwx------+ 96 lukas staff 3072 12 May 20:12 ..
-rw-r--r--@ 1 lukas staff 6148 12 May 20:14 .DS_Store
-rw-r--r--@ 1 lukas staff 37 11 May 20:54 .sync_install_id
-rw-r--r-- 1 lukas staff 0 10 May 14:43 clipboard-disabled-after-crash
drwxr-xr-x 3660 lukas staff 117120 12 May 17:41 data
-rw-r--r--@ 1 lukas staff 4457357312 12 May 17:41 db.sqlite
-rw-r--r-- 1 lukas staff 65536 12 May 09:26 db.sqlite-shm
-rw-r--r-- 1 lukas staff 5001712 12 May 17:41 db.sqlite-wal
drwxr-xr-x 9 lukas staff 288 10 May 11:39 pipes
-rw-r--r-- 1 lukas staff 28408 6 May 21:02 screenpipe.2026-05-06.0.log
-rw-r--r-- 1 lukas staff 566164 7 May 21:50 screenpipe.2026-05-07.0.log
-rw-r--r-- 1 lukas staff 382102 8 May 22:20 screenpipe.2026-05-08.0.log
-rw-r--r-- 1 lukas staff 167023 9 May 23:04 screenpipe.2026-05-09.0.log
-rw-r--r-- 1 lukas staff 88266 10 May 23:51 screenpipe.2026-05-10.0.log
-rw-r--r-- 1 lukas staff 528943 11 May 22:54 screenpipe.2026-05-11.0.log
-rw-r--r-- 1 lukas staff 245484 12 May 17:39 screenpipe.2026-05-12.0.log
-rwxr-xr-x@ 1 lukas staff 32005 11 May 20:54 screenpipe_sync.sh
-rwxr-xr-x@ 1 lukas staff 14994 6 May 20:26 screenpipe_sync.sh.bak
-rwxr-xr-x@ 1 lukas staff 21485 10 May 13:34 screenpipe_sync.sh.bak2
-rw-r--r--@ 1 lukas staff 8541 11 May 20:54 sync.log
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ cat screenpipe_sync.sh | pbcopy
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ~/.screenpipe/screenpipe_sync.sh 2026-05-11
[2026-05-12 20:19:37] ========================================
[2026-05-12 20:19:37] Screenpipe sync starting for: 2026-05-11
[2026-05-12 20:19:37] install_id: 2ff6574c-4272-4dbf-a20b-434b024c65fb
[2026-05-12 20:19:37] ========================================
[+00m00s] ▶ Preflight checks
Source DB: OK (4.2G)
NAS mount: OK /Volumes/screenpipe
Archive DB: will be created
Frame data dir: OK (283 files, 318M)
Audio files: OK (2507 files, 267M)
[+00m00s] ▶ Counting source rows for 2026-05-11
frames: 6857
elements: 672129
ui_events: 7063
ocr_text: 2332
meetings: 1
audio_chunks: 2507
audio_transcriptions: 226
audio_tags: 0
speakers: 15 (all-time)
speaker_embeddings: 58 (all-time)
[+00m01s] ▶ Initialising tables (CREATE IF NOT EXISTS)
creating vision tables ✓ 0m00s
creating audio tables ✓ 0m01s
Error: in prepare, no such column: id
S idx_ocr_text_install_pk ON ocr_text(install_id, id);
error here ---^
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "PRAGMA table_info(ocr_text);"
0|frame_id|INTEGER|1||0
1|text|TEXT|1||0
2|text_json|TEXT|0||0
3|app_name|TEXT|1|''|0
4|ocr_engine|TEXT|1|'unknown'|0
5|window_name|TEXT|0||0
6|focused|BOOLEAN|0|FALSE|0
7|text_length|INTEGER|0||0
8|sync_id|TEXT|0||0
9|synced_at|DATETIME|0||0
10|redacted_at|INTEGER|0||0
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (screenpipe")
Close Tab
-zsh
Close Tab
⌥⌘1
-zsh...
|
iTerm2
|
-zsh
|
NULL
|
27862
|
|
27863
|
Last login: Tue May 12 20:12:05 on ttys007
Poetry Last login: Tue May 12 20:12:05 on ttys007
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/jiminny/app (JY-20725-handle-HS-search-rate-limit) $ open ~/.screenpipe
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/jiminny/app (JY-20725-handle-HS-search-rate-limit) $ cd ~/.screenpipe
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ll
total 8720288
drwxr-xr-x 21 lukas staff 672 12 May 09:21 .
drwx------+ 96 lukas staff 3072 12 May 20:12 ..
-rw-r--r--@ 1 lukas staff 6148 12 May 20:14 .DS_Store
-rw-r--r--@ 1 lukas staff 37 11 May 20:54 .sync_install_id
-rw-r--r-- 1 lukas staff 0 10 May 14:43 clipboard-disabled-after-crash
drwxr-xr-x 3660 lukas staff 117120 12 May 17:41 data
-rw-r--r--@ 1 lukas staff 4457357312 12 May 17:41 db.sqlite
-rw-r--r-- 1 lukas staff 65536 12 May 09:26 db.sqlite-shm
-rw-r--r-- 1 lukas staff 5001712 12 May 17:41 db.sqlite-wal
drwxr-xr-x 9 lukas staff 288 10 May 11:39 pipes
-rw-r--r-- 1 lukas staff 28408 6 May 21:02 screenpipe.2026-05-06.0.log
-rw-r--r-- 1 lukas staff 566164 7 May 21:50 screenpipe.2026-05-07.0.log
-rw-r--r-- 1 lukas staff 382102 8 May 22:20 screenpipe.2026-05-08.0.log
-rw-r--r-- 1 lukas staff 167023 9 May 23:04 screenpipe.2026-05-09.0.log
-rw-r--r-- 1 lukas staff 88266 10 May 23:51 screenpipe.2026-05-10.0.log
-rw-r--r-- 1 lukas staff 528943 11 May 22:54 screenpipe.2026-05-11.0.log
-rw-r--r-- 1 lukas staff 245484 12 May 17:39 screenpipe.2026-05-12.0.log
-rwxr-xr-x@ 1 lukas staff 32005 11 May 20:54 screenpipe_sync.sh
-rwxr-xr-x@ 1 lukas staff 14994 6 May 20:26 screenpipe_sync.sh.bak
-rwxr-xr-x@ 1 lukas staff 21485 10 May 13:34 screenpipe_sync.sh.bak2
-rw-r--r--@ 1 lukas staff 8541 11 May 20:54 sync.log
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ cat screenpipe_sync.sh | pbcopy
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ~/.screenpipe/screenpipe_sync.sh 2026-05-11
[2026-05-12 20:19:37] ========================================
[2026-05-12 20:19:37] Screenpipe sync starting for: 2026-05-11
[2026-05-12 20:19:37] install_id: 2ff6574c-4272-4dbf-a20b-434b024c65fb
[2026-05-12 20:19:37] ========================================
[+00m00s] ▶ Preflight checks
Source DB: OK (4.2G)
NAS mount: OK /Volumes/screenpipe
Archive DB: will be created
Frame data dir: OK (283 files, 318M)
Audio files: OK (2507 files, 267M)
[+00m00s] ▶ Counting source rows for 2026-05-11
frames: 6857
elements: 672129
ui_events: 7063
ocr_text: 2332
meetings: 1
audio_chunks: 2507
audio_transcriptions: 226
audio_tags: 0
speakers: 15 (all-time)
speaker_embeddings: 58 (all-time)
[+00m01s] ▶ Initialising tables (CREATE IF NOT EXISTS)
creating vision tables ✓ 0m00s
creating audio tables ✓ 0m01s
Error: in prepare, no such column: id
S idx_ocr_text_install_pk ON ocr_text(install_id, id);
error here ---^
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "PRAGMA table_info(ocr_text);"
0|frame_id|INTEGER|1||0
1|text|TEXT|1||0
2|text_json|TEXT|0||0
3|app_name|TEXT|1|''|0
4|ocr_engine|TEXT|1|'unknown'|0
5|window_name|TEXT|0||0
6|focused|BOOLEAN|0|FALSE|0
7|text_length|INTEGER|0||0
8|sync_id|TEXT|0||0
9|synced_at|DATETIME|0||0
10|redacted_at|INTEGER|0||0
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (screenpipe")
Close Tab
-zsh
Close Tab
⌥⌘1
-zsh...
|
iTerm2
|
-zsh
|
NULL
|
27863
|
|
27864
|
Last login: Tue May 12 20:12:05 on ttys007
Poetry Last login: Tue May 12 20:12:05 on ttys007
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/jiminny/app (JY-20725-handle-HS-search-rate-limit) $ open ~/.screenpipe
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/jiminny/app (JY-20725-handle-HS-search-rate-limit) $ cd ~/.screenpipe
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ll
total 8720288
drwxr-xr-x 21 lukas staff 672 12 May 09:21 .
drwx------+ 96 lukas staff 3072 12 May 20:12 ..
-rw-r--r--@ 1 lukas staff 6148 12 May 20:14 .DS_Store
-rw-r--r--@ 1 lukas staff 37 11 May 20:54 .sync_install_id
-rw-r--r-- 1 lukas staff 0 10 May 14:43 clipboard-disabled-after-crash
drwxr-xr-x 3660 lukas staff 117120 12 May 17:41 data
-rw-r--r--@ 1 lukas staff 4457357312 12 May 17:41 db.sqlite
-rw-r--r-- 1 lukas staff 65536 12 May 09:26 db.sqlite-shm
-rw-r--r-- 1 lukas staff 5001712 12 May 17:41 db.sqlite-wal
drwxr-xr-x 9 lukas staff 288 10 May 11:39 pipes
-rw-r--r-- 1 lukas staff 28408 6 May 21:02 screenpipe.2026-05-06.0.log
-rw-r--r-- 1 lukas staff 566164 7 May 21:50 screenpipe.2026-05-07.0.log
-rw-r--r-- 1 lukas staff 382102 8 May 22:20 screenpipe.2026-05-08.0.log
-rw-r--r-- 1 lukas staff 167023 9 May 23:04 screenpipe.2026-05-09.0.log
-rw-r--r-- 1 lukas staff 88266 10 May 23:51 screenpipe.2026-05-10.0.log
-rw-r--r-- 1 lukas staff 528943 11 May 22:54 screenpipe.2026-05-11.0.log
-rw-r--r-- 1 lukas staff 245484 12 May 17:39 screenpipe.2026-05-12.0.log
-rwxr-xr-x@ 1 lukas staff 32005 11 May 20:54 screenpipe_sync.sh
-rwxr-xr-x@ 1 lukas staff 14994 6 May 20:26 screenpipe_sync.sh.bak
-rwxr-xr-x@ 1 lukas staff 21485 10 May 13:34 screenpipe_sync.sh.bak2
-rw-r--r--@ 1 lukas staff 8541 11 May 20:54 sync.log
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ cat screenpipe_sync.sh | pbcopy
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ~/.screenpipe/screenpipe_sync.sh 2026-05-11
[2026-05-12 20:19:37] ========================================
[2026-05-12 20:19:37] Screenpipe sync starting for: 2026-05-11
[2026-05-12 20:19:37] install_id: 2ff6574c-4272-4dbf-a20b-434b024c65fb
[2026-05-12 20:19:37] ========================================
[+00m00s] ▶ Preflight checks
Source DB: OK (4.2G)
NAS mount: OK /Volumes/screenpipe
Archive DB: will be created
Frame data dir: OK (283 files, 318M)
Audio files: OK (2507 files, 267M)
[+00m00s] ▶ Counting source rows for 2026-05-11
frames: 6857
elements: 672129
ui_events: 7063
ocr_text: 2332
meetings: 1
audio_chunks: 2507
audio_transcriptions: 226
audio_tags: 0
speakers: 15 (all-time)
speaker_embeddings: 58 (all-time)
[+00m01s] ▶ Initialising tables (CREATE IF NOT EXISTS)
creating vision tables ✓ 0m00s
creating audio tables ✓ 0m01s
Error: in prepare, no such column: id
S idx_ocr_text_install_pk ON ocr_text(install_id, id);
error here ---^
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "PRAGMA table_info(ocr_text);"
0|frame_id|INTEGER|1||0
1|text|TEXT|1||0
2|text_json|TEXT|0||0
3|app_name|TEXT|1|''|0
4|ocr_engine|TEXT|1|'unknown'|0
5|window_name|TEXT|0||0
6|focused|BOOLEAN|0|FALSE|0
7|text_length|INTEGER|0||0
8|sync_id|TEXT|0||0
9|synced_at|DATETIME|0||0
10|redacted_at|INTEGER|0||0
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (screenpipe")
Close Tab
-zsh
Close Tab
⌥⌘1
-zsh...
|
iTerm2
|
-zsh
|
NULL
|
27864
|
|
27865
|
Last login: Tue May 12 20:12:05 on ttys007
Poetry Last login: Tue May 12 20:12:05 on ttys007
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/jiminny/app (JY-20725-handle-HS-search-rate-limit) $ open ~/.screenpipe
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/jiminny/app (JY-20725-handle-HS-search-rate-limit) $ cd ~/.screenpipe
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ll
total 8720288
drwxr-xr-x 21 lukas staff 672 12 May 09:21 .
drwx------+ 96 lukas staff 3072 12 May 20:12 ..
-rw-r--r--@ 1 lukas staff 6148 12 May 20:14 .DS_Store
-rw-r--r--@ 1 lukas staff 37 11 May 20:54 .sync_install_id
-rw-r--r-- 1 lukas staff 0 10 May 14:43 clipboard-disabled-after-crash
drwxr-xr-x 3660 lukas staff 117120 12 May 17:41 data
-rw-r--r--@ 1 lukas staff 4457357312 12 May 17:41 db.sqlite
-rw-r--r-- 1 lukas staff 65536 12 May 09:26 db.sqlite-shm
-rw-r--r-- 1 lukas staff 5001712 12 May 17:41 db.sqlite-wal
drwxr-xr-x 9 lukas staff 288 10 May 11:39 pipes
-rw-r--r-- 1 lukas staff 28408 6 May 21:02 screenpipe.2026-05-06.0.log
-rw-r--r-- 1 lukas staff 566164 7 May 21:50 screenpipe.2026-05-07.0.log
-rw-r--r-- 1 lukas staff 382102 8 May 22:20 screenpipe.2026-05-08.0.log
-rw-r--r-- 1 lukas staff 167023 9 May 23:04 screenpipe.2026-05-09.0.log
-rw-r--r-- 1 lukas staff 88266 10 May 23:51 screenpipe.2026-05-10.0.log
-rw-r--r-- 1 lukas staff 528943 11 May 22:54 screenpipe.2026-05-11.0.log
-rw-r--r-- 1 lukas staff 245484 12 May 17:39 screenpipe.2026-05-12.0.log
-rwxr-xr-x@ 1 lukas staff 32005 11 May 20:54 screenpipe_sync.sh
-rwxr-xr-x@ 1 lukas staff 14994 6 May 20:26 screenpipe_sync.sh.bak
-rwxr-xr-x@ 1 lukas staff 21485 10 May 13:34 screenpipe_sync.sh.bak2
-rw-r--r--@ 1 lukas staff 8541 11 May 20:54 sync.log
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ cat screenpipe_sync.sh | pbcopy
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ~/.screenpipe/screenpipe_sync.sh 2026-05-11
[2026-05-12 20:19:37] ========================================
[2026-05-12 20:19:37] Screenpipe sync starting for: 2026-05-11
[2026-05-12 20:19:37] install_id: 2ff6574c-4272-4dbf-a20b-434b024c65fb
[2026-05-12 20:19:37] ========================================
[+00m00s] ▶ Preflight checks
Source DB: OK (4.2G)
NAS mount: OK /Volumes/screenpipe
Archive DB: will be created
Frame data dir: OK (283 files, 318M)
Audio files: OK (2507 files, 267M)
[+00m00s] ▶ Counting source rows for 2026-05-11
frames: 6857
elements: 672129
ui_events: 7063
ocr_text: 2332
meetings: 1
audio_chunks: 2507
audio_transcriptions: 226
audio_tags: 0
speakers: 15 (all-time)
speaker_embeddings: 58 (all-time)
[+00m01s] ▶ Initialising tables (CREATE IF NOT EXISTS)
creating vision tables ✓ 0m00s
creating audio tables ✓ 0m01s
Error: in prepare, no such column: id
S idx_ocr_text_install_pk ON ocr_text(install_id, id);
error here ---^
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "PRAGMA table_info(ocr_text);"
0|frame_id|INTEGER|1||0
1|text|TEXT|1||0
2|text_json|TEXT|0||0
3|app_name|TEXT|1|''|0
4|ocr_engine|TEXT|1|'unknown'|0
5|window_name|TEXT|0||0
6|focused|BOOLEAN|0|FALSE|0
7|text_length|INTEGER|0||0
8|sync_id|TEXT|0||0
9|synced_at|DATETIME|0||0
10|redacted_at|INTEGER|0||0
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (screenpipe")
Close Tab
-zsh
Close Tab
⌥⌘1
-zsh...
|
iTerm2
|
-zsh
|
NULL
|
27865
|
|
27866
|
Last login: Tue May 12 20:12:05 on ttys007
Poetry Last login: Tue May 12 20:12:05 on ttys007
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/jiminny/app (JY-20725-handle-HS-search-rate-limit) $ open ~/.screenpipe
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/jiminny/app (JY-20725-handle-HS-search-rate-limit) $ cd ~/.screenpipe
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ll
total 8720288
drwxr-xr-x 21 lukas staff 672 12 May 09:21 .
drwx------+ 96 lukas staff 3072 12 May 20:12 ..
-rw-r--r--@ 1 lukas staff 6148 12 May 20:14 .DS_Store
-rw-r--r--@ 1 lukas staff 37 11 May 20:54 .sync_install_id
-rw-r--r-- 1 lukas staff 0 10 May 14:43 clipboard-disabled-after-crash
drwxr-xr-x 3660 lukas staff 117120 12 May 17:41 data
-rw-r--r--@ 1 lukas staff 4457357312 12 May 17:41 db.sqlite
-rw-r--r-- 1 lukas staff 65536 12 May 09:26 db.sqlite-shm
-rw-r--r-- 1 lukas staff 5001712 12 May 17:41 db.sqlite-wal
drwxr-xr-x 9 lukas staff 288 10 May 11:39 pipes
-rw-r--r-- 1 lukas staff 28408 6 May 21:02 screenpipe.2026-05-06.0.log
-rw-r--r-- 1 lukas staff 566164 7 May 21:50 screenpipe.2026-05-07.0.log
-rw-r--r-- 1 lukas staff 382102 8 May 22:20 screenpipe.2026-05-08.0.log
-rw-r--r-- 1 lukas staff 167023 9 May 23:04 screenpipe.2026-05-09.0.log
-rw-r--r-- 1 lukas staff 88266 10 May 23:51 screenpipe.2026-05-10.0.log
-rw-r--r-- 1 lukas staff 528943 11 May 22:54 screenpipe.2026-05-11.0.log
-rw-r--r-- 1 lukas staff 245484 12 May 17:39 screenpipe.2026-05-12.0.log
-rwxr-xr-x@ 1 lukas staff 32005 11 May 20:54 screenpipe_sync.sh
-rwxr-xr-x@ 1 lukas staff 14994 6 May 20:26 screenpipe_sync.sh.bak
-rwxr-xr-x@ 1 lukas staff 21485 10 May 13:34 screenpipe_sync.sh.bak2
-rw-r--r--@ 1 lukas staff 8541 11 May 20:54 sync.log
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ cat screenpipe_sync.sh | pbcopy
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ~/.screenpipe/screenpipe_sync.sh 2026-05-11
[2026-05-12 20:19:37] ========================================
[2026-05-12 20:19:37] Screenpipe sync starting for: 2026-05-11
[2026-05-12 20:19:37] install_id: 2ff6574c-4272-4dbf-a20b-434b024c65fb
[2026-05-12 20:19:37] ========================================
[+00m00s] ▶ Preflight checks
Source DB: OK (4.2G)
NAS mount: OK /Volumes/screenpipe
Archive DB: will be created
Frame data dir: OK (283 files, 318M)
Audio files: OK (2507 files, 267M)
[+00m00s] ▶ Counting source rows for 2026-05-11
frames: 6857
elements: 672129
ui_events: 7063
ocr_text: 2332
meetings: 1
audio_chunks: 2507
audio_transcriptions: 226
audio_tags: 0
speakers: 15 (all-time)
speaker_embeddings: 58 (all-time)
[+00m01s] ▶ Initialising tables (CREATE IF NOT EXISTS)
creating vision tables ✓ 0m00s
creating audio tables ✓ 0m01s
Error: in prepare, no such column: id
S idx_ocr_text_install_pk ON ocr_text(install_id, id);
error here ---^
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "PRAGMA table_info(ocr_text);"
0|frame_id|INTEGER|1||0
1|text|TEXT|1||0
2|text_json|TEXT|0||0
3|app_name|TEXT|1|''|0
4|ocr_engine|TEXT|1|'unknown'|0
5|window_name|TEXT|0||0
6|focused|BOOLEAN|0|FALSE|0
7|text_length|INTEGER|0||0
8|sync_id|TEXT|0||0
9|synced_at|DATETIME|0||0
10|redacted_at|INTEGER|0||0
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (screenpipe")
Close Tab
-zsh
Close Tab
⌥⌘1
-zsh...
|
iTerm2
|
-zsh
|
NULL
|
27866
|
|
27867
|
Last login: Tue May 12 20:12:05 on ttys007
Poetry Last login: Tue May 12 20:12:05 on ttys007
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/jiminny/app (JY-20725-handle-HS-search-rate-limit) $ open ~/.screenpipe
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/jiminny/app (JY-20725-handle-HS-search-rate-limit) $ cd ~/.screenpipe
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ll
total 8720288
drwxr-xr-x 21 lukas staff 672 12 May 09:21 .
drwx------+ 96 lukas staff 3072 12 May 20:12 ..
-rw-r--r--@ 1 lukas staff 6148 12 May 20:14 .DS_Store
-rw-r--r--@ 1 lukas staff 37 11 May 20:54 .sync_install_id
-rw-r--r-- 1 lukas staff 0 10 May 14:43 clipboard-disabled-after-crash
drwxr-xr-x 3660 lukas staff 117120 12 May 17:41 data
-rw-r--r--@ 1 lukas staff 4457357312 12 May 17:41 db.sqlite
-rw-r--r-- 1 lukas staff 65536 12 May 09:26 db.sqlite-shm
-rw-r--r-- 1 lukas staff 5001712 12 May 17:41 db.sqlite-wal
drwxr-xr-x 9 lukas staff 288 10 May 11:39 pipes
-rw-r--r-- 1 lukas staff 28408 6 May 21:02 screenpipe.2026-05-06.0.log
-rw-r--r-- 1 lukas staff 566164 7 May 21:50 screenpipe.2026-05-07.0.log
-rw-r--r-- 1 lukas staff 382102 8 May 22:20 screenpipe.2026-05-08.0.log
-rw-r--r-- 1 lukas staff 167023 9 May 23:04 screenpipe.2026-05-09.0.log
-rw-r--r-- 1 lukas staff 88266 10 May 23:51 screenpipe.2026-05-10.0.log
-rw-r--r-- 1 lukas staff 528943 11 May 22:54 screenpipe.2026-05-11.0.log
-rw-r--r-- 1 lukas staff 245484 12 May 17:39 screenpipe.2026-05-12.0.log
-rwxr-xr-x@ 1 lukas staff 32005 11 May 20:54 screenpipe_sync.sh
-rwxr-xr-x@ 1 lukas staff 14994 6 May 20:26 screenpipe_sync.sh.bak
-rwxr-xr-x@ 1 lukas staff 21485 10 May 13:34 screenpipe_sync.sh.bak2
-rw-r--r--@ 1 lukas staff 8541 11 May 20:54 sync.log
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ cat screenpipe_sync.sh | pbcopy
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ~/.screenpipe/screenpipe_sync.sh 2026-05-11
[2026-05-12 20:19:37] ========================================
[2026-05-12 20:19:37] Screenpipe sync starting for: 2026-05-11
[2026-05-12 20:19:37] install_id: 2ff6574c-4272-4dbf-a20b-434b024c65fb
[2026-05-12 20:19:37] ========================================
[+00m00s] ▶ Preflight checks
Source DB: OK (4.2G)
NAS mount: OK /Volumes/screenpipe
Archive DB: will be created
Frame data dir: OK (283 files, 318M)
Audio files: OK (2507 files, 267M)
[+00m00s] ▶ Counting source rows for 2026-05-11
frames: 6857
elements: 672129
ui_events: 7063
ocr_text: 2332
meetings: 1
audio_chunks: 2507
audio_transcriptions: 226
audio_tags: 0
speakers: 15 (all-time)
speaker_embeddings: 58 (all-time)
[+00m01s] ▶ Initialising tables (CREATE IF NOT EXISTS)
creating vision tables ✓ 0m00s
creating audio tables ✓ 0m01s
Error: in prepare, no such column: id
S idx_ocr_text_install_pk ON ocr_text(install_id, id);
error here ---^
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "PRAGMA table_info(ocr_text);"
0|frame_id|INTEGER|1||0
1|text|TEXT|1||0
2|text_json|TEXT|0||0
3|app_name|TEXT|1|''|0
4|ocr_engine|TEXT|1|'unknown'|0
5|window_name|TEXT|0||0
6|focused|BOOLEAN|0|FALSE|0
7|text_length|INTEGER|0||0
8|sync_id|TEXT|0||0
9|synced_at|DATETIME|0||0
10|redacted_at|INTEGER|0||0
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (screenpipe")
Close Tab
-zsh
Close Tab
⌥⌘1
-zsh...
|
iTerm2
|
-zsh
|
NULL
|
27867
|
|
27868
|
Last login: Tue May 12 20:12:05 on ttys007
Poetry Last login: Tue May 12 20:12:05 on ttys007
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/jiminny/app (JY-20725-handle-HS-search-rate-limit) $ open ~/.screenpipe
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/jiminny/app (JY-20725-handle-HS-search-rate-limit) $ cd ~/.screenpipe
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ll
total 8720288
drwxr-xr-x 21 lukas staff 672 12 May 09:21 .
drwx------+ 96 lukas staff 3072 12 May 20:12 ..
-rw-r--r--@ 1 lukas staff 6148 12 May 20:14 .DS_Store
-rw-r--r--@ 1 lukas staff 37 11 May 20:54 .sync_install_id
-rw-r--r-- 1 lukas staff 0 10 May 14:43 clipboard-disabled-after-crash
drwxr-xr-x 3660 lukas staff 117120 12 May 17:41 data
-rw-r--r--@ 1 lukas staff 4457357312 12 May 17:41 db.sqlite
-rw-r--r-- 1 lukas staff 65536 12 May 09:26 db.sqlite-shm
-rw-r--r-- 1 lukas staff 5001712 12 May 17:41 db.sqlite-wal
drwxr-xr-x 9 lukas staff 288 10 May 11:39 pipes
-rw-r--r-- 1 lukas staff 28408 6 May 21:02 screenpipe.2026-05-06.0.log
-rw-r--r-- 1 lukas staff 566164 7 May 21:50 screenpipe.2026-05-07.0.log
-rw-r--r-- 1 lukas staff 382102 8 May 22:20 screenpipe.2026-05-08.0.log
-rw-r--r-- 1 lukas staff 167023 9 May 23:04 screenpipe.2026-05-09.0.log
-rw-r--r-- 1 lukas staff 88266 10 May 23:51 screenpipe.2026-05-10.0.log
-rw-r--r-- 1 lukas staff 528943 11 May 22:54 screenpipe.2026-05-11.0.log
-rw-r--r-- 1 lukas staff 245484 12 May 17:39 screenpipe.2026-05-12.0.log
-rwxr-xr-x@ 1 lukas staff 32005 11 May 20:54 screenpipe_sync.sh
-rwxr-xr-x@ 1 lukas staff 14994 6 May 20:26 screenpipe_sync.sh.bak
-rwxr-xr-x@ 1 lukas staff 21485 10 May 13:34 screenpipe_sync.sh.bak2
-rw-r--r--@ 1 lukas staff 8541 11 May 20:54 sync.log
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ cat screenpipe_sync.sh | pbcopy
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ~/.screenpipe/screenpipe_sync.sh 2026-05-11
[2026-05-12 20:19:37] ========================================
[2026-05-12 20:19:37] Screenpipe sync starting for: 2026-05-11
[2026-05-12 20:19:37] install_id: 2ff6574c-4272-4dbf-a20b-434b024c65fb
[2026-05-12 20:19:37] ========================================
[+00m00s] ▶ Preflight checks
Source DB: OK (4.2G)
NAS mount: OK /Volumes/screenpipe
Archive DB: will be created
Frame data dir: OK (283 files, 318M)
Audio files: OK (2507 files, 267M)
[+00m00s] ▶ Counting source rows for 2026-05-11
frames: 6857
elements: 672129
ui_events: 7063
ocr_text: 2332
meetings: 1
audio_chunks: 2507
audio_transcriptions: 226
audio_tags: 0
speakers: 15 (all-time)
speaker_embeddings: 58 (all-time)
[+00m01s] ▶ Initialising tables (CREATE IF NOT EXISTS)
creating vision tables ✓ 0m00s
creating audio tables ✓ 0m01s
Error: in prepare, no such column: id
S idx_ocr_text_install_pk ON ocr_text(install_id, id);
error here ---^
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "PRAGMA table_info(ocr_text);"
0|frame_id|INTEGER|1||0
1|text|TEXT|1||0
2|text_json|TEXT|0||0
3|app_name|TEXT|1|''|0
4|ocr_engine|TEXT|1|'unknown'|0
5|window_name|TEXT|0||0
6|focused|BOOLEAN|0|FALSE|0
7|text_length|INTEGER|0||0
8|sync_id|TEXT|0||0
9|synced_at|DATETIME|0||0
10|redacted_at|INTEGER|0||0
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (screenpipe")
Close Tab
-zsh
Close Tab
⌥⌘1
-zsh...
|
iTerm2
|
-zsh
|
NULL
|
27868
|
|
27869
|
Last login: Tue May 12 20:12:05 on ttys007
Poetry Last login: Tue May 12 20:12:05 on ttys007
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/jiminny/app (JY-20725-handle-HS-search-rate-limit) $ open ~/.screenpipe
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/jiminny/app (JY-20725-handle-HS-search-rate-limit) $ cd ~/.screenpipe
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ll
total 8720288
drwxr-xr-x 21 lukas staff 672 12 May 09:21 .
drwx------+ 96 lukas staff 3072 12 May 20:12 ..
-rw-r--r--@ 1 lukas staff 6148 12 May 20:14 .DS_Store
-rw-r--r--@ 1 lukas staff 37 11 May 20:54 .sync_install_id
-rw-r--r-- 1 lukas staff 0 10 May 14:43 clipboard-disabled-after-crash
drwxr-xr-x 3660 lukas staff 117120 12 May 17:41 data
-rw-r--r--@ 1 lukas staff 4457357312 12 May 17:41 db.sqlite
-rw-r--r-- 1 lukas staff 65536 12 May 09:26 db.sqlite-shm
-rw-r--r-- 1 lukas staff 5001712 12 May 17:41 db.sqlite-wal
drwxr-xr-x 9 lukas staff 288 10 May 11:39 pipes
-rw-r--r-- 1 lukas staff 28408 6 May 21:02 screenpipe.2026-05-06.0.log
-rw-r--r-- 1 lukas staff 566164 7 May 21:50 screenpipe.2026-05-07.0.log
-rw-r--r-- 1 lukas staff 382102 8 May 22:20 screenpipe.2026-05-08.0.log
-rw-r--r-- 1 lukas staff 167023 9 May 23:04 screenpipe.2026-05-09.0.log
-rw-r--r-- 1 lukas staff 88266 10 May 23:51 screenpipe.2026-05-10.0.log
-rw-r--r-- 1 lukas staff 528943 11 May 22:54 screenpipe.2026-05-11.0.log
-rw-r--r-- 1 lukas staff 245484 12 May 17:39 screenpipe.2026-05-12.0.log
-rwxr-xr-x@ 1 lukas staff 32005 11 May 20:54 screenpipe_sync.sh
-rwxr-xr-x@ 1 lukas staff 14994 6 May 20:26 screenpipe_sync.sh.bak
-rwxr-xr-x@ 1 lukas staff 21485 10 May 13:34 screenpipe_sync.sh.bak2
-rw-r--r--@ 1 lukas staff 8541 11 May 20:54 sync.log
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ cat screenpipe_sync.sh | pbcopy
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ~/.screenpipe/screenpipe_sync.sh 2026-05-11
[2026-05-12 20:19:37] ========================================
[2026-05-12 20:19:37] Screenpipe sync starting for: 2026-05-11
[2026-05-12 20:19:37] install_id: 2ff6574c-4272-4dbf-a20b-434b024c65fb
[2026-05-12 20:19:37] ========================================
[+00m00s] ▶ Preflight checks
Source DB: OK (4.2G)
NAS mount: OK /Volumes/screenpipe
Archive DB: will be created
Frame data dir: OK (283 files, 318M)
Audio files: OK (2507 files, 267M)
[+00m00s] ▶ Counting source rows for 2026-05-11
frames: 6857
elements: 672129
ui_events: 7063
ocr_text: 2332
meetings: 1
audio_chunks: 2507
audio_transcriptions: 226
audio_tags: 0
speakers: 15 (all-time)
speaker_embeddings: 58 (all-time)
[+00m01s] ▶ Initialising tables (CREATE IF NOT EXISTS)
creating vision tables ✓ 0m00s
creating audio tables ✓ 0m01s
Error: in prepare, no such column: id
S idx_ocr_text_install_pk ON ocr_text(install_id, id);
error here ---^
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "PRAGMA table_info(ocr_text);"
0|frame_id|INTEGER|1||0
1|text|TEXT|1||0
2|text_json|TEXT|0||0
3|app_name|TEXT|1|''|0
4|ocr_engine|TEXT|1|'unknown'|0
5|window_name|TEXT|0||0
6|focused|BOOLEAN|0|FALSE|0
7|text_length|INTEGER|0||0
8|sync_id|TEXT|0||0
9|synced_at|DATETIME|0||0
10|redacted_at|INTEGER|0||0
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (screenpipe")
Close Tab
-zsh
Close Tab
⌥⌘1
-zsh...
|
iTerm2
|
-zsh
|
NULL
|
27869
|
|
27870
|
Last login: Tue May 12 20:12:05 on ttys007
Poetry Last login: Tue May 12 20:12:05 on ttys007
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/jiminny/app (JY-20725-handle-HS-search-rate-limit) $ open ~/.screenpipe
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/jiminny/app (JY-20725-handle-HS-search-rate-limit) $ cd ~/.screenpipe
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ll
total 8720288
drwxr-xr-x 21 lukas staff 672 12 May 09:21 .
drwx------+ 96 lukas staff 3072 12 May 20:12 ..
-rw-r--r--@ 1 lukas staff 6148 12 May 20:14 .DS_Store
-rw-r--r--@ 1 lukas staff 37 11 May 20:54 .sync_install_id
-rw-r--r-- 1 lukas staff 0 10 May 14:43 clipboard-disabled-after-crash
drwxr-xr-x 3660 lukas staff 117120 12 May 17:41 data
-rw-r--r--@ 1 lukas staff 4457357312 12 May 17:41 db.sqlite
-rw-r--r-- 1 lukas staff 65536 12 May 09:26 db.sqlite-shm
-rw-r--r-- 1 lukas staff 5001712 12 May 17:41 db.sqlite-wal
drwxr-xr-x 9 lukas staff 288 10 May 11:39 pipes
-rw-r--r-- 1 lukas staff 28408 6 May 21:02 screenpipe.2026-05-06.0.log
-rw-r--r-- 1 lukas staff 566164 7 May 21:50 screenpipe.2026-05-07.0.log
-rw-r--r-- 1 lukas staff 382102 8 May 22:20 screenpipe.2026-05-08.0.log
-rw-r--r-- 1 lukas staff 167023 9 May 23:04 screenpipe.2026-05-09.0.log
-rw-r--r-- 1 lukas staff 88266 10 May 23:51 screenpipe.2026-05-10.0.log
-rw-r--r-- 1 lukas staff 528943 11 May 22:54 screenpipe.2026-05-11.0.log
-rw-r--r-- 1 lukas staff 245484 12 May 17:39 screenpipe.2026-05-12.0.log
-rwxr-xr-x@ 1 lukas staff 32005 11 May 20:54 screenpipe_sync.sh
-rwxr-xr-x@ 1 lukas staff 14994 6 May 20:26 screenpipe_sync.sh.bak
-rwxr-xr-x@ 1 lukas staff 21485 10 May 13:34 screenpipe_sync.sh.bak2
-rw-r--r--@ 1 lukas staff 8541 11 May 20:54 sync.log
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ cat screenpipe_sync.sh | pbcopy
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ~/.screenpipe/screenpipe_sync.sh 2026-05-11
[2026-05-12 20:19:37] ========================================
[2026-05-12 20:19:37] Screenpipe sync starting for: 2026-05-11
[2026-05-12 20:19:37] install_id: 2ff6574c-4272-4dbf-a20b-434b024c65fb
[2026-05-12 20:19:37] ========================================
[+00m00s] ▶ Preflight checks
Source DB: OK (4.2G)
NAS mount: OK /Volumes/screenpipe
Archive DB: will be created
Frame data dir: OK (283 files, 318M)
Audio files: OK (2507 files, 267M)
[+00m00s] ▶ Counting source rows for 2026-05-11
frames: 6857
elements: 672129
ui_events: 7063
ocr_text: 2332
meetings: 1
audio_chunks: 2507
audio_transcriptions: 226
audio_tags: 0
speakers: 15 (all-time)
speaker_embeddings: 58 (all-time)
[+00m01s] ▶ Initialising tables (CREATE IF NOT EXISTS)
creating vision tables ✓ 0m00s
creating audio tables ✓ 0m01s
Error: in prepare, no such column: id
S idx_ocr_text_install_pk ON ocr_text(install_id, id);
error here ---^
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "PRAGMA table_info(ocr_text);"
0|frame_id|INTEGER|1||0
1|text|TEXT|1||0
2|text_json|TEXT|0||0
3|app_name|TEXT|1|''|0
4|ocr_engine|TEXT|1|'unknown'|0
5|window_name|TEXT|0||0
6|focused|BOOLEAN|0|FALSE|0
7|text_length|INTEGER|0||0
8|sync_id|TEXT|0||0
9|synced_at|DATETIME|0||0
10|redacted_at|INTEGER|0||0
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (screenpipe")
Close Tab
-zsh
Close Tab
⌥⌘1
-zsh...
|
iTerm2
|
-zsh
|
NULL
|
27870
|
|
27871
|
iTerm2Shell•EditViewSessionScriptsProfilesWindowHe iTerm2Shell•EditViewSessionScriptsProfilesWindowHelp-zshDOCKERO ₴81DEV (-zsh)lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe$lukas@Lukas-Kovaliks-MacBook-Pro-Jiminnycat screenpipe_sync.sh |O ₴2pbcopy~/.screenpipe $ ~/.screenpipe/screenpipe_sync.sh 2026-05-11[2026-05-1220:19:37J[2026-05-1220:19:37J[2026-05-12 20:19:37]Screenpipe sync startingfor: 2026-05-11install_id: 2ff6574c-4272-4dbf-a20b-434b024c65fb[2026-05-12 20:19:37][+00m00s] • Preflight checksSource DB:NAS mount:Archive DB:Frame data dir:Audio files:OKOK(4.2G)/Volumes/screenpipewill be createdOK(283 files, 318M)OK(2507 files, 267M)[+00m00s]• Counting source rows for 2026-05-11frames:6857elements:672129ui_events:7063ocr_text:2332meetings:1audio_chunks:2507audio_transcriptions:226audio_tags:0speakers:15(all-time)speaker_embeddings:58(all-time)[+00m01s] • Initialising tables (CREATE IF NOT EXISTS)creating vision tablescreating audio tables• Om00s• Om01sError: in prepare, no such column: idS idx_ocr_text_install_pk ON ocr_text(install_id, id);error here---^lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqliteOlframe_idlINTEGERI11101ltext|TEXT|11102Itext_json|TEXTl01103 lapp_name | TEXT |1| ' * 104locr_engine|TEXT|1l 'unknown' 105 Iwindow_name | TEXTI011061 focused| BOOLEANIOIFALSEI07Itext_length| INTEGERI0I108lsync_id|TEXTI01109lsynced_at I DATETIME I011010|redacted_at|INTEGERI0110lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $A100% C8•Tue 12 May 20:24:53T₴1APP (screenpipe")83-zsh...
|
iTerm2
|
NULL
|
NULL
|
27871
|
|
27872
|
v screenpipe [SSH: nas)› Ch app› data658662)settin v screenpipe [SSH: nas)› Ch app› data658662)settings.json686687688689S838screenpipe sync.sh M XAAU S(HAUOTO FULES (e)) -9t o lA ther8-365 v %dm802ds (%s files, &5)\n"*"rsync audio - NAS"\"$(( RSYNC_DUR / 60 ))" "$( ( RSYNC DUR & 60 ))" \"SCOPTED AUDTO" "SAUDTO STZE" teeelseprintf "%-36s %s\n" "rsvnc audio → NAS" "skiooed (no audilo for date)""Copying screenpipe logs for $TARGET_DATE"NAS LOGS="SNAS MOUNT/loas'shopt -s nullglobLOG_FILES=( "SHOME/.screenpipe/screenpipe.$TARGET_DATE."*. log )shopt -u nullglobif I $(#LOG_FILES(@l) -gt 0 1; then%-36s " "rsvnc loas → NAS'rsvnc ca "SflOG FTLFSIall" "SNAS LOGS/" ?>>"SLOG FTLF"TOTAL STZE=S(du -ch "S/LoG FTLESal}" | tail -1 1 cut."$(#LOG_FILES(@]}" "STOTAL_SIZE" | tee -a "$LOG_FILE"printf"$-36s %5\n" "rsync logs » NAS" "skipped (no matching logs)"TOTAI FIAPSFD=<(( <(date +%c) - SGRTPT START )\DB_SIZE=$(du -sh "SNAS_DB" | cut -f1)echo "log"Archive DB size:CDR ST7F"C/ TOTAI FLADCED 1 60 ImelI TOTAL FLAPCEN & 60 1)srsync -a "SHOME/ .screenpipe/sync.log"' "SNAS_LOGS/sync. log" 2>/dev/null || trueData Migration and Sy•0u.+0 .*•ok lets forget on install id for a while. Given the @screenpipe_sync.sh why do I get error like this when ruynning the same scritp from(2026-05-12 20:19:37) install_id: 2416574c-4272-4dbf-a20b-434b024c65fb2026-05-12 20*19'3/===================================za===Source DB:OK (4.2G)OK /volumes/screenpiptThe error occurs because the ocr_text table doesn't have an id column, but the script tries to create a unique index on (instalnave an id column. Une script assumes all tables nave an id column as thelr primary key, our ocrtext likely nas a amerentCheck the actual schema of vour ocr text tableon the script's usage, ocr_text likely uses frame_id as a foreign key and may not havels own 1d primaly key (it mightuse seuke s imollcit rowid.The fix would be to modity the script to handle tables without an id column. Options1. Skio the unique index for tables without id and use a different constraint2. Use rowid instead of id for tables that don't have an exolicit id columnWhat does the schema show for ocr text ?0 .l .Ports 1AbashA +[EMAIL] urat omg re gltes okuna/screnpipe/rchive. db "SELECT COAT(») as total, COMT(OSTINCT in.Ask anvthinalX SSH: nas %& master © @0A0 (1zed Ln 689, Col 8 Spaces: 2 UTF-8 LF Shell Script Teams Windsurf - Settingsscreenpipelpe sync.snipe_fts_migrate.shdb.bak-pre-installide-shmnpipe.2026-05-07.0.1o0-05-07-05-06-04-28-04-27-04-25-04-24-04-22-04-20-04-21-04-17-04-16-04-15-04-14ipe_sync_updated.shdb-bake-waltings. sonioe.db$0.Q SearchDate ModifiedTodau at 20:16Today at 20:19Today at 20:19Todav at 20:12Today at 17:41Today at 15:20Today at 5:4810 May 2026 at 13:4710 May 2026 at 13:477 May 2026 at 21:5010 Mav 2026 at 12:168 May 2026 at 9:266 May 2026 at 21:0428 Aor 2026 at 22:2328 Apr 2026 at 9:1926 Apr 2026 at 16:3524 Aor 2026 at 22:3024 Aor 2026 at 12:0924 Apr 2026 at 12:0722 Apr 2026 at 18:4422 Anr 2026 at 0:1618 Apr 2026 at 13:3517 Apr 2026 at 8:5716 Aor 2026 at 9:1315 Apr 2026 at 9:5910 May 2026 at 13:0610 May 2026 at 12:3126 Anr 2026 at 20:1026 Apr 2026 at 17:1718 Apr 2026 at 17:4213 Aor 2026 at 17:2111 Apr 2026 at 16:518• Tue 12 May 20:24:53v Size22 kplerminal scripts70,01 GBFolder9 KETerminal scriote4,46 GB Document12,92 GBDocument33 K:Document573 KB Folder7 KBLog File566 KBLoa File72 GR Colder305,6 MB Folder18,8 MB Folder166.7 MB Folden339,8 MB Folder149,1 MBFolder265 5 MP Soldon171,8 MB Folder525,4 MB450 8 MR Folden699,6 MB Folder837,2 MB1.15 G:Folden100 ep Soldor20 KB11,13 GBDocument102 KPColderZero bytes Document31 bytesJSONZero butes12KR Coldor32 items, 1,93 TB available...
|
iTerm2
|
NULL
|
NULL
|
27872
|
|
27873
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp100% <-zsh8• Tue 12 May 20:24:54T81DOCKERO 81DEV (-zsh)O ₴2lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe$lukas@Lukas-Kovaliks-MacBook-Pro-Jiminnycat screenpipe_sync.sh |pbcopy~/.screenpipe $~/.screenpipe/screenpipe_sync.sh 2026-05-11[2026-05-1220:19:37J[2026-05-1220:19:37J[2026-05-12 20:19:37]Screenpipe sync startingfor: 2026-05-11install_id: 2ff6574c-4272-4dbf-a20b-434b024c65fb[2026-05-12 20:19:37]APP (screenpipe")[+00m00s] • Preflight checksSource DB:NAS mount:Archive DB:Frame data dir:Audio files:OKOK(4.2G)/Volumes/screenpipewill be createdOK(283 files, 318M)OK(2507 files, 267M)[+00m00s]• Counting source rows for 2026-05-11frames:6857elements:672129ui_events:7063ocr_text:2332meetings:1audio_chunks:2507audio_transcriptions:226audio_tags:0speakers:15(all-time)speaker_embeddings:58(all-time)[+00m01s] • Initialising tables (CREATE IF NOT EXISTS)creating vision tablescreating audio tables• Om00s• Om01sError: in prepare, no such column:S idx_ocr_text_install_pk ON ocr_text(install_id, id);error here---^lukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "PRAGMA table_info(ocr_text);"Olframe_idlINTEGERI11101ltext|TEXT|11102Itext_json|TEXTl01103 lapp_name | TEXT |1| ' * 104locr_engine|TEXT|1l 'unknown' 105 Iwindow_name | TEXTI011061 focused| BOOLEANIOIFALSEI07Itext_length| INTEGERI0I108lsync_id|TEXTI01109lsynced_at I DATETIME I011010|redacted_at|INTEGERI0110lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ 0• *3-zsh...
|
iTerm2
|
NULL
|
NULL
|
27873
|
|
27874
|
selectionViewlerminalWinaow• screenpipe SSH: nas - selectionViewlerminalWinaow• screenpipe SSH: nas - screenpipe sync.sh - Moditied• screenpipe [ssm: nas)tr appsettings.jsor658659666661662)AAU S(HAUDTO FULES (e)) 9t 0 l thers-36s /%dm%02dsus fiaes, ss/lnuu"rsvnc audio → NAS""S(ORSYNC_OUR/ 60)"S(RSNC-DUR% 60 )"SCOPTED AUDTO" "SAUDTO STZE" teeelse%-36s %s\n" "rsvnc audio » NAS" "skiooed (no audio for date)""Copyina screenpine loas for STARGET DATE"NAS LOGS="SNAS MOUNT/loas'shopt -s nullglobLOG_FILES=( "$HOME/.screenpipe/screenpipe.$TARGET_DATE."*.log )shont -u nullalohif [ ${#LOG_FILES[@]} -gt 0 ]; then%-36s " "rsvnc loas → NAS'rsvnc ca "SflOG FTLFSIall" "SNAS LOGS/" 2>>"SLOG FTLF"TOTAL STZE=S(du -ch "S/LoG FTLESal}" | tail -1 1 cut.-f1)"${#LOG_FILES[@]}" "$TOTAL SIZE" | tee -a "$LOG_FILE"nrintf"%-36s %s\n" "rsync logs → NAS" "skipped (no matching logs)"TOTAI FIAPSFD=<(( <(date +%c) - SGRTPT START ))DB_SIZE=$(du -sh "$NAS_DB" | cut -f1)echoloa"Archive DR size:CDR ST7F"C/ TOTAI FLADCED / 60 ImelI TOTAL FLAPCEN & 60 1)cH•П к vData Migration and Sylukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ salite3 ~/.screenpipe/db.salite "PRAGMA table_info(ocr text):oftrame_idjINTEGER/1Ie2HeL SOnITEXTOIOAlocr enginelTEXTfunknown'Y0GlfocusedIBOOLEANIOIFAL.SEIOThe ocr text table hasno id column - its primary kev is frame 1d. The scriot incorrectly assumes all tables have an id columnThe fix is in › screenpipe sync.sh around line 363-370. The loop needs to check if the table has an id column before creatingbash* Re-run sinstall id + index setup so freshly-created tables aet them toolfor tbl in "S<ALL SYNC TABLES (@"; doHAS COL=S(squite3 "SNAS DB" "SELECT COUNT(*) FROM pragma table info('stbl") WHERE name='install id':")salite? "SNAS DR" "ALTER TABLE Stbl ADD COLUMN install id TEXT."M praqma table info('stbl") WHERE name='id':*)salite? HCNAS DRI IGRFATE UNTOUE TNOFX TE NOT FYTSTS idy </thll inctall nk ON </thl}(inctall id. id)."else# For tables without Sid', use rowid sinsteadsalite3 "SNAS DB" "CREATE UNTOUE INDEX IF NOT EXISTS idx S"tbl) install ok ON Stbl)(install id, rowid):"The same fix applies to › screenpipe fts migrate.sh at line 106. Both scripts have the same bugYou'll need to switch to Code mode to apply these changes.687688680S838@.l**rsync -a "$HOME/.screenpipe/sync.log" "$NAS_LOGS/sync.log" 2>/dev/null || truePorts1AbashA +[EMAIL] urat omg re gltes okuna/screnpipe/rchive. db "SELECT COAT(») as total, COMT(OSTINCT in.Ask anvthinal*SSH: nas iômaster @oA0 (g1zed Ln 689, Col 8 Spaces: 2 UTF-8 LF Shell Script TeamsWindsurf - Settings100% C• Tue 12 May 20:25:008=mGscreenpipeipe sync.snipe_fts_migrate.shdb.bak-pre-installide-shmnpipe.2026-05-07.0.1o0-05-07-05-06-04-28-04-27-04-25-04-24-04.22-04-20-04-21-04-17-04-16-04-15ipe_sync_updated.shdb-bake-walltings. sonine.doDate ModifiedTodau at 20:10Today at 20:19Today at 20:19Todav at 20:12Today at 17:41Today at 15:20Today at 5:4810 May 2026 at 13:4710 May 2026 at 13:477 May 2026 at 21:5010 Mav 2026 at 12:168 Mav 2026 at 9:2628 Aor 2026 at 22:2328 Apr 2026 at 9:1926 Apr 2026 at 16:3524 Aor 2026 at 22:302A Aor 2026 at 12:0924 Apr 2026 at 12:0722 Apr 2026 at 18:4422 Anr 2026 at 0:1618 Apr 2026 at 13:3517 Apr 2026 at 8:5716 Aor 2026 at 9:1315 Anr 2026 at 0:5010 May 2026 at 13:0610 May 2026 at 12:3126 Anr 2026 at 20:1026 Apr 2026 at 17:1718 Apr 2026 at 17:4213 Aor 2026 at 17:2111 Anr 2006 at 16:5122 KPlerminal scripts70.01 GEFolder9 KETerminal scriote4.46 GB Documen12,92 GBDocument33 K:Document573 KB Folder7 KBLog File566 KBLoa File72 GR Colder305,6 MB Folder18,8 MB Folder166.7 MB Folden339.8 MB Folder149.1 MBFolder265 6 MR Soldon171,8 MB Folder525,4 MB450 8 MR Folden699.6 MB Folder837,2 MB2.15 G:Folden100 ep Coldor20 KB11,13 GBDocument102 KPColderZero butes Document31 bytesZero butes12KR Coldor32 items, 1.93 TB availabld...
|
iTerm2
|
NULL
|
NULL
|
27874
|
|
27875
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp100% <-zsh8• Tue 12 May 20:25:12T81DOCKERO 81DEV (-zsh)O ₴2lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe$lukas@Lukas-Kovaliks-MacBook-Pro-Jiminnycat screenpipe_sync.sh |pbcopy~/.screenpipe $~/.screenpipe/screenpipe_sync.sh 2026-05-11[2026-05-1220:19:37J[2026-05-1220:19:37J[2026-05-12 20:19:37]Screenpipe sync startingfor: 2026-05-11install_id: 2ff6574c-4272-4dbf-a20b-434b024c65fb[2026-05-12 20:19:37]APP (screenpipe")[+00m00s] • Preflight checksSource DB:NAS mount:Archive DB:Frame data dir:Audio files:OKOK(4.2G)/Volumes/screenpipewill be createdOK(283 files, 318M)OK(2507 files, 267M)[+00m00s]• Counting source rows for 2026-05-11frames:6857elements:672129ui_events:7063ocr_text:2332meetings:1audio_chunks:2507audio_transcriptions:226audio_tags:0speakers:15(all-time)speaker_embeddings:58(all-time)[+00m01s] • Initialising tables (CREATE IF NOT EXISTS)creating vision tablescreating audio tables• Om00s• Om01sError: in prepare, no such column:S idx_ocr_text_install_pk ON ocr_text(install_id, id);error here---^lukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "PRAGMA table_info(ocr_text);"Olframe_idlINTEGERI11101ltext|TEXT|11102Itext_json|TEXTl01103 lapp_name | TEXT |1| ' * 104locr_engine|TEXT|1l 'unknown' 105 Iwindow_name | TEXTI011061 focused| BOOLEANIOIFALSEI07Itext_length| INTEGERI0I108lsync_id|TEXTI01109lsynced_at I DATETIME I011010|redacted_at|INTEGERI0110lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ 0• *3-zsh...
|
iTerm2
|
NULL
|
NULL
|
27875
|
|
27876
|
selectionViewlerminalWinaow• screenpipe SSH: nas - selectionViewlerminalWinaow• screenpipe SSH: nas - screenpipe sync.sh - Moditied• screenpipe [ssm: nas)tr appsettings.jsor658659666661[PHONE]80S838AAU S(HAUDTO FULES (e)) -9t 0 l thers-36s /%dm%02dsus fiaes, ss/lnuu"rsvnc audio → NAS""S(ORSYNC_OUR/ 60)"S(RSNC-DUR% 60 )"SCOPTED AUDTO" "SAUDTO STZE" teeelse%-36s %s\n" "rsvnc audio » NAS" "skooed (no audio for date)""Copyina screenpine loas for STARGET DATE"NAS LOGS="<NAS MOUNT/loas"shopt -s nullglobLOG_FILES=( "$HOME/.screenpipe/screenpipe.$TARGET_DATE."*.log )shont -u nullalohif [ ${#LOG_FILES[@]} -gt 0 ]; then%-36s " "rsvnc loas → NAS'rsvnc ca "SflOG FTLFSIall" "SNAS LOGS/" 2>>"SLOG FTLF"TOTAL STZE=S(du -ch "S/LoG FTLESal}" | tail -1 1 cut.-f1)"${#LOG_FILES[@]}" "$TOTAL SIZE" | tee -a "$LOG_FILE"nrintf"%-36s %s\n" "rsync logs → NAS" "skipped (no matching logs)"TOTAI FIAPSFD=<(( <(date +%c) - SGRTPT START ))DB_SIZE=$(du -sh "$NAS_DB" | cut -f1)echoloa"Archive DR size:CDR ST7F"C/ TOTAI FLADCED / 60 ImelI TOTAL FLAPCEN & 60 1)cHrsync -a "$HOME/.screenpipe/sync.log" "$NAS_LOGS/sync.log" 2>/dev/null || true•П к vData Migration and Sylukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ salite3 ~/.screenpipe/db.salite "PRAGMA table_info(ocr text):oftrame_idjINTEGER/1o2HeL SOnITEXTOIOAlocr enginelTEXTfunknown'Y0GilfocusedIBOOLEANIOIFALSEIOThe ocr text table hasno id column - its primary kev is frame 1d. The scriot incorrectly assumes all tables have an id columnreenpipe sync. sh around line 363-370. The loop needs to check if the table has an id column before creatingbash* Re-run sinstall id + index setup so freshly-created tables aet them toolfor tbl in "S<ALL SYNC TABLES (@"; doHAS COL=S(squite3 "SNAS DB" "SELECT COUNT(*) FROM pragma table info('stbl") WHERE name='install id':")salite? "SNAS DR" "ALTER TABLE Stbl ADD COLUMN install id TEXT."M praqma table info('stbl") WHERE name='id':*)salite? HCNAS DRI IGRFATE UNTOUE TNOFX TE NOT FYTSTS idy </thll inctall nk ON </thl}(inctall id. id)."else# For tables without Sid', use rowid sinsteadsalite3 "SNAS DB" "CREATE UNTOUE INDEX IF NOT EXISTS idx S"tbl) install ok ON Stbl)(install id, rowid):"The same fix applies to › screenpipe fts migrate.sh at line 106. Both scripts have the same bugYou'll need to switch to Code mode to apply these changes.@.l**Ports1AbashA +[EMAIL] urat omg re gltes okuna/screnpipe/rchive. db "SELECT COAT(») as total, COMT(OSTINCT in.Ask anvthinal*SSH: nas iômaster ® @0A0 (g1zed Ln 689, Col 8 Spaces: 2 UTF-8 LF Shell Script TeamsWindsurf - Settings100% C4• Tue 12 May 20:25:128=mCscreenpipelpe sync.snipe_fts_migrate.shdb.bak-pre-installide-shmnpipe.2026-05-07.0.100-05-07-05-06-04-28-04-27-04-25-04-24-04.22-04-20-04-21-04-17-04-16-04-15ipe_sync_updated.shdb-bake-walltings. sonine.doDate ModifiedTodau at 20:16Today at 20:19Today at 20:19Todav at 20:12Today at 17:41Today at 15:20Today at 5:4810 May 2026 at 13:4710 May 2026 at 13:477 May 2026 at 21:5010 May 2026 at 12:168 Mav 2026 at 9:266 May 2026 at 21:0428 Aor 2026 at 22:2328 Apr 2026 at 9:1926 Apr 2026 at 16:3524 Aor 2026 at 22:3024 Aor 2026 at 12:0924 Apr 2026 at 12:0722 Apr 2026 at 18:4422 Anr 2026 at 0:1618 Apr 2026 at 13:3517 Apr 2026 at 8:5716 Aor 2026 at 9:1315 Anr 2026 at 0:5010 May 2026 at 13:0610 May 2026 at 12:3126 Anr 2026 at 20:1026 Apr 2026 at 17:1718 Apr 2026 at 17:4213 Aor 2026 at 17:2111 Anr 2006 at 16:5122 KPlerminal scripts70.01 GEFolder9 KETerminal scriote4.46 GB Documen12,92 GBDocument33 K:Document573 KB Folder7 KBLog File566 KBLoa File72 GR Colder305,6 MB Folder18,8 MB Folder166.7 MB Folden339.8 MB Folder149.1 MBFolder265 5 MP Soldon171,8 MB Folder525,4 MB450 8 MR Folden699.6 MB Folder837,2 MB1.15 G:Folden100 ep Soldor20 KB11,13 GBDocument102 KPColderZero butes Document31 bytesJSONZero butes12KR Coldor32 items, 1.93 TB availabld...
|
iTerm2
|
NULL
|
NULL
|
27876
|
|
27877
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp100% <-zsh8• Tue 12 May 20:25:14T81DOCKERO 81DEV (-zsh)O ₴2lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe$lukas@Lukas-Kovaliks-MacBook-Pro-Jiminnycat screenpipe_sync.sh |pbcopy~/.screenpipe $~/.screenpipe/screenpipe_sync.sh 2026-05-11[2026-05-1220:19:37J[2026-05-1220:19:37J[2026-05-12 20:19:37]Screenpipe sync startingfor: 2026-05-11install_id: 2ff6574c-4272-4dbf-a20b-434b024c65fb[2026-05-12 20:19:37]APP (screenpipe")[+00m00s] • Preflight checksSource DB:NAS mount:Archive DB:Frame data dir:Audio files:OKOK(4.2G)/Volumes/screenpipewill be createdOK(283 files, 318M)OK(2507 files, 267M)[+00m00s]• Counting source rows for 2026-05-11frames:6857elements:672129ui_events:7063ocr_text:2332meetings:1audio_chunks:2507audio_transcriptions:226audio_tags:0speakers:15(all-time)speaker_embeddings:58(all-time)[+00m01s] • Initialising tables (CREATE IF NOT EXISTS)creating vision tablescreating audio tables• Om00s• Om01sError: in prepare, no such column:S idx_ocr_text_install_pk ON ocr_text(install_id, id);error here---^lukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "PRAGMA table_info(ocr_text);"Olframe_idlINTEGERI11101ltext|TEXT|11102Itext_json|TEXTl01103 lapp_name | TEXT |1| ' * 104locr_engine|TEXT|1l 'unknown' 105 Iwindow_name | TEXTI011061 focused| BOOLEANIOIFALSEI07Itext_length| INTEGERI0I108lsync_id|TEXTI01109lsynced_at I DATETIME I011010|redacted_at|INTEGERI0110lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ 0• *3-zsh...
|
iTerm2
|
NULL
|
NULL
|
27877
|
|
27878
|
selectionViewlerminalWinaow• screenpipe SSH: nas - selectionViewlerminalWinaow• screenpipe SSH: nas - screenpipe sync.sh - Moditied• screenpipe [ssm: nas)tr appsettings.jsor658659666661[PHONE]80S838AAU S(HAUDTO FULES (e)) -9t 0 l, thers-36s /%dm%02dsus fiaes, ss/lnuu"rsvnc audio → NAS""S(ORSYNC_OUR/ 60)"S(RSNC-DUR% 60 )"SCOPTED AUDTO" "SAUDTO STZE" teeelse%-36s %s\n" "rsvnc audio » NAS" "skooed (no audio for date)""Copyina screenpine loas for STARGET DATE"NAS LOGS="<NAS MOUNT/loas"shopt -s nullglobLOG_FILES=( "$HOME/.screenpipe/screenpipe.$TARGET_DATE."*.log )shont -u nullalohif [ ${#LOG_FILES[@]} -gt 0 ]; then%-36s " "rsvnc loas → NAS'rsvnc ca "SflOG FTLFSIall" "SNAS LOGS/" 2>>"SLOG FTLF"TOTAL STZE=S(du -ch "S/LoG FTLESal}" | tail -1 1 cut.-f1)"${#LOG_FILES[@]}" "$TOTAL SIZE" | tee -a "$LOG_FILE"nrintf"%-36s %s\n" "rsync logs → NAS" "skipped (no matching logs)"TOTAI FIAPSFD=<(( <(date +%c) - SGRTPT START ))DB_SIZE=$(du -sh "$NAS_DB" | cut -f1)echoloa"Archive DR size:CDR ST7F"C/ TOTAI FLADCED / 60 ImelI TOTAL FLAPCEN & 60 1)cHrsync -a "$HOME/.screenpipe/sync.log" "$NAS_LOGS/sync.log" 2>/dev/null || true•П к vData Migration and Sylukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ salite3 ~/.screenpipe/db.salite "PRAGMA table_info(ocr text):oftrame_idjINTEGER/1Ie2HeL SOnITEXTOIOAlocr enginelTEXTfunknown'Y0GilfocusedIBOOLEANIOIFALSEIOThe ocr text table hasno id column - its primary kev is frame 1d. The scriot incorrectly assumes all tables have an id columnreenpipe sync. sh around line 363-370. The loop needs to check if the table has an id column before creatingbash* Re-run sinstall id + index setup so freshly-created tables aet them toolfor tbl in "S<ALL SYNC TABLES (@"; doHAS COL=S(squite3 "SNAS DB" "SELECT COUNT(*) FROM pragma table info('stbl") WHERE name='install id':")salite? "SNAS DR" "ALTER TABLE Stbl ADD COLUMN install id TEXT."M praqma table info('stbl") WHERE name='id':*)salite? HCNAS DRI IGRFATE UNTOUE TNOFX TE NOT FYTSTS idy </thll inctall nk ON </thl}(inctall id. id)."else# For tables without Sid', use rowid sinsteadsalite3 "SNAS DB" "CREATE UNTOUE INDEX IF NOT EXISTS idx S"tbl) install ok ON Stbl)(install id, rowid):"The same fix applies to › screenpipe fts migrate.sh at line 106. Both scripts have the same bugYou'll need to switch to Code mode to apply these changes.@.l**Ports1AbashA +[EMAIL]« CodeD Aans but wort edt.Use * (. to switch modesattap urat omg re gltes okuna/screnpipe/rchive. db "SELECT COAT(») as total, COMT(OSTINCT in.*SSH: nas iômaster ® @0A0 (g1ized Ln 689, Col 8 Spaces: 2 UTF-8 LF Shell Script Teams Windsurf - Settings100% C4• Tue 12 May 20:25:148=mCscreenpipelpe sync.snipe_fts_migrate.shdb.bak-pre-installide-shmnpipe.2026-05-07.0.100-05-07-05-06-04-28-04-27-04-25-04-24-04.22-04-20-04-21-04-17-04-16-04-15ipe_sync_updated.shdb-bake-walltings. sonine.doDate ModifiedTodau at 20:16Today at 20:19Today at 20:19Todav at 20:12Today at 17:41Today at 15:20Today at 5:4810 May 2026 at 13:4710 May 2026 at 13:477 May 2026 at 21:5010 May 2026 at 12:168 Mav 2026 at 9:266 May 2026 at 21:0428 Aor 2026 at 22:2328 Apr 2026 at 9:1926 Apr 2026 at 16:3524 Aor 2026 at 22:3024 Aor 2026 at 12:0924 Apr 2026 at 12:0722 Apr 2026 at 18:4422 Anr 2026 at 0:1618 Apr 2026 at 13:3517 Apr 2026 at 8:5716 Aor 2026 at 9:1315 Anr 2026 at 0:5010 May 2026 at 13:0610 May 2026 at 12:3126 Anr 2026 at 20:1026 Apr 2026 at 17:1718 Apr 2026 at 17:4213 Aor 2026 at 17:2111 Anr 2006 at 16:5122 KPlerminal scripts70.01 GEFolder9 KETerminal scriote4.46 GB Documen12,92 GBDocument33 K:Document573 KB Folder7 KBLog File566 KBLoa File72 GR Colder305,6 MB Folder18,8 MB Folder166.7 MB Folden339.8 MB Folder149.1 MBFolder265 5 MP Soldon171,8 MB Folder525,4 MB450 8 MR Folden699.6 MB Folder837,2 MB1.15 G:Folden100 ep Soldor20 KB11,13 GBDocument102 KPColderZero butes Document31 bytesJSONZero butes12KR Coldor32 items, 1.93 TB availabld...
|
iTerm2
|
NULL
|
NULL
|
27878
|
|
27879
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp100% <-zsh8• Tue 12 May 20:25:15T81DOCKERO 81DEV (-zsh)O ₴2lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe$lukas@Lukas-Kovaliks-MacBook-Pro-Jiminnycat screenpipe_sync.sh |pbcopy~/.screenpipe $~/.screenpipe/screenpipe_sync.sh 2026-05-11[2026-05-1220:19:37J[2026-05-1220:19:37J[2026-05-12 20:19:37]Screenpipe sync startingfor: 2026-05-11install_id: 2ff6574c-4272-4dbf-a20b-434b024c65fb[2026-05-12 20:19:37]APP (screenpipe")[+00m00s] • Preflight checksSource DB:NAS mount:Archive DB:Frame data dir:Audio files:OKOK(4.2G)/Volumes/screenpipewill be createdOK(283 files, 318M)OK(2507 files, 267M)[+00m00s]• Counting source rows for 2026-05-11frames:6857elements:672129ui_events:7063ocr_text:2332meetings:1audio_chunks:2507audio_transcriptions:226audio_tags:0speakers:15(all-time)speaker_embeddings:58(all-time)[+00m01s] • Initialising tables (CREATE IF NOT EXISTS)creating vision tablescreating audio tables• Om00s• Om01sError: in prepare, no such column:S idx_ocr_text_install_pk ON ocr_text(install_id, id);error here---^lukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "PRAGMA table_info(ocr_text);"Olframe_idlINTEGERI11101ltext|TEXT|11102Itext_json|TEXTl01103 lapp_name | TEXT |1| ' * 104locr_engine|TEXT|1l 'unknown' 105 Iwindow_name | TEXTI011061 focused| BOOLEANIOIFALSEI07Itext_length| INTEGERI0I108lsync_id|TEXTI01109lsynced_at I DATETIME I011010|redacted_at|INTEGERI0110lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ 0• *3-zsh...
|
iTerm2
|
NULL
|
NULL
|
27879
|
|
27880
|
selectionViewlerminalWinaow100% C• Tue 12 May 20:2 selectionViewlerminalWinaow100% C• Tue 12 May 20:25:19• screenpipe SSH: nas — screenpipe sync.sh — Moditied•П к v8=mG• screenpipe [ssm: nas)tr appsettings.jsor658659666661662)AAU S(HAUDTO FULES (e)) 9t 0 l thers-36s /%dm%02dsus fiaes, ss/lnuu"rsvnc audio → NAS""S(ORSYNC_OUR/ 60)"S(RSNC-DUR% 60 )"SCOPTED AUDTO" "SAUDTO STZE" teeelse%-36s %s\n" "rsvnc audio → NAS" "skiooed (no audio for date)""Copyina screenpine loas for STARGET DATE"NAS LOGS="<NAS MOUNT/loas"shopt -s nullglobLOG_FILES=( "$HOME/.screenpipe/screenpipe.$TARGET_DATE."*. log )shont -u nullalohif [ ${#LOG_FILES[@]} -gt 0 ]; then%-36s " "rsvnc loas → NAS'rsvnc ca "SflOG FTLFSIall" "SNAS LOGS/" 2>>"SLOG FTLF"TOTAL STZE=S(du -ch "SLoG FTLESIal}" | tail -1 1 cut.-f1)"${#LOG_FILES[@]}" "$TOTAL SIZE" | tee -a "$LOG_FILE"nrintf"%-36s %s\n" "rsync logs → NAS" "skipped (no matching logs)"TOTAI FIAPSFD=<(( <(date +%c) - SGRTPT START ))DB_SIZE=$(du -sh "$NAS_DB" | cut -f1)echoloa"Archive DR size:CDR ST7F"C/ TOTAI FLADCED / 60 ImelI TOTAL FLAPCEN % 60 1)c"screenpipeipe sync.snipe_fts_migrate.shdb.bak-pre-installide-shmnpipe.2026-05-07.0.100-05-07-05-06-04-28-04-27-04-25-04-24-04.22-04-20-04-21-04-17-04-16ipe_sync_updated.shdb-baktings. sonine.do687688680S838Date ModifiedTodau at 20:10Today at 20:19Today at 20:19Todav at 20:12Today at 17:41Today at 15:20Today at 5:4810 May 2026 at 13:4710 May 2026 at 13:477 May 2026 at 21:5010 MAy 2026 at 12:168 Mav 2026 at 9:2628 Aor 2026 at 22:2328 Apr 2026 at 9:1926 Apr 2026 at 16:3524 Aor 2026 at 22:302A Aor 2026 at 12:0924 Apr 2026 at 12:0722 Apr 2026 at 18:4422 Anr 2026 at 0:1618 Apr 2026 at 13:3517 Apr 2026 at 8:5716 Aor 2026 at 9:1315 Anr 2026 at 0:5010 May 2026 at 13:0610 May 2026 at 12:3126 Anr 2026 at 20:1026 Apr 2026 at 17:1718 Apr 2026 at 17:4213 Aor 2026 at 17:2111 Anr 2006 at 16:5122 KPlerminal scripts70.01 GEFolder9 KETerminal scriote4.46 GB Documen12,92 GBDocument33 K:Document573 KB Folder7 KBLog File566 KBLoa File72 GR Colder305,6 MB Folder18,8 MB Folder166.7 MB Folden339.8 MB Folder149.1 MBFolder265 6 MR Soldon171,8 MB Folder525,4 MB450 8 MR Folden699.6 MB Folder837,2 MB2.15 G:Folden100 ep Coldor20 KB11,13 GBDocument102 KPColderZero butes Document31 bytesZero butes12KR Coldorrsync -a "$HOME/.screenpipe/sync.log" "$NAS_LOGS/sync.log" 2>/dev/null || truePorts1AbashA +[EMAIL] urat omg re gltes okuna/screnpipe/rchive. db "SELECT COAT(») as total, COMT(OSTINCT in.*SSH: nas iômaster ® @0A0 (g1zed Ln 689, Col 8 Spaces: 2 UTF-8 LF Shell Script Teams Windsurf - Settings32 items, 1.93 TB availabld...
|
iTerm2
|
NULL
|
NULL
|
27880
|
|
27881
|
• screenpipe [ssm: nas)• _ #recycietr app- data•db • screenpipe [ssm: nas)• _ #recycietr app- data•db.saliteescreenpine.dbEditselectionViewlerminalWindow• screenpipe SSH: nas - screenpipe sync.sh — Moditiedscreenpipe fts migrate.sh Uoscreenpipe_sync.sn6575666681682682684687602[PHONE]98600%if S#AUDTO FILES a -at 01: thenRSYNC STARTES(date +%s)%-36s " "rsync audio → NAS"rsvnc -a --ianore-existina "sAUDTO FILESa" "SNAS DATA/STARGET DATE/audio/" 2>>"$LOG_ FILERSYNC DURES Sdate +%s = RSYNC START)ICOPTED AUDTO=SOLS "SNAS DATA/STARGET DATE/audio" | wc = tr -d**)AUDTO SIESdu =sh "SNAS DATA/STARGET DATE/audio" cut -1)%-36s / %dm%02ds %s files. %s)\n" |"rsvnc audio & NAS""S RSYNC DUR / 60" "S RSYNG DUR % 60)""SCOPTED AUDTO" "SAUDTO SIE" teeorintf"%-36s %sln" "rsvnc audio » NAS" "skoned no audio for date)"step "Copying screenpipe logs for $TARGET_DATE"NAS_LOGS="$NAS_MOUNT/logs'shont =s nullalobLoG FTIFS=( "sHOM-/.screennine/screennine.STARGFT DATF "*.100 )shont -u nullalobif [ $(#LOG_FILES[@]} -gt 0 ]; then%-36s " "rsvnc loas - NAS!revnc ca HCflOG FTLECIOR" "CNAS LOGS/" OSS"CLAG FTIETOTAI ST7F=<(du ch "cflog FTIFSIall" I tail -1 l cut -f1)printf ",%d file(s), %s\n" "${#LOG_FILES[@]}" "$TOTAL_SIZE" | tee -a "$LOG_FILE"nrintf "%-36s %s\n" "rsync logs → NAS" "skipped (no matching logs)'TOTAI FLAPCEN-E C/date 19c) = CCRTPT CTAPT )YDR ST7F-&(du _ch "GNAS DRi 1 cut _f1)echolod"Archive OR cize.sOR CTZEIC/I TOTAL FLAPSED / 60 )ImS/( TOTAL FLAPSEN % 60 J)c"700701|• Accent File 1o Reiect File oxalPorts1AbshA +[EMAIL] x•П к v8=mGTumix botn scripts to nandle tables without an id column.• screenpipe_sync.shSqtates "SNAS_DB" "CREATE UNIQUE INDEX IF NOT EXISTS 1dx_S(tbl)_install_pk ON S(tbL)(instalLid, rowid)."+8 -1UNTQUE INDEX TF NOT EXISTS idx vision taas install ok OM vision taostinstall $d, vision id. taosqlite3 "SNAS_DB" "CREATE UNIQUE INDEX IF NOT EXISTS idx_$(tbl)_install_pk ON $(tbl)(install_id, id);"screenpipeipe sync.snipe_fts_migrate.shdb.bak-pre-installide-shmnpipe.2026-05-07.0.100-05-07-05-06-04-28-04-27-04-25-04-24-04.22-04-20-04-21-04-17-04-16-04-15ipe_sync_updated.shdb-bake-walltings. sonine.doDate ModifiedTodau at 20:10Today at 20:19Today at 20:19Todav at 20:12Today at 17:41Today at 15:20Today at 5:4810 May 2026 at 13:4710 May 2026 at 13:477 May 2026 at 21:5010 Mav 2026 at 12:168 Mav 2026 at 9:2628 Aor 2026 at 22:2328 Apr 2026 at 9:1926 Apr 2026 at 16:3524 Aor 2026 at 22:302A Aor 2026 at 12:0924 Apr 2026 at 12:0722 Apr 2026 at 18:4422 Anr 2026 at 0:1618 Apr 2026 at 13:3517 Apr 2026 at 8:5716 Aor 2026 at 9:1315 Anr 2026 at 0:5010 May 2026 at 13:0610 May 2026 at 12:3126 Anr 2026 at 20:1026 Apr 2026 at 17:1718 Apr 2026 at 17:4213 Aor 2026 at 17:2111 Anr 2006 at 16:51100% C• Tue 12 May 20:25:2522 KPlerminal scripts70.01 GEFolder9 KETerminal scriote4.46 GB Documen12,92 GBDocument33 K:Document573 KB Folder7 KBLog File566 KBLoa File72 GR Colder305,6 MB Folder18,8 MB Folder166.7 MB Folden339.8 MB Folder149.1 MBFolder265 6 MR Soldon171,8 MB Folder525,4 MB450 8 MR Folden699.6 MB Folder837,2 MB2.15 G:Folden100 ep Coldor20 KB11,13 GBDocument102 KPColderZero butes Document31 bytesZero butes12KR Coldor2 a oe te te o ures/erepie/srchive d SLCT CoAr(a) s t8a1, COuAr(OSTNCT InAsk anvthind*SSH: nas iômaster @oA0 (g1ized Ln 696, Col 8 Spaces: 2 UTF-8 LF Shell Script Teams Windsurf - Settings32 items, 1.93 TB availabld...
|
iTerm2
|
NULL
|
NULL
|
27881
|
|
27882
|
Winasum100% C4• Tue 12 May 20:25:43• screenpipe SS Winasum100% C4• Tue 12 May 20:25:43• screenpipe SSH: nas — screenpipe sync.sh — ModitiedTumix botn scripts to nandle tables without an id column."Satates "SNAS_DB" "CREATE UNIQUE INDEX IF NOT EXISTS 1dx_S(tbl)_install_pk ON S(tbL)(instalLid, rowid) ."salites "SNAS DB" "CREATE UNTQUE INDEX IF NOT EXISTS idx S<tbU Installok ON S<tbl(installid, rowid):*Fixed both scrints. They now check if a table has an di column before creatina the unique index. If the table lacks an 3dl columnl) screennine svnc.ch (line 269-375): Added check for 1a column. fallback to rouidl• ›_ screenpipe_fts_migrate.sh (line 106-113): Added check for id column, fallback to rowidYou can now retry runnina the sunc scrint from vour Mac.•0кv+8 -10 aila.screenpipelpe nsmigrate.shlpe_sync.shdb.bak-pre-installide-shmnpipe.2026-05-07.0.100-05-07-05-06-04-28-04-27-04-25-04-24-04.22-04-20-04-21-04-17-04-16-04-15ои-1лipe_sync_updated.shdb-bake-walltings. sonine.do8=mC• screenpipe [ssH: nas,• _ #recycietr appSelectionViewlerminalWindowscreenpipe fts_migrate.sh Uscreenpipe sync.sh M Xnppe-sync.snS TOTAL ELAPSED 60ms TOTAL ELAPSED & 60 s'Sunc comolete for STARGET DATE Ginstall STNSTALL TD"rsync -a "SHOME/.screenpipe/sync.log" "$NAS_LOGS/sync.log" 2>/dev/null || trueDate ModifiedToday at 20:25Today at 20:19Todav at 20:10Today at 17:41Today at 15:20Today at 5:4810 May 2026 at 13:4710 May 2026 at 13:477 May 2026 at 21:5010 Mav 2026 at 12:168 Mav 2026 at 9:266 May 2026 at 21:0428 Aor 2026 at 22:2328 Apr 2026 at 9:1926 Apr 2026 at 16:3524 Aor 2026 at 22:3024 Aor 2026 at 12:0924 Apr 2026 at 12:0722 Apr 2026 at 18:4422 Anr 2026 at 0:1618 Apr 2026 at 13:3517 Apr 2026 at 8:5716 Aor 2026 at 9:1315 Anr 2026 at 0:5010 May 2026 at 13:0610 May 2026 at 12:3126 Anr 2026 at 20:1026 Apr 2026 at 17:1718 Apr 2026 at 17:4213 Aor 2026 at 17:2111 Anr 2006 at 16:519 KB Terminal scripts32 KBTerminal scriots61 KB Document70.01 GB Folden4.46 GB Document12,92 GBDocument33 K:Document573 KB Folder7 KBLog File566 KBLoa File72 GR Colder305,6 MB Folder18,8 MB Folder166.7 MB Folden339.8 MB Folder149.1 MBFolder265 5 MP Soldon171,8 MB Folder525,4 MB450 8 MR Folden699.6 MB Folder837,2 MB1.15 G:Folden100 ep Soldor20 KB11,13 GBDocument102 KPColderZero butes Document31 bytesJSONZero butes12KR ColdorAccent Sile 1e Reiect File &x6OutouAbshA +[EMAIL] x2 files 114plS 8se as unaye colos Pa8 glite ualunez/screenpipe/archive.db "SELECT COUNT(*) as total, COUNT(OZSTINCT in.Ask anvthind* SSH: nasomaster' 00A0 1nized Ln 696, Col 8 Spaces: 2 UTF-8 LF Shell Script Teams Windsurf - Settings32 items, 1.93 TB availabld...
|
iTerm2
|
NULL
|
NULL
|
27882
|
|
27883
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp100% C7-zshDOCKERO 81DEV (-zsh)O ₴2lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe$lukas@Lukas-Kovaliks-MacBook-Pro-Jiminnycat screenpipe_sync.sh |pbcopy~/.screenpipe $~/.screenpipe/screenpipe_sync.sh 2026-05-11[2026-05-1220:19:37J[2026-05-1220:19:37J[2026-05-12 20:19:37]Screenpipe sync startingfor: 2026-05-11install_id: 2ff6574c-4272-4dbf-a20b-434b024c65fb[2026-05-12 20:19:37]APP (screenpipe")[+00m00s] • Preflight checksSource DB:NAS mount:Archive DB:Frame data dir:Audio files:OKOK(4.2G)/Volumes/screenpipewill be createdOK(283 files, 318M)OK(2507 files, 267M)[+00m00s]• Counting source rows for 2026-05-11frames:6857elements:672129ui_events:7063ocr_text:2332meetings:1audio_chunks:2507audio_transcriptions:226audio_tags:0speakers:15(all-time)speaker_embeddings:58(all-time)[+00m01s] • Initialising tables (CREATE IF NOT EXISTS)creating vision tablescreating audio tables• Om00s• Om01sError: in prepare, no such column:S idx_ocr_text_install_pk ON ocr_text(install_id, id);error here---^lukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "PRAGMA table_info(ocr_text);"Olframe_idlINTEGERI11101ltext|TEXT|11102Itext_json|TEXTl01103 lapp_name | TEXT |1| ' * 104locr_engine|TEXT|1l 'unknown' 105 Iwindow_name | TEXTI011061 focused| BOOLEANIOIFALSEI07Itext_length| INTEGERI0I108lsync_id|TEXTI01109lsynced_at I DATETIME I011010|redacted_at|INTEGERI0110lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ 0• *3-zsh8• Tue 12 May 20:25:45T81*4...
|
iTerm2
|
NULL
|
NULL
|
27883
|
|
27884
|
tr appsettings.jsor555565555565555555*SS tr appsettings.jsor555565555565555555*SSH: nas iômaster ® @0A0 (g1TerminalWindow100% C4• Tue 12 May 20:25:46screenpipe SSH: nas — screenpipe_sync.sh — Moditiedif ! table_exists "$DB_SRC" "$table"; therif I tahle exicte "CNAS DRI "ctahlel. thenreturn 0sre colcetitable columns with tvnes HeDR SRc" ustable"ynas colcet/table columns HGNAS DR" "ctable"'while IFS='|* read -r name type; doecho"Snas cols" | grep -Fxq "$name"; thensqlite3 "SNAS DB" "ALTER TABLE $table ADD COLUMN \"$name)" $type;"added names="Sadded names $nameTumix botn scripts to nandle tables without an id column."Satates "SNAS_DB" "CREATE UNIQUE INDEX IF NOT EXISTS 1dx_S(tbl)_install_pk ON S(tbL)(instalLid, rowid) ."sqLites "SNAS_OB" "CREATE UNIQUE INDEX IE NOT EXISTS J0X.S(tol)_Install_pk ON S{tol)(3nstall_10, rowzd);*Fixed both scrints. They now check if a table has an di column before creatina the unique index. If the table lacks an 3dl columnl) screennine svnc.ch (line 269-375): Added check for 1a column. fallback to rouidl• ›_ screenpipe_fts_migrate.sh (line 106-113): Added check for id column, fallback to rowidYou can now retry runnina the sunc scrint from vour Mac.•П к v+8 -10 aila.screenpipelpe nsmigrate.shlpe_sync.shdb.bak-pre-installide-shmnpipe.2026-05-07.0.100-05-07-05-06-04-28-04-27-04-25-04-24-04-20-04-21-04-17-04-16-04-15ои-1лipe_sync_updated.shdb-bake-walltings. sonine.do8=mCDate ModifiedToday at 20:25Today at 20:19Todav at 20:10Today at 17:41Today at 15:20Today at 5:4810 May 2026 at 13:4710 May 2026 at 13:477 May 2026 at 21:5010 May 2026 at 12:168 Mav 2026 at 9:266 May 2026 at 21:0428 Aor 2026 at 22:2328 Apr 2026 at 9:1926 Apr 2026 at 16:3524 Aor 2026 at 22:3024 Aor 2026 at 12:0924 Apr 2026 at 12:0722 Apr 2026 at 18:4422 Anr 2026 at 0:1618 Apr 2026 at 13:3517 Apr 2026 at 8:5716 Aor 2026 at 9:1315 Anr 2026 at 0:5010 May 2026 at 13:0610 May 2026 at 12:3126 Anr 2026 at 20:1026 Apr 2026 at 17:1718 Apr 2026 at 17:4213 Aor 2026 at 17:2111 Anr 2006 at 16:519 KB Terminal scripts32 KBTerminal scriots61 KB Document70.01 GB Folden4.46 GB Document12,92 GBDocument33 K:Document573 KB Folder7 KBLog File566 KBLoa File72 GR Colder305,6 MB Folder18,8 MB Folder166.7 MB Folden339.8 MB Folder149.1 MBFolder265 5 MP Soldon171,8 MB Folder525,4 MB450 8 MR Folden699.6 MB Folder837,2 MB1.15 G:Folden100 ep Soldor20 KB11,13 GBDocument102 KPColderZero butes Document31 bytesJSONZero butes12KR Coldor"SDB_SRC" "Stable" | awk 'NF' | awk -v p="Sprefix" '{print p """ $0 "ju"}"Accent Sile 1o Reiect file Ox6Ports 1AbashA +v@Mm.lex2 files 114Ask anvthindsqlite3 /volumel/screenpipe/archive.db "SELECT COUNT(*) as total, COUNT(DISTINCT innized Ln 696, Col 8 Spaces: 2 UTF-8 LF Shell Script Teams Windsurf - Settings32 items, 1.93 TB availabld...
|
iTerm2
|
NULL
|
NULL
|
27884
|
|
27885
|
• screenpipe [ssH: nas,tr app- dataselectionlermin • screenpipe [ssH: nas,tr app- dataselectionlerminalWinaow?_screenpipe_sync.shCOSATS TARIS TE NOT GYTSTC nac. der tovtrun_sqlite heredoc "creating audio tables" "• screenpipe SSH: nas - screenpipesync.sh - Moditiedc cAS Stltc * FroM main.aud1o chunksTumix botn scripts to nandle tables without an id column."Satates "SNAS_DB" "CREATE UNIQUE INDEX IF NOT EXISTS 1dx_S(tbl)_install_pk ON S(tbl)(instalLid, rowid)."• COUNT* FROM praoma table into'stbl" WHERE name='1nsqlitesSOAS BEW NALT ER FABLE StOL ADD COLUVN installLid TEXT,sqLites "SNAS_OB" "CREATE UNIQUE INDEX IF NOT EXISTS J0X.S(tol)_Install_pk ON S{tol)(3nstall_10, rowid);*Fixed both scrints. They now check if a table has an di column before creatina the unique index. If the table lacks an 3dl columnl) screennine svnc.ch (line 269-375): Added check for 1a column. fallback to rouidl• ›_ screenpipe_fts_migrate.sh (line 106-113): Added check for id column, fallback to rowidYou can now retry runnina the sunc scriot from vour Mac.sqlite3 "SNAS_DB'"CREATE UNTOUE INDEX IF NOT EXISTS idx S{tbl} install ok ON s{tbl}(i•TABLES(al}": densure_columns•П к v+8 -10 aila.screenpipelpe nsmigrate.shlpe_sync.shdb.bak-pre-installide-shmnpipe.2026-05-07.0.1o0-05-07-05-06-04-28-04-27-04-25-04-24-04.22-04-20-04-21-04-17-04-16-04-15ои-1лipe_sync_updated.shdb-bake-walltings. sonine.do8=mCDate ModifiedTodau at 20:20Today at 20:19Todav at 20:10Today at 17:41Today at 15:20Today at 5:4810 May 2026 at 13:4710 May 2026 at 13:477 May 2026 at 21:5010 May 2026 at 12:168 Mav 2026 at 9:266 May 2026 at 21:0428 Aor 2026 at 22:2328 Apr 2026 at 9:1926 Apr 2026 at 16:3524 Aor 2026 at 22:3024 Aor 2026 at 12:0924 Apr 2026 at 12:0722 Apr 2026 at 18:4422 Anr 2026 at 0:1618 Apr 2026 at 13:3517 Apr 2026 at 8:5716 Aor 2026 at 9:1315 Anr 2026 at 0:5010 May 2026 at 13:0610 May 2026 at 12:3126 Anr 2026 at 20:1026 Apr 2026 at 17:1718 Apr 2026 at 17:4213 Aor 2026 at 17:2111 Anr 2006 at 16:51100% C4• Tue 12 May 20:25:529 KB Terminal scripts32 KBTerminal scriots61 KB Document70.01 GB Folden4.46 GB Document12,92 GBDocument33 K:Document573 KB Folder7 KBLog File566 KBLoa File72 GR Colder305,6 MB Folder18,8 MB Folder166.7 MB Folden339.8 MB Folder149.1 MBFolder265 5 MP Soldon171,8 MB Folder525,4 MB450 8 MR Folden699.6 MB Folder837,2 MB1.15 G:Folden100 ep Soldor20 KB11,13 GBDocument102 KPColderZero butes Document31 bytesJSONZero butes12KR ColdorReiect file oxaPorts1IN firames(timestamo)tetrolticeclooneliAbshA +[EMAIL] x2 files 114Ask anvthinde1/screenpipes sqlite3 /volumel/screenpipe/archive.db "SELECT COUNT(*) as total, COUNT(DISTINCT inAdm1naDYPARRAPLIS-RSER-/volunet /ecreennines n*SSH: nas iômaster ® @0A0 (g1nized Ln 696, Col 8 Spaces: 2 UTF-8 LF Shell Script Teams Windsurf - Settings32 items, 1.93 TB availabld...
|
iTerm2
|
NULL
|
NULL
|
27885
|
|
27886
|
TerminalWindowreenpipe sync.sh - ModitiedTumix bot TerminalWindowreenpipe sync.sh - ModitiedTumix botn scripts to nandle tables without an id column,+8 -1SqLIte "ANAS,DB' "CREATE UNTQUE INDEX IF NOT EXISTS J6k._S(tbl)_ instolL_pk ON S(tbl) (instalL_1d, ronie);*sqLites "SNAS_OB" "CREATE UNIQUE INDEX IE NOT EXISTS J0X.S(tol)_Install_pk ON S{tol)(3nstall_10, rowzd);*Fixed both scrints. They now check if a table has an di column before creatina the unique index. If the table lacks an 3dl columnl) screennine svnc.ch (line 269-375): Added check for 1a column. fallback to rouidl• >_ screenpipe_fts_migrate.sh (line 106-113): Added check for id column, fallback to rowidYou can now retry runnina the sunc scriot from vour Maci0 aila.2 files +14 ›Ask anvthindX SSH: nas %& master © @0A0 (1nized Ln 696, Col 8 Spaces: 2 UTF-8 LF Shell Script Teams Windsurf - Settings100% C4&• Tue 12 May 20:25:55screenpipelpe nsmigrate.shipe_sync.shdb.bak-pre-installide-shmnpipe.2026-05-07.0.100-05-07-05-06-04-28-04-27-04-25-04-24-04-22-04-20-04-21-04-17-04-16-04-15-04-14ipe_sync_updated.shdb-bake-waltings. sonine.doDate ModifiedToday at 20:25Today at 20:19Todav at 20:10Today at 17:41Today at 15:20Today at 5:4810 May 2026 at 13:4710 May 2026 at 13:477 May 2026 at 21:5010 Mav 2026 at 12:168 May 2026 at 9:266 May 2026 at 21:0228 Aor 2026 at 22:2328 Apr 2026 at 9:1926 Apr 2026 at 16:3524 Aor 2026 at 22:3024 Aor 2026 at 12:0924 Apr 2026 at 12:0722 Apr 2026 at 18:4422 Anr 2026 at 0:1618 Apr 2026 at 13:3517 Apr 2026 at 8:5716 Aor 2026 at 9:1315 Apr 2026 at 9:5910 May 2026 at 13:0610 May 2026 at 12:3126 Anr 2026 at 20:1026 Apr 2026 at 17:1718 Apr 2026 at 17:4213 Aor 2026 at 17:2111 Apr 2026 at 16:519 KB Terminal scripts32 KBTerminal scripts61 KB Document70.01 GB Folden4,46 GB Document12,92 GBDocument33 K:Document573 KB Folder7 KBLog File566 KBLoa File72 GR Colder305,6 MB Folder18,8 MB Folder166.7 MB Folden339,8 MB Folder149,1 MBFolder265 5 MP Soldon171,8 MB Folder525,4 MB450 8 MR Folden699,6 MB Folder837,2 MB1.15 G:Folden100 ep Soldor20 KB11,13 GBDocument102 KPColderZero bytes Document31 bytesJSONZero butes12KR Coldor32 items, 1,93 TB available...
|
iTerm2
|
NULL
|
NULL
|
27886
|
|
27887
|
• screenpipe [ssH: nas,tr app- dataselectionlermin • screenpipe [ssH: nas,tr app- dataselectionlerminalWindow?_screenpipe_sync.shCOSATS TARIS TE NOT GYTSTC nac. der tovtrun_sqlite heredoc "creating audio tables" "• screenpipe SSH: nas - screenpipesync.sh - Moditiedc cAS Stltc * FroM main.aud1o chunksTumix botn scripts to nandle tables without an id column."Satates "SNAS_DB" "CREATE UNIQUE INDEX IF NOT EXISTS 1dx_S(tbl)_install_pk ON S(tbl)(instalLid, rowid)."• COUNT* FROM praoma table into'stbl" WHERE name='1nsqlitesSOAS BEW NALT ER FABLE StOL ADD COLUVN installLid TEXT,sqLites "SNAS_OB" "CREATE UNIQUE INDEX IF NOT EXISTS J0X.S(tol)_Install_pk ON S{tol)(3nstall_10, rowid);*Fixed both scrints. They now check if a table has an di column before creatina the unique index. If the table lacks an 3dl columnl) screennine svnc.ch (line 269-375): Added check for 1a column. fallback to rouidl• ›_ screenpipe_fts_migrate.sh (line 106-113): Added check for id column, fallback to rowidYou can now retry runnina the sunc scriot from vour Mac.sqlite3 "SNAS_DB'"CREATE UNTOUE INDEX IF NOT EXISTS idx S{tbl} install ok ON s{tbl}(i• TABLES (al}": densure_columns•П к v+8 -10 aila.screenpipelpe nsmigrate.shlpe_sync.shdb.bak-pre-installide-shmnpipe.2026-05-07.0.1o0-05-07-05-06-04-28-04-27-04-25-04-24-04.22-04-20-04-21-04-17-04-16-04-15ои-1лipe_sync_updated.shdb-bake-walltings. sonine.do8=mCDate ModifiedToday at 20:25Today at 20:19Todav at 20:10Today at 17:41Today at 15:20Today at 5:4810 May 2026 at 13:4710 May 2026 at 13:477 May 2026 at 21:5010 May 2026 at 12:168 Mav 2026 at 9:266 May 2026 at 21:0428 Aor 2026 at 22:2328 Apr 2026 at 9:1926 Apr 2026 at 16:3524 Aor 2026 at 22:3024 Aor 2026 at 12:0924 Apr 2026 at 12:0722 Apr 2026 at 18:4422 Anr 2026 at 0:1618 Apr 2026 at 13:3517 Apr 2026 at 8:5716 Aor 2026 at 9:1315 Anr 2026 at 0:5010 May 2026 at 13:0610 May 2026 at 12:3126 Anr 2026 at 20:1026 Apr 2026 at 17:1718 Apr 2026 at 17:4213 Aor 2026 at 17:2111 Anr 2006 at 16:51100% C4• Tue 12 May 20:26:049 KB Terminal scripts32 KBTerminal scriots61 KB Document70.01 GB Folden4.46 GB Document12,92 GBDocument33 K:Document573 KB Folder7 KBLog File566 KBLoa File72 GR Colder305,6 MB Folder18,8 MB Folder166.7 MB Folden339.8 MB Folder149.1 MBFolder265 5 MP Soldon171,8 MB Folder525,4 MB450 8 MR Folden699.6 MB Folder837,2 MB1.15 G:Folden100 ep Soldor20 KB11,13 GBDocument102 KPColderZero butes Document31 bytesJSONZero butes12KR ColdorReiect file oxaPorts 1IN firames(timestamo)tetrolticeclooneliAbshA +[EMAIL] x2 files 114Ask anvthinde1/screenpipes sqlite3 /volumel/screenpipe/archive.db "SELECT COUNT(*) as total, COUNT(DISTINCT inAdm1naDYPARRAPLIS-RSER-/volunet /ecreennines n*SSH: nas iômaster ® @0A0 (g1nized Ln 696, Col 8 Spaces: 2 UTF-8 LF Shell Script Teams Windsurf - Settings32 items, 1.93 TB availabld...
|
iTerm2
|
NULL
|
NULL
|
27887
|
|
27888
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp100% <-zsh8• Tue 12 May 20:26:16T81DOCKERO 81DEV (-zsh)O ₴2lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe$lukas@Lukas-Kovaliks-MacBook-Pro-Jiminnycat screenpipe_sync.sh |pbcopy~/.screenpipe $~/.screenpipe/screenpipe_sync.sh 2026-05-11[2026-05-1220:19:37J[2026-05-1220:19:37J[2026-05-12 20:19:37]Screenpipe sync startingfor: 2026-05-11install_id: 2ff6574c-4272-4dbf-a20b-434b024c65fb[2026-05-12 20:19:37]APP (screenpipe")[+00m00s] • Preflight checksSource DB:NAS mount:Archive DB:Frame data dir:Audio files:OKOK(4.2G)/Volumes/screenpipewill be createdOK(283 files, 318M)OK(2507 files, 267M)[+00m00s]• Counting source rows for 2026-05-11frames:6857elements:672129ui_events:7063ocr_text:2332meetings:1audio_chunks:2507audio_transcriptions:226audio_tags:0speakers:15(all-time)speaker_embeddings:58(all-time)[+00m01s] • Initialising tables (CREATE IF NOT EXISTS)creating vision tablescreating audio tables• Om00s• Om01sError: in prepare, no such column:S idx_ocr_text_install_pk ON ocr_text(install_id, id);error here---^lukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "PRAGMA table_info(ocr_text);"Olframe_idlINTEGERI11101ltext|TEXT|11102Itext_json|TEXTl01103 lapp_name | TEXT |1| ' * 104locr_engine|TEXT|1l 'unknown' 105 Iwindow_name | TEXTI011061 focused| BOOLEANIOIFALSEI07Itext_length| INTEGERI0I108lsync_id|TEXTI01109lsynced_at I DATETIME I011010|redacted_at|INTEGERI0110lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ 0• *3-zsh...
|
iTerm2
|
NULL
|
NULL
|
27888
|
|
27889
|
100% C4• Tue 12 May 20:26:36Tiltix both scripts to 100% C4• Tue 12 May 20:26:36Tiltix both scripts to nandle tables without an id column,Sqtates "SASLDB "CREATE UNIQUE INDEX IF NOT EXISTS idX_S(tbl)_install_pk ON S(tbl)(instat(_id, rowid);"salite? "SNAS DB" "CREATE UNTOUE INDEX IF NOT EXTSTS idx s<tbuinstall.ok ON S<tbl(instali_id, rowid):*Fixed both scrints. They now check if a table hac an 4dl column before creatina the unique indey If the table lacks an sal columnl•, screennine svnc.sh (line 260-275)- Added check for sdl column fallback to rousdl• ›_ screenpipe_fts_migrate.sh (line 106-113): Added check for id column, fallback to rowidYou can now retry running the sunc scrint from vour Mac.•П к vscreenpipelpe nsmigrate.shlpe_sync.shdb.bak-pre-installide-shmnpipe.2026-05-07.0.1o0-05-07-05-06-04-28-04-27-04-25-04-24-04-20-04-21-04-17-04-16-04-15Mal.ои-1лipe_sync_updated.shdb-bake-walltings. sonine.do8=mC• screenpipe [SSH: nas), _ #recycietr app- data-archive.do.oak-pre-installic•db.saliteescreenpine.dbSelectionViewTerminalWindowHelpscreenpipe SSH: nas — screenpipe sync.sh — Moditiedscreenpipe fts miarate.sh UCREATE TABLE IF NOT EXISTS nas.ocr textWHERE 0CREATE TABLE IF NOT EXISTS nas.video chunks AS SELECT * FROM main.video chunks WHERE 0-CREATE TABLE IF NOT EXISTS nas.meetinasWHERE ODETACH nas:run salite heredoc "creatina audio tables""ATTACH ISNAS DR' AS nas.CREATE TABLE IF NOT EXISTS nas.audio chunksAS SELECT * FROM main. audio chunksGREATE TARLE TE NOT SXTSTS nas.audio transcrintions AS SELECT * FROM main.audio transcrintionsCREATE TABLE IF NOT EXISTS nas. speakersiCREATE TABLE IF NOT EXISTS nas.speaker_embeddingsCREATE TABLE IF NOT EXISTS nas.audio_tagsAS SELECT * FROM main.speaker_embeddings# Re-run install_id + index setup so freshly-created tables get them too.for thi in "efall SYNG TARlEciall". doHAS_COL=$(sqlite3 "$NAS_DB" "SELECT COUNT(*) FROM pragma_table_info('$tbl') WHERE name='iniff HeHAS GOI" = "qu 1. thensqlite3 "SNAS_DB" "ALTER TABLE $tbl ADD COLUMN install id TEXT;"# Check if table has 'id' column before creating indexHAS ID=$(sqlite3 "$NAS DB" "SELECT COUNT(*) FROM pragma table info('$tbl') WHERE name='id';if [ "$HAS_ID" -gt "0" ]; thensqlite3 "SNAS DB" "CREATE UNIQUE INDEX IF NOT EXISTS idx S{tbl} install pk ON ${tbl}(inst)elce# For tahlec without lidi, uce rowid incteadsqlite3 "$NAS_DB" "CREATE UNIQUE INDEX IF NOT EXISTS idx_${tbl}_install_pk ON ${tbl}(inst270SCHEMA neTET290291step "Reconciling NAS schema with source"for tbl in "${ALL_SYNC_TABLES[@]}"; do2922921294295run_sqlite heredoc "creating indexes"ATTACH 'SNAS DB' AS nas;387299GREATE TNOSY TE NOT FYTSTS nas.idy frames +imectamnON frames(timestamp):290200391ProblemsOutouPorts (abashA +v@Mm .Ie xDate ModifiedToday at 20:25Today at 20:19Todav at 20:10Today at 17:41Today at 15:20Today at 5:4810 May 2026 at 13:4710 May 2026 at 13:477 May 2026 at 21:5010 Mav 2026 at 12:168 Mav 2026 at 9:266 May 2026 at 21:0428 Aor 2026 at 22:2328 Apr 2026 at 9:1926 Apr 2026 at 16:3524 Aor 2026 at 22:3024 Aor 2026 at 12:0924 Apr 2026 at 12:0722 Apr 2026 at 18:4422 Anr 2026 at 0:1618 Apr 2026 at 13:3517 Apr 2026 at 8:5716 Aor 2026 at 9:1315 Anr 2026 at 0:5010 May 2026 at 13:0610 May 2026 at 12:3126 Anr 2026 at 20:1026 Apr 2026 at 17:1718 Apr 2026 at 17:4213 Aor 2026 at 17:2111 Anr 2006 at 16:519 KB Terminal scripts32 KBTerminal scriots61 KB Document70.01 GB Folden4.46 GB Document12,92 GBDocument33 K:Document573 KB Folder7 KBLog File566 KBLoa File72 GR Colder305,6 MB Folder18,8 MB Folder166.7 MB Folden339.8 MB Folder149.1 MBFolder265 5 MP Soldon171,8 MB Folder525,4 MB450 8 MR Folden699.6 MB Folder837,2 MB1.15 G:Folden100 ep Soldor20 KB11,13 GBDocument102 KPColderZero butes Document31 bytesJSONZero butes12KR Coldor1 uaa ree pe lte olue /serensipecartive d SsatEer Cunrite) as total, COMIOSTINET 112 files 114Ask anvthind*SSH: nas iômaster @oA0 (g1nized Ln 696, Col 8 Spaces: 2 UTF-8 LF Shell Script Teams Windsurf - Settings32 items, 1.93 TB availabld...
|
iTerm2
|
NULL
|
NULL
|
27889
|
|
27890
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp100% C7-zsh8• Tue 12 May 20:26:46T81DOCKERO 81DEV (-zsh)O ₴2lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe$lukas@Lukas-Kovaliks-MacBook-Pro-Jiminnycat screenpipe_sync.sh |pbcopy~/.screenpipe $~/.screenpipe/screenpipe_sync.sh 2026-05-11[2026-05-1220:19:37J[2026-05-1220:19:37J[2026-05-12 20:19:37]Screenpipe sync startingfor: 2026-05-11install_id: 2ff6574c-4272-4dbf-a20b-434b024c65fb[2026-05-12 20:19:37]APP (screenpipe")[+00m00s] • Preflight checksSource DB:NAS mount:Archive DB:Frame data dir:Audio files:OKOK(4.2G)/Volumes/screenpipewill be createdOK(283 files, 318M)OK(2507 files, 267M)[+00m00s]• Counting source rows for 2026-05-11frames:6857elements:672129ui_events:7063ocr_text:2332meetings:1audio_chunks:2507audio_transcriptions:226audio_tags:0speakers:15(all-time)speaker_embeddings:58(all-time)[+00m01s] • Initialising tables (CREATE IF NOT EXISTS)creating vision tablescreating audio tables• Om00s• Om01sError: in prepare, no such column:S idx_ocr_text_install_pk ON ocr_text(install_id, id);error here---^lukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "PRAGMA table_info(ocr_text);"Olframe_idlINTEGERI11101ltext|TEXT|11102Itext_json|TEXTl01103 lapp_name | TEXT |1| ' * 104locr_engine|TEXT|1l 'unknown' 105 Iwindow_name | TEXTI011061 focused| BOOLEANIOIFALSEI07Itext_length| INTEGERI0I108lsync_id|TEXTI01109lsynced_at I DATETIME I011010|redacted_at|INTEGERI0110lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ 03,- 883-zsh...
|
iTerm2
|
NULL
|
NULL
|
27890
|
|
27891
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp100% C7-zshDOCKER• 81DEV (-zsh)O ₴2lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe$lukas@Lukas-Kovaliks-MacBook-Pro-Jiminnycat screenpipe_sync.sh |pbcopy~/.screenpipe $~/.screenpipe/screenpipe_sync.sh 2026-05-11[2026-05-1220:19:37J[2026-05-1220:19:37J[2026-05-12 20:19:37]Screenpipe sync startingfor: 2026-05-11install_id: 2ff6574c-4272-4dbf-a20b-434b024c65fb[2026-05-12 20:19:37]APP (screenpipe")[+00m00s] • Preflight checksSource DB:NAS mount:Archive DB:Frame data dir:Audio files:OKOK(4.2G)/Volumes/screenpipewill be createdOK(283 files, 318M)OK(2507 files, 267M)[+00m00s]• Counting source rows for 2026-05-11frames:6857elements:672129ui_events:7063ocr_text:2332meetings:1audio_chunks:2507audio_transcriptions:226audio_tags:0speakers:15(all-time)speaker_embeddings:58(all-time)[+00m01s] • Initialising tables (CREATE IF NOT EXISTS)creating vision tablescreating audio tables• Om00s• Om01sError: in prepare, no such column:S idx_ocr_text_install_pk ON ocr_text(install_id, id);error here---^lukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "PRAGMA table_info(ocr_text);"Olframe_idlINTEGERI11101ltext|TEXT|11102Itext_json|TEXTl01103 lapp_name | TEXT|1| ' '104locr_engine|TEXT|1l 'unknown' 105 Iwindow_name | TEXTI011061 focused| BOOLEANIOIFALSEI07Itext_length| INTEGERI0I108lsync_id|TEXTI01109lsynced_at I DATETIME I011010|redacted_at|INTEGERI0110lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ 0• *3-zsh8• Tue 12 May 20:26:54T81*4...
|
iTerm2
|
NULL
|
NULL
|
27891
|
|
27892
|
selection› Ch appc c© screenpipe.db* SSH: nas& selection› Ch appc c© screenpipe.db* SSH: nas&master* 00A0 Д1Terminal100% C48• Tue 12 May 20:26:54screenpipe SSH: nas — screenpipe_sync.sh — Moditied00KvsaLite? HANAS DR" "CREATE UNTOUE INDSX TF MOT SXTSTS Jdx S/tbl). install ok ON S/tbl)(install fd. rouid)•"+8-1Fixed both scripts. They now check if a table has an id column before creating the unique index. If the table lacks an id column• >_ screenpipe_sync.sh (line 369-375): Added check for id column, fallback to rowid• ›_ screenpipe_fts_migrate.sh (line 106-113): Added check for id column, fallback to rowidYou can now retry runnina the svnc scriot from vour Maclscreenpipelpe ns_migrate.snipe_sync.shdb.bak-pre-installide-shmnpipe.2026-05-07.0.1o0-05-07-05-06-04-28-04-27-04-25-04-24-04-22-04-20-04-21-04-17-04-16-04-15-04-14ipe_sync_updated.shdb-bake-waltings. sonine.doDate ModifiedToday at 20:25Today at 20:19Todav at 20:10Today at 17:41Today at 15:20Today at 5:4810 May 2026 at 13:4710 May 2026 at 13:477 May 2026 at 21:5010 Mav 2026 at 12:168 May 2026 at 9:266 May 2026 at 21:0228 Aor 2026 at 22:2328 Apr 2026 at 9:1926 Apr 2026 at 16:3524 Aor 2026 at 22:3024 Aor 2026 at 12:0924 Apr 2026 at 12:0722 Apr 2026 at 18:4422 Anr 2026 at 0:1618 Apr 2026 at 13:3517 Apr 2026 at 8:5716 Aor 2026 at 9:1315 Apr 2026 at 9:5910 May 2026 at 13:0610 May 2026 at 12:3126 Anr 2026 at 20:1026 Apr 2026 at 17:1718 Apr 2026 at 17:4213 Aor 2026 at 17:2111 Apr 2026 at 16:519 KB Terminal scripts32 KBTerminal scripts61 KB Document70.01 GB Folden4,46 GB Document12,92 GBDocument33 K:Document573 KB Folder7 KBLog File566 KBLoa File72 GR Colder305,6 MB Folder18,8 MB Folder166.7 MB Folden339,8 MB Folder149,1 MBFolder265 5 MP Soldon171,8 MB Folder525,4 MB450 8 MR Folden699,6 MB Folder837,2 MB1.15 G:Folden100 ep Soldor20 KB11,13 GBDocument102 KPColderZero bytes Document31 bytesJSONZero butes12KR ColdorAT e de e iecesting inenes e@bashA +w@wd.|ex2 files +14 ›Ask anvthindized Ln 696, Col 8 Spaces: 2 UTF-8 LF Shell Script Teams Windsurf - Settings32 items, 1,93 TB available...
|
iTerm2
|
NULL
|
NULL
|
27892
|
|
27893
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp100% <-zsh8• Tue 12 May 20:26:58T81DOCKERO 81DEV (-zsh)O ₴2lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe$lukas@Lukas-Kovaliks-MacBook-Pro-Jiminnycat screenpipe_sync.sh |pbcopy~/.screenpipe $~/.screenpipe/screenpipe_sync.sh 2026-05-11[2026-05-1220:19:37J[2026-05-1220:19:37J[2026-05-12 20:19:37]Screenpipe sync startingfor: 2026-05-11install_id: 2ff6574c-4272-4dbf-a20b-434b024c65fb[2026-05-12 20:19:37]APP (screenpipe")[+00m00s] • Preflight checksSource DB:NAS mount:Archive DB:Frame data dir:Audio files:OKOK(4.2G)/Volumes/screenpipewill be createdOK(283 files, 318M)OK(2507 files, 267M)[+00m00s]• Counting source rows for 2026-05-11frames:6857elements:672129ui_events:7063ocr_text:2332meetings:1audio_chunks:2507audio_transcriptions:226audio_tags:0speakers:15(all-time)speaker_embeddings:58(all-time)[+00m01s] • Initialising tables (CREATE IF NOT EXISTS)creating vision tablescreating audio tables• Om00s• Om01sError: in prepare, no such column:S idx_ocr_text_install_pk ON ocr_text(install_id, id);error here---^lukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "PRAGMA table_info(ocr_text);"Olframe_idlINTEGERI11101ltext|TEXT|11102Itext_json|TEXTl01103 lapp_name | TEXT |1| ' * 104locr_engine|TEXT|1l 'unknown' 105 Iwindow_name | TEXTI011061 focused| BOOLEANIOIFALSEI07Itext_length| INTEGERI0I108lsync_id|TEXTI01109lsynced_at I DATETIME I011010|redacted_at|INTEGERI0110lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ 0• *3-zsh...
|
iTerm2
|
NULL
|
NULL
|
27893
|
|
27894
|
SelectionTerminalWindow100% C48• Tue 12 May 20:26: SelectionTerminalWindow100% C48• Tue 12 May 20:26:58screenpipe [SSH: nas] — screenpipe_sync.sh — Modified00Kv> Ch appGiac csaLite? HANAS DR" "CREATE UNTOUE INDSX TF MOT SXTSTS Jdx S/tbl). install ok ON S/tbl)(install fd. rouid)•"+8-1© screenpipe.dbFixed both scripts. They now check if a table has an id column before creating the unique index. If the table lacks an id column• > screenpipe_sync.sh (line 369-375): Added check for id column, fallback to rowid• ›_ screenpipe_fts_migrate.sh (line 106-113): Added check for id column, fallback to rowidYou can now retry runnina the svnc scriot from vour Maclscreenpipelpe ns_migrate.snipe_sync.shdb.bak-pre-installide-shmnpipe.2026-05-07.0.1o0-05-07-05-06-04-28-04-27-04-25-04-24-04-22-04-20-04-21-04-17-04-16-04-15-04-14ipe_sync_updated.shdb-bake-waltings. sonine.doDate ModifiedToday at 20:25Today at 20:19Todav at 20:10Today at 17:41Today at 15:20Today at 5:4810 May 2026 at 13:4710 May 2026 at 13:477 May 2026 at 21:5010 Mav 2026 at 12:168 May 2026 at 9:266 May 2026 at 21:0228 Aor 2026 at 22:2328 Apr 2026 at 9:1926 Apr 2026 at 16:3524 Aor 2026 at 22:3024 Aor 2026 at 12:0924 Apr 2026 at 12:0722 Apr 2026 at 18:4422 Anr 2026 at 0:1618 Apr 2026 at 13:3517 Apr 2026 at 8:5716 Aor 2026 at 9:1315 Apr 2026 at 9:5910 May 2026 at 13:0610 May 2026 at 12:3126 Anr 2026 at 20:1026 Apr 2026 at 17:1718 Apr 2026 at 17:4213 Aor 2026 at 17:2111 Apr 2026 at 16:519 KB Terminal scripts32 KBTerminal scripts61 KB Document70.01 GB Folden4,46 GB Document12,92 GBDocument33 K:Document573 KB Folder7 KBLog File566 KBLoa File72 GR Colder305,6 MB Folder18,8 MB Folder166.7 MB Folden339,8 MB Folder149,1 MBFolder265 5 MP Soldon171,8 MB Folder525,4 MB450 8 MR Folden699,6 MB Folder837,2 MB1.15 G:Folden100 ep Soldor20 KB11,13 GBDocument102 KPColderZero bytes Document31 bytesJSONZero butes12KR ColdorObash A +w@md.Iax2 files +10 ›Ask anvthind* SSH: nas&master* 00A0 Д1ized Ln 696, Col 8 Spaces: 2 UTF-8 LF Shell Script Teams Windsurf - Settings32 items, 1,93 TB available...
|
iTerm2
|
NULL
|
NULL
|
27894
|
|
27895
|
Selection› Ch appc c© screenpipe.dbK SSH: nas %&am Selection› Ch appc c© screenpipe.dbK SSH: nas %& master O ®0 A0 ( 1TerminalWindow100% C48• Tue 12 May 20:26:59screenpipe SSH: nas — screenpipe_sync.sh — ModitiedTumix botn scripts to nandle tables without an id column,SqLIte "ANAS,DB' "CREATE UNTQUE INOEX IF NOT EXISTS 16k.S(tbl) instalLgk ON S(tbl)(instalL_1d, ronid);,™sqlite3 "SNAS_DB" "ALTER TABLE $tbl ADD COLUMN install_id TEXT;sqLites "SNAS_OB" "CREATE UNIQUE INDEX IF NOT EXISTS JdX_S(tol)_Install_pk ON S{tol)(3nstall_10, rowzd);*Fixed both scrints. They now check if a table has an di column before creatina the unique index. If the table lacks an 3dl columnl) screennine svnc.ch (line 269-375): Added check for 1a column. fallback to rouidl• ›_ screenpipe_fts_migrate.sh (line 106-113): Added check for id column, fallback to rowidYou can now retry runnina the sunc scrint from vour Mac.00Kvscreenpipe+8 -10 aila.ipe_fts_migrate.shipe_sync.shdb.bak-pre-installide-shmnpipe.2026-05-07.0.1o0-05-07-05-06-04-28-04-27-04-25-04-24-04-22-04-20-04-21-04-17-04-16-04-15-04-14ipe_sync_updated.shdb-bake-waltings. sonine.doDate ModifiedToday at 20:25Today at 20:19Todav at 20:10Today at 17:41Today at 15:20Today at 5:4810 May 2026 at 13:4710 May 2026 at 13:477 May 2026 at 21:5010 Mav 2026 at 12:168 May 2026 at 9:266 May 2026 at 21:0228 Aor 2026 at 22:2328 Apr 2026 at 9:1926 Apr 2026 at 16:3524 Aor 2026 at 22:3024 Aor 2026 at 12:0924 Apr 2026 at 12:0722 Apr 2026 at 18:4422 Anr 2026 at 0:1618 Apr 2026 at 13:3517 Apr 2026 at 8:5716 Aor 2026 at 9:1315 Apr 2026 at 9:5910 May 2026 at 13:0610 May 2026 at 12:3126 Anr 2026 at 20:1026 Apr 2026 at 17:1718 Apr 2026 at 17:4213 Aor 2026 at 17:2111 Apr 2026 at 16:519 KB Terminal scripts32 KBTerminal scripts61 KB Document70.01 GB Folden4,46 GB Document12,92 GBDocument33 K:Document573 KB Folder7 KBLog File566 KBLoa File72 GR Colder305,6 MB Folder18,8 MB Folder166.7 MB Folden339,8 MB Folder149,1 MBFolder265 5 MP Soldon171,8 MB Folder525,4 MB450 8 MR Folden699,6 MB Folder837,2 MB1.15 G:Folden100 ep Soldor20 KB11,13 GBDocument102 KPColderZero bytes Document31 bytesJSONZero butes12KR ColdorATAd e ere icestig intoes@bashA +v@wdIexAsk anvthindnized Ln 696, Col 8 Spaces: 2 UTF-8 LF Shell Script Teams Windsurf - Settings32 items, 1,93 TB available...
|
iTerm2
|
NULL
|
NULL
|
27895
|
|
27896
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp100% C7-zsh8• Tue 12 May 20:27:00T81DOCKERO 81DEV (-zsh)O ₴2lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe$lukas@Lukas-Kovaliks-MacBook-Pro-Jiminnycat screenpipe_sync.sh |pbcopy~/.screenpipe $~/.screenpipe/screenpipe_sync.sh 2026-05-11[2026-05-1220:19:37J[2026-05-1220:19:37J[2026-05-12 20:19:37]Screenpipe sync startingfor: 2026-05-11install_id: 2ff6574c-4272-4dbf-a20b-434b024c65fb[2026-05-12 20:19:37]APP (screenpipe")[+00m00s] • Preflight checksSource DB:NAS mount:Archive DB:Frame data dir:Audio files:OKOK(4.2G)/Volumes/screenpipewill be createdOK(283 files, 318M)OK(2507 files, 267M)[+00m00s]• Counting source rows for 2026-05-11frames:6857elements:672129ui_events:7063ocr_text:2332meetings:1audio_chunks:2507audio_transcriptions:226audio_tags:0speakers:15(all-time)speaker_embeddings:58(all-time)[+00m01s] • Initialising tables (CREATE IF NOT EXISTS)creating vision tablescreating audio tables• 0m00s• Om01sError: in prepare, no such column:S idx_ocr_text_install_pk ON ocr_text(install_id, id);error here---^lukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "PRAGMA table_info(ocr_text);"Olframe_idlINTEGERI11101ltext|TEXT|11102Itext_json|TEXTl01103 lapp_name | TEXT |1| ' * 104locr_engine|TEXT|1l 'unknown' 105 Iwindow_name | TEXTI011061 focused| BOOLEANIOIFALSEI07Itext_length| INTEGERI0I108lsync_id|TEXTI01109lsynced_at I DATETIME I011010|redacted_at|INTEGERI0110lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ 0• *3-zsh...
|
iTerm2
|
NULL
|
NULL
|
27896
|
|
27897
|
Selection› Ch appc c© screenpipe.dbK SSH: nas %&am Selection› Ch appc c© screenpipe.dbK SSH: nas %& master O ®0 A0 ( 1TerminalWindow100% C4&• Tue 12 May 20:27:00screenpipe SSH: nas — screenpipe_sync.sh — ModitiedTumix botn scripts to nandle tables without an id column,SqLIte "ANAS,DB' "CREATE UNTQUE INOEX IF NOT EXISTS 16k.S(tbl) instalLgk ON S(tbl)(instalL_1d, ronid);,™sqlite3 "SNAS_DB" "ALTER TABLE $tbl ADD COLUMN install_id TEXT;sqLites "SNAS_OB" "CREATE UNIQUE INDEX IF NOT EXISTS JdX_S(tol)_Install_pk ON S{tol)(3nstall_10, rowzd);*Fixed both scrints. They now check if a table has an di column before creatina the unique index. If the table lacks an 3dl columnl) screennine svnc.ch (line 269-375): Added check for 1a column. fallback to rouidl• ›_ screenpipe_fts_migrate.sh (line 106-113): Added check for id column, fallback to rowidYou can now retry runnina the sunc scrint from vour Mac.00Kvscreenpipe+8 -1C 0 ail aipe_fts_migrate.shipe_sync.shdb.bak-pre-installide-shmnpipe.2026-05-07.0.1o0-05-07-05-06-04-28-04-27-04-25-04-24-04-22-04-20-04-21-04-17-04-16-04-15-04-14ipe_sync_updated.shdb-bake-waltings. sonine.doDate ModifiedTodau at 20:20Today at 20:19Todav at 20:10Today at 17:41Today at 15:20Today at 5:4810 May 2026 at 13:4710 May 2026 at 13:477 May 2026 at 21:5010 Mav 2026 at 12:168 May 2026 at 9:266 May 2026 at 21:0228 Aor 2026 at 22:2328 Apr 2026 at 9:1926 Apr 2026 at 16:3524 Aor 2026 at 22:3024 Aor 2026 at 12:0924 Apr 2026 at 12:0722 Apr 2026 at 18:4422 Anr 2026 at 0:1618 Apr 2026 at 13:3517 Apr 2026 at 8:5716 Aor 2026 at 9:1315 Apr 2026 at 9:5910 May 2026 at 13:0610 May 2026 at 12:3126 Anr 2026 at 20:1026 Apr 2026 at 17:1718 Apr 2026 at 17:4213 Aor 2026 at 17:2111 Apr 2026 at 16:519 KB Terminal scripts32 KB61 KB Document70.01 GB Folden4,46 GB Document12,92 GBDocument33 K:Document573 KB Folder7 KBLog File566 KBLoa File72 GR Colder305,6 MB Folder18,8 MB Folder166.7 MB Folden339,8 MB Folder149,1 MBFolder265 5 MP Soldon171,8 MB Folder525,4 MB450 8 MR Folden699,6 MB Folder837,2 MB1.15 G:Folden100 ep Soldor20 KB11,13 GBDocument102 KPColderZero bytes Document31 bytesJSONZero butes12KR ColdorATAd e ere icestig intoes@bashA +v@wdIexAsk anvthindnized Ln 696, Col 8 Spaces: 2 UTF-8 LF Shell Script Teams Windsurf - Settings32 items, 1,93 TB available...
|
iTerm2
|
NULL
|
NULL
|
27897
|
|
27898
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp100% C7-zsh8• Tue 12 May 20:27:06T81DOCKERO 81DEV (-zsh)O ₴2lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe$lukas@Lukas-Kovaliks-MacBook-Pro-Jiminnycat screenpipe_sync.sh |pbcopy~/.screenpipe $~/.screenpipe/screenpipe_sync.sh 2026-05-11[2026-05-1220:19:37J[2026-05-1220:19:37J[2026-05-12 20:19:37]Screenpipe sync startingfor: 2026-05-11install_id: 2ff6574c-4272-4dbf-a20b-434b024c65fb[2026-05-12 20:19:37]APP (screenpipe")[+00m00s] • Preflight checksSource DB:NAS mount:Archive DB:Frame data dir:Audio files:OKOK(4.2G)/Volumes/screenpipewill be createdOK(283 files, 318M)OK(2507 files, 267M)[+00m00s]• Counting source rows for 2026-05-11frames:6857elements:672129ui_events:7063ocr_text:2332meetings:1audio_chunks:2507audio_transcriptions:226audio_tags:0speakers:15(all-time)speaker_embeddings:58(all-time)[+00m01s] • Initialising tables (CREATE IF NOT EXISTS)creating vision tablescreating audio tables• Om00s• Om01sError: in prepare, no such column:S idx_ocr_text_install_pk ON ocr_text(install_id, id);error here---^lukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "PRAGMA table_info(ocr_text);"Olframe_idlINTEGERI11101ltext|TEXT|11102Itext_json|TEXTl01103 lapp_name | TEXT |1| ' * 104locr_engine|TEXT|1l 'unknown' 105 Iwindow_name | TEXTI011061 focused| BOOLEANIOIFALSEI07Itext_length| INTEGERI0I108lsync_id|TEXTI01109lsynced_at I DATETIME I011010|redacted_at|INTEGERI0110lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ 0• *3-zsh...
|
iTerm2
|
NULL
|
NULL
|
27898
|
|
27899
|
SelectionTerminalWindowscreenpipe SSH: nas — scree SelectionTerminalWindowscreenpipe SSH: nas — screenpipe_sync.sh — Moditiedscreenpipe sync.sh M X• screenpipe [SSH: nas)tr app- dataarchive.db.bak-pre-installidTumix botn scripts to nandle tables without an id column.c c# screenpine.db"creating audio tables" "EBEES'SELECT COUNT(* FROM oraama table info('stbl') WHERE name='isalite? "SNAS DR" "ALTER TABLE Stbl ADD COLUMN install id TEXT."sqtates "SAS_DB" "CREATE UNIQUE INDEX IF NOT EXISTS 1dx_S(tbl)_install_pk ON S(tbL)(instalLid, rowid) ."sqlite3 "SNAS_DB" "CREATE UNIQUE INDEX IF NOT EXISTS idx_${tbl}_install_pk ON ${tbl}(instsqLites "SNAS_OB" "CREATE UNIQUE INDEX IF NOT EXISTS JdX_S(tol)_Install_pk ON S{tol)(3nstall_10, rowzd);*Fixed both scrints. They now check if a table has an di column before creatina the unique index. If the table lacks an 3dl columnl•) screennine svnc.ch (line 269-375): Added check for 1a column. fallback to rouidl• ›_ screenpipe_fts_migrate.sh (line 106-113): Added check for id column, fallback to rowidYou can now retry runnina the sunc scrint from vour Mac.•П к v+8 -10 aila.screenpipelpe nsmigrate.shlpe_sync.shdb.bak-pre-installide-shmnpipe.2026-05-07.0.100-05-07-05-06-04-28-04-27-04-25-04-24-04.22-04-20-04-21-04-17-04-16-04-15ои-1лipe_sync_updated.shdb-bake-walltings. sonine.do8=mCDate ModifiedTodau at 20:20Today at 20:19Todav at 20:10Today at 17:41Today at 15:20Today at 5:4810 May 2026 at 13:4710 May 2026 at 13:477 May 2026 at 21:5010 May 2026 at 12:168 Mav 2026 at 9:266 May 2026 at 21:0428 Aor 2026 at 22:2328 Apr 2026 at 9:1926 Apr 2026 at 16:3524 Aor 2026 at 22:3024 Aor 2026 at 12:0924 Apr 2026 at 12:0722 Apr 2026 at 18:4422 Anr 2026 at 0:1618 Apr 2026 at 13:3517 Apr 2026 at 8:5716 Aor 2026 at 9:1315 Anr 2026 at 0:5010 May 2026 at 13:0610 May 2026 at 12:3126 Anr 2026 at 20:1026 Apr 2026 at 17:1718 Apr 2026 at 17:4213 Aor 2026 at 17:2111 Anr 2006 at 16:51100% C4• Tue 12 May 20:27:069 KB Terminal scripts32 KB61 KB Document70.01 GB Folden4.46 GB Document12,92 GBDocument33 K:Document573 KB Folder7 KBLog File566 KBLoa File72 GR Colder305,6 MB Folder18,8 MB Folder166.7 MB Folden339.8 MB Folder149.1 MBFolder265 5 MP Soldon171,8 MB Folder525,4 MB450 8 MR Folden699.6 MB Folder837,2 MB1.15 G:Folden100 ep Soldor20 KB11,13 GBDocument102 KPColderZero butes Document31 bytesJSONZero butes12KR Coldorensure_columns "$tbl"ATTACH SitSDereAse "ereating indexes" n'$NAS DB' AS nas;ON frames(video chunk id):(abashA +v@ Mm.Ie xAsk anvthind* SSH: nas iômaster @0A0 (g1ó Not Committed Yet Screen Reader Optimized Ln 372, Col 57 Spaces: 2 UTF-8 LF Shell Script Teams Windsurf - Settings32 items, 1.93 TB availabld...
|
iTerm2
|
NULL
|
NULL
|
27899
|
|
27900
|
Selectiona screenpipe (SSH: nas) - screenpipe_sync Selectiona screenpipe (SSH: nas) - screenpipe_sync.sh - Modified› Ch appTumix botn scripts to nandle tables without an id column,+8 -1SqLIte "ANAS,DB' "CREATE UNTQUE INDEX IF NOT EXISTS 6.S(tbl)_ instolL_pk ON S(tbl (instalL_1d, romid);*sqLites "SNAS_OB" "CREATE UNIQUE INDEX IF NOT EXISTS JdX_S(tol)_Install_pk ON S{tol)(3nstall_10, rowzd);*Fixed both scrints. They now check if a table has an di column before creatina the unique index. If the table lacks an 3dl columnl) screennine svnc.ch (line 269-375): Added check for 1a column. fallback to rouidl• ›_ screenpipe_fts_migrate.sh (line 106-113): Added check for id column, fallback to rowidYou can now retry runnina the sunc scrint from vour Mac.C 0 ail aAsk anvthindtted Yet Screen Reader Optimized Ln 377, Col 7 (820 selected) Spaces: 2 UTF-8 LF Shell Script Teams Windsurf - Settings100% C4&• Tue 12 May 20:27:08screenpipeipe_fts_migrate.shipe_sync.shdb.bak-pre-installide-shmnpipe.2026-05-07.0.1o0-05-07-05-06-04-28-04-27-04-25-04-24-04-22-04-20-04-21-04-17-04-16-04-15-04-14ipe_sync_updated.shdb-bake-waltings. sonine.doDate ModifiedTodau at 20:20Today at 20:19Todav at 20:10Today at 17:41Today at 15:20Today at 5:4810 May 2026 at 13:4710 May 2026 at 13:477 May 2026 at 21:5010 Mav 2026 at 12:168 May 2026 at 9:266 May 2026 at 21:0228 Aor 2026 at 22:2328 Apr 2026 at 9:1926 Apr 2026 at 16:3524 Aor 2026 at 22:3024 Aor 2026 at 12:0924 Apr 2026 at 12:0722 Apr 2026 at 18:4422 Anr 2026 at 0:1618 Apr 2026 at 13:3517 Apr 2026 at 8:5716 Aor 2026 at 9:1315 Apr 2026 at 9:5910 May 2026 at 13:0610 May 2026 at 12:3126 Anr 2026 at 20:1026 Apr 2026 at 17:1718 Apr 2026 at 17:4213 Aor 2026 at 17:2111 Apr 2026 at 16:519 KB Terminal scripts32 KB61 KB Document70.01 GB Folden4,46 GB Document12,92 GBDocument33 K:Document573 KB Folder7 KBLog File566 KBLoa File72 GR Colder305,6 MB Folder18,8 MB Folder166.7 MB Folden339,8 MB Folder149,1 MBFolder265 5 MP Soldon171,8 MB Folder525,4 MB450 8 MR Folden699,6 MB Folder837,2 MB1.15 G:Folden100 ep Soldor20 KB11,13 GBDocument102 KPColderZero bytes Document31 bytesJSONZero butes12KR Coldor32 items, 1,93 TB available...
|
iTerm2
|
NULL
|
NULL
|
27900
|
|
27901
|
Last login: Tue May 12 20:12:05 on ttys007
Poetry Last login: Tue May 12 20:12:05 on ttys007
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/jiminny/app (JY-20725-handle-HS-search-rate-limit) $ open ~/.screenpipe
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/jiminny/app (JY-20725-handle-HS-search-rate-limit) $ cd ~/.screenpipe
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ll
total 8720288
drwxr-xr-x 21 lukas staff 672 12 May 09:21 .
drwx------+ 96 lukas staff 3072 12 May 20:12 ..
-rw-r--r--@ 1 lukas staff 6148 12 May 20:14 .DS_Store
-rw-r--r--@ 1 lukas staff 37 11 May 20:54 .sync_install_id
-rw-r--r-- 1 lukas staff 0 10 May 14:43 clipboard-disabled-after-crash
drwxr-xr-x 3660 lukas staff 117120 12 May 17:41 data
-rw-r--r--@ 1 lukas staff 4457357312 12 May 17:41 db.sqlite
-rw-r--r-- 1 lukas staff 65536 12 May 09:26 db.sqlite-shm
-rw-r--r-- 1 lukas staff 5001712 12 May 17:41 db.sqlite-wal
drwxr-xr-x 9 lukas staff 288 10 May 11:39 pipes
-rw-r--r-- 1 lukas staff 28408 6 May 21:02 screenpipe.2026-05-06.0.log
-rw-r--r-- 1 lukas staff 566164 7 May 21:50 screenpipe.2026-05-07.0.log
-rw-r--r-- 1 lukas staff 382102 8 May 22:20 screenpipe.2026-05-08.0.log
-rw-r--r-- 1 lukas staff 167023 9 May 23:04 screenpipe.2026-05-09.0.log
-rw-r--r-- 1 lukas staff 88266 10 May 23:51 screenpipe.2026-05-10.0.log
-rw-r--r-- 1 lukas staff 528943 11 May 22:54 screenpipe.2026-05-11.0.log
-rw-r--r-- 1 lukas staff 245484 12 May 17:39 screenpipe.2026-05-12.0.log
-rwxr-xr-x@ 1 lukas staff 32005 11 May 20:54 screenpipe_sync.sh
-rwxr-xr-x@ 1 lukas staff 14994 6 May 20:26 screenpipe_sync.sh.bak
-rwxr-xr-x@ 1 lukas staff 21485 10 May 13:34 screenpipe_sync.sh.bak2
-rw-r--r--@ 1 lukas staff 8541 11 May 20:54 sync.log
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ cat screenpipe_sync.sh | pbcopy
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ~/.screenpipe/screenpipe_sync.sh 2026-05-11
[2026-05-12 20:19:37] ========================================
[2026-05-12 20:19:37] Screenpipe sync starting for: 2026-05-11
[2026-05-12 20:19:37] install_id: 2ff6574c-4272-4dbf-a20b-434b024c65fb
[2026-05-12 20:19:37] ========================================
[+00m00s] ▶ Preflight checks
Source DB: OK (4.2G)
NAS mount: OK /Volumes/screenpipe
Archive DB: will be created
Frame data dir: OK (283 files, 318M)
Audio files: OK (2507 files, 267M)
[+00m00s] ▶ Counting source rows for 2026-05-11
frames: 6857
elements: 672129
ui_events: 7063
ocr_text: 2332
meetings: 1
audio_chunks: 2507
audio_transcriptions: 226
audio_tags: 0
speakers: 15 (all-time)
speaker_embeddings: 58 (all-time)
[+00m01s] ▶ Initialising tables (CREATE IF NOT EXISTS)
creating vision tables ✓ 0m00s
creating audio tables ✓ 0m01s
Error: in prepare, no such column: id
S idx_ocr_text_install_pk ON ocr_text(install_id, id);
error here ---^
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "PRAGMA table_info(ocr_text);"
0|frame_id|INTEGER|1||0
1|text|TEXT|1||0
2|text_json|TEXT|0||0
3|app_name|TEXT|1|''|0
4|ocr_engine|TEXT|1|'unknown'|0
5|window_name|TEXT|0||0
6|focused|BOOLEAN|0|FALSE|0
7|text_length|INTEGER|0||0
8|sync_id|TEXT|0||0
9|synced_at|DATETIME|0||0
10|redacted_at|INTEGER|0||0
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (screenpipe")
Close Tab
-zsh
Close Tab
⌥⌘1
-zsh...
|
iTerm2
|
-zsh
|
NULL
|
27901
|
|
27902
|
Last login: Tue May 12 20:12:05 on ttys007
Poetry Last login: Tue May 12 20:12:05 on ttys007
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/jiminny/app (JY-20725-handle-HS-search-rate-limit) $ open ~/.screenpipe
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/jiminny/app (JY-20725-handle-HS-search-rate-limit) $ cd ~/.screenpipe
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ll
total 8720288
drwxr-xr-x 21 lukas staff 672 12 May 09:21 .
drwx------+ 96 lukas staff 3072 12 May 20:12 ..
-rw-r--r--@ 1 lukas staff 6148 12 May 20:14 .DS_Store
-rw-r--r--@ 1 lukas staff 37 11 May 20:54 .sync_install_id
-rw-r--r-- 1 lukas staff 0 10 May 14:43 clipboard-disabled-after-crash
drwxr-xr-x 3660 lukas staff 117120 12 May 17:41 data
-rw-r--r--@ 1 lukas staff 4457357312 12 May 17:41 db.sqlite
-rw-r--r-- 1 lukas staff 65536 12 May 09:26 db.sqlite-shm
-rw-r--r-- 1 lukas staff 5001712 12 May 17:41 db.sqlite-wal
drwxr-xr-x 9 lukas staff 288 10 May 11:39 pipes
-rw-r--r-- 1 lukas staff 28408 6 May 21:02 screenpipe.2026-05-06.0.log
-rw-r--r-- 1 lukas staff 566164 7 May 21:50 screenpipe.2026-05-07.0.log
-rw-r--r-- 1 lukas staff 382102 8 May 22:20 screenpipe.2026-05-08.0.log
-rw-r--r-- 1 lukas staff 167023 9 May 23:04 screenpipe.2026-05-09.0.log
-rw-r--r-- 1 lukas staff 88266 10 May 23:51 screenpipe.2026-05-10.0.log
-rw-r--r-- 1 lukas staff 528943 11 May 22:54 screenpipe.2026-05-11.0.log
-rw-r--r-- 1 lukas staff 245484 12 May 17:39 screenpipe.2026-05-12.0.log
-rwxr-xr-x@ 1 lukas staff 32005 11 May 20:54 screenpipe_sync.sh
-rwxr-xr-x@ 1 lukas staff 14994 6 May 20:26 screenpipe_sync.sh.bak
-rwxr-xr-x@ 1 lukas staff 21485 10 May 13:34 screenpipe_sync.sh.bak2
-rw-r--r--@ 1 lukas staff 8541 11 May 20:54 sync.log
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ cat screenpipe_sync.sh | pbcopy
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ~/.screenpipe/screenpipe_sync.sh 2026-05-11
[2026-05-12 20:19:37] ========================================
[2026-05-12 20:19:37] Screenpipe sync starting for: 2026-05-11
[2026-05-12 20:19:37] install_id: 2ff6574c-4272-4dbf-a20b-434b024c65fb
[2026-05-12 20:19:37] ========================================
[+00m00s] ▶ Preflight checks
Source DB: OK (4.2G)
NAS mount: OK /Volumes/screenpipe
Archive DB: will be created
Frame data dir: OK (283 files, 318M)
Audio files: OK (2507 files, 267M)
[+00m00s] ▶ Counting source rows for 2026-05-11
frames: 6857
elements: 672129
ui_events: 7063
ocr_text: 2332
meetings: 1
audio_chunks: 2507
audio_transcriptions: 226
audio_tags: 0
speakers: 15 (all-time)
speaker_embeddings: 58 (all-time)
[+00m01s] ▶ Initialising tables (CREATE IF NOT EXISTS)
creating vision tables ✓ 0m00s
creating audio tables ✓ 0m01s
Error: in prepare, no such column: id
S idx_ocr_text_install_pk ON ocr_text(install_id, id);
error here ---^
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "PRAGMA table_info(ocr_text);"
0|frame_id|INTEGER|1||0
1|text|TEXT|1||0
2|text_json|TEXT|0||0
3|app_name|TEXT|1|''|0
4|ocr_engine|TEXT|1|'unknown'|0
5|window_name|TEXT|0||0
6|focused|BOOLEAN|0|FALSE|0
7|text_length|INTEGER|0||0
8|sync_id|TEXT|0||0
9|synced_at|DATETIME|0||0
10|redacted_at|INTEGER|0||0
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (screenpipe")
Close Tab
-zsh
Close Tab
⌥⌘1
-zsh...
|
iTerm2
|
-zsh
|
NULL
|
27902
|
|
27903
|
Last login: Tue May 12 20:12:05 on ttys007
Poetry Last login: Tue May 12 20:12:05 on ttys007
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/jiminny/app (JY-20725-handle-HS-search-rate-limit) $ open ~/.screenpipe
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/jiminny/app (JY-20725-handle-HS-search-rate-limit) $ cd ~/.screenpipe
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ll
total 8720288
drwxr-xr-x 21 lukas staff 672 12 May 09:21 .
drwx------+ 96 lukas staff 3072 12 May 20:12 ..
-rw-r--r--@ 1 lukas staff 6148 12 May 20:14 .DS_Store
-rw-r--r--@ 1 lukas staff 37 11 May 20:54 .sync_install_id
-rw-r--r-- 1 lukas staff 0 10 May 14:43 clipboard-disabled-after-crash
drwxr-xr-x 3660 lukas staff 117120 12 May 17:41 data
-rw-r--r--@ 1 lukas staff 4457357312 12 May 17:41 db.sqlite
-rw-r--r-- 1 lukas staff 65536 12 May 09:26 db.sqlite-shm
-rw-r--r-- 1 lukas staff 5001712 12 May 17:41 db.sqlite-wal
drwxr-xr-x 9 lukas staff 288 10 May 11:39 pipes
-rw-r--r-- 1 lukas staff 28408 6 May 21:02 screenpipe.2026-05-06.0.log
-rw-r--r-- 1 lukas staff 566164 7 May 21:50 screenpipe.2026-05-07.0.log
-rw-r--r-- 1 lukas staff 382102 8 May 22:20 screenpipe.2026-05-08.0.log
-rw-r--r-- 1 lukas staff 167023 9 May 23:04 screenpipe.2026-05-09.0.log
-rw-r--r-- 1 lukas staff 88266 10 May 23:51 screenpipe.2026-05-10.0.log
-rw-r--r-- 1 lukas staff 528943 11 May 22:54 screenpipe.2026-05-11.0.log
-rw-r--r-- 1 lukas staff 245484 12 May 17:39 screenpipe.2026-05-12.0.log
-rwxr-xr-x@ 1 lukas staff 32005 11 May 20:54 screenpipe_sync.sh
-rwxr-xr-x@ 1 lukas staff 14994 6 May 20:26 screenpipe_sync.sh.bak
-rwxr-xr-x@ 1 lukas staff 21485 10 May 13:34 screenpipe_sync.sh.bak2
-rw-r--r--@ 1 lukas staff 8541 11 May 20:54 sync.log
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ cat screenpipe_sync.sh | pbcopy
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ~/.screenpipe/screenpipe_sync.sh 2026-05-11
[2026-05-12 20:19:37] ========================================
[2026-05-12 20:19:37] Screenpipe sync starting for: 2026-05-11
[2026-05-12 20:19:37] install_id: 2ff6574c-4272-4dbf-a20b-434b024c65fb
[2026-05-12 20:19:37] ========================================
[+00m00s] ▶ Preflight checks
Source DB: OK (4.2G)
NAS mount: OK /Volumes/screenpipe
Archive DB: will be created
Frame data dir: OK (283 files, 318M)
Audio files: OK (2507 files, 267M)
[+00m00s] ▶ Counting source rows for 2026-05-11
frames: 6857
elements: 672129
ui_events: 7063
ocr_text: 2332
meetings: 1
audio_chunks: 2507
audio_transcriptions: 226
audio_tags: 0
speakers: 15 (all-time)
speaker_embeddings: 58 (all-time)
[+00m01s] ▶ Initialising tables (CREATE IF NOT EXISTS)
creating vision tables ✓ 0m00s
creating audio tables ✓ 0m01s
Error: in prepare, no such column: id
S idx_ocr_text_install_pk ON ocr_text(install_id, id);
error here ---^
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "PRAGMA table_info(ocr_text);"
0|frame_id|INTEGER|1||0
1|text|TEXT|1||0
2|text_json|TEXT|0||0
3|app_name|TEXT|1|''|0
4|ocr_engine|TEXT|1|'unknown'|0
5|window_name|TEXT|0||0
6|focused|BOOLEAN|0|FALSE|0
7|text_length|INTEGER|0||0
8|sync_id|TEXT|0||0
9|synced_at|DATETIME|0||0
10|redacted_at|INTEGER|0||0
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ nano screenpipe_
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (screenpipe")
Close Tab
-zsh
Close Tab
⌥⌘1
-zsh...
|
iTerm2
|
-zsh
|
NULL
|
27903
|
|
27904
|
Last login: Tue May 12 20:12:05 on ttys007
Poetry Last login: Tue May 12 20:12:05 on ttys007
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/jiminny/app (JY-20725-handle-HS-search-rate-limit) $ open ~/.screenpipe
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/jiminny/app (JY-20725-handle-HS-search-rate-limit) $ cd ~/.screenpipe
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ll
total 8720288
drwxr-xr-x 21 lukas staff 672 12 May 09:21 .
drwx------+ 96 lukas staff 3072 12 May 20:12 ..
-rw-r--r--@ 1 lukas staff 6148 12 May 20:14 .DS_Store
-rw-r--r--@ 1 lukas staff 37 11 May 20:54 .sync_install_id
-rw-r--r-- 1 lukas staff 0 10 May 14:43 clipboard-disabled-after-crash
drwxr-xr-x 3660 lukas staff 117120 12 May 17:41 data
-rw-r--r--@ 1 lukas staff 4457357312 12 May 17:41 db.sqlite
-rw-r--r-- 1 lukas staff 65536 12 May 09:26 db.sqlite-shm
-rw-r--r-- 1 lukas staff 5001712 12 May 17:41 db.sqlite-wal
drwxr-xr-x 9 lukas staff 288 10 May 11:39 pipes
-rw-r--r-- 1 lukas staff 28408 6 May 21:02 screenpipe.2026-05-06.0.log
-rw-r--r-- 1 lukas staff 566164 7 May 21:50 screenpipe.2026-05-07.0.log
-rw-r--r-- 1 lukas staff 382102 8 May 22:20 screenpipe.2026-05-08.0.log
-rw-r--r-- 1 lukas staff 167023 9 May 23:04 screenpipe.2026-05-09.0.log
-rw-r--r-- 1 lukas staff 88266 10 May 23:51 screenpipe.2026-05-10.0.log
-rw-r--r-- 1 lukas staff 528943 11 May 22:54 screenpipe.2026-05-11.0.log
-rw-r--r-- 1 lukas staff 245484 12 May 17:39 screenpipe.2026-05-12.0.log
-rwxr-xr-x@ 1 lukas staff 32005 11 May 20:54 screenpipe_sync.sh
-rwxr-xr-x@ 1 lukas staff 14994 6 May 20:26 screenpipe_sync.sh.bak
-rwxr-xr-x@ 1 lukas staff 21485 10 May 13:34 screenpipe_sync.sh.bak2
-rw-r--r--@ 1 lukas staff 8541 11 May 20:54 sync.log
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ cat screenpipe_sync.sh | pbcopy
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ~/.screenpipe/screenpipe_sync.sh 2026-05-11
[2026-05-12 20:19:37] ========================================
[2026-05-12 20:19:37] Screenpipe sync starting for: 2026-05-11
[2026-05-12 20:19:37] install_id: 2ff6574c-4272-4dbf-a20b-434b024c65fb
[2026-05-12 20:19:37] ========================================
[+00m00s] ▶ Preflight checks
Source DB: OK (4.2G)
NAS mount: OK /Volumes/screenpipe
Archive DB: will be created
Frame data dir: OK (283 files, 318M)
Audio files: OK (2507 files, 267M)
[+00m00s] ▶ Counting source rows for 2026-05-11
frames: 6857
elements: 672129
ui_events: 7063
ocr_text: 2332
meetings: 1
audio_chunks: 2507
audio_transcriptions: 226
audio_tags: 0
speakers: 15 (all-time)
speaker_embeddings: 58 (all-time)
[+00m01s] ▶ Initialising tables (CREATE IF NOT EXISTS)
creating vision tables ✓ 0m00s
creating audio tables ✓ 0m01s
Error: in prepare, no such column: id
S idx_ocr_text_install_pk ON ocr_text(install_id, id);
error here ---^
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "PRAGMA table_info(ocr_text);"
0|frame_id|INTEGER|1||0
1|text|TEXT|1||0
2|text_json|TEXT|0||0
3|app_name|TEXT|1|''|0
4|ocr_engine|TEXT|1|'unknown'|0
5|window_name|TEXT|0||0
6|focused|BOOLEAN|0|FALSE|0
7|text_length|INTEGER|0||0
8|sync_id|TEXT|0||0
9|synced_at|DATETIME|0||0
10|redacted_at|INTEGER|0||0
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ nano screenpipe_sync.sh
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (screenpipe")
Close Tab
-zsh
Close Tab
⌥⌘1
-zsh...
|
iTerm2
|
-zsh
|
NULL
|
27904
|
|
27905
|
Last login: Tue May 12 20:12:05 on ttys007
Poetry Last login: Tue May 12 20:12:05 on ttys007
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/jiminny/app (JY-20725-handle-HS-search-rate-limit) $ open ~/.screenpipe
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/jiminny/app (JY-20725-handle-HS-search-rate-limit) $ cd ~/.screenpipe
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ll
total 8720288
drwxr-xr-x 21 lukas staff 672 12 May 09:21 .
drwx------+ 96 lukas staff 3072 12 May 20:12 ..
-rw-r--r--@ 1 lukas staff 6148 12 May 20:14 .DS_Store
-rw-r--r--@ 1 lukas staff 37 11 May 20:54 .sync_install_id
-rw-r--r-- 1 lukas staff 0 10 May 14:43 clipboard-disabled-after-crash
drwxr-xr-x 3660 lukas staff 117120 12 May 17:41 data
-rw-r--r--@ 1 lukas staff 4457357312 12 May 17:41 db.sqlite
-rw-r--r-- 1 lukas staff 65536 12 May 09:26 db.sqlite-shm
-rw-r--r-- 1 lukas staff 5001712 12 May 17:41 db.sqlite-wal
drwxr-xr-x 9 lukas staff 288 10 May 11:39 pipes
-rw-r--r-- 1 lukas staff 28408 6 May 21:02 screenpipe.2026-05-06.0.log
-rw-r--r-- 1 lukas staff 566164 7 May 21:50 screenpipe.2026-05-07.0.log
-rw-r--r-- 1 lukas staff 382102 8 May 22:20 screenpipe.2026-05-08.0.log
-rw-r--r-- 1 lukas staff 167023 9 May 23:04 screenpipe.2026-05-09.0.log
-rw-r--r-- 1 lukas staff 88266 10 May 23:51 screenpipe.2026-05-10.0.log
-rw-r--r-- 1 lukas staff 528943 11 May 22:54 screenpipe.2026-05-11.0.log
-rw-r--r-- 1 lukas staff 245484 12 May 17:39 screenpipe.2026-05-12.0.log
-rwxr-xr-x@ 1 lukas staff 32005 11 May 20:54 screenpipe_sync.sh
-rwxr-xr-x@ 1 lukas staff 14994 6 May 20:26 screenpipe_sync.sh.bak
-rwxr-xr-x@ 1 lukas staff 21485 10 May 13:34 screenpipe_sync.sh.bak2
-rw-r--r--@ 1 lukas staff 8541 11 May 20:54 sync.log
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ cat screenpipe_sync.sh | pbcopy
UW PICO 5.09 New Buffer
[ Read 695 lines ]
^G Get Help ^O WriteOut ^R Read File ^Y Prev Pg ^K Cut Text ^C Cur Pos
^X Exit ^J Justify ^W Where is ^V Next Pg ^U UnCut Text ^T To Spell
UW PICO 5.09 File: screenpipe_sync.sh
#!/bin/bash
# screenpipe_sync.sh
# Syncs Screenpipe SQLite data (vision + audio) to a NAS archive database.
# Append-only, no deletions.
#
# Key design points
# -----------------
# 1. Multi-install safe via install_id.
# Source IDs reset to 1 on every screenpipe reinstall. To avoid collisions
# in the NAS archive, every synced table gets an extra `install_id` column,
# and the logical primary key becomes (install_id, id) enforced by a
# unique index. The install_id is a UUID stored in
# ~/.screenpipe/.sync_install_id — wiping ~/.screenpipe/ (which is what
# happens on reinstall) discards it, so the next run generates a new one.
#
# 2. Schema-drift tolerant. If screenpipe migrations add new columns to the
# source DB, the NAS gets ALTER TABLE'd to match. Inserts use explicit
# column lists so positional mismatches can't occur.
#
# 3. FTS caveat. FTS tables in the NAS use source `id` as rowid. After a
# reinstall, INSERT OR IGNORE will silently skip rows whose id collides
# with a previous install's id, so FTS only reliably indexes the most
# recent install. Falls back to LIKE queries on the base tables for
# multi-install searches (which can filter by install_id).
#
# Usage
# -----
# ./screenpipe_sync.sh # syncs yesterday
# ./screenpipe_sync.sh 2026-04-15 # syncs a specific date
# ./screenpipe_sync.sh today # syncs today so far
# ./screenpipe_sync.sh --reset-install-id # rotate install_id and exit
# ./screenpipe_sync.sh --show-install-id # print install_id and exit
set -euo pipefail
# ─── CONFIG ───────────────────────────────────────────────────────────────────
DB_SRC="${SCREENPIPE_DB:-$HOME/.screenpipe/db.sqlite}"
NAS_MOUNT="${NAS_MOUNT:-/Volumes/screenpipe}"
NAS_DB="$NAS_MOUNT/archive.db"
NAS_DATA="$NAS_MOUNT/data"
^G Get Help ^O WriteOut ^R Read File ^Y Prev Pg ^K Cut Text ^C Cur Pos
^X Exit ^J Justify ^W Where is ^V Next Pg ^U UnCut Text ^T To Spell
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (screenpipe")
Close Tab
nano
Close Tab
⌥⌘1
nano...
|
iTerm2
|
nano
|
NULL
|
27905
|
|
27906
|
Last login: Tue May 12 20:12:05 on ttys007
Poetry Last login: Tue May 12 20:12:05 on ttys007
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
Poetry could not find a pyproject.toml file in /Users/lukas/jiminny/app or its parents
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/jiminny/app (JY-20725-handle-HS-search-rate-limit) $ open ~/.screenpipe
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/jiminny/app (JY-20725-handle-HS-search-rate-limit) $ cd ~/.screenpipe
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ll
total 8720288
drwxr-xr-x 21 lukas staff 672 12 May 09:21 .
drwx------+ 96 lukas staff 3072 12 May 20:12 ..
-rw-r--r--@ 1 lukas staff 6148 12 May 20:14 .DS_Store
-rw-r--r--@ 1 lukas staff 37 11 May 20:54 .sync_install_id
-rw-r--r-- 1 lukas staff 0 10 May 14:43 clipboard-disabled-after-crash
drwxr-xr-x 3660 lukas staff 117120 12 May 17:41 data
-rw-r--r--@ 1 lukas staff 4457357312 12 May 17:41 db.sqlite
-rw-r--r-- 1 lukas staff 65536 12 May 09:26 db.sqlite-shm
-rw-r--r-- 1 lukas staff 5001712 12 May 17:41 db.sqlite-wal
drwxr-xr-x 9 lukas staff 288 10 May 11:39 pipes
-rw-r--r-- 1 lukas staff 28408 6 May 21:02 screenpipe.2026-05-06.0.log
-rw-r--r-- 1 lukas staff 566164 7 May 21:50 screenpipe.2026-05-07.0.log
-rw-r--r-- 1 lukas staff 382102 8 May 22:20 screenpipe.2026-05-08.0.log
-rw-r--r-- 1 lukas staff 167023 9 May 23:04 screenpipe.2026-05-09.0.log
-rw-r--r-- 1 lukas staff 88266 10 May 23:51 screenpipe.2026-05-10.0.log
-rw-r--r-- 1 lukas staff 528943 11 May 22:54 screenpipe.2026-05-11.0.log
-rw-r--r-- 1 lukas staff 245484 12 May 17:39 screenpipe.2026-05-12.0.log
-rwxr-xr-x@ 1 lukas staff 32005 11 May 20:54 screenpipe_sync.sh
-rwxr-xr-x@ 1 lukas staff 14994 6 May 20:26 screenpipe_sync.sh.bak
-rwxr-xr-x@ 1 lukas staff 21485 10 May 13:34 screenpipe_sync.sh.bak2
-rw-r--r--@ 1 lukas staff 8541 11 May 20:54 sync.log
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ cat screenpipe_sync.sh | pbcopy
UW PICO 5.09 New Buffer
[ Read 695 lines ]
^G Get Help ^O WriteOut ^R Read File ^Y Prev Pg ^K Cut Text ^C Cur Pos
^X Exit ^J Justify ^W Where is ^V Next Pg ^U UnCut Text ^T To Spell
UW PICO 5.09 File: screenpipe_sync.sh
SRC_FRAMES=$(sqlite3 "$DB_SRC" "SELECT COUNT(*) FROM frames WHERE date(timestamp) = '$TARGET_DATE';")
SRC_ELEMENTS=$(sqlite3 "$DB_SRC" "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) = '$TARGET_DATE';")
SRC_OCR=$(sqlite3 "$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';")
SRC_ACHUNKS=$(sqlite3 "$DB_SRC" "SELECT COUNT(*) FROM audio_chunks WHERE date(timestamp) = '$TARGET_DATE';")
SRC_ATRANS=$(sqlite3 "$DB_SRC" "SELECT COUNT(*) FROM audio_transcriptions WHERE audio_chunk_id IN (SELECT id FROM audio_chunks WHERE date(timestamp) = '$TARGET_DATE');")
SRC_ATAGS=$(sqlite3 "$DB_SRC" "SELECT COUNT(*) FROM audio_tags WHERE audio_chunk_id IN (SELECT id FROM audio_chunks WHERE date(timestamp) = '$TARGET_DATE');")
# speakers + speaker_embeddings are install-global, not per-date; we sync all.
SRC_SPEAKERS=$(sqlite3 "$DB_SRC" "SELECT COUNT(*) FROM speakers;")
SRC_SEMB=$(sqlite3 "$DB_SRC" "SELECT COUNT(*) FROM speaker_embeddings;")
printf " %-25s %s\n" "frames:" "$SRC_FRAMES"
printf " %-25s %s\n" "elements:" "$SRC_ELEMENTS"
printf " %-25s %s\n" "ui_events:" "$SRC_UI"
printf " %-25s %s\n" "ocr_text:" "$SRC_OCR"
printf " %-25s %s\n" "meetings:" "$SRC_MEETINGS"
printf " %-25s %s\n" "audio_chunks:" "$SRC_ACHUNKS"
printf " %-25s %s\n" "audio_transcriptions:" "$SRC_ATRANS"
printf " %-25s %s\n" "audio_tags:" "$SRC_ATAGS"
printf " %-25s %s (all-time)\n" "speakers:" "$SRC_SPEAKERS"
printf " %-25s %s (all-time)\n" "speaker_embeddings:" "$SRC_SEMB"
if [ "$SRC_FRAMES" -eq "0" ] && [ "$SRC_ACHUNKS" -eq "0" ]; then
log "No frames or audio chunks for $TARGET_DATE — skipping DB sync"
DB_ALREADY_SYNCED=true
fi
fi
if [ "$DB_ALREADY_SYNCED" = false ]; then
# ─── INIT TABLES ──────────────────────────────────────────────────────────
step "Initialising tables (CREATE IF NOT EXISTS)"
run_sqlite_heredoc "creating vision tables" "
ATTACH '$NAS_DB' AS nas;
CREATE TABLE IF NOT EXISTS nas.frames AS SELECT * FROM main.frames WHERE 0;
^G Get Help ^O WriteOut ^R Read File ^Y Prev Pg ^K Cut Text ^C Cur Pos
^X Exit ^J Justify ^W Where is ^V Next Pg ^U UnCut Text ^T To Spell
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (screenpipe")
Close Tab
nano
Close Tab
⌥⌘1
nano...
|
iTerm2
|
nano
|
NULL
|
27906
|