Here should be fine - in the interim, if you open your browser’s devtools, you’ll have the metrics i

Here should be fine - in the interim, if you open your browser’s devtools, you’ll have the metrics in the response under the same meta object.

Not ideal, but if you just want to quickly check a query then it’s there

Kkian Here should be fine - in the interim, if you open your browser’s devtools, you’l...

Adi•10/27/23, 9:59 AM

Oh my lord you're absolutely correct. Thank you!!
This helps so much in the interim XD

charl.dev•10/27/23, 1:37 PM

im trying to seed my dbs but keep getting

The request is malformed: failed to decode id

The request is malformed: failed to decode id

charl.dev•10/27/23, 1:38 PM

"code": 7400,

charl.dev•10/27/23, 1:38 PM

just basic queries, nothing fancy

Dahoom•10/27/23, 1:38 PM

the issue is with the request, just telling us its basic doesnt really help :)

Dahoom•10/27/23, 1:39 PM

if you want you can just show the id column and what you tried to insert into it, incase its sensitive data

charl.dev•10/27/23, 1:41 PM

the db is emtpy, im trying to create the tables via query

charl.dev•10/27/23, 1:41 PM

e.g.

https://api.cloudflare.com/client/v4/accounts/account_id/d1/database/db_id/query

{
  "params": [],
  "sql": "DROP TABLE IF EXISTS comments; CREATE TABLE IF NOT EXISTS comments ( id integer PRIMARY KEY AUTOINCREMENT, author text NOT NULL, body text NOT NULL, post_slug text NOT NULL ); CREATE INDEX idx_comments_post_slug ON comments (post_slug);"
}

https://api.cloudflare.com/client/v4/accounts/account_id/d1/database/db_id/query

{
  "params": [],
  "sql": "DROP TABLE IF EXISTS comments; CREATE TABLE IF NOT EXISTS comments ( id integer PRIMARY KEY AUTOINCREMENT, author text NOT NULL, body text NOT NULL, post_slug text NOT NULL ); CREATE INDEX idx_comments_post_slug ON comments (post_slug);"
}

Dahoom•10/27/23, 1:42 PM

try

CREATE TABLE IF NOT EXISTS comments ( id integer PRIMARY KEY, author text NOT NULL, body text NOT NULL, post_slug text NOT NULL ); CREATE INDEX idx_comments_post_slug ON comments (post_slug)

CREATE TABLE IF NOT EXISTS comments ( id integer PRIMARY KEY, author text NOT NULL, body text NOT NULL, post_slug text NOT NULL ); CREATE INDEX idx_comments_post_slug ON comments (post_slug)

(removed autoincrement)

charl.dev•10/27/23, 1:42 PM

my bad

charl.dev•10/27/23, 1:42 PM

was using db name instead of id

Dahoom•10/27/23, 1:43 PM

ah no problem

Dahoom•10/27/23, 1:43 PM

happens sometimes

slagathor•10/27/23, 8:46 PM

Does anyone have a good way to visualize D1 data?

slagathor•10/27/23, 8:47 PM

Right now I'm using DataGrip with https://github.com/isaac-mcfadyen/d1-jdbc-driver, but it's a bit buggy

slagathor•10/27/23, 8:48 PM

(Honestly it's been very helpful so far. I'm just curious what other people are using.)

Sslagathor Right now I'm using DataGrip with https://github.com/isaac-mcfadyen/d1-jdbc-driv...

Paul•10/28/23, 2:45 PM

this is exactly what i've been looking for, thanks. What's buggy about it?

Paul•10/28/23, 3:02 PM

i'm going to try and use that with DBeaver

Paul•10/28/23, 3:02 PM

or is that a bad idea?

Paul•10/28/23, 3:24 PM

How can we export the sqlite backup file for our beta D1?

PPaul How can we export the sqlite backup file for our beta D1?

Cyb3r-Jak3•10/28/23, 3:32 PM

You can use https://github.com/nora-soderlund/cloudflare-d1-backups to backup your database and then download that. There is currently no built in way

Onik•10/28/23, 5:54 PM

Hey guys, has anyone tried to access their database using a client? or is it only via packages they provided or API?
Client being like HeidiSQL, or Visual Studio Code Database Extension

Dahoom•10/28/23, 6:13 PM

I think the only way to access it is through workers/cloudflare REST api

OOnik Hey guys, has anyone tried to access their database using a client? or is it onl...

Dahoom•10/28/23, 6:16 PM

You could create your own worker that routes your sql queries or you can use https://github.com/elithrar/http-api-d1-example (I have not used it for a while so I'm unsure if it still works)

Onik•10/28/23, 6:17 PM

sounds good, thanks

Kkian Here should be fine - in the interim, if you open your browser’s devtools, you’l...

Old Man Maker•10/28/23, 6:21 PM

That's really awesome

Rex•10/28/23, 7:21 PM

Is there a way to upload sql to d1?

Rex•10/28/23, 7:29 PM

or run sql

RRex or run sql

Dahoom•10/28/23, 7:30 PM

https://developers.cloudflare.com/workers/wrangler/commands/#execute

Commands - Wrangler · Cloudflare Workers docs

Create, develop, and deploy your Cloudflare Workers with Wrangler commands.

Rex•10/28/23, 7:31 PM

Thank you

EvanPiro•10/28/23, 7:32 PM

When running migrations that create temp tables, copy data, drop the original tables, and rename the new tables, how much memory do I have to perform this operation?

EvanPiro•10/28/23, 7:33 PM

For instance sqlite doesn't support adding a foreign key column to an existing table, so you need to create a new table and migrate.

DDahoom https://developers.cloudflare.com/workers/wrangler/commands/#execute

Rex•10/28/23, 8:04 PM

Trying to run commands read on page but it just says syntac error

Dahoom•10/28/23, 8:04 PM

that means your command is incorrect

Dahoom•10/28/23, 8:04 PM

use gippity to form your command

Dahoom•10/28/23, 8:05 PM

some people mistake the understandable mistake of using regular sql syntax with sqlite

Rex•10/28/23, 8:07 PM

whats the command to execute sql i made?

Dahoom•10/28/23, 8:08 PM

Rex•10/28/23, 8:08 PM

like how can i inject my sql into the databvase

Dahoom•10/28/23, 8:10 PM

Its been a while since i've done it but its something similar to

wrangler d1 execute <DATABASE_NAME> --command "SELECT * FROM table"

wrangler d1 execute <DATABASE_NAME> --command "SELECT * FROM table"

Rex•10/28/23, 8:11 PM

right

Rex•10/28/23, 8:11 PM

still having issues but its fine for now

kianOP•10/29/23, 11:02 AM

How have you checked that the database doesn’t update?

IdkWhatever69•10/29/23, 5:21 PM

hi guys

IdkWhatever69•10/29/23, 5:22 PM

hows the d1 latency?

Original message was deleted

IdkWhatever69•10/29/23, 7:44 PM

doesnt d1 automatically spawn replicas?

IdkWhatever69•10/29/23, 9:03 PM

does D1 also have the write constrains of sqlite? (max ~1-10k row writes/s)

https://api.cloudflare.com/client/v4/accounts/account_id/d1/database/db_id/query { "params": [], "sql": "DROP TABLE IF EXISTS comments; CREATE TABLE IF NOT EXISTS comments ( id integer PRIMARY KEY AUTOINCREMENT, author text NOT NULL, body text NOT NULL, post_slug text NOT NULL ); CREATE INDEX idx_comments_post_slug ON comments (post_slug);" }

Here should be fine - in the interim, if you open your browser’s devtools, you’ll have the metrics i

Similar Threads

Similar Threads

Similar Threads