hey, im a beginner with D1 and i was hoping to find some help I created a model for a DB with prisma

LLucho hey, im a beginner with D1 and i was hoping to find some help I created a model ...

M

I'd recommend stepping through this guide from beginning to end! https://developers.cloudflare.com/d1/tutorials/d1-and-prisma-orm/

Cloudflare Docs

Query D1 using Prisma ORM · Cloudflare D1 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 …

L

LuchoOP•4/4/24, 4:17 PM

thank you!!

L

LuchoOP•4/4/24, 6:05 PM

I was following the guide until this error appeared

L

LuchoOP•4/4/24, 6:06 PM

does someone know how to resolve it?

LLucho I was following the guide until this error appeared

M

Max (@rozenmd)•4/4/24, 6:09 PM

whats the contents of that SQL file?

L

LuchoOP•4/4/24, 6:10 PM

just this

LLucho just this

M

Max (@rozenmd)•4/4/24, 6:11 PM

out of curiousity, does it work if you remove the comments?

-- CreateTable

-- CreateTable

-- CreateTable

-- CreateTable and

-- CreateIndex

-- CreateIndex

-- CreateIndex

-- CreateIndex

L

LuchoOP•4/4/24, 6:12 PM

i'll try

L

LuchoOP•4/4/24, 6:12 PM

nope

L

LuchoOP•4/4/24, 6:12 PM

same error

M

Max (@rozenmd)•4/4/24, 6:17 PM

and the contents of that file is now just this?

CREATE TABLE "User" ( 
    "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 
    "email" TEXT NOT NULL, 
    "name" TEXT 
);

CREATE UNIQUE INDEX "User_email_key" ON "User"("email");

CREATE TABLE "User" ( 
    "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 
    "email" TEXT NOT NULL, 
    "name" TEXT 
);

CREATE UNIQUE INDEX "User_email_key" ON "User"("email");

CREATE TABLE "User" ( 
    "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 
    "email" TEXT NOT NULL, 
    "name" TEXT 
);

CREATE UNIQUE INDEX "User_email_key" ON "User"("email");

CREATE TABLE "User" ( 
    "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 
    "email" TEXT NOT NULL, 
    "name" TEXT 
);

CREATE UNIQUE INDEX "User_email_key" ON "User"("email");

LLucho just this

T

tsion•4/4/24, 6:33 PM

the loose emoji on line 10 is probably the problem?

Ttsion the loose emoji on line 10 is probably the problem?

L

LuchoOP•4/4/24, 6:34 PM

it isnt an emoji, it's from copilot

L

LuchoOP•4/4/24, 6:35 PM

it goes away if i tap aywhere else

T

tsion•4/4/24, 6:35 PM

i see

MMax (@rozenmd)and the contents of that file is now just this? ``` CREATE TABLE "User" ( "...

L

LuchoOP•4/4/24, 6:38 PM

thats right

I

Isaac McFadyen•4/4/24, 6:57 PM

Check your line endings?

I

Isaac McFadyen•4/4/24, 6:58 PM

The "near ??" error makes it seem like there are some unprintable characters in there somewhere, maybe line endings or empty spaces?

M

Matt Silverlock•4/4/24, 6:58 PM

Runs perfectly for me as copied from @Max (@rozenmd)'s code block:

~/repos/d1 (main) ✗
➜  pbpaste > user_repro_20240404.sql
~/repos/d1 (main) ✗
➜  wrangler d1 execute db-enam --file=user_repro_20240404.sql

🌀 Mapping SQL input into an array of statements
🌀 Parsing 2 statements
🌀 Executing on db-enam (c89db32e-83f4-4e62-8cd7-7c8f97659029):
🚣 Executed 2 commands in 0.4695ms

~/repos/d1 (main) ✗
➜  pbpaste > user_repro_20240404.sql
~/repos/d1 (main) ✗
➜  wrangler d1 execute db-enam --file=user_repro_20240404.sql

🌀 Mapping SQL input into an array of statements
🌀 Parsing 2 statements
🌀 Executing on db-enam (c89db32e-83f4-4e62-8cd7-7c8f97659029):
🚣 Executed 2 commands in 0.4695ms

~/repos/d1 (main) ✗
➜  pbpaste > user_repro_20240404.sql
~/repos/d1 (main) ✗
➜  wrangler d1 execute db-enam --file=user_repro_20240404.sql

🌀 Mapping SQL input into an array of statements
🌀 Parsing 2 statements
🌀 Executing on db-enam (c89db32e-83f4-4e62-8cd7-7c8f97659029):
🚣 Executed 2 commands in 0.4695ms

~/repos/d1 (main) ✗
➜  pbpaste > user_repro_20240404.sql
~/repos/d1 (main) ✗
➜  wrangler d1 execute db-enam --file=user_repro_20240404.sql

🌀 Mapping SQL input into an array of statements
🌀 Parsing 2 statements
🌀 Executing on db-enam (c89db32e-83f4-4e62-8cd7-7c8f97659029):
🚣 Executed 2 commands in 0.4695ms

I

Isaac McFadyen•4/4/24, 7:00 PM

If you're on a Windows system try changing from CRLF to just LF?

M

Matt Silverlock•4/4/24, 7:02 PM

Something is definitely off with your editor here, @Lucho.

The migration (just copy pasted from the docs):

K

kian•4/4/24, 7:09 PM

at offset 0 is weird

K

kian•4/4/24, 7:10 PM

it's pulled from

sqlite3_error_offset

sqlite3_error_offset

which indicates it's the first character of that given input, but since Wrangler splits the statements you don't really know which one it is

I

Isaac McFadyen•4/4/24, 7:24 PM

Just tried CRLF vs LF and both work so that's not the issue.

K

kian•4/4/24, 7:28 PM

Usually if it's LF/CRLF you get a "you can't execute multiple statements" error or something like that

K

kian•4/4/24, 7:29 PM

A prepared SQL statement must contain only one statement. even

MMatt Silverlock Something is definitely off with your editor here, @Lucho. The migration (just ...

L

LuchoOP•4/4/24, 7:39 PM

oh okay

L

LuchoOP•4/4/24, 7:39 PM

it might be

L

LuchoOP•4/4/24, 7:41 PM

i'll try doing the entire guide again from scratch

A

adjlsncm•4/4/24, 8:11 PM

is d1 sqlite or sql? is sqlite worse?

A

adjlsncm•4/4/24, 8:15 PM

it seems like sqlite is worse for anything potentially large scale from what im reading

M

mzadz•4/4/24, 8:23 PM

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

seed.ts

. Can't seem to find any example of this in the tutorials

Aadjlsncm it seems like sqlite is worse for anything potentially large scale from what im ...

M

Max (@rozenmd)•4/4/24, 8:33 PM

D1/sqlite fits some use cases, classic DBs fit others - depends what you're trying to do.

A

adjlsncm•4/4/24, 8:34 PM

social 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

Aadjlsncm social media application similar to letterboxd, bad idea or no? im between using...

M

Max (@rozenmd)•4/4/24, 8:43 PM

Planetscale would support scaling and replication from the start, D1 is still building it

Original message was deleted

M

Max (@rozenmd)•4/4/24, 8:47 PM

No but cool idea - best is probably logging the prepared query string

wrangler d1 insights

wrangler d1 insights

could tell you summary stats but it only shows the query string too

MMax (@rozenmd)Planetscale would support scaling and replication from the start, D1 is still bu...

A

adjlsncm•4/4/24, 8:47 PM

regardless of that technically speaking, SQLite would be worse?

Aadjlsncm regardless of that technically speaking, SQLite would be worse?

M

Max (@rozenmd)•4/4/24, 8:48 PM

there's no better/worse here, It Depends

MMax (@rozenmd)there's no better/worse here, It Depends

A

adjlsncm•4/4/24, 8:50 PM

on?

Original message was deleted

M

Max (@rozenmd)•4/4/24, 8:50 PM

query execution time inside D1, yeah

Aadjlsncm on?

M

Max (@rozenmd)•4/4/24, 9:01 PM

expected 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

M

Max (@rozenmd)•4/4/24, 9:03 PM

whereas the tech underneath planetscale powers youtube, but you pay a price for that scalability

A

adjlsncm•4/4/24, 9:05 PM

thanks for the run down

A

adjlsncm•4/4/24, 9:06 PM

is there a simple reason why CF chose SQLite then since mySQL seems superior

Aadjlsncm is there a simple reason why CF chose SQLite then since mySQL seems superior

M

Max (@rozenmd)•4/4/24, 9:08 PM

simple reason? easiest, most battle-tested path to enable an sql interface for storing data for Workers

A

adjlsncm•4/4/24, 9:23 PM

got it

A

adjlsncm•4/4/24, 9:38 PM

ill just stick with keeping everything under cloudflare for now then and down the line when i do need "more" if CF isnt enough ill look into Planetscale

A

adjlsncm•4/4/24, 10:17 PM

im reading the docs to query D1 locally with bindings, but im using next-pages and so when i develop locally i just use npm run dev for fast refresh, how am i supposed to initialize the prisma client in that case?

A

adjlsncm•4/4/24, 10:18 PM

this is what i was using before for planetscale but obviously no database_url for d1

Aadjlsncm is there a simple reason why CF chose SQLite then since mySQL seems superior

T

Tony Leung•4/5/24, 2:17 AM

It's hard to maintain a large mysql cluster for the edge. Even if they do, the price will be as high as everest

hey, im a beginner with D1 and i was hoping to find some help I created a model for a DB with prisma

Similar Threads

Similar Threads

Similar Threads