you can, but it'll always be called `results`, so you'll need to make the second call `const { resul

you can, but it'll always be called

results

results

, so you'll need to make the second call

const { results: countResults...

const { results: countResults...

const { results: countResults...

const { results: countResults...

MMax (@rozenmd)you can, but it'll always be called `results`, so you'll need to make the second...

Matt Silverlock•3/31/23, 12:51 PM

To 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

Destructuring assignment - JavaScript | MDN

The destructuring assignment syntax is a JavaScript expression that makes it possible to unpack values from arrays, or properties from objects, into distinct variables.

MMatt Silverlock To add to what Max said: this isn't a D1 thing, it's Object Destructuring in JS:...

Matt Silverlock•3/31/23, 12:53 PM

countResults

countResults

isn't a property of

results

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.

Unsmart•3/31/23, 6:47 PM

it depends on your use case

Noel•4/1/23, 11:33 AM

Can we have math functions?

NNoel Can we have math functions? 🥺

Max (@rozenmd)OP•4/1/23, 2:44 PM

long term you'll be able to have arbitrary functions

Max (@rozenmd)OP•4/1/23, 2:44 PM

also which math functions are you after

Noel•4/1/23, 2:46 PM

i only needed pow so it wasn't a big issue

Noel•4/1/23, 2:47 PM

i have a query to find places near a given coordinate and i had to calculate the squared distance so i can order the results

Jason Hostetter•4/2/23, 6:53 PM

Is 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?

JJason Hostetter Is there a way to programmatically create and manage D1 databases? Like for inst...

Matt Silverlock•4/2/23, 7:28 PM

Not 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)

MMatt Silverlock Not yet! We want to get into beta before we publish the external API, which will...

Jason Hostetter•4/2/23, 11:23 PM

Sounds good! Looking forward to it

hanpolo•4/3/23, 5:09 PM

I 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

wrangler d1 migrations apply

Hhanpolo I would like to experiment with d1 migrations in a CI/CD environment like GitHub...

hanpolo•4/3/23, 5:12 PM

Actually, I think I found it .. there's D1:EDIT under accounts

Walshy•4/3/23, 7:52 PM

D1 support isn't in workers-rs yet, issue tracking: https://github.com/cloudflare/workers-rs/issues/221

SebastiaanYN•4/3/23, 9:56 PM

fwiw 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

feat: Added D1 Support by FlareLine · Pull Request #270 · cloudflar...

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...

Mmacron is it possible to use D1 in workers through dashboard? or I only should use wran...

Max (@rozenmd)OP•4/4/23, 6:55 AM

you can't use D1 with the dashboard Worker quick editor yet - just wrangler CLI

Max (@rozenmd)OP•4/4/23, 6:56 AM

but if you need to edit data, the basics (TEXT and INTEGER) work

Epailes•4/5/23, 11:08 AM

I saw we can request increases above 100MB limit, is that something easy to get or is it generally just ent+ until beta/launch?

EEpailes I saw we can request increases above 100MB limit, is that something easy to get ...

Max (@rozenmd)OP•4/5/23, 11:24 AM

It's more to work out what folks want to use a larger db for - I don't know if we'll be increasing the limit until beta

MMax (@rozenmd)It's more to work out what folks want to use a larger db for - I don't know if w...

Epailes•4/5/23, 2:56 PM

Ah okay, yeah any increase in DB size above 100MB can equally be handled by having multiple D1 instances, hopefully it'll be possible to access them using a string as an identifier rather than needing to manually bind them

SmallShen•4/8/23, 8:33 AM

Is it possible to dynamically get a d1 database(usecase for saas)?

Original message was deleted

Hello, I’m Allie!•4/8/23, 8:37 AM

Yes https://developers.cloudflare.com/d1/learning/backups/

Backups · Cloudflare D1 docs

D1 has built-in support for creating and restoring backups of your databases, including support for scheduled automatic backups and manual backup …

SSmallShen Is it possible to dynamically get a d1 database(usecase for saas)?

Hello, I’m Allie!•4/8/23, 8:37 AM

As a binding? No

Hello, I’m Allie!•4/8/23, 8:37 AM

As a call to the API, yes

HHello, I’m Allie!As a binding? No

SmallShen•4/8/23, 8:53 AM

env.dbNamespace.get('db-id')

env.dbNamespace.get('db-id')

SSmallShen like `env.dbNamespace.get('db-id')`

Hello, I’m Allie!•4/8/23, 8:55 AM

Yeah, you can’t do that

Atinux•4/8/23, 5:07 PM

I get around 200ms of latency when querying the database (living in France). Is the SQLite database right know hosted in US?

Atinux•4/8/23, 5:08 PM

From what I understand there is no replica yet right?

AAtinux I get around 200ms of latency when querying the database (living in France). Is ...

zegevlier•4/8/23, 7:15 PM

AFAIK the database is hosted wherever the DO behind it gets created, which is usually near to where the first request is made. Is the latency lower when you are requesting from the US?

AAtinux From what I understand there is no replica yet right?

zegevlier•4/8/23, 7:15 PM

Not yet!

TigersWay•4/9/23, 1:34 AM

Hi, Is some kind of

REGEXP

REGEXP

extension already installed (and I did not yet succeed to call it), or will it be later?
Thanks

mrwind•4/9/23, 9:26 AM

is d1 support index by column?

Mmrwind is d1 support index by column?

Matt Silverlock•4/9/23, 12:34 PM

Yes: https://www.sqlitetutorial.net/sqlite-index/

SQLite Tutorialadmin

SQLite Index: An Essential Guide to SQLite Indexes

In this tutorial, you will learn how to utilize SQLite index to query data faster, speed up sort operation, and enforce unique constraints.

Jökull Sólberg•4/9/23, 5:13 PM

Is there a way to see where the D1 is hosted? I know replication is not yet switched on but I would love to get a sense of things. Also, is it possible to move the DB, perhaps by recreating it? Super excited about D1.

Jökull Sólberg•4/9/23, 5:16 PM

Also. Random observation, sqlite very powerful paradigm for user/org specific things. So if product is like Salesforce, each org could evolve schema with fields they want to use for their db. Opens door to amazing tooling! Not yet supported but interesting angle - dynamic bindings?

Cyb3r-Jak3•4/10/23, 12:41 PM

I thought there was

you can, but it'll always be called `results`, so you'll need to make the second call `const { resul

Similar Threads