I am using wrangler 3.4.0 to generate code

N

nejcOP•8/3/23, 2:26 PM

this is select that I am doing

N

nejcOP•8/3/23, 2:27 PM

await env.DB
    .prepare(
      'SELECT error, provider, created_at FROM errors WHERE created_at >=?1'
    )
    .bind(timestamp)
    .all()

await env.DB
    .prepare(
      'SELECT error, provider, created_at FROM errors WHERE created_at >=?1'
    )
    .bind(timestamp)
    .all()

await env.DB
    .prepare(
      'SELECT error, provider, created_at FROM errors WHERE created_at >=?1'
    )
    .bind(timestamp)
    .all()

await env.DB
    .prepare(
      'SELECT error, provider, created_at FROM errors WHERE created_at >=?1'
    )
    .bind(timestamp)
    .all()

N

nejcOP•8/3/23, 2:29 PM

where insert is working just fine

N

nejcOP•8/3/23, 2:29 PM

only select is returning fetch error

Nnejc I am using wrangler 3.4.0 to generate code

J

Jsx•8/3/23, 2:57 PM

their is no target provided for bind

env.DB
    .prepare(
      'SELECT error, provider, created_at FROM errors WHERE created_at = ?'
    )
    .bind(timestamp)
    .all()

env.DB
    .prepare(
      'SELECT error, provider, created_at FROM errors WHERE created_at = ?'
    )
    .bind(timestamp)
    .all()

env.DB
    .prepare(
      'SELECT error, provider, created_at FROM errors WHERE created_at = ?'
    )
    .bind(timestamp)
    .all()

env.DB
    .prepare(
      'SELECT error, provider, created_at FROM errors WHERE created_at = ?'
    )
    .bind(timestamp)
    .all()

Did you mean to do this? I am sorry if I got it wrong.

N

nejcOP•8/3/23, 3:00 PM

@heyjsx sorry for that, didn't copy the whole thing. You are right

N

nejcOP•8/3/23, 3:01 PM

updated snippet

J

Jsx•8/3/23, 3:03 PM

what's with the 1 at the last?

N

nejcOP•8/3/23, 3:15 PM

I am just using this to mark positions

O

oncetalk•8/3/23, 4:36 PM

I also encountered this situation yesterday, and repeated testing found that it was a problem with d1. Now, I have solved the problem by recreating the database and recreating the worker, then rebinding and importing the old database into the new database. However, my website has been greatly affected: (Remember, don't edit the code online now, once you do this, you will make an error)

MMatt Silverlock This is part of the alpha. We don't directly support going back and forth betwee...

O

oncetalk•8/3/23, 4:38 PM

thank you

MMatt Silverlock This is part of the alpha. We don't directly support going back and forth betwee...

O

oncetalk•8/3/23, 4:41 PM

And then, move the D1 binding out of wrangler? Does this mean that the d1 database can be bound on the dashboard?

Ooncetalk And then, move the D1 binding out of wrangler? Does this mean that the d1 databa...

M

Matt Silverlock•8/3/23, 4:42 PM

That is the plan.

MMatt Silverlock That is the plan.

O

oncetalk•8/3/23, 4:42 PM

This is great, I'm looking forward to it!

C

chientrm.com•8/3/23, 5:01 PM

I completely move from PlanetScale to D1, have stronk faith

LLogan Grasby this is the way

C

chientrm.com•8/3/23, 5:03 PM

this is the way.

LLogan Grasby Is --experimental-backend the new default?

U

Unsmart•8/3/23, 5:04 PM

it should be yes

C

chientrm.com•8/3/23, 5:29 PM

select * from Audio where createdAt < '2023-03-23T11:16:31.500';

select * from Audio where createdAt < '2023-03-23T11:16:31.500';

select * from Audio where createdAt < '2023-03-23T11:16:31.500';

select * from Audio where createdAt < '2023-03-23T11:16:31.500';

C

chientrm.com•8/3/23, 5:30 PM

return

id=47,createdAt='2023-03-23T11:16:31.500'

id=47,createdAt='2023-03-23T11:16:31.500'

id=47,createdAt='2023-03-23T11:16:31.500'

id=47,createdAt='2023-03-23T11:16:31.500'

C

chientrm.com•8/3/23, 5:30 PM

smth wrong with D1 date comparision

LLogan Grasby Is --experimental-backend the new default?

M

Matt Silverlock•8/3/23, 5:43 PM

https://developers.cloudflare.com/d1/changelog/#new-default-storage-subsystem

Changelog · Cloudflare D1 docs

Databases using D1’s new storage subsystem can now grow to 500 MB each, up from the previous 100 MB limit. This applies to both existing and newly …

Original message was deleted

N

nejcOP•8/3/23, 6:33 PM

With removing wrapper, you are also removing

__D1_BETA__

__D1_BETA__

__D1_BETA__

__D1_BETA__ from D1 binding prefix? Does this means that you will also have UI in dashboard as part of this wrangler release

N

nejcOP•8/3/23, 6:37 PM

I tried doing build based on this PR https://github.com/cloudflare/workers-sdk/pull/3595, but I am getting DB not found

N

nejcOP•8/3/23, 6:42 PM

@skye_31 so in this release you will just remove shim from wrangler?

N

nejcOP•8/3/23, 6:46 PM

great, do you maybe know when this wrangler release is going out?

N

nejcOP•8/3/23, 6:53 PM

thank you

Eetrepum Is there a straightforward way to download a dump of a new storage engine d1 dat...

M

Matt Silverlock•8/3/23, 8:06 PM

There is not.

MMatt Silverlock There is not.

A

Adi•8/4/23, 1:47 AM

Out of curiosity, is this on the roadmap?

AAdi Out of curiosity, is this on the roadmap?

M

Matt Silverlock•8/4/23, 1:55 AM

Further out. We’re focused on expanding Time Travel and many other core things (performance, larger DBs, more analytics, etc) - we think Time Travel is more valuable for most folks.

MMatt Silverlock Further out. We’re focused on expanding Time Travel and many other core things (...

A

Adi•8/4/23, 1:59 AM

That's quite fair. I mostly agree that those features would be much more useful.

Maybe an explanation of how CF protects against catastrophic failure in the backend would be beneficial until then.
I'm mostly thinking from the perspective of someone who wants to use D1 in production, some understanding on how likely/unlikely data loss is would be very helpful.

N

nick•8/4/23, 2:03 AM

After editing the worker code online, D1 still encounters errors. Downloading it to the local location using Wrangler and redeploying it will also cause errors. Can we restore normal operations today? thanks

Ggeelen I'm looking forward to making that possible: branching a new DB for testing/deve...

A

Adi•8/4/23, 2:07 AM

Honestly so keen for this

. The stuff you guys are doing with D1 is really exciting! We basically have our entire stack on Cloudflare, so we're waiting eagerly for more D1 goodness XD

Ggeelen that doesn't directly answer your data loss question, but it's the sort of flexi...

A

Adi•8/4/23, 2:09 AM

All good. Thanks for providing insight

. It's simply enough to write a snapshot cron with current DB sizes. It would only become unsustainable once DB sizes get a lot larger

ZZebra Hello! I have a stupid question but how do I view my table entries in D1 ? I c...

L

LeftSpace•8/4/23, 6:24 AM

same btw

MMatt Silverlock Click to see attachment

L

LeftSpace•8/4/23, 6:25 AM

might be dumb question but does that user_id auto increments if so how you Archieved that with D1 I'm kinda lost in that

L

LeftSpace•8/4/23, 6:31 AM

I'm glad

N

nick•8/4/23, 7:24 AM

The new version of the database cannot be downloaded and backed up in the dashboard. Can I download it locally through wrangler?

Nnick The new version of the database cannot be downloaded and backed up in the dashbo...

M

Matt Silverlock•8/4/23, 8:07 AM

https://developers.cloudflare.com/d1/changelog/#time-travel

Databases using D1’s new storage subsystemcan use Time Travel. Time Travel replaces the snapshot-based backups used for legacy alpha databases.

Changelog · Cloudflare D1 docs

Databases using D1’s new storage subsystem can now grow to 500 MB each, up from the previous 100 MB limit. This applies to both existing and newly …

B

Bram•8/4/23, 8:58 AM

Hi all, in Neon they have the concept of bottomless storage, where cold data can be written to a cheaper location, for example S3. Is this something that D1 also wants to offer in the long run?

BBram Hi all, in Neon they have the concept of bottomless storage, where cold data can...

M

Matt Silverlock•8/4/23, 12:43 PM

D1 doesn’t charge for CPU hours or data transfer, and “cold” storage in the way Neon refers to it doesn’t make much sense here. We don’t think storage is ever the dominant cost for a transactional database.

I am using wrangler 3.4.0 to generate code

Similar Threads

Similar Threads

Similar Threads