not really offline but someone who works in industry here once detailed out that each scanner has it's own copy of a SQLite database that is being updated as fast as possible based on inserts of other scanners since any downtime is a big deal at these venues
i.e., theoretically duplicate tickets would be identified but not instantly but still pretty quickly
i.e., theoretically duplicate tickets would be identified but not instantly but still pretty quickly