Store Locations of OCR Results in Database

jasonjmcghee / rem

An open source approach to locally record and enable searching everything you view on your Mac.

https://rem.ing

MIT License

2.18k stars 60 forks source link

Store Locations of OCR Results in Database #87

Closed cparish312 closed 1 month ago

cparish312 commented 1 month ago

Plan is to create a a new table "frames_text" with columns (frame_id, text, x, y, w, h)

Considerations: 1) Could make it a Virtual Table to allow FTS4 2) Could replace (or migrate) allText table and replicate current functionality using new table. Without combining the text bounding boxes this could limit search results.

jasonjmcghee commented 1 month ago

Seems pretty reasonable! Curious what kind of performance improvement this brings!