.sqlite export is being specced out but is unlikely to arrive within the month, i would look at spli

.sqlite export is being specced out but is unlikely to arrive within the month, i would look at splitting the workload across multiple dbs in the meanwhile or using a query limit on nora's tool
14 Replies
elithrar
elithrar9mo ago
Fixing in a PR Changelog going out soon, but for those here: * D1's .raw(), .all() and .run() query statement methods (https://developers.cloudflare.com/d1/build-databases/query-databases/#query-statement-methods) have been updated to reflect their intended behaviour and improving compatibility with ORMs. * .raw() now correctly returns results an array of arrays, allowing the correct handling of duplicate column names (such as when joining tables), as compared to .all(), which is unchanged and returns an array of objects. To include an array of column names in the results when using .raw(), use .raw({columnNames: true}). * .run() no longer incorrectly returns a D1Result and instead returns a D1ExecResult (https://developers.cloudflare.com/d1/build-databases/query-databases/#return-object) as originally intended and documented. This may be a breaking change for some applications that expected .raw() to return an array of objects.
kev-ac
kev-ac9mo ago
It was indeed a breaking change for us, even if it was never intended to work that way. Replacing the .run() with .all() seemed to have done the trick for now. Back to sleep 😅
Unsmart
Unsmart9mo ago
That’s what a betas for tho 🤝
Unknown User
Unknown User9mo ago
Message Not Public
Sign In & Join Server To View
Unknown User
Unknown User9mo ago
Message Not Public
Sign In & Join Server To View
sultan.xh
sultan.xh9mo ago
Is anyone having an issue with D1? It looks like it is failing to return results.
No description
No description
sultan.xh
sultan.xh9mo ago
A basic simple select query does not return any result array.
Kyrre
Kyrre9mo ago
Same issue here @sultan.xh.
sultan.xh
sultan.xh9mo ago
Yes, the Return object is missing results.
Nehal Ali
Nehal Ali9mo ago
@sultan.xh if you are using .run() it is now won't be returning any results
sultan.xh
sultan.xh9mo ago
What should I use then?
Nehal Ali
Nehal Ali9mo ago
@sultan.xh .all() instead
sultan.xh
sultan.xh9mo ago
Okay, it is a small change, but it has a big impact. I need to modify everything now. Thanks!
Want results from more Discord servers?
Add your server