Anže
anze3db.pecar.me
Anže
@anze3db.pecar.me
Writing Python and surfing waves 🏄‍♂️
I've also added a benchmarking utility so that I can have a fancy README with all the run times 😎
November 30, 2025 at 12:24 PM
It's always DNS:

> We have identified a potential root cause for error rates for the DynamoDB APIs in the US-EAST-1 Region. Based on our investigation, the issue appears to be related to DNS resolution of the DynamoDB API endpoint in US-EAST-1
October 20, 2025 at 9:23 AM
Ah, right. Yes, I see it could make a bit of a difference:

>>> from pympler.asizeof import asizeof
>>> asizeof(Case(When(pk=1, then=1)))
3408
October 13, 2025 at 4:30 PM
Wouldn't raw SQL strings take even more memory?

>>> sys.getsizeof(Case(
... When(pk=1, then=1),
... output_field=IntegerField()
... ))
48
>>> sys.getsizeof("""CASE WHEN "your_table"."pk" = 1 THEN 1 ELSE 0 END""")
90
October 13, 2025 at 3:47 PM
Yes, it's milliseconds. The web server and PostgreSQL server run on the same machine, so there is no network lag.
October 11, 2025 at 10:26 AM