Can you also send me your accountId + databaseId? Here or in DM?
Can you also send me your accountId + databaseId? Here or in DM?
EReally small, I didn't measure or anything, but I guess not more than 10/s ... and it's just a short burst.
EOk, I'll DM you, I don't know my account ID
EI don't know if the DM was received or not ... anyway, DB ID = 2d159a31-757e-46c2-865b-095792688269
EI believe you should be able to find the account info from that
Jis there any way of doing a connection link instead of using workers?
HNot at the moment
PIs there any limit on server locations when using D1? I'm from Brazil and there's about ~500ms to make a simple crud GET/POST. When I use another database (Cloudflare pages/workers + any other DB service) this value decreases to ~150ms
PThank you! =)
Cdoes D1 support full text search?
Cis that D1 atomic write?
Ccan perform transaction?
MNo worries
BIf I use
wrangler d1 execute
KAt least 3.39.4 - it's probably much newer by now, but that's the last version I recall mentioned.
S
Myou can, but it'll always be called
resultsconst { results: countResults...
MTo add to what Max said: this isn't a D1 thing, it's Object Destructuring in JS: https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Operators/Destructuring_assignment
The destructuring assignment syntax is a JavaScript expression that makes it possible to unpack values from arrays, or properties from objects, into distinct variables.
McountResultsresultsEach destructured property can have a default value. The default value is used when the property is not present, or has value undefined. It is not used if the property has value null.
Uit depends on your use case 
NCan we have math functions? 
Mlong term you'll be able to have arbitrary functions
Malso which math functions are you after
Ni only needed pow so it wasn't a big issue
Ni have a query to find places near a given coordinate and i had to calculate the squared distance so i can order the results
JIs there a way to programmatically create and manage D1 databases? Like for instance, could I have a worker that creates a new database for a user using an api request?
MNot yet! We want to get into beta before we publish the external API, which will allow you to do this (and also allow us to add Terraform support)
JSounds good! Looking forward to it
HI would like to experiment with d1 migrations in a CI/CD environment like GitHub but it seems my CLOUDFLARE_API_TOKEN does not have the right permissions. Any ideas how to configure the right permissions to be able run
wrangler d1 migrations apply?