read replicas are also critical above the 500-1k RPS mark, otherwise the individual DO starts queuin
read replicas are also critical above the 500-1k RPS mark, otherwise the individual DO starts queuing/overloading
FAah right its an DO, valid case! Thanks for heads up. Cant imagine that load per user for my case but better safe than sorry 
(especially with that “price”!)
(especially with that “price”!)
M:soontm:
MThis is definitely not expected - we have metrics for cold starts. Are you seeing this repeatedly, or just a one-off?
Lhey, im a beginner with D1 and i was hoping to find some help
I created a model for a DB with prisma and migrated it SQLite. How can i "connect" this DB to Cloudflare D1?
I created a model for a DB with prisma and migrated it SQLite. How can i "connect" this DB to Cloudflare D1?
MI'd recommend stepping through this guide from beginning to end! https://developers.cloudflare.com/d1/tutorials/d1-and-prisma-orm/
Cloudflare Docs
Prisma ORM is a next-generation JavaScript and TypeScript ORM that unlocks a new level of developer experience when working with databases thanks to …
Lthank you!!
LI was following the guide until this error appeared
Ldoes someone know how to resolve it?
Mwhats the contents of that SQL file?
Ljust this
Mout of curiousity, does it work if you remove the comments?
-- CreateTable-- CreateIndexi'll try
Lnope
Lsame error
Mand the contents of that file is now just this?
Lit isnt an emoji, it's from copilot
Lit goes away if i tap aywhere else
Ti see
Lthats right
ICheck your line endings?
IThe "near ??" error makes it seem like there are some unprintable characters in there somewhere, maybe line endings or empty spaces?
MRuns perfectly for me as copied from @Max (@rozenmd)'s code block:
IIf you're on a Windows system try changing from CRLF to just LF?
MSomething is definitely off with your editor here, @Lucho.
The migration (just copy pasted from the docs):
The migration (just copy pasted from the docs):
Kat offset 0 is weird
Kit's pulled from
sqlite3_error_offsetJust tried CRLF vs LF and both work so that's not the issue.
KUsually if it's LF/CRLF you get a "you can't execute multiple statements" error or something like that
KA prepared SQL statement must contain only one statement. even
Lit might be
Li'll try doing the entire guide again from scratch
Ais d1 sqlite or sql? is sqlite worse?
Ait seems like sqlite is worse for anything potentially large scale from what im reading
MIs it possible to run a Prisma seed script and apply it to a D1 DB, either locally or remote? It would involve executing a TypeScript file i.e
seed.tsD1/sqlite fits some use cases, classic DBs fit others - depends what you're trying to do.
Asocial media application similar to letterboxd, bad idea or no? im between using D1 because im already using R2 + Pages for hosting or just using Planetscale
MPlanetscale would support scaling and replication from the start, D1 is still building it
MNo but cool idea - best is probably logging the prepared query string
wrangler d1 insightsregardless of that technically speaking, SQLite would be worse?
Mthere's no better/worse here, It Depends
Aon?
Mquery execution time inside D1, yeah
Mexpected reads/writes per second and amount of data stored to start with - sqlite can be really good for scaling simple read-heavy use cases really far as there's less to worry about
Mwhereas the tech underneath planetscale powers youtube, but you pay a price for that scalability
Athanks for the run down
Ais there a simple reason why CF chose SQLite then since mySQL seems superior
Msimple reason? easiest, most battle-tested path to enable an sql interface for storing data for Workers
