Cloudflare Developers•3y ago

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

Caleb•8/4/23, 5:21 PM

anyone know when d1 will be out of open alpha

CCaleb anyone know when d1 will be out of open alpha

Epailes•8/4/23, 6:58 PM

https://tenor.com/view/ogvhs-crystal-ball-prediction-future-predict-gif-18199743

Tenor

Caleb•8/4/23, 7:16 PM

So no?

Cyb3r-Jak3•8/4/23, 7:19 PM

There is no date for when it leaves alpha stage

Caleb•8/4/23, 8:27 PM

sad

Caleb•8/4/23, 8:31 PM

I want to use it for production enviroment. I have a very small amount of data (maybe 200MB) with a pretty simple scheme with one table. I know D1 current state is not recommended for production environment, but for my case do you think it would be ok?

Mozzy•8/4/23, 8:31 PM

You'd be fine, until you're not

Mozzy•8/4/23, 8:42 PM

I use it in production, but for non-essential things

Trixrabbit•8/4/23, 10:00 PM

is having a wrangler.confwrangler.conf with d1 information

[[d1_databases]]
binding = "DB"                                       
database_name = "local_db"
database_id = "123456789"

[[d1_databases]]
binding = "DB"                                       
database_name = "local_db"
database_id = "123456789"

the same as using wrangler with --remote -d1=DB--remote -d1=DB ?

I'm struggling to see if/when/why I need wrangler.conf when using Pages

TTrixrabbit is having a `wrangler.conf` with d1 information ``` [[d1_databases]] binding = ...

Cyb3r-Jak3•8/4/23, 10:06 PM

Pages doesn't use

wrangler.toml

wrangler.toml

. You set all the bindings via the dashboard or API

CCyb3r-Jak3 Pages doesn't use `wrangler.toml`. You set all the bindings via the dashboard or...

Trixrabbit•8/4/23, 10:12 PM

I think there is undocumented behaviour with pages and d1 because wrangler says it parses wrangler.confwrangler.conf when using wranger pages devwranger pages dev

MMozzy I use it in production, but for non-essential things

Caleb•8/4/23, 10:21 PM

yeah i need it for nonessentials

TTrixrabbit I think there is undocumented behaviour with pages and d1 because wrangler says ...

Cyb3r-Jak3•8/4/23, 10:21 PM

It might parse it due to it being wrangler but you need to pass binding in order for them to work locally

CCyb3r-Jak3 It might parse it due to it being wrangler but you need to pass binding in order...

Trixrabbit•8/4/23, 10:24 PM

gotcha, I just started playing with d1 and wrangler and there are things that aren't trivial or well explained.. most of the wrangler d1wrangler d1 commands seems to be only for remote, not local e.g.

list

list

...but it seems possible to apply migrations to local d1
very cool thing though, just requires a lot of trial and error to see what works

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

nick•8/5/23, 2:49 AM

After query, user_ id is a text type, but the content stored in the database has become a numerical type, and the stored code is the same as before. The old version of the database is normal

Vishnu Sankar•8/5/23, 8:34 AM

Does D1 support transaction?

I’m trying build a web app with next-on-pages, D1 and drizzle-orm.

Drizzle transaction API seems to be working fine for local development. However, it fails on production and preview deployments with the following error “Error: D1_Error: Error: not authorized”

This doesn’t looks like a binding issue as all other non-transaction calls to D1 works without any errors.

VVishnu Sankar Does D1 support transaction? I’m trying build a web app with next-on-pages, D1...

itsmatteomanf•8/5/23, 9:19 AM

D1 commands run in an implicit transaction, you can't write a specific transaction yourself.

There is not.

Similar Threads

Similar Threads

Similar Threads