Cloudflare Developers•3y ago

You can use the REST API to query your database.

EEisenbergEffect Is it possible to connect a local tool like SQLiteStudio to a remote D1 database...

Cyb3r-Jak3OP•10/24/23, 12:28 PM

Not unless someone has added support for D1 API to the tool.

EEisenbergEffect Another question I have...there seems to be conflicting guidance in the docs on ...

Dahoom•10/24/23, 12:40 PM

both work

Dahoom•10/24/23, 12:41 PM

both do the same thing

Dahoom•10/24/23, 12:42 PM

i think its that way in the docs because the --d1 param was added after the toml method so they used that as an example

Dahoom•10/24/23, 12:42 PM

since d1 was in alpha

Dahoom•10/24/23, 12:44 PM

through a cloudflare worker

Dahoom•10/24/23, 12:45 PM

I run my projects in cloudflare pages so its just as easy as adding 1 parameter, but for you, you might need to create a worker that takes the api calls from your server and routes them to d1 and returns the answer

Dahoom•10/24/23, 12:45 PM

make sure to secure it with an api key or something with the secret variable

Dahoom•10/24/23, 12:48 PM

its already built you'll find it somewhere in the d1 docs

Dahoom•10/24/23, 12:49 PM

if not just look for a public repo, overall the worker should only be like ~5 lines if you dont want to add any validation or anything

CCyb3r-Jak3 You can use the REST API to query your database.

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

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 7f983ae1•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-Jak3OP•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 7f983ae1•10/24/23, 3:20 PM

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

Deleted User 7f983ae1•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-Jak3OP•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 7f983ae1•10/24/23, 3:22 PM

ok, thx a lot\

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

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

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

instead of having to click left and right constantly

Deleted User 7f983ae1•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

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

You can use the REST API to query your database.

Similar Threads