Recoll integration for Zotero

Why: one search across all my data

Sometimes I can’t remember where I saw something (email, blog post, notes, etc) — it’s tedious to have to do a separate search for each data source.

Goal: pull request to the Recoll project

DONE try datasette for poking around zotero db

mise shell python@3.13
python3 -m pip install datasette
datasette serve /home/tsoap/tso/bu/devel/third-party/jackyzha0--quartz/content-org-roam/scratch/zotero.sqlite

STRT recoll open source project: get a feel for development practices, CI

https://framagit.org/medoc92/recoll

git clone https://framagit.org/medoc92/recoll.git

AFAICT:

• no shared CI

STRT understand existing recoll support for Joplin

https://framagit.org/medoc92/recoll/-/issues/193 — by the owner themselves, so this is the way to do it

<~/tso/bu/devel/third-party/recoll/src/filters/rcljoplin.py>

Probably worth creating a simple joplin DB and trying it out.

TODO search Zotero source code for how it builds info pane from its database

TODO sqlite database locking

• does zotero lock it
  • for how long
• what happens when my python script reads when it locked

TODO narrow the mime handler for just zotero database directory

mimemap supports restricting mappings to directories and supports ”~” too

TODO HTML output, fields

https://www.recoll.org/usermanual/webhelp/docs/RCL.PROGRAM.FIELDS.html

TODO use Zotero URL scheme in the search results

https://framagit.org/medoc92/recoll/-/issues/193

So you can click a link in the recoll search result and it opens zotero at the right item, nice!