Cloudflare Developers•6mo ago

There is no D1 error message, just failed query

cosbgnOP•7/11/25, 11:14 AM

cosbgnOP•7/11/25, 11:15 AM

I just don't understand why it would fail

Ccosbgn There is no D1 error message, just failed query

lambrospetrou•7/11/25, 11:27 AM

Who is logging that? They hide the actual error message. I can't help without more details.

cosbgnOP•7/11/25, 11:28 AM

I guess is drizzle then

MMikkel-T Any plans to have jurisdiction for D1?

lambrospetrou•7/11/25, 2:15 PM

It's planned but no exact ETA we can communicate yet.

matt•7/12/25, 2:45 AM

are there any plans for global active-active D1? especially useful for append-only tables

Ccosbgn I guess is drizzle then

vkalahas•7/12/25, 5:41 AM

i've run into problems with drizzle and d1 too, it looks like they haven't run through all the edge cases

Ccosbgn I guess is drizzle then

vkalahas•7/12/25, 5:48 AM

it's also telling that none of the official cloudflare templates on their github use drizzle at all, i think the way to go is just SQL without any abstractions

iLearn•7/12/25, 10:20 AM

is following a valid SQL for execution by Cloudflare D1 .. thanks ..

Reason (shared by ChatGPT) : As of July 2025, there's no evidence that changes() is supported in D1. Its omission in docs combined with reported limitations strongly suggests it’s not available.

Worker Code Snippet with SQL execution planned :
// AIM : "to execute stmtUpdate statement ONLY if insertRes statement is success, without any JS stament in between D1 calls"
const stmts = await env.DB.batch([
env.DB.prepare(INSERT INTO users (sid) VALUES (?)INSERT INTO users (sid) VALUES (?)).bind(sid),
env.DB.prepare(


        UPDATE users
        SET number_of_books = number_of_books + 1
        WHERE sid = ?
          AND changes() = 1


        UPDATE users
        SET number_of_books = number_of_books + 1
        WHERE sid = ?
          AND changes() = 1

).bind(sid)
]);

SQL File : (for reference)

CREATE TABLE users (
id INTEGER PRIMARY KEY AUTOINCREMENT,
sid TEXT UNIQUE,
number_of_books INTEGER NOT NULL DEFAULT 0
);

PPotato ~thanks, but "..not sensitive .. on its own" ?? so far beside the database name i...

Silvan•7/12/25, 12:37 PM

its bound to the account yes

Vvkalahas i've run into problems with drizzle and d1 too, it looks like they haven't run t...

James•7/12/25, 7:57 PM

I find drizzle edge cases more annoying than just making the sql myself. There's still a bug that has something to do with setting an integer field as a date time with particular defaults in sql`` template syntax that just plain breaks. I'm sure there's more, but it was annoying as hell to deal with because it wasn't obvious at all.

JJames I find drizzle edge cases more annoying than just making the sql myself. There's...

vkalahas•7/12/25, 8:25 PM

i completely agree, drizzle has a lot of hype but it's not battle-tested, lots of non-obvious things breaking

i'm fairly comfortable in sql so the extra safety that drizzle provides isn't really worth it for small apps anyway in my opinion when you have to deal with the cost of fixing the bugs/problems that it causes

Vvkalahas i completely agree, drizzle has a lot of hype but it's not battle-tested, lots o...

James•7/12/25, 8:28 PM

not to mention with D1/DO, you're paying by the row r/w, it helps to fully understand your queries. AI sql generation just makes this even more of a no-brainer

JJames not to mention with D1/DO, you're paying by the row r/w, it helps to fully under...

vkalahas•7/12/25, 8:30 PM

definitely! it helps with cost too and SQL is a standard anyway so getting better at it never hurts

Original message was deleted

vkalahas•7/12/25, 8:33 PM

i just checked this out, look cool! so it's only a cli tool and no abstraction right?

vkalahas•7/12/25, 8:36 PM

it looks like the typescript variant is still in beta and they're mainly supporting postgres although i do see one sqlite example

vkalahas•7/12/25, 8:36 PM

https://github.com/sqlc-dev/sqlc-gen-typescript

GitHub

GitHub - sqlc-dev/sqlc-gen-typescript

Contribute to sqlc-dev/sqlc-gen-typescript development by creating an account on GitHub.

vkalahas•7/12/25, 8:37 PM

i don't think i'll use this right now but will definitely keep an eye out because it looks really cool!!

Original message was deleted

vkalahas•7/12/25, 8:44 PM

that makes sense, sqlc looks very mature on the go side as well as postgres

Silvan•7/13/25, 6:47 PM

i never realized sqlc works for js lol

dandoen•7/13/25, 10:11 PM

i want to export d1 to duckdb periodically for analytical queries. does anyone have an good reference architecture? i'm pretty worried about this mention of the docs:

A running export will block other database requests.
Source

IiLearn is following a valid SQL for execution by Cloudflare D1 .. thanks .. Reason (sh...

iLearn•7/14/25, 10:35 AM

bumping msg again for kind response .. thanks ..

Ashkan•7/14/25, 2:25 PM

Dear CF team would you please add option of Download Database SchemeDownload Database Scheme for D1 databases? why it's very important because database scheme may change in dashboard that makes some difference from original scheme that been deployed via wrangler. if there be an option to download current database scheme, then before deploying new original scheme for D1 databases we can check if there is any changes that hasn't been considered in original (local) databases scheme or not. Thank You you are the best.

AAshkan Dear CF team would you please add option of `Download Database Scheme` for D1 da...

James•7/14/25, 3:13 PM

pretty simple to download it yourself from sqlite_master

JJames pretty simple to download it yourself from sqlite_master

Ashkan•7/14/25, 3:47 PM

is it via dashboard? wrangler ? can u bring an example or a link to read about it? I haven't ever used sqlite_mastersqlite_master maybe I don't remember.

AAshkan is it via dashboard? wrangler ? can u bring an example or a link to read about i...

James•7/14/25, 3:48 PM

you gotta do it via raw sql, but all the schema data you need is already available, ask chatgpt if you're unsure how to do it in your own app context

if you're trying to manually manage schema, thats a recipe for disaster, you're better off having strict database migration cycles

JJames you gotta do it via raw sql, but all the schema data you need is already availab...

Ashkan•7/14/25, 3:50 PM

I will read about it thank you.

NNabeel Rahman why i am getting this error, can anyone help please?

Brayden•7/14/25, 6:49 PM

Do you have the code that's triggering that error available to share? TIMESTAMP isn't a data type in SQLite so I suspect it's something around your query.

NNabeel Rahman why i am getting this error, can anyone help please?

can•7/15/25, 5:01 AM

I'm getting the same error when i'm trying it. It was working just a day before :/ Could that may be related to CURRENT_TIMESTAMPCURRENT_TIMESTAMP?
These fields was already here for the last 3 months, so I assume it's related with drizzle. I installed and downgraded drizzle-zod and drizzle packages. That's maybe why.

Ddandoen i want to export d1 to duckdb periodically for analytical queries. does anyone h...

dandoen•7/15/25, 11:12 AM

pretty please? any guidance on just dumping it in r2 without blocking the db would also work.

Ddandoen pretty please? any guidance on just dumping it in r2 without blocking the db wou...

Brayden•7/15/25, 1:19 PM

Can't really think of a decent way of doing this without manually writing a service that queries and fetches N records at a time and then do the storing in R2 yourself in chunks to allow requests to continue between your requests. The risks there are if data changes that you've already exported then you kind of are in a bad state.

Exports on the database though will block other database requests.

BBrayden Can't really think of a decent way of doing this without manually writing a serv...

dandoen•7/15/25, 1:20 PM

if only there was a way – as a work around – to do point in time recovery of a d1 (replica) into a new d1, that i could then use to export and then delete aftewards. but looks like creating a d1 from a snapshot isn't supported either

TeamDave•7/15/25, 2:40 PM

Hello! I'm building out an analytics tool that makes a lot of db calls (10+ calls to get the things like total users, unique sessions, events, etc).

I'm using cloudflare pages, so locally, it's using a sqlite db and the requests can take up to 2 seconds. When I go to staging it uses the D1 db and my requests can take up to 3 minutes.

Any ideas why it would be so different? I'm thinking maybe the db connections are what's taking so long, I am making a lot of connections but don't want to spend the time trying to combine the sql if it's not going to get me down to that ~2 second mark.

TTeamDave Hello! I'm building out an analytics tool that makes a lot of db calls (10+ call...

James•7/15/25, 4:12 PM

single thread on D1 and network latency is going to kill you, you're better off batching if possible, this is one thing DO is better than D1 because you can customize how you batch queries better when you need things like shared IDs, groupig or aggregation outside of SQL. but for straight D1, you're way better off working your query into something that grabs it all in one go, especially since you don't pay for CPU on D1

IiLearn is following a valid SQL for execution by Cloudflare D1 .. thanks .. Reason (sh...

iLearn•7/17/25, 12:00 AM

Re-posting my Q .. as no answer received for 5-days ..

is following a valid SQL for execution by Cloudflare D1 .. thanks ..

Reason (shared by ChatGPT) : As of July 2025, there's no evidence that changes() is supported in D1. Its omission in docs combined with reported limitations strongly suggests it’s not available.

Worker Code Snippet with SQL execution planned :
// AIM : "to execute stmtUpdate statement ONLY if insertRes statement is success, without any JS stament in between D1 calls"
const stmts = await env.DB.batch([
env.DB.prepare(INSERT INTO users (sid) VALUES (?)).bind(sid),
env.DB.prepare(
UPDATE users
SET number_of_books = number_of_books + 1
WHERE sid = ?
AND changes() = 1
).bind(sid)
]);

SQL File : (for reference)

CREATE TABLE users (
id INTEGER PRIMARY KEY AUTOINCREMENT,
sid TEXT UNIQUE,
number_of_books INTEGER NOT NULL DEFAULT 0
);

CanRau•7/17/25, 1:02 AM

Heyho

any thought gone into the possibility of supporting pqlite in d1/do at some point?

Rob M.•7/17/25, 9:34 AM

Hi guys

What is the official flow to do migrations for a bunch of D1 dbs via REST API? As I know, D1 is about horizontal scaling and we should use rest api instead of bindings. But what about migrations in this case?

Rob M.•7/17/25, 10:03 AM

Also, can you advise a good ORM for this case?

RRob M.Hi guys 👋 What is the official flow to do migrations for a bunch of D1 dbs via ...

James•7/17/25, 3:06 PM

bindings are always better than the REST api unless you need something meta out of the API the sql won't give you

JJames bindings are always better than the REST api unless you need something meta out ...

Rob M.•7/17/25, 3:54 PM

Thanks! But afaik, you can't scale horizontally using bindings.

James•7/17/25, 3:55 PM

what do you mean by that though, thats not clear

Rob M.•7/17/25, 3:57 PM

I mean that D1 is about horizontal scaling (one db per tenant/team/user) so you need to create/delete/query lots of dbs in runtime.

Rob M.•7/17/25, 3:58 PM

You can't create bindings in runtime so the only way is using the API

James•7/17/25, 3:58 PM

the REST api has hard limits, so its pretty janky to use as an operational scale tool

for those kind of use cases, DO sql is more appropriate for horizontal scale at runtime

James•7/17/25, 4:01 PM

id avoid an ORM btw, they have oddball edge cases that break things, all to save using raw SQL, but raw SQL is way more clear and easy these days with AI

James•7/17/25, 4:03 PM

that being said, I do use drizzle-kit to manage migrations and hydrate query recordsets to JS data types based on the schema, but not to run sql.

Rob M.•7/17/25, 4:32 PM

Great points. Thanks a lot!

There is no D1 error message, just failed query

Similar Threads