I tried making a request to /query/batch and I get page not found

U

Up•10/14/23, 3:46 PM

anyone know what I'm doing wrong when trying to dump my DB?

const dump = await c.env.DB.dump();
    return new Response(dump, {
        status: 200,
        headers: {
            'Content-Type': 'application/octet-stream',
            'Content-Disposition': 'attachment; filename="sqlite.db"',
        }
    });

const dump = await c.env.DB.dump();
    return new Response(dump, {
        status: 200,
        headers: {
            'Content-Type': 'application/octet-stream',
            'Content-Disposition': 'attachment; filename="sqlite.db"',
        }
    });

const dump = await c.env.DB.dump();
    return new Response(dump, {
        status: 200,
        headers: {
            'Content-Type': 'application/octet-stream',
            'Content-Disposition': 'attachment; filename="sqlite.db"',
        }
    });

const dump = await c.env.DB.dump();
    return new Response(dump, {
        status: 200,
        headers: {
            'Content-Type': 'application/octet-stream',
            'Content-Disposition': 'attachment; filename="sqlite.db"',
        }
    });

running locally, getting a

D1_DUMP_ERROR: Status + 404

D1_DUMP_ERROR: Status + 404

D1_DUMP_ERROR: Status + 404

D1_DUMP_ERROR: Status + 404 when I call that endpoint

U

Up•10/14/23, 4:24 PM

CCyb3r-Jak3 @Samantas5855 The `/query/batch` endpoint exists for the worker because it calls...

S

Samantas5855OP•10/14/23, 5:27 PM

regarding that, it doesn't seem to exist anymore

S

Samantas5855OP•10/14/23, 5:28 PM

unless I'm doing something wrong?

MMatt Silverlock Note that if you're using DBeaver: I don't think it supports D1. Local SQLite !=...

P

Paul•10/14/23, 7:52 PM

are there any GUI clients we can use to view the local .wrangler/ D1?

SSamantas5855 I tried making a request to /query/batch and I get page not found

M

Matt Silverlock•10/14/23, 8:09 PM

I think you’re mixing up a standalone example with D1’s official API. I strongly recommend slowing down a tad and reading the docs:

SSamantas5855 I tried making a request to /query/batch and I get page not found

M

Matt Silverlock•10/14/23, 8:09 PM

The example you are referring to has nothing to do with D1’s official REST API.

M

Matt Silverlock•10/14/23, 8:11 PM

I invite folks to open GitHub issues so we can understand where/why they are running into limits -> allows us to increase them where it makes sense to. It’s not “fixed” at 32, but if you’re generating 1000+ then something is likely wrong with the query. This is why we ask folks to open issues (or use the form linked in the docs)

MMatt Silverlock The example you are referring to has nothing to do with D1’s official REST API.

S

Samantas5855OP•10/14/23, 10:52 PM

is there any example of performning batch commands with the official d1 rest api?

S

Samantas5855OP•10/14/23, 10:53 PM

it's the last piece that's missing to complete the implementation

C

Cyb3r-Jak3•10/14/23, 11:17 PM

You won't get the same transaction benefits as using a worker but something like

INSERT INTO 'tablename' ('column1', 'column2') VALUES
  ('data1', 'data2'),
  ('data3', 'data4'),
  ('data5', 'data6'),
  ('data7', 'data8');`

INSERT INTO 'tablename' ('column1', 'column2') VALUES
  ('data1', 'data2'),
  ('data3', 'data4'),
  ('data5', 'data6'),
  ('data7', 'data8');`

INSERT INTO 'tablename' ('column1', 'column2') VALUES
  ('data1', 'data2'),
  ('data3', 'data4'),
  ('data5', 'data6'),
  ('data7', 'data8');`

INSERT INTO 'tablename' ('column1', 'column2') VALUES
  ('data1', 'data2'),
  ('data3', 'data4'),
  ('data5', 'data6'),
  ('data7', 'data8');`

as a statement should work. Do also keep in mind that the API has a rate limit of 1200 requests per 5 minutes which is another reason deploying your own worker as an REST endpoint is recommended

CCyb3r-Jak3 You won't get the same transaction benefits as using a worker but something like...

S

Samantas5855OP•10/15/23, 12:12 AM

this has a limit of 32

S

Samantas5855OP•10/15/23, 12:12 AM

that's why I want batch

C

Cyb3r-Jak3•10/15/23, 12:31 AM

Ah gotcha then to batch you’ll need to run the proxy worker

K

Kaique Nunes•10/15/23, 8:39 AM

can I create trigger functions in D1 ? For example, I need to auto update a counter in table B when there is a new insert in table A

CCyb3r-Jak3 Ah gotcha then to batch you’ll need to run the proxy worker

S

Samantas5855OP•10/15/23, 9:36 AM

Yeah but that would cost extra

S

Samantas5855OP•10/15/23, 9:37 AM

It would make sense if the rest api just had an endpoint for it

KKaique Nunes can I create trigger functions in D1 ? For example, I need to auto update a coun...

K

Kaique Nunes•10/15/23, 11:07 AM

nervermind, it's possible just like SQLITE.

SSamantas5855 Yeah but that would cost extra

C

Cyb3r-Jak3•10/15/23, 1:09 PM

You get 100k requests per day for free with workers.

KKaique Nunes can I create trigger functions in D1 ? For example, I need to auto update a coun...

P

Paul•10/15/23, 2:26 PM

Yep, working great too!

Y

Yasin•10/15/23, 2:34 PM

Hello Cloudflare community

. I need help accessing tables in databases. I have created a database and binded it to my worker through workers.toml file. But when I make a search in a particular table, it gives "no such table" error. Here is an image of tables in my database, "Customers" is just for test purposes.

Y

Yasin•10/15/23, 2:35 PM

app.get('/posts/:lang/:slug/comments', async c => {

    const { results } = await c.env.comDB.prepare(

app.get('/posts/:lang/:slug/comments', async c => {

    const { results } = await c.env.comDB.prepare(

app.get('/posts/:lang/:slug/comments', async c => {

    const { results } = await c.env.comDB.prepare(

app.get('/posts/:lang/:slug/comments', async c => {

    const { results } = await c.env.comDB.prepare(

SELECT name, sql FROM sqlite_master

);
        return c.text(results, 200);

}

);
        return c.text(results, 200);

}

);
        return c.text(results, 200);

}

);
        return c.text(results, 200);

}

Here I am just trying to list all tables

Y

Yasin•10/15/23, 2:36 PM

here is the response, no tables

Y

Yasin•10/15/23, 2:40 PM

I have tried deleting and recreating the database and the tables many times. It doesn't work

YYasin Hello Cloudflare community 👋 . I need help accessing tables in databases. I hav...

C

Cyb3r-Jak3•10/15/23, 2:52 PM

Wrangler dev uses local mode by default so it doesn’t use the values in the dashboard. You can add values by running the d1 execute command with the

—local

—local

flag

I

Ian•10/15/23, 3:24 PM

For database-per-user usecase, is there no dynamic binding to avoid having to modify workers binding every time a new database is added ?

IIan For database-per-user usecase, is there no dynamic binding to avoid having to mo...

C

Cyb3r-Jak3•10/15/23, 3:43 PM

Correct. That is something they want to do but isn’t possible currently.

CCyb3r-Jak3 Correct. That is something they want to do but isn’t possible currently.

I

Ian•10/15/23, 3:43 PM

perhaps having somehting like "database-group"

I

Ian•10/15/23, 3:44 PM

well, i'll keep waiting for updates i guess

CCyb3r-Jak3 Wrangler dev uses local mode by default so it doesn’t use the values in the dash...

Y

Yasin•10/15/23, 4:00 PM

Nothing has changed unfortunately

YYasin Nothing has changed unfortunately

C

Cyb3r-Jak3•10/15/23, 4:03 PM

Actually looking at your code you never execute the query. You need to add

.all()

.all()

at the end of your prepare in order to use the statement

C

Cyb3r-Jak3•10/15/23, 4:04 PM

Docs: https://developers.cloudflare.com/d1/platform/client-api/#await-stmtall

CCyb3r-Jak3 Actually looking at your code you never execute the query. You need to add `.all...

Y

Yasin•10/15/23, 4:06 PM

It's working now. The weird thing is, it used to work without --local keyword when I first created it. Thanks for the help

P

Paul•10/16/23, 2:29 AM

anyone else with boolean issues?

Error: D1_TYPE_ERROR: Type 'boolean' not supported for value 'true'

Error: D1_TYPE_ERROR: Type 'boolean' not supported for value 'true'

PPaul anyone else with boolean issues? `Error: D1_TYPE_ERROR: Type 'boolean' not suppo...

C

Cyb3r-Jak3•10/16/23, 2:31 AM

What does your schema look like? SQLite doesn't have a concept of boolean and uses an integer instead

P

Paul•10/16/23, 2:32 AM

oh lol, well it is somehow a boolean

P

Paul•10/16/23, 2:32 AM

email_verified BOOLEAN DEFAULT 0,

email_verified BOOLEAN DEFAULT 0,

P

Paul•10/16/23, 2:32 AM

how is this possible

C

Cyb3r-Jak3•10/16/23, 2:33 AM

Ah instead of using

true

true

use

for your SQL query

P

Paul•10/16/23, 2:33 AM

ooof, kinda difficult, i'm many layers above where that happens.

P

Paul•10/16/23, 2:33 AM

https://tenor.com/view/shummer-death_dive-dive-fail-failed-dive-dive-gif-12569456

Tenor

C

Cyb3r-Jak3•10/16/23, 2:34 AM

Are you using an ORM or something?

P

Paul•10/16/23, 2:34 AM

using Lucia adapter

P

Paul•10/16/23, 2:34 AM

so i don't really have access to that

C

Cyb3r-Jak3•10/16/23, 2:35 AM

Might be worth asking in their discord if this is a known thing

R

riskiidrus•10/16/23, 3:08 AM

Does anyone know why D1 feels slow for simple queries or commands?

I live in Indonesia, I access D1 from there. This is what the query or command looks like:

SELECT * FROM users WHERE id = ? LIMIT 1

.....

UPDATE user SET ..... WHERE id = ?

Even the User Registration Process took a few seconds for me to complete. I thought it was just a problem of my slow internet connection, but when I tried to deploy it on Pages, it made no difference.

Isn't it on the Page "https://pages.cloudflare.com" that Cloudflare claims that they run the Pages Project on the Cloudflare Edge Network which is up to 115% faster than competing platforms?

I'm afraid this will be a Bad End User Experience.

U

Unsmart•10/16/23, 3:17 AM

D1 is single region so the database exists in 1 location and might not be super close to you causing latency.

For me D1 queries are pretty fast ~100ms

T

TigersWay•10/16/23, 4:54 AM

Cloud someone confirm the create DB D1 API (https://developers.cloudflare.com/api/operations/cloudflare-d1-create-database#Request) doesn't allow to set a location hint as wrangler or the dashboard do?

Cloudflare API Documentation

Interact with Cloudflare's products and services via the Cloudflare API

K

kian•10/16/23, 7:44 AM

d1-database

I tried making a request to /query/batch and I get page not found

Similar Threads

Similar Threads

Similar Threads