Mehdi Akiki

Posts tagged "pagination"

  • Published on
    A page cursor belongs to an ordering, filter, and authorized scope. Version its format and reject incompatible reuse without mistaking encoding for authorization.
  • Published on

    Article · Interrupted execution

    Resuming a Paginated Import After Page 417 Fails

    A paginated import should resume from a committed cursor and stable item identities, not from a human page number that may no longer describe the same data.
  • Published on

    Investigation · Part 4 of 10 · Inside a database index

    Why Column Order Matters in a Composite Index

    Two indexes with the same two columns in a different order. For the same query, one reads 1,885 entries and the other 27,243. I measured why on a SQLite table of one million rows, and found that the leftmost-column rule has an exception called skip-scan.