does d1 works on miniflare (local version)

• https://www.sqlite.org/optoverview.html

• see the note there. If you don't specify a primary key there is an implicit ROWID INTEGER PRIMARY KEYROWID INTEGER PRIMARY KEY that is used.

If you're doing lookups by some form of UUID, then you should create an index on that column so that your WHERE order_id = ?1 queries benefit from the index.

• it's 8 on the experimental backend. It's being upped to 32, but waiting on next week's release.