Summary

Adds an optional http configuration to @payloadcms/db-d1-sqlite so D1 can be used from runtimes without a Workers binding (for example Node or Vercel) by calling Cloudflare’s D1 HTTP API. The adapter accepts either a Workers binding or http credentials, validates that they are not combined, and documents that read-replica session mode is Workers-only.

Implements a small REST client (prepare, batch, exec, and query) plus Vitest coverage with mocked fetch. Because dropDatabase in @payloadcms/drizzle/sqlite expects a libsql-style client.execute API, connect wires a shim that maps execute / executeMultiple onto D1’s prepare().all() and exec, which fixes PAYLOAD_DROP_DATABASE and other code paths that assumed a libsql client.

Adds an integration test under test/d1-http that runs against a real D1 database when CLOUDFLARE_ACCOUNT_ID, CLOUDFLARE_D1_DATABASE_ID, and CLOUDFLARE_API_TOKEN are set, and skips otherwise. README updates describe Workers vs HTTP usage and environment variables.