Any expectation on how long that'll take to make it in? Curious if I should roll back to my old DB

Any expectation on how long that'll take to make it in? Curious if I should roll back to my old DB and write batching functions instead (which is why I was trying a move to the new backend).

itsmatteomanf•5/30/23, 8:12 PM

Any specific reasoning why

CURRENT_TIMESTAMP

CURRENT_TIMESTAMP

works when using it as the default for a column in the schema, but fails when used in any kind of statement (with a "not authorized")?

itsmatteomanf•5/30/23, 8:14 PM

To note, a

datetime('now')

datetime('now')

works fine in the statement.

MMurder Chicken Any expectation on how long that'll take to make it in? Curious if I should rol...

Max (@rozenmd)•5/30/23, 8:17 PM

it depends if it's a standard thing we missed - CC: @elithrar

MMurder Chicken Any expectation on how long that'll take to make it in? Curious if I should rol...

Matt Silverlock•5/30/23, 9:11 PM

No faster than a week.

kian•5/30/23, 9:36 PM

A random guess is that the D1 shim seems to do some ArrayBuffer conversions of it's own (https://github.com/cloudflare/workers-sdk/blob/main/packages/wrangler/templates/d1-beta-facade.js#L112-L149)

itsmatteomanf•5/31/23, 7:36 AM

Are foreign keys actually supported? It accepts them in the schema, but it doesn't enforce them, at all.

itsmatteomanf•5/31/23, 10:06 AM

Yeah, I know SQLite supports that, but they specifically state that the

PRAGMA foreign_keys = on;

PRAGMA foreign_keys = on;

command is supported in the docs.

itsmatteomanf•5/31/23, 10:07 AM

https://developers.cloudflare.com/d1/platform/client-api/#pragma-statements

Iitsmatteomanf Any specific reasoning why `CURRENT_TIMESTAMP` works when using it as the defaul...

itsmatteomanf•5/31/23, 10:09 AM

I saw your

, @rozenmd, can I expect it to work at some point or not? Just to design the schema and Workers accordingly.

Iitsmatteomanf I saw your 🤔, @rozenmd, can I expect it to work at some point or not? Just to d...

Max (@rozenmd)•5/31/23, 10:12 AM

let me ask internally, I'm not sure

Iitsmatteomanf Any specific reasoning why `CURRENT_TIMESTAMP` works when using it as the defaul...

Max (@rozenmd)•5/31/23, 12:20 PM

can you file a github issue for this in workerd? https://github.com/cloudflare/workerd/issues

Ttobias I was trying to run a migration with following content. ```sql CREATE VIRTUAL TA...

Max (@rozenmd)•5/31/23, 12:23 PM

can you rerun it with

fts5

fts5

instead of

FTS5

FTS5

? looks like a bug

MMax (@rozenmd)can you file a github issue for this in workerd? https://github.com/cloudflare/w...

itsmatteomanf•5/31/23, 12:31 PM

https://github.com/cloudflare/workerd/issues/718

GitHub

🐛 Bug Report — Runtime APIs: D1 Does Not Allow `CURRENT_TIMESTAMP` ...

The Experimental Backend doesn't allow using CURRENT_TIMESTAMP when running any type of query. It's supported perfectly when it's set as default value for a column.

Lleonhma does anyone know whether D1 supports the unixepoch expression? (`createdAt integ...

Matt Silverlock•5/31/23, 1:07 PM

unixepoch

unixepoch

is supported. Does that create table statement work outside of D1? Usually you can’t have functions like that.

Matt Silverlock•5/31/23, 1:14 PM

https://github.com/cloudflare/workerd/blob/bc3fc4cdd309dccc553e18240ef432a39f53d5eb/src/workerd/util/sqlite.c%2B%2B#L171 (the function is typo’ed on the allowlist)

GitHub

workerd/sqlite.c++ at bc3fc4cdd309dccc553e18240ef432a39f53d5eb · cl...

The JavaScript / Wasm runtime that powers Cloudflare Workers - workerd/sqlite.c++ at bc3fc4cdd309dccc553e18240ef432a39f53d5eb · cloudflare/workerd

Lleonhma can you not in sqlite? I am quite new to this database stuff but I swear I saw s...

Matt Silverlock•5/31/23, 1:14 PM

Not at my computer so asking, otherwise I’d test.

Lleonhma does anyone know whether D1 supports the unixepoch expression? (`createdAt integ...

Max (@rozenmd)•5/31/23, 1:21 PM

what are you using to insert btw?

a basic example seems to work:

Lleonhma okay so i tested this again this time using the wrangler cli and a small repro d...

Max (@rozenmd)•5/31/23, 1:46 PM

default backend or experimental btw?

Max (@rozenmd)•5/31/23, 1:47 PM

ah okay I'll try again on the default, I just tested on the experimental one

Max (@rozenmd)•5/31/23, 1:53 PM

oh ok

Lleonhma okay it works now too on cf pages. No idea why it suddenly works. Sorry to waste...

Max (@rozenmd)•5/31/23, 2:05 PM

not a waste, always worth double checking these things

lokiwind•5/31/23, 2:24 PM

@elithrar @rozenmd I wrote a code for D1. However, this code gives the following error when there are too many requests:

{
    "message": "Error while checking rows: Error: D1_ERROR\n    at D1Database._send (worker.js:149:13)\n    at async D1PreparedStatement.all (worker.js:215:7)\n    at async Object.fetch (worker.js:11:18)"
}

{
    "message": "Error while checking rows: Error: D1_ERROR\n    at D1Database._send (worker.js:149:13)\n    at async D1PreparedStatement.all (worker.js:215:7)\n    at async Object.fetch (worker.js:11:18)"
}

Can I send the code via pm?
NOT:*It works with few users. but it does not work when there are many instant requests.

Llokiwind @elithrar @rozenmd I wrote a code for D1. However, this code gives the following...

Matt Silverlock•5/31/23, 3:00 PM

Better to post it here: we can't formally/directly support folks via DM, but others may be able to help

Ccam "D1 storage operation exceeded timeout which caused object to be reset"

Matt Silverlock•5/31/23, 3:05 PM

What's your database ID? And is this on the

--experimental-backend

--experimental-backend

or the original alpha backend?

Ccam its on the experimental backend, ff81e8fa-1199-43d0-ac0b-1c8c14e8ef12

Matt Silverlock•5/31/23, 3:12 PM

Perfect, thanks. Let me see if I can track down the log entry on our side.

Eemppu When D1 is released with read replication, will D1 charge for only a single writ...

Max (@rozenmd)•5/31/23, 7:00 PM

Importantly, when we enable global read replication, you won’t have to pay extra for it, nor will replication multiply your storage consumption

Any expectation on how long that'll take to make it in? Curious if I should roll back to my old DB

Similar Threads

Similar Threads

Similar Threads