Start where the work happens.
Each worker began with a local SQLite database. Alessandro used content hashes to identify duplicates as records travelled between machines. On May 12, his migration brought 22,116 unique observations and 311 sessions into Postgres with zero reported import errors.
Give every workstation the same history.
His customized server then accepted hook events from all three machines. The development environment could write a record; a bot on another machine could search the shared index. Postgres, Redis and Qdrant were infrastructure choices he made for this fleet.