CNot officially. There is an HTTP API but is isn't documented and isn't stable
MD1 is Cloudflare’s native serverless database. Create your first D1 database by following the Get started guide, learn how to import data into a …
Yalso are changes instant ? like immediatly visible in all cf locations
Mwe haven't turned on replication yet, so yep
Awe all await the magical day when this becomes reality
Msame
MDumb question... What is replication and why is it wanted if changes are not immediately visible in all locations?
Vsingle write multipe reader is good because you can move a read only copy of your database close to your users
Veg your writer instance is in Europe but users in Sydney can read data from their local Sydney reader replica
MIn most user-facing / web application databases, ~80% of your queries are just reads. Getting those closer to users = better app performance 
CMy D1 DB running the new experimental backend has stopped working entirely, any clue on why? All Queries return
972558fd-cadf-4bec-8b0b-5a140d7d51fb
I waited a bit to see if it would come back after a bit, but it seems hard dead
D1_ERROR: Error: Internal error while starting up D1 storage caused object to be reset.972558fd-cadf-4bec-8b0b-5a140d7d51fb
I waited a bit to see if it would come back after a bit, but it seems hard dead
MHow does that work with data consistency? Let's say I write to it, and I want the user in any location to immediately be able to get that fresh write?
Can I opt-in to / choose this in any way?
Can I opt-in to / choose this in any way?
MWe’ll manage that behind the scenes so you can read your writes. When we ship replication there will be docs covering all of this 
MLooking. Is this still occurring?
CThanks! Yea it seems to be in an even worse state now, it's not instantly erroring, but infinitely loading, queries against it, and trying to load it in the dashboard, just take so long I get a gateway timeout
Edit: Looks like I'm back to instant d1 errors, same error as above. Still broken sadly
Edit: Looks like I'm back to instant d1 errors, same error as above. Still broken sadly
MOkay thanks 
MStill broken?
Ahey guys, can we manage the database using some client?
MThe Drizzle team are working on support in Drizzle Studio - https://twitter.com/drizzleorm/status/1675617777636212738?s=46
Drizzle ORM (@DrizzleOrm)
Twitter
•
We will make @Cloudflare D1 adapter this week for Drizzle Studio, should be great
Likes
105
7/2/23, 9:29 PM
AI'll dump it and upload it
Cit is yea
972558fd-cadf-4bec-8b0b-5a140d7d51fb
972558fd-cadf-4bec-8b0b-5a140d7d51fb
C@elithrar can I jump on this thread or should I open a new one? I'm getting an error when trying out your tutorial.
MThis is definitely not related to Chaika’s issue. I think you have a typo in your code (unexpected token).
CIt wasn't immediately clear to me that this is a subchannel for all things related to d1-open-alpha -- sometimes I overlook the obvious.
CBut the error I got, if it's a typo, I'm pretty sure I copied and pasted from the example you give on Github.
MWhich example? Mind stepping back a sec and helping me understand a) what you’re trying to run / b) the code?
CThanks, I'm trying to run the https://github.com/elithrar/svelte-demo-d1 and I put the sample code in src/routes/api/users/+server.js -- (the only difference I see is that I'm using .js and not .ts)
GitHub
Cloudflare Pages + SvelteKit + Cloudflare D1 - https://developers.cloudflare.com/pages/framework-guides/deploy-a-svelte-site/#deploy-with-cloudflare-pages
- GitHub - elithrar/svelte-demo-d1: Cloudf...
MIf you aren’t building TypeScript I can’t guarantee it will work. That is also my personal account - not an officially supported project. I strongly recommend using our official tutorial first: https://developers.cloudflare.com/pages/framework-guides/deploy-a-svelte-site/#deploy-with-cloudflare-pages
Svelte is an increasingly popular, open-source framework for building user interfaces and web applications. Unlike most frameworks, Svelte is …
MI have that exact repo deployed as a project: if you're changing things it's probably breaking it.
CI have deployed several sites already, following both the Cloudflare tutorial and Sveltekit's guide. Functions are proving a challenge.
MMIf this is specific to Pages Functions, I'd ask over in #pages-help
CI have started reaching out there, too.
MI just forced a rebuild of that Pages site — unchanged, not a line changed from my original push ~3 weeks ago — and it works: https://32b48f37.svelte-demo-d1.pages.dev/api/users latest deploy, just pushed ~10 seconds ago.
I would ask in #pages-help and be very clear about what you're changing here.
I would ask in #pages-help and be very clear about what you're changing here.
CI'll keep at it. What does your users database look like, do you have the schema?
CI see it from the output, email, id, etc. but I haven't actually added any tables to the db. I was hoping it would just return some system info to start. Maybe the error has to do with an incomplete db setup.
MIt's impossible to tell from the error you've posted. If you haven't populated your DB - it won't work.
The query in the example app is just
The query in the example app is just
"SELECT * FROM users LIMIT 5"I'm off for the night, but I'd strongly recommend:
- Going through the D1 tutorial first if you haven't. If you're also new to SvelteKit, then you're just adding friction: https://developers.cloudflare.com/d1/get-started/
- Once you have that working, deploy a basic Svelte site to Pages: https://developers.cloudflare.com/pages/framework-guides/deploy-a-svelte-site/
- Then you can combine it all
COkay, thanks for your help!
CFIY -- https://temp-d1demo-ts.pages.dev/api/users it's working for me. I made a fresh repo with JSDoc and it didn't work. Then I made a fresh repo and created the sveltekit app with TypeScript and it worked. Thanks so much for this. It's really interesting to get this all combined and working.
VHow many regions will D1 replicate to? Regional level?
Vany predictions? i'm evaluating using D1 or Dynamo and if the replication is similar to like a 3-4 region deployment with a singler writer and N read replicas I might aswell just stick with Dynamo
VThey surely wont put replicas in every PoP
MKeep in mind that each Dynamo replica adds to your storage costs + adds additional replication costs. D1 will not for the 'default' global replication.
M(I like a lot of what Dynamo did, but replication stacks up fast: https://aws.amazon.com/dynamodb/pricing/on-demand/)
Mhttps://silverlock-d1-remix-svelte-e.cloudflare-docs-7ou.pages.dev/d1/examples/
- what framework should we add next? The Pages docs cover the whole list, but (IMO) having specific examples you can copy+paste to get started for D1 == easier
UI assume D1 will only be single region writer? Or will it be like Dynamo where you can write to the primary node in each region?
MSingle writer: we think (and others like PlanetScale & Google's Spanner team also share this view) that multiple writers introduces too many consistency issues for user-facing apps. DynamoDB makes a bunch of trade-offs (and they are welcome to!) that we don't think are the right ones for user-facing apps / cause you to have to think about consistency a lot in your app design.
