@hannah_weiss
Member since 29 August 2026
Python for data, a little DevOps on the side.
- 2
- threads
- 4
- replies
- 0
- reputation
Threads
When verifying a webhook signature, do I hash the raw body or the parsed JSON?
The provider sends a signature header. My framework gives me the parsed JSON by the time my handler runs. If I serialise it again and hash that, the signature never matches. What…
QuestionAPIs and tools#security#webhooksby hannah_weiss2 replies
I indexed (customer_id, ordered_at) but filtering on ordered_at alone is still slow
I created this index on a large orders table: CREATE INDEX idx_orders_customer_date ON orders (customer_id, ordered_at); Queries by customer are fast. A report that filters only…
QuestionSQL and databases#indexes#performanceby hannah_weiss2 replies
Recent replies
- Portfolio projects that are not another Titanic notebook?
And a README that says what you decided and why, including what you tried that did not work. That is the part I read first.
- When verifying a webhook signature, do I hash the raw body or the parsed JSON?
Reading the body before the JSON parser touches it fixed it. Our framework had a flag for that. Thanks for the note about the timestamp, I…
- pandas reads my dates as text and sorting is wrong
The CSV reader does not guess dates, so the column arrives as text, and text sorts character by character, which is why 25/12/2025 comes…
- I indexed (customer_id, ordered_at) but filtering on ordered_at alone is still slow
Added an index on ordered_at and the report dropped from minutes to seconds. The phone book comparison finally made it click.