thanks! I tripped up on language here. Our intention was with D1 GA, alpha dbs should be considered

thanks! I tripped up on language here. Our intention was with D1 GA, alpha dbs should be considered deprecated (everything still works). And then July 1st (3 months after), alpha dbs stop accpecting SQL queries. Can work to clarify in the future

VVy thanks! I tripped up on language here. Our intention was with D1 GA, alpha dbs s...

Isaac McFadyen•4/30/24, 6:46 PM

Definitely understand the idea of deprecation at D1 GA but it wasn't really communicated to the user very well.

VVy thanks! I tripped up on language here. Our intention was with D1 GA, alpha dbs s...

James•4/30/24, 6:46 PM

That may have been the intention, but that was never communicated to people, and that's the core problem here.

Isaac McFadyen•4/30/24, 6:47 PM

They were "superceded" but no real indication that they were going to be turned off until now.

James•4/30/24, 6:48 PM

I would strongly encourage you to push this "cut-off" date back until after the communicated deprecation date (after July 1st), and re-communicate that. It's going to be really hard to want to adopt something early from Cloudflare in future if this becomes commonplace.

Chaika•4/30/24, 6:49 PM

there was even that D1 GA Email, but it didn't mention anything about deprecation or cutoff, other then that "you can" migrate

Unsmart•4/30/24, 6:53 PM

I'm surprised alpha dbs arent already yeeted lol

VyOP•4/30/24, 6:58 PM

Team can re-evaluate "cut off" (stop SQL requests) date.

Unsmart•4/30/24, 7:00 PM

I dont think any of the convo here holds any value since we dont have any and I cant imagine that many people have alpha dbs still. Would probably be more useful to find out who has alpha still and just email with them to get the old ones deleted

Unsmart•4/30/24, 7:01 PM

Or at least of those who still do I doubt they are really used, maybe a lot of people have abandoned old ones

UUnsmart I dont think any of the convo here holds any value since we dont have any and I ...

Chaika•4/30/24, 7:04 PM

me, james, and isaac at the very least all have Alpha DBs, I think I have one or two old projects pointed at them, not that they're super important but more notice is appreciated regardless/a proper deprecation

Chaika•4/30/24, 7:04 PM

iirc only people with alpha dbs only got the email, I only got it on 2/3 out of my accounts, and both had alpha dbs

Unsmart•4/30/24, 7:05 PM

I got it and dont have one so

josh•4/30/24, 7:05 PM

If anyone has any concerns about getting their database migrated, I would be glad to hop on a call and help walk through the migration guide https://developers.cloudflare.com/d1/platform/alpha-migration/

Cloudflare Docs

Alpha database migration guide · Cloudflare D1 docs

D1 alpha databases will stop accepting live SQL queries on July 1, 2024.

Chaika•4/30/24, 7:07 PM

that's appreciated :MeowHeartCloudflare: although migration isn't that hard/not the core of theconcern, it's just more of the process of it. Being emailed 2 months before without it telling you which DBs are effected, the dash doesn't explicitly tell you either which ones, and calling it "deprecation" when it's really more like full shutdown

VVy Team can re-evaluate "cut off" (stop SQL requests) date.

James•4/30/24, 7:07 PM

This would be the best approach. Deprecate, clearly mark that everywhere, set a cut-off date after deprecation, and then actively communicate that. :MeowHeartCloudflare:

CChaika that's appreciated :MeowHeartCloudflare: although migration isn't that hard/no...

josh•4/30/24, 7:09 PM

We will also add a banner to the dash. That's a good idea. I had assumed more folks would be using the command line or APIs and we did add a warning there.

Jjosh If anyone has any concerns about getting their database migrated, I would be gla...

Chaika•4/30/24, 7:09 PM

would be cool if it was possible to do it automatically for everyone and would avoid a lot of it, I assume a lot of DBs could be migrated without issue automagically

CChaika would be cool if it was possible to do it automatically for everyone and would a...

josh•4/30/24, 7:14 PM

Yeah. That would have generated less pushback. Doing a 0 downtime migration is a lot of work, and frankly not worth it for an alpha product. We could migrate DBs that are not in use with no problem, but it might be pointless to migrate them. We could take downtime to migrate DBs for active use cases, but that would still have to be coordinated with customers.

Jjosh Yeah. That would have generated less pushback. Doing a 0 downtime migration is a...

Chaika•4/30/24, 7:16 PM

That makes sense, can understand why that would be difficult, then I would just hope there's a proper shut off, deprecation happening on x date, shutdown on y, emails telling you which DBs need to be upgraded with reminders, and stuff in the dash is all that would be needed

DaniFoldi•4/30/24, 7:16 PM

I'd argue it's still way less frustrating to take an alpha db offline for a minute or two to keep it going on the new backend

DaniFoldi•4/30/24, 7:16 PM

vs dumping it from the old backend, recreating it, ingesting data and changing bindings

CChaika there was even that D1 GA Email, but it didn't mention anything about deprecatio...

VyOP•4/30/24, 7:24 PM

@Chaika did you recieve this email recently? The copy is from our alpha to beta email, not for GA

kingmesal•4/30/24, 7:24 PM

I've got a use case where I am running into the D1 LIMITS on sql queries - I'm on paid plan

Queries per Worker invocation (read subrequest limits)    50 (Bundled) / 1000 (Unbound)

Queries per Worker invocation (read subrequest limits)    50 (Bundled) / 1000 (Unbound)

I allow my customer to upload a csv of users. I insert or update the user records into my d1 table. So, if the unique key (email address) already exists, I perform an update. (2 queries). Can the insert in conflict be batched? Is there a limit on how many statements can get put into a batch? Is this a potential way to get around the 1000 queries?

VVy @Chaika did you recieve this email recently? The copy is from our alpha to beta ...

Chaika•4/30/24, 7:26 PM

oh you're right that is older opps, that's from August of last year. That doesn't really help though, still lack of communication and suddenly an email about them being gone in 2 months

CChaika oh you're right that is older opps, that's from August of last year. That doesn'...

VyOP•4/30/24, 7:26 PM

thanks, we're workign to clarify here based on feedback. just wanted to check somethign else weird wasnt happening on email side

James•4/30/24, 7:27 PM

thanks Vy. If we can help in any way, please just let us know

VVy thanks, we're workign to clarify here based on feedback. just wanted to check so...

Chaika•4/30/24, 7:27 PM

nah you're good, I was just looking for anything mentioning d1 alpha (besides the latest one today) and that's all I found, could have sworn it was more recent

somoni•4/30/24, 8:22 PM

is there a tutorial or guide on how to do schema upgrades on a live production site using d1 ? i was not able to find one in the d1 docs. By schema upgrade i mean adding and/or removing fields from a table that would make it backward incompatible with the previous deployed code

VyOP•4/30/24, 8:50 PM

I'm working to update various channels but re-worked proposal is:
* With D1 generally available, we're deprecating alpha databases. Clarifying that deprecation does not impact D1 alpha operations, everything still works.
* Users should follow the alpha database migration guide to recreate a new D1 database from their alpha database backup. Following a 3-month deprecation period, D1 alpha databases will stop accepting live SQL queries on August 1, 2024.
* After August 1, 2024, users can still access alpha database backups until the end of 2024.

VVy I'm working to update various channels but re-worked proposal is: * With D1 gene...

James•4/30/24, 8:56 PM

3 months notice until complete inoperability is a little shorter than I would like/expect, but this is much nicer than 60 days, assuming it's actively and well communicated over the coming weeks and months. I appreciate you hearing our concerns and feedback here :MeowHeartCloudflare:

James•4/30/24, 8:59 PM

In future, I think it would really good to communicate deprecations like this significantly more actively. It sounds like this has been the plan since GA announcement at dev week, and if that's the case, the deprecation should have been announced as early as then.

VVy I'm working to update various channels but re-worked proposal is: * With D1 gene...

Chaika•4/30/24, 9:04 PM

that is way better, just please have the emails include which D1 DBs are effected and the dash communicate that as well. People will react very differently to "in 3 months D1 Alpha is shutting down..migrate now" vs "This list of DBs <list of DBS> need to be migrated before then" when the list of dbs may include a super important one. Not everyone follows alpha vs beta/production differences, some people may have setup something a while ago and just not be paying attention, need to be directly told something of importance is going to break soon

F0rce•4/30/24, 9:21 PM

Just wanted to put this on the radar because with D1 reaching GA some time ago, this is still a major game-breaker during local development or migrating to d1

Vlady•4/30/24, 11:53 PM

Hey folks, how do I reset my remote database without deleting the binding? I tried running

delete from sqlite_master where type in ('table', 'index', 'trigger')

delete from sqlite_master where type in ('table', 'index', 'trigger')

, but got this error

D1_ERROR: table sqlite_master may not be modified

D1_ERROR: table sqlite_master may not be modified

di_uthred•5/1/24, 3:54 AM

Am the only one who had a bunch a DBs dissappear from the console recently? I had like 12 - now I see 6. What's interesting, they still seem to be accessible by the workers.

Ddi_uthred Am the only one who had a bunch a DBs dissappear from the console recently? I h...

Hello, I’m Allie!•5/1/24, 7:06 AM

FF0rce Just wanted to put [this](https://github.com/cloudflare/workers-sdk/issues/3160)...

geg•5/1/24, 8:12 AM

HHello, I’m Allie!May be related to this? https://canary.discord.com/channels/595317990191398933/9...

Max (@rozenmd)•5/1/24, 8:34 AM

Definitely not - we're not touching any databases

Ddi_uthred Am the only one who had a bunch a DBs dissappear from the console recently? I h...

Max (@rozenmd)•5/1/24, 8:35 AM

What's your accountId?

Jordan•5/1/24, 11:12 AM

Is deploying D1 myself (e.g. in my own k8s cluster for example) supported?

Jordan•5/1/24, 11:13 AM

I assume this is done with the local version of D1? If that's true is the local D1 version via Wrangler prod-capable? (ignoring the fact that D1 is in beta currently)