Mehdi Akiki

Posts tagged "JSON"

  • Published on
    Adding an optional field can break strict parsers, signatures, hashes, exhaustive logic, size limits, identity rules, and old round trips even when the wire format accepts it.
  • Published on

    Investigation · Part 8 of 10 · Inside a database index

    Partial and Expression Indexes: Index Only What You Query

    A partial index of the 2% active users took 138 pages instead of 9,096 and answered as fast. But SQLite uses it only when the query says the condition in the same way, or binds the same value, and an index on json_extract() is ignored by the ->> operator, which returns the same value.
  • Published on
    This article contrasts the simplicity and intuitiveness of JSON serialization in Go with the more complex, yet powerful, approach in Rust, highlighting the trade-offs between ease of use and control.