BUG: Acknowledgments are problematic due to shortend ids #4

New Issue

jonas · 2025-10-08T07:29:45Z

jonas commented

2025-10-08 07:29:45 +00:00

Alpine Bits requires cutting off certain values to fit arbitrary limitations. This is annoying if our unique_ids happen to be longer.

Our unique_ids sometimes are longer because we piggyback of the data wix is using. That also makes it possible to match data to the Wix CRM if necessary. To bad alpinebits can't handle those. So we shorten the id.

Ackwnolegdment Requests then return the shortend Id making lookups in the database more annoying.

Proposal. Save both original_id and transformed_id in the database. To transform the id we can use md5. Not the best hash function but happens to always output 32 chars. Collissions are still very unlikely.

Alpine Bits requires cutting off certain values to fit arbitrary limitations. This is annoying if our unique_ids happen to be longer. Our unique_ids sometimes are longer because we piggyback of the data wix is using. That also makes it possible to match data to the Wix CRM if necessary. To bad alpinebits can't handle those. So we shorten the id. Ackwnolegdment Requests then return the shortend Id making lookups in the database more annoying. Proposal. Save both original_id and transformed_id in the database. To transform the id we can use md5. Not the best hash function but happens to always output 32 chars. Collissions are still very unlikely.

jonas commented

2025-10-08 14:00:06 +00:00

Fixed. Changed database schema. Now always using hashed md5 unique id for asa. Fits in 32 chars :)

jonas closed this issue

2025-10-08 14:00:06 +00:00

Sign in to join this conversation.

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: jonas/alpinebits_python#4