np, good luck on your project

DDahoom np, good luck on your project

C

captain•10/27/23, 5:46 AM

thank you for taking the time, it was very helpful!

A

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

To the D1 team, not sure if this is already on the cards but I have a feature request.
When making queries on the Cloudflare dashboard for D1, it would be great if we could get back query metrics similar to how the client API gives back metrics.
Would make testing query performance a breeze.

A

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

Also not sure if there is a better place to make this request (e.g github), if so, please let me know.

K

kian•10/27/23, 9:16 AM

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

A

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

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

C

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

The request is malformed: failed to decode id

The request is malformed: failed to decode id

C

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

"code": 7400,

C

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

just basic queries, nothing fancy

D

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

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

D

DahoomOP•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

C

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

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

C

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);"
}

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);"
}

D

DahoomOP•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)

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)

C

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

my bad

C

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

was using db name instead of id

D

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

ah no problem

D

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

happens sometimes

S

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

Does anyone have a good way to visualize D1 data?

S

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

S

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

P

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

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

P

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

i'm going to try and use that with DBeaver

P

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

or is that a bad idea?

P

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?

C

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

O

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

D

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

D

DahoomOP•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)

O

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

O

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

That's really awesome

R

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

Is there a way to upload sql to d1?

R

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

or run sql

RRex or run sql

D

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

R

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

Thank you

E

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?

E

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

R

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

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

D

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

that means your command is incorrect

D

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

use gippity to form your command

D

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

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

R

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

whats the command to execute sql i made?

D

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

??

R

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

like how can i inject my sql into the databvase

D

DahoomOP•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"

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

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

R

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

right

R

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

still having issues but its fine for now

K

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

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

I

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

hi guys

Similar Threads

Similar Threads

Similar Threads