is there any way of doing a connection link instead of using workers?
is 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 to run an SQL query, will this query be all in one db transaction, even if there are multiple udates, inserts and deletes in there?
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
results, so you'll need to make the second call const { 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.
McountResults isn't a property of results and so it'll always be undefined if it doesn't exist on the object.Each 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 applyActually, I think I found it .. there's D1:EDIT under accounts
WD1 support isn't in workers-rs yet, issue tracking: https://github.com/cloudflare/workers-rs/issues/221
Sfwiw you can use this PR as your workers-rs version and use D1, or copy over the code for it https://github.com/cloudflare/workers-rs/pull/270
GitHub
Summary
These changes add D1 support to the worker crate, resolving #221.
Due to the nature of local development with Rust workers, developing an easy process for locally debugging this integration...
These changes add D1 support to the worker crate, resolving #221.
Due to the nature of local development with Rust workers, developing an easy process for locally debugging this integration...
Myou can't use D1 with the dashboard Worker quick editor yet - just wrangler CLI
