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

D

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?

C

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.

D

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

ok, thx a lot\

D

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

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

D

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

instead of having to click left and right constantly

D

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

V

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

M

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

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

D

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

nora's project should be linked in the docs

D

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

if it isnt already

B

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?

M

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 …

O

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

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

Unknown argument: table_info(tablename)'

Unknown argument: table_info(tablename)'

O

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

Some SQL commands are running, others are not

O

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

K

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

Are you on Windows?

K

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

cmd

cmd

isn't a fan of single quotes.

G

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?

K

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

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

K

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

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

K

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

Given the breakpoints, I assume you're using

wrangler dev

wrangler dev

K

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

That is likely using an older version of

workerd

workerd

which doesn't have the changes merged.

K

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.

O

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

E

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

E

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

E

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

And now the issue has vanished

¯\_(ツ)_/¯

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

E

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

probably due to eventual consistency, right?

F

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

Is there a D1 portal outage atm?

F

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

I tried relogging and still nothing

K

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

#cloudflare-status something wrong going on

F

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

thank you @kane

EEvanPiro probably due to eventual consistency, right?

C

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?

M

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

F

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 ?

F

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

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

J

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?

G

GuillaumeLakano•10/26/23, 8:50 AM

There is not yet a #d1-feature-suggestions but I would like to suggest somes features:

G

GuillaumeLakano•10/26/23, 8:50 AM

1) To permit in a batch requests list to have a way to continue or stop the batch, based on the previous result. This will prevent multiple roundtrips between the Workers <=> D1, for example you want to execute some requests but first, you need to be sure the session of this user is still alive and also want to update the session:

await db.batch([
    db.prepare('UPDATE sessions SET updated=CURRENT_TIMESTAMP WHERE id_session=?1')
        .bind(session)
        .expect({ meta: { changes: 1 } }),
    db.prepare('SELECT * FROM ...'),
    ...
])

await db.batch([
    db.prepare('UPDATE sessions SET updated=CURRENT_TIMESTAMP WHERE id_session=?1')
        .bind(session)
        .expect({ meta: { changes: 1 } }),
    db.prepare('SELECT * FROM ...'),
    ...
])

await db.batch([
    db.prepare('UPDATE sessions SET updated=CURRENT_TIMESTAMP WHERE id_session=?1')
        .bind(session)
        .expect({ meta: { changes: 1 } }),
    db.prepare('SELECT * FROM ...'),
    ...
])

await db.batch([
    db.prepare('UPDATE sessions SET updated=CURRENT_TIMESTAMP WHERE id_session=?1')
        .bind(session)
        .expect({ meta: { changes: 1 } }),
    db.prepare('SELECT * FROM ...'),
    ...
])

G

GuillaumeLakano•10/26/23, 8:50 AM

2) An extension of this idea, still to prevent roundtrips, is to catch a value from a previous result and to uses it in another request of the batch. Imagine the client/browser never known his own id_user, only the session ID, but the id_user is stored in a field of the sesssion table, then you could optimise your roundtrips like this:

await db.batch([
    db.prepare('UPDATE sessions SET updated=CURRENT_TIMESTAMP WHERE id_session=?1 RETURNING *')
        .bind(session)
        .expect({ meta: { changes: 1 } })
        .set({ user: 'id_user' }), // Or user: [ 'id_user', 0 ] to indicate a position in the results array
        
    db.prepare('SELECT * FROM users WHERE id_user=?1').bind( db.get('user') )
    ...
])

await db.batch([
    db.prepare('UPDATE sessions SET updated=CURRENT_TIMESTAMP WHERE id_session=?1 RETURNING *')
        .bind(session)
        .expect({ meta: { changes: 1 } })
        .set({ user: 'id_user' }), // Or user: [ 'id_user', 0 ] to indicate a position in the results array
        
    db.prepare('SELECT * FROM users WHERE id_user=?1').bind( db.get('user') )
    ...
])

await db.batch([
    db.prepare('UPDATE sessions SET updated=CURRENT_TIMESTAMP WHERE id_session=?1 RETURNING *')
        .bind(session)
        .expect({ meta: { changes: 1 } })
        .set({ user: 'id_user' }), // Or user: [ 'id_user', 0 ] to indicate a position in the results array
        
    db.prepare('SELECT * FROM users WHERE id_user=?1').bind( db.get('user') )
    ...
])

await db.batch([
    db.prepare('UPDATE sessions SET updated=CURRENT_TIMESTAMP WHERE id_session=?1 RETURNING *')
        .bind(session)
        .expect({ meta: { changes: 1 } })
        .set({ user: 'id_user' }), // Or user: [ 'id_user', 0 ] to indicate a position in the results array
        
    db.prepare('SELECT * FROM users WHERE id_user=?1').bind( db.get('user') )
    ...
])

G

GuillaumeLakano•10/26/23, 8:50 AM

3) It's not really a feature, but activate the SQLite configuration flag SQLITE_ENABLE_UPDATE_DELETE_LIMIT to permit to uses LIMIT on INSERT/UPDATE/DELETE, could also permit us to optimise some requests and to add a layer of security.

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

Similar Threads

Similar Threads

Similar Threads