Cloudflare Developers•3y ago

That is the plan.

MMatt Silverlock That is the plan.

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

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

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

I completely move from PlanetScale to D1, have stronk faith

LLogan Grasby this is the way

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

this is the way.

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

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

it should be yes

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';

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'

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

smth wrong with D1 date comparision

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

Matt SilverlockOP•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

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

With removing wrapper, you are also removing

__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

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

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

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

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

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

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

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

There is not.

MMatt Silverlock There is not.

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

Out of curiosity, is this on the roadmap?

AAdi Out of curiosity, is this on the roadmap?

Matt SilverlockOP•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 (...

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.

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

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

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

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

same btw

MMatt Silverlock Click to see attachment

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

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

I'm glad

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

Matt SilverlockOP•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 …

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

Matt SilverlockOP•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.

nick•8/4/23, 1:47 PM

Hello, I have used the latest D1 database and imported the original data. My user ID field was originally a string, but now it has been changed to a number

Nnick Hello, I have used the latest D1 database and imported the original data. My use...

Cyb3r-Jak3•8/4/23, 2:01 PM

My guess it is just how rendered in the browser. Check with wrangler to confirm

CCyb3r-Jak3 My guess it is just how rendered in the browser. Check with wrangler to confirm

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

thanks I'll give it a try

Matt SilverlockOP•8/4/23, 2:13 PM

Use the console to describe your schema. PRAGMA table_xinfo(table)PRAGMA table_xinfo(table)

Cchientrm.com I completely move from PlanetScale to D1, have stronk faith 💪

Tony Leung•8/4/23, 4:25 PM

is there anyway to migrate old D1 to new engine rather than dumping data from old database and import it to the new one?

TTony Leung is there anyway to migrate old D1 to new engine rather than dumping data from ol...

chientrm.com•8/4/23, 4:27 PM

nope I guess

chientrm.com•8/4/23, 4:27 PM

just backup in old engine, download, copy paste script to new db.

Tony Leung•8/4/23, 4:27 PM

chientrm.com•8/4/23, 4:28 PM

it's simple, they're not all SQLite,

Unsmart•8/4/23, 4:29 PM

I'm pretty sure its been said in the past that there would not be any sort of auto migration of them. It is an alpha product so weird things like this are to be expected

UUnsmart I'm pretty sure its been said in the past that there would not be any sort of au...

Tony Leung•8/4/23, 4:31 PM

yeah... it's not recommended to be used in production

benthecarman•8/4/23, 5:07 PM

Hey, we're using the D1 experimental backend, currently we're at 50mb in storage and are worried we could hit the 500mb cap, if we get close to that, is it possible to get that increased

Bbenthecarman Hey, we're using the D1 experimental backend, currently we're at 50mb in storage...

Cyb3r-Jak3•8/4/23, 5:12 PM

Right now the 500 MB is a global limit. I believe the blog post had 1GB for workers paid so they are probably working their way up

That is the plan.

Similar Threads

Similar Threads

Similar Threads