if my module is multiple js files will this handle that?

ag_dubsOP•8/21/23, 2:22 PM

(this is what i mean by bundling, i realize that that was ambuguous in this context, apologies)

ag_dubsOP•8/21/23, 2:23 PM

i know this says multiple modules can be present but it's not clear to me if that means js modules that are conceptually a single worker module or multiple worker modules

Aag_dubs if my module is multiple js files will this handle that?

Matt Silverlock•8/21/23, 2:23 PM

Yes. All of this is (only) single Worker.

ag_dubsOP•8/21/23, 2:24 PM

oh ok awesome, well that rules

Matt Silverlock•8/21/23, 2:30 PM

Gotta fix that content-type drop down / properly default to module worker syntax in those docs

kian•8/21/23, 2:33 PM

Wrangler typically bundles it all into a single file w/ esbuild but added

--no-bundle

--no-bundle

which is basically what you're doing with the API, and allows 'proper' dynamic imports

sultan.xh•8/21/23, 3:15 PM

I am wondering any json function that can be used in where clause to get matched data?

sultan.xh•8/21/23, 3:18 PM

For example, I want to get all the rows where status is 1.

id | data
1 | { "status": 1 }
2 | { "status": 0 }
3 | { "status": 1 }

It will return 1 and 3

sultan.xh•8/21/23, 3:35 PM

SELECT * FROM content WHERE json_extract(data, '$.status') = 1

SELECT * FROM content WHERE json_extract(data, '$.status') = 1

sultan.xh•8/21/23, 3:37 PM

Love these JSON functions. Thanks for the great work!

sultan.xh•8/21/23, 4:40 PM

How to order data like DESC?

RRenato On this beta version, how can I download a copy of the database?

sultan.xh•8/21/23, 4:43 PM

Read this https://developers.cloudflare.com/d1/learning/backups/

Backups (Legacy) · 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 …

landon•8/21/23, 5:02 PM

im getting an odd behavior in my pages project when trying to bind a d1 database. i printed out the env from one of the routes and noticed the variable

__D1_BETA__D1_DB

__D1_BETA__D1_DB

rather than

D1_DB

D1_DB

that i have specified as the binding in the settings. what could be causing this?

landon•8/21/23, 5:03 PM

could this be a symptom of using wrangler

3.4.0

3.4.0

rather than

3.5.1

3.5.1

RRenato On this beta version, how can I download a copy of the database?

Cyb3r-Jak3•8/21/23, 5:06 PM

The beta backend doesn’t allow for you to export a copy

Llandon could this be a symptom of using wrangler `3.4.0` rather than `3.5.1`?

Cyb3r-Jak3•8/21/23, 5:08 PM

Correct. They removed the D1 shim in wrangler 3.5.0

landon•8/21/23, 5:08 PM

so upgrade wrangler and maybe thats the win?

sultan.xh•8/21/23, 5:09 PM

Anyone can help me figure out the ORDER BY option?

Ssultan.xh Anyone can help me figure out the ORDER BY option?

chientrm.com•8/21/23, 5:15 PM

say it

Cchientrm.com say it

sultan.xh•8/21/23, 5:30 PM

How can I sort data by id? Something like

order by id desc

order by id desc

Ssultan.xh How can I sort data by id? Something like `order by id desc`?

chientrm.com•8/21/23, 5:32 PM

that's it

Cchientrm.com that's it

sultan.xh•8/21/23, 5:36 PM

Ahh thanks! I was checking this query

'SELECT * FROM content WHERE json_extract(data, "$.s") IN (0,1) AND json_extract(data, "$.t") IN (0) ORDER BY id DESC LIMIT 10 OFFSET 10'

'SELECT * FROM content WHERE json_extract(data, "$.s") IN (0,1) AND json_extract(data, "$.t") IN (0) ORDER BY id DESC LIMIT 10 OFFSET 10'

and it worked.

But if you add

order by

order by

end of the query, it does not work. Anyways, thanks again.

landon•8/21/23, 5:40 PM

ive upgraded to 3.5.1, removed bindings, re-added, re-deployed still getting the same behavior:

__D1_BETA_

__D1_BETA_

is being added as a prefix in the environment, but not binding named

DB

DB

binding name: DB
env contains: __D1_BETA_DB

binding name: DB
env contains: __D1_BETA_DB

I tried to reference that variable

__D1_BETA_DB

__D1_BETA_DB

, but it tells me that there is no function

prepare

prepare

on it.

im expecting (and this was previous behavior) that a

DB

DB

variable is hanging on the env that i can call prepare on. any ideas?

Original message was deleted

mrwind•8/21/23, 11:57 PM

lol i looking for that too on yesterday on a previous version we can run backup. but with that timetravel the backup command will not work.I will try your library

Cretezy•8/22/23, 3:56 AM

Hi! Quick question: How can I create (and download) a backup with wrangler?
Using

wrangler d1 backup create <db>

wrangler d1 backup create <db>

throws

Experimental DBs do not support backups yet

Experimental DBs do not support backups yet

(Seems like I have Time Travel enabled on my DB, but no way to download it's contents?)

itstmillertime•8/22/23, 4:49 AM

With wrangler v3,

--persist-to=./path-to-persist-db

--persist-to=./path-to-persist-db

is not working as expected.

I don't see any directory being populated with the sqlite DB

CCretezy Hi! Quick question: How can I create (and download) a backup with wrangler? Usin...

Matt Silverlock•8/22/23, 6:49 AM

There is no support for downloading backups at this point. You don’t need to with Time Travel. https://developers.cloudflare.com/d1/learning/time-travel/

Time Travel and backups · Cloudflare D1 docs

Time Travel is D1’s approach to backups and point-in-time-recovery, and allows you to restore a database to any minute within the last 30 days.

Mikyari•8/22/23, 8:13 AM

When I try to backup my db manually, I got this error. Do I have to submit the request to enable this feature?
X [ERROR] A request to the Cloudflare API (/accounts/c3b90596442e73b936440cef3f7895f8/d1/database/ebe13d38-cbc0-465f-a1dd-0f533ea1aeed/backup) failed.

The request is malformed: Experimental DBs do not support backups yet:
ebe13d38-cbc0-465f-a1dd-0f533ea1aeed (v3) [code: 7400]

MMikyari When I try to backup my db manually, I got this error. Do I have to submit the r...

Hello, I’m Allie!•8/22/23, 8:17 AM

No, it means that this feature just doesn’t exist yet, so it can’t be enabled

Mikyari•8/22/23, 8:18 AM

thank you

Mikyari•8/22/23, 8:21 AM

I get stuck when I tried to input real number on the web UI.

Mikyari•8/22/23, 8:22 AM

Even though I set the column to

REAL

REAL

value

MMikyari I get stuck when I tried to input real number on the web UI.

Max (@rozenmd)•8/22/23, 8:25 AM

looks like a bug, will investigate

fork•8/22/23, 10:37 AM

Thanks for great product, I've done some searches in here but can't get to bottom of what is likely pricing structure going forward, I've seen one based on pure rows read/written and another based on 4kb/1kb blocks read/written. Which is the model planned to take forward? Or are they the same model? Best

Ffork Thanks for great product, I've done some searches in here but can't get to botto...

Max (@rozenmd)•8/22/23, 10:38 AM

https://developers.cloudflare.com/d1/platform/pricing/#billing-metrics

Pricing · Cloudflare D1 docs

While in public Alpha, D1 is currently free to use on all Workers plans. Refer to the our recent announcement ) for more information.

Max (@rozenmd)•8/22/23, 10:39 AM

you'll be able to see how many rows your database reads/writes in the metrics tab in the dashboard very soon

MMax (@rozenmd)https://developers.cloudflare.com/d1/platform/pricing/#billing-metrics

fork•8/22/23, 10:40 AM

Thanks @rozenmd, does that mean a structure that makes use of the rich json querying may fare better than breaking more of the data into rows? For example, logging timestamps or user logins may be more affordable in a single text column in json format, then a table with rows marking timestamps?

Max (@rozenmd)•8/22/23, 10:42 AM

it may, but I wonder if performance would suffer vs using a regular table with an index

MMax (@rozenmd)it may, but I wonder if performance would suffer vs using a regular table with a...

fork•8/22/23, 10:43 AM

Many thanks, seems like a very clear pricing model. Do you have a sense of how likely it will be you stick with it through to production?

Ffork Many thanks, seems like a very clear pricing model. Do you have a sense of how l...

Max (@rozenmd)•8/22/23, 10:45 AM

can't say/don't know tbh, but we're aiming to be affordable w/ very clear pricing, so would iterate towards that goal if we did change

fork•8/22/23, 10:46 AM

(You might want to update either this blog post "D1: We turned it up to 11" or the pricing page header as it seems to suggest the blog post has the more up-to-date information)

Ffork (You might want to update either this blog post "D1: We turned it up to 11" or t...

Max (@rozenmd)•8/22/23, 10:49 AM

fair point, will do

Nat•8/22/23, 1:22 PM

I'm trying to use d1 in my worker but something about adding the wrangler config totally broke my

wrangler dev

wrangler dev

⎔ Starting local server...
workerd/server/workerd-api.c++:615: error: wrapped binding module can't be resolved (internal modules only); moduleName = cloudflare-internal:d1-api
workerd/util/symbolizer.c++:99: warning: Not symbolizing stack traces because $LLVM_SYMBOLIZER is not set. To symbolize stack traces, set $LLVM_SYMBOLIZER to the location of the llvm-symbolizer binary. When running tests under bazel, use `--test_env=LLVM_SYMBOLIZER=<path>`.
workerd/jsg/util.c++:275: error: e = workerd/server/workerd-api.c++:635: failed: expected !value.IsEmpty(); global did not produce v8::Value
stack: 104c8d3cf 104f000cf 104c55d6f 104c5ad4f 104c5d717 104c5c397 104c4fe87 104c4fc23 104c4fa8f 104c4fa77 106562367 1065625c3 106560d1b 106560aeb 104c441ab 1a8577f27; sentryErrorContext = jsgInternalError
service core:user:<MY_PROJECT_NAME>: Uncaught Error: internal error
✘ [ERROR] MiniflareCoreError [ERR_RUNTIME_FAILURE]: The Workers runtime failed to start. There is likely additional logging output above.

⎔ Starting local server...
workerd/server/workerd-api.c++:615: error: wrapped binding module can't be resolved (internal modules only); moduleName = cloudflare-internal:d1-api
workerd/util/symbolizer.c++:99: warning: Not symbolizing stack traces because $LLVM_SYMBOLIZER is not set. To symbolize stack traces, set $LLVM_SYMBOLIZER to the location of the llvm-symbolizer binary. When running tests under bazel, use `--test_env=LLVM_SYMBOLIZER=<path>`.
workerd/jsg/util.c++:275: error: e = workerd/server/workerd-api.c++:635: failed: expected !value.IsEmpty(); global did not produce v8::Value
stack: 104c8d3cf 104f000cf 104c55d6f 104c5ad4f 104c5d717 104c5c397 104c4fe87 104c4fc23 104c4fa8f 104c4fa77 106562367 1065625c3 106560d1b 106560aeb 104c441ab 1a8577f27; sentryErrorContext = jsgInternalError
service core:user:<MY_PROJECT_NAME>: Uncaught Error: internal error
✘ [ERROR] MiniflareCoreError [ERR_RUNTIME_FAILURE]: The Workers runtime failed to start. There is likely additional logging output above.

The wrangler.toml config seems pretty straightforward:

[[d1_databases]]
  binding = "DB" # i.e. available in your Worker on env.DB
  database_name = "REDACTED"
  database_id = "REDACTED"

[[d1_databases]]
  binding = "DB" # i.e. available in your Worker on env.DB
  database_name = "REDACTED"
  database_id = "REDACTED"

Could someone help me sort this out?

Nat•8/22/23, 1:36 PM

Looks like ^ happens when you try to add a d1 config to your

wrangler.toml

wrangler.toml

but you're still using the old ServiceWorker format.

wrangler deploy

wrangler deploy

gave a much better error message that helped me sort this out. But maybe y'all can improve that error message on

wrangler dev

wrangler dev

MMatt Silverlock There is no support for downloading backups at this point. You don’t need to wit...

Cretezy•8/22/23, 2:05 PM

I think it's very important to be able to export data out of 3rd parties. I strongly believe backups/exports should be implemented

CCretezy I think it's _very_ important to be able to export data out of 3rd parties. I st...

Hello, I’m Allie!•8/22/23, 2:07 PM

Note too that afaik this is a planned feature at some point, it just isn’t built yet.

Cretezy•8/22/23, 2:07 PM

Thanks, that makes sense.

⎔ Starting local server... workerd/server/workerd-api.c++:615: error: wrapped binding module can't be resolved (internal modules only); moduleName = cloudflare-internal:d1-api workerd/util/symbolizer.c++:99: warning: Not symbolizing stack traces because $LLVM_SYMBOLIZER is not set. To symbolize stack traces, set $LLVM_SYMBOLIZER to the location of the llvm-symbolizer binary. When running tests under bazel, use `--test_env=LLVM_SYMBOLIZER=<path>`. workerd/jsg/util.c++:275: error: e = workerd/server/workerd-api.c++:635: failed: expected !value.IsEmpty(); global did not produce v8::Value stack: 104c8d3cf 104f000cf 104c55d6f 104c5ad4f 104c5d717 104c5c397 104c4fe87 104c4fc23 104c4fa8f 104c4fa77 106562367 1065625c3 106560d1b 106560aeb 104c441ab 1a8577f27; sentryErrorContext = jsgInternalError service core:user:<MY_PROJECT_NAME>: Uncaught Error: internal error ✘ [ERROR] MiniflareCoreError [ERR_RUNTIME_FAILURE]: The Workers runtime failed to start. There is likely additional logging output above.

if my module is multiple js files will this handle that?

Similar Threads

Similar Threads

Similar Threads