are there any method currently to download the database file? I only saw it in the doc in legacy whi

are there any method currently to download the database file? I only saw it in the doc in legacy which only work in alpha release

Deleted User 7f983ae1OP•10/24/23, 2:39 PM

but not sure for now

GGuillaumeLakano Hi ! The LIMIT in a UPDATE/DELETE request doesn't seems to be supported, it's de...

GuillaumeLakano•10/24/23, 2:44 PM

Is it possible to enable this SQLite configuration option please?
Permit to uses LIMIT on UPDATE and DELETE requests are useful, especially for security reasons

DDeleted User 7f983ae1 are there any method currently to download the database file? I only saw it in t...

Cyb3r-Jak3•10/24/23, 2:53 PM

Not to directly download. There is a community project that will backup to R2 and then you can download from there.

Deleted User 7f983ae1OP•10/24/23, 3:20 PM

also what is account identifier and how can I find it?

Deleted User 7f983ae1OP•10/24/23, 3:20 PM

trying to use api

DDeleted User 7f983ae1 also what is account identifier and how can I find it?

Cyb3r-Jak3•10/24/23, 3:21 PM

https://developers.cloudflare.com/fundamentals/setup/find-account-and-zone-ids/

Find zone and account IDs · Cloudflare Fundamentals docs

Once you set up a new account and add your domain to Cloudflare, you may need access to your zone and account IDs for API operations.

Deleted User 7f983ae1OP•10/24/23, 3:22 PM

ok, thx a lot\

Deleted User 7f983ae1OP•10/24/23, 6:26 PM

Recommendation on web panel do have a input field to go to specific page

Deleted User 7f983ae1OP•10/24/23, 6:27 PM

instead of having to click left and right constantly

Deleted User 7f983ae1OP•10/24/23, 6:27 PM

like when I want to go to last page in 196 row, just type page 20 instead of having to click and load each page

Village (Josef)•10/24/23, 7:20 PM

Is there any documentation on transactions and rollback behavior? Is every query/batch it's own transaction effectively?

CCyb3r-Jak3 Not to directly download. There is a community project that will backup to R2 an...

matt•10/24/23, 7:57 PM

~~What's the link to this community project?~~ https://github.com/nora-soderlund/cloudflare-d1-backups

Dahoom•10/24/23, 8:14 PM

nora's project should be linked in the docs

Dahoom•10/24/23, 8:14 PM

if it isnt already

Billy•10/24/23, 8:16 PM

what do you all do for D1 types in sveltekit?

BBilly what do you all do for D1 types in sveltekit?

Matt Silverlock•10/24/23, 8:30 PM

See https://developers.cloudflare.com/d1/examples/d1-and-sveltekit/

Query D1 from SvelteKit · Cloudflare D1 docs

SvelteKit is a full-stack framework that combines the Svelte front-end framework with Vite for server-side capabilities and rendering. You can query …

Old Man Maker•10/25/23, 3:37 AM

I'm currently getting errors on wrangler executions:

npx wrangler d1 execute dbname --command 'PRAGMA table_info(tablename)'

npx wrangler d1 execute dbname --command 'PRAGMA table_info(tablename)'

Error is :

Unknown argument: table_info(tablename)'

Unknown argument: table_info(tablename)'

Old Man Maker•10/25/23, 3:37 AM

Some SQL commands are running, others are not

Old Man Maker•10/25/23, 3:40 AM

Actually, looking at this - I'm not sure if this is my fault or a change in wrangler etc?
I just noticed that the command above is using single quotes '...' - switched them out to double quotes and it now works. Strange thing is that all of these commands are saved in a file so I can just paste them in and execute... oh well. I guess that answers that one

kian•10/25/23, 3:50 AM

Are you on Windows?

kian•10/25/23, 3:51 AM

cmd

cmd

isn't a fan of single quotes.

GuillaumeLakano•10/25/23, 7:06 AM

Hi! How is billed the usage of SQL extension RETURNING * on INSERT/UPDATE/DELETE ?
Is the cost of the writing ( 500x to 1000x more expansive that a read cost ) offer the content returned?

kian•10/25/23, 7:10 AM

Take a look at the returned meta object and see how rows_read and rows_written change

kian•10/25/23, 7:10 AM

If they don’t change if you add RETURNING, then there is no difference to billing.

kian•10/25/23, 7:37 AM

Given the breakpoints, I assume you're using

wrangler dev

wrangler dev

kian•10/25/23, 7:37 AM

That is likely using an older version of

workerd

workerd

which doesn't have the changes merged.

kian•10/25/23, 7:38 AM

You need at least Wrangler 3.13.2 for the changes to be reflected in local development.

Kkian `cmd` isn't a fan of single quotes.

Old Man Maker•10/25/23, 12:15 PM

Thanks @kian, I think you are spot on - powershell appears to be fine, but this was backed into a cmd - great pick up. Cheers

EvanPiro•10/25/23, 2:23 PM

I'm not able to delete a table from d1 due to this mysterious error. It's the only table in my database.

Screen_Shot_2023-10-25_at_10.14.14_AM.png

EEvanPiro I'm not able to delete a table from d1 due to this mysterious error. It's the on...

EvanPiro•10/25/23, 2:23 PM

The table view also doesn't load

Screen_Shot_2023-10-25_at_10.23.46_AM.png

EEvanPiro The table view also doesn't load

EvanPiro•10/25/23, 2:25 PM

And now the issue has vanished

¯\_(ツ)_/¯

EEvanPiro And now the issue has vanished ¯\_(ツ)_/¯

EvanPiro•10/25/23, 2:26 PM

probably due to eventual consistency, right?

Farhian•10/25/23, 3:38 PM

Is there a D1 portal outage atm?

Farhian•10/25/23, 3:38 PM

I tried relogging and still nothing

kane•10/25/23, 3:39 PM

#cloudflare-status something wrong going on

Farhian•10/25/23, 3:39 PM

thank you @kane

EEvanPiro probably due to eventual consistency, right?

Chaika•10/25/23, 3:46 PM

(D1 isn't eventually consistent, no read replicas right now, strongly consistent)

EEvanPiro probably due to eventual consistency, right?

Matt Silverlock•10/25/23, 5:49 PM

There is an incident with a number of our APIs (not specific to D1, but affects the dashboard): https://www.cloudflarestatus.com/incidents/s1hkh315y9s9

Cloudflare Dashboard and Cloudflare API service issues

Fun Miles•10/25/23, 8:25 PM

Is it possible to get inserted row ids from a batch insert ?

FFun Miles Is it possible to get inserted row ids from a batch insert ?

Fun Miles•10/25/23, 8:33 PM

I found the answer: using "RETURNING rowId" at the end of the statement did the job.

Jacob Wright•10/25/23, 10:25 PM

I have a couple of questions about migrations. Do they run automatically locally, or remotely? Or do you always run them with the command? And second, is there any way to specify which migrations go to which database? It looks like you create them with a database name, but then any database will list them as a migration for it. Is that an oversight?

are there any method currently to download the database file? I only saw it in the doc in legacy whi

Similar Threads

Similar Threads

Similar Threads