Choice we had to make. This will be the backend going forward.
Choice we had to make. This will be the backend going forward.
D1 is currently in Open Alpha and is not recommended for production data and trafficMove database from PlanetScale to D1wrangler d1 list should give you a list back of your D1 databases and what backend they're running on. If you see version: beta, they're on the new backend
dump is not working yet/anymore on the new/default/experimental backend... Am I right?rowsEffected? 
UPDATEs, but that seems pretty slow...rowsAffected? 


~/repos/d1 (main) ✔
➜ wrangler d1 execute db-wnam --file=$HOME/Downloads/schema.sql
🌀 Mapping SQL input into an array of statements
🌀 Parsing 9 statements
🌀 Executing on db-wnam (6f2478dc-789b-4f31-95ff-d6001dc617d2):
🚣 Executed 9 commands in 0.6782660111784935ms➜ wrangler d1 execute db-wnam --command "PRAGMA table_xinfo(scores)"
🌀 Mapping SQL input into an array of statements
🌀 Parsing 1 statements
🌀 Executing on db-wnam (6f2478dc-789b-4f31-95ff-d6001dc617d2):
🚣 Executed 1 commands in 0.225492000579834ms
┌─────┬───────────────┬─────────┬─────────┬────────────┬────┬────────┐
│ cid │ name │ type │ notnull │ dflt_value │ pk │ hidden │
├─────┼───────────────┼─────────┼─────────┼────────────┼────┼────────┤
│ 0 │ scoreId │ INTEGER │ 0 │ │ 1 │ 0 │
├─────┼───────────────┼─────────┼─────────┼────────────┼────┼────────┤
│ 1 │ leaderboardId │ INTEGER │ 0 │ │ 0 │ 0 │
├─────┼───────────────┼─────────┼─────────┼────────────┼────┼────────┤
│ 2 │ userId │ INTEGER │ 1 │ │ 0 │ 0 │
├─────┼───────────────┼─────────┼─────────┼────────────┼────┼────────┤
│ 3 │ value │ INTEGER │ 1 │ │ 0 │ 0 │
├─────┼───────────────┼─────────┼─────────┼────────────┼────┼────────┤
│ 4 │ gameVersion │ TEXT │ 1 │ │ 0 │ 0 │
├─────┼───────────────┼─────────┼─────────┼────────────┼────┼────────┤
│ 5 │ timestamp │ INTEGER │ 1 │ │ 0 │ 0 │
├─────┼───────────────┼─────────┼─────────┼────────────┼────┼────────┤
│ 6 │ hasReplay │ INTEGER │ 0 │ 0 │ 0 │ 0 │
├─────┼───────────────┼─────────┼─────────┼────────────┼────┼────────┤
│ 7 │ verified │ INTEGER │ 0 │ 0 │ 0 │ 0 │
└─────┴───────────────┴─────────┴─────────┴────────────┴────┴────────┘