3 placeholders 3 parameters.. not sure why I'd be getting an error

Jjohtso 3 placeholders 3 parameters.. not sure why I'd be getting an error

K

K•4/8/24, 3:55 PM

Maybe inner query doesn't receive param

J

johtsoOP•4/8/24, 3:56 PM

oh actually.. skill issue.. I'm not allowed to use placeholders like that am I?

J

johtsoOP•4/8/24, 3:57 PM

like inside an argument to

date()

date()

date()

date()

J

johtsoOP•4/8/24, 3:58 PM

aha: https://stackoverflow.com/a/62911303/311220

Stack Overflow

Query Parameter Binding in DateTime Function of Sqlite3

I am using python and attempting to insert into a sqlite3 table as follows:
database.execute("INSERT INTO EXAMPLE VALUES (?, ?, DATETIME('now','+? seconds'), ?);", (id, statement, time_du...

A

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

what is the prisma migrate diff command to apply changes ive made to the schema to the local database?

A

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

it returns a summary in the migration file?

K

kindaraffy•4/8/24, 4:32 PM

If you are trying to apply migrations to your database, the diff command might not be what you want. Its been a while since I've used Prisma, so maybe someone here might be able to help you.

K

kindaraffy•4/8/24, 4:32 PM

Are there any (current) future plans to extend D1 past 10Gb? Or will you guys instead focus on implementing some kind of sharding solution as a higher priority?

A

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

oh i am an idiot

A

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

i forgot the --script tag

Aadjlsncm if i use npm run dev to start local development for fast refresh it seems like i...

A

adjlsncm•4/8/24, 6:17 PM

still curious about this

TTony!My CF Worker can apparently not see any data in my DB

V

Vy•4/8/24, 6:57 PM

What error are you seeing?

TTony!My CF Worker can apparently not see any data in my DB

M

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

are you using

--remote

--remote

--remote

--remote or

--local

--local

--local

--local with a recent version of wrangler?

J

jstn•4/8/24, 9:20 PM

Does anyone have any suggestions or comments about a CMS that leverages D1 (and R2)? I looked at sonicjs and microfeed but they don't seem to have very active development.

P

PhilH•4/8/24, 10:48 PM

Forgive me if this is a stupid error, but does anyone have any idea why on earth prepared statements aren't working for me at all?

router.post('/:brand/:slug', async (r,e,c) => {
    const brand = r.brand;
    const slug = r.slug;
    const db = e.LINK_DB
    const body = await r.json();

    const stmt = db.prepare(`INSERT INTO ? (slug, type, data, clicks) VALUES ('?', "ArtistLanding", '?', 0)`)
    stmt.bind(brand,slug,body.data)
    return await stmt.run();
})

router.post('/:brand/:slug', async (r,e,c) => {
    const brand = r.brand;
    const slug = r.slug;
    const db = e.LINK_DB
    const body = await r.json();

    const stmt = db.prepare(`INSERT INTO ? (slug, type, data, clicks) VALUES ('?', "ArtistLanding", '?', 0)`)
    stmt.bind(brand,slug,body.data)
    return await stmt.run();
})

router.post('/:brand/:slug', async (r,e,c) => {
    const brand = r.brand;
    const slug = r.slug;
    const db = e.LINK_DB
    const body = await r.json();

    const stmt = db.prepare(`INSERT INTO ? (slug, type, data, clicks) VALUES ('?', "ArtistLanding", '?', 0)`)
    stmt.bind(brand,slug,body.data)
    return await stmt.run();
})

router.post('/:brand/:slug', async (r,e,c) => {
    const brand = r.brand;
    const slug = r.slug;
    const db = e.LINK_DB
    const body = await r.json();

    const stmt = db.prepare(`INSERT INTO ? (slug, type, data, clicks) VALUES ('?', "ArtistLanding", '?', 0)`)
    stmt.bind(brand,slug,body.data)
    return await stmt.run();
})

No matter what request I make, I always get -

{
  "status": 500,
  "error": "D1_ERROR: near \"?\": syntax error at offset 12"
}

{
  "status": 500,
  "error": "D1_ERROR: near \"?\": syntax error at offset 12"
}

{
  "status": 500,
  "error": "D1_ERROR: near \"?\": syntax error at offset 12"
}

{
  "status": 500,
  "error": "D1_ERROR: near \"?\": syntax error at offset 12"
}

The offset varies but it seems that wherever my first

is in my statement, there is a syntax error, regardless of where it is in the project
I really hope I'm just being stupid and missing something obvious here!

P

PhilH•4/8/24, 10:49 PM

I can get this to work by using a template string and just inserting the variables directly into the SQL statement, but I'd rather be able to actually use the bind feature

PPhilH Forgive me if this is a stupid error, but does anyone have any idea why on earth...

K

kian•4/8/24, 11:09 PM

Answered in Prepared Statements don't seem to be working

A

Alvee•4/9/24, 2:04 AM

I don't see (BETA)? it's released ?

AAlvee I don't see (BETA)? it's released ?

C

Chaika•4/9/24, 2:09 AM

out of beta/into ga at least yea: https://blog.cloudflare.com/making-full-stack-easier-d1-ga-hyperdrive-queues

CChaika out of beta/into ga at least yea: <https://blog.cloudflare.com/making-full-stack...

A

Alvee•4/9/24, 2:11 AM

can it be used in non worker env? like node js backend

A

Alvee•4/9/24, 2:11 AM

is the support there good or not that much

C

Chaika•4/9/24, 2:12 AM

kind of, but not meant to be/not very realistically.. it's a SQLite Database so there's no network protocol for it or anything. You can use either the D1 API (but it sends all requests back to core/not at edge, so slow), or a Worker proxying queries, but nothing direct

ZZiga Zajc would D1 do something like sharding to avoid database size limit?

C

Chaika•4/9/24, 3:41 AM

they've talked about it before d1-database but nothing confirmed

C

Chaika•4/9/24, 3:41 AM

d1-database

S

snacks•4/9/24, 8:21 AM

Hey everyone, I'm keen to give D1 a try for this project, I'm building a nextjs app, is there a way I can local dev to a remote D1 db? I've been told I should just use Sqlite locally and then swap it on prod in pages. Any advice? Thank you!

S

snacks•4/9/24, 9:40 AM

can this be used independently of running my next app through wrangler? as in it can just let me connect with a next app running through another command or does it all have to be bundled?

Ssnacks can this be used independently of running my next app through wrangler? as in it...

M

Max (@rozenmd)•4/9/24, 9:45 AM

you can have a separate Worker running as an API, and have your Pages app talking to it, as we've done in this demo: https://github.com/cloudflare/d1-northwind

PPhilH Forgive me if this is a stupid error, but does anyone have any idea why on earth...

M

Max (@rozenmd)•4/9/24, 9:47 AM

should be

INSERT INTO ? (slug, type, data, clicks) VALUES (?, "ArtistLanding", ?, 0)

INSERT INTO ? (slug, type, data, clicks) VALUES (?, "ArtistLanding", ?, 0)

INSERT INTO ? (slug, type, data, clicks) VALUES (?, "ArtistLanding", ?, 0)

INSERT INTO ? (slug, type, data, clicks) VALUES (?, "ArtistLanding", ?, 0)

sqlite automatically escapes the input correctly

dit: oops, just noticed the table param too, yeah that won't work

MMax (@rozenmd)you can have a separate Worker running as an API, and have your Pages app talkin...

S

snacks•4/9/24, 9:50 AM

thanks I'll have a look into it

Original message was deleted

B

bun•4/9/24, 11:20 AM

You can just use drizzle and log those using their logger

K

Kimitri•4/10/24, 2:45 AM

I'm new on D1 so I have some questions, the only way to use D1 is with workers? I'm ask it because when I tried to create a D1 db, the only way I got was if I create a worker.
I wanna use D1 with my currently api but I guess I don't understand very well what's D1 is exaclty and how it work

Original message was deleted

K

Kimitri•4/10/24, 4:12 AM

So basically if I want to migrate my data base to D1 I should rewrite the entire api endpoints to workers right?

Original message was deleted

K

Kimitri•4/10/24, 4:16 AM

Thank you for clarify how it's work. I'll test it to see the performance differences

S

Super Morris•4/10/24, 8:04 AM

simple question:
d1 processing performance per d1 instance or per cloudflare account?
we thing about horizontally scaling d1 databases vs. vertically scaling

S

Super Morris•4/10/24, 8:07 AM

thanks a lot! any idea about its vertically scaling capacity? on planet scale I can manage the "hardware" but where are the performance limits on a single d1/do?

S

Super Morris•4/10/24, 8:13 AM

or maybe I ask the other way around: we are building an app builder. so far on planetscale we had one (or a few) db for all apps. now as d1 is no longer in beta, we are looking into moving it to d1. and the main question is one db per app or the same like we did on planet scale....

3 placeholders 3 parameters.. not sure why I'd be getting an error

Similar Threads

Similar Threads

Similar Threads