Pydantic

Pydantic's Logfire engineering team says it sped up queries by up to 1000x by shredding JSON columns, extracting nested fields into dedicated columns instead of parsing JSON blobs at query time. The article details how the observability platform handles dynamic attributes in its database. Developers on Hacker News are discussing the tradeoffs between schema flexibility and query performance.