ahh i missread, i thaught he meant storage per account

S

SteffTekOP•6/21/24, 7:11 PM

not per db

S

SteffTekOP•6/21/24, 7:11 PM

10gb per db is MUCH

SSteffTek ahh i missread, i thaught he meant storage per account

C

Chaika•6/21/24, 7:12 PM

the storage per account is 250 GB (Workers Paid) but yea that's a soft limit that can be raised
https://developers.cloudflare.com/d1/platform/limits/

M

Matt•6/21/24, 7:47 PM

Can anyone spot what I'm doing wrong?

Drizzle:

export async function searchByFontFamilyName(db: DB, search: string) {
  return db
    .select({
      family: table_fonts.family,
    })
    .from(table_fonts)
    .where(
      ilike(table_fonts.family, `%${search}%`), // search: "nato"
    );
}

export async function searchByFontFamilyName(db: DB, search: string) {
  return db
    .select({
      family: table_fonts.family,
    })
    .from(table_fonts)
    .where(
      ilike(table_fonts.family, `%${search}%`), // search: "nato"
    );
}

export async function searchByFontFamilyName(db: DB, search: string) {
  return db
    .select({
      family: table_fonts.family,
    })
    .from(table_fonts)
    .where(
      ilike(table_fonts.family, `%${search}%`), // search: "nato"
    );
}

export async function searchByFontFamilyName(db: DB, search: string) {
  return db
    .select({
      family: table_fonts.family,
    })
    .from(table_fonts)
    .where(
      ilike(table_fonts.family, `%${search}%`), // search: "nato"
    );
}

Logs this output:

Query: select "family" from "fonts" where "fonts"."family" ilike ? -- params: ["%nato%"]

Query: select "family" from "fonts" where "fonts"."family" ilike ? -- params: ["%nato%"]

Query: select "family" from "fonts" where "fonts"."family" ilike ? -- params: ["%nato%"]

Query: select "family" from "fonts" where "fonts"."family" ilike ? -- params: ["%nato%"]

I get this error:

D1_ERROR: near \"ilike\": syntax error at offset 66

D1_ERROR: near \"ilike\": syntax error at offset 66

D1_ERROR: near \"ilike\": syntax error at offset 66

D1_ERROR: near \"ilike\": syntax error at offset 66

M

Matt•6/21/24, 8:08 PM

For some reason,

like

like

like

like works but

ilike

ilike

ilike

ilike doesn't

MMatt For some reason, `like` works but `ilike` doesn't

C

Chaika•6/21/24, 8:11 PM

D1 is just SQlite, does Sqlite support ilike? I don't think so..

C

Chaika•6/21/24, 8:11 PM

looks like like in sqlite is case insensitive by default

M

Matt•6/21/24, 8:12 PM

Ah okay! Thanks. Still getting used to using SQLite.

MMatt Ah okay! Thanks. Still getting used to using SQLite.

S

SteffTekOP•6/21/24, 9:15 PM

SQLite on the edge was one of the dumbest, but best things to happen to the CF ecosystem

SSoftbear Hello has anyone tested the d1 driver for datagrip ? I can't manage to make pa...

V

vrballer•6/23/24, 12:27 AM

were you able to get this working (or possibly find some working alternative)

G

Gerbuuun•6/23/24, 6:43 PM

How would one access a DB specific to a user with the same pages project? Isn't there a limit on bindings per worker/pages project? I've read the messages around this: d1-database (or this d1-database ) Is this multi-tenancy support already available? I can't find anything about it in the documentation

GGerbuuun How would one access a DB specific to a user with the same pages project? Isn't ...

H

Hello, I’m Allie!•6/23/24, 6:44 PM

:soontm:

G

Gerbuuun•6/23/24, 6:44 PM

Ah the classic.. Looking forward to it!

D

Disciple of Caoximeihao•6/24/24, 8:40 AM

hello

D

Disciple of Caoximeihao•6/24/24, 8:40 AM

i from hono and D1

D

Disciple of Caoximeihao•6/24/24, 8:41 AM

const insertedOptionValues = await c.env.DB.prepare(`INSERT INTO optionValues (optionId, valueName) VALUES (?, ?), (?, ?), (? ,? )`)
      .bind(optionId, valueName[0], optionId, valueName[1], optionId, valueName[2])
      .run();

const insertedOptionValues = await c.env.DB.prepare(`INSERT INTO optionValues (optionId, valueName) VALUES (?, ?), (?, ?), (? ,? )`)
      .bind(optionId, valueName[0], optionId, valueName[1], optionId, valueName[2])
      .run();

const insertedOptionValues = await c.env.DB.prepare(`INSERT INTO optionValues (optionId, valueName) VALUES (?, ?), (?, ?), (? ,? )`)
      .bind(optionId, valueName[0], optionId, valueName[1], optionId, valueName[2])
      .run();

const insertedOptionValues = await c.env.DB.prepare(`INSERT INTO optionValues (optionId, valueName) VALUES (?, ?), (?, ?), (? ,? )`)
      .bind(optionId, valueName[0], optionId, valueName[1], optionId, valueName[2])
      .run();

D

Disciple of Caoximeihao•6/24/24, 8:41 AM

how to insert multi in d1

DDisciple of Caoximeihao ```const insertedOptionValues = await c.env.DB.prepare(`INSERT INTO optionValues...

H

Hard@Work•6/24/24, 8:50 AM

I would probably do

const ps = c.env.DB.prepare(`INSERT INTO optionValues (optionId, valueName) VALUES (?, ?)`);
const queries = [];
for(const row of rows) {
  queries.push(ps.bind(...row));
}
await c.env.DB.batch(queries);

const ps = c.env.DB.prepare(`INSERT INTO optionValues (optionId, valueName) VALUES (?, ?)`);
const queries = [];
for(const row of rows) {
  queries.push(ps.bind(...row));
}
await c.env.DB.batch(queries);

const ps = c.env.DB.prepare(`INSERT INTO optionValues (optionId, valueName) VALUES (?, ?)`);
const queries = [];
for(const row of rows) {
  queries.push(ps.bind(...row));
}
await c.env.DB.batch(queries);

const ps = c.env.DB.prepare(`INSERT INTO optionValues (optionId, valueName) VALUES (?, ?)`);
const queries = [];
for(const row of rows) {
  queries.push(ps.bind(...row));
}
await c.env.DB.batch(queries);

HHard@Work I would probably do ```js const ps = c.env.DB.prepare(`INSERT INTO optionValues ...

D

Disciple of Caoximeihao•6/24/24, 9:05 AM

working, but sql create 3 query, how to 1 query done

DDisciple of Caoximeihao working, but sql create 3 query, how to 1 query done

H

Hard@Work•6/24/24, 9:05 AM

I'm not sure I understand the question?

HHello, I’m Allie!:soontm:

M

Miloš•6/24/24, 5:10 PM

next to Dynamic Bindings, are there plans for sharding as well perhaps?

M

Miloš•6/24/24, 5:15 PM

Asking because my app requires a lot of queries across users which I believe wouldn't be that easy with per user db setup

DDisciple of Caoximeihao ```const insertedOptionValues = await c.env.DB.prepare(`INSERT INTO optionValues...

V

Vinodh•6/25/24, 4:55 AM

Use Drizzle ORM -> https://orm.drizzle.team/docs/insert#insert-multiple-rows

MMiloš next to Dynamic Bindings, are there plans for sharding as well perhaps?

H

Hard@Work•6/25/24, 10:53 AM

That one I'm not sure about, might be good to ask for an update in #community-call-questions if there isn't one already

P

Pavlo•6/25/24, 10:56 AM

Hello, what does this error mean and how to solve it? D1_ERROR: D1 exceeded its CPU time limit and was reset

PPavlo Hello, what does this error mean and how to solve it? D1_ERROR: D1 exceeded its ...

S

SteffTekOP•6/25/24, 11:39 AM

your D1 Query was so big, that your worker shut itself off

S

SteffTekOP•6/25/24, 11:40 AM

you have limited time to answer a worker request

Vvrballer were you able to get this working (or possibly find some working alternative)

S

Softbear•6/25/24, 2:49 PM

I'm using TablePlus

D

dqwqwdldowqqw•6/25/24, 4:42 PM

@Hard@Work

D

dqwqwdldowqqw•6/25/24, 4:42 PM

Can you help sorry for ping

D

dqwqwdldowqqw•6/25/24, 4:42 PM

Check #general-help latest.

Ddqwqwdldowqqw Check #general-help latest.

H

Hard@Work•6/25/24, 4:46 PM

?pings

F

Flare•6/25/24, 4:46 PM

Please do not ping community members for non-moderation reasons. Doing so will not solve your issue faster and will make people less likely to want to help you.

H

Hard@Work•6/25/24, 4:46 PM

Also, not sure what this has to do with D1

S

SteffTekOP•6/25/24, 5:14 PM

i've got this error multiple times while migrating my database. someone knows why this keeps showing up? i always killed the last migration but this time i have follow migrations and it's not that easy

S

SteffTekOP•6/25/24, 5:31 PM

i removed so many comments after finding a github issue, this is dumb lol

EEisenbergEffect Looking at limits to D1, I see that a single DB is limted to 10GB and that an ac...

S

Sam•6/25/24, 5:52 PM

The 10gb per database not, but I think the account limit can be increased by contacting support

Ppeshakoo I wonder how many users I can fit into 10GB without sharding

S

SteffTekOP•6/25/24, 5:59 PM

SSoftbear I'm using TablePlus

V

vrballer•6/25/24, 10:23 PM

Thanks!

P

puerh•6/26/24, 12:24 PM

Is there any way to restrict people from just using the UI to add a record to a d1 database directly (or even KV) - but still giving them worker write access? Feels like a really annoying permissions gap if not

I just want a db that we can only add to through known sources rather than anyone with enough permissions in cloudflare

Original message was deleted

P

puerh•6/26/24, 6:51 PM

I think that's what I'm trying to work out

Ideally the only way to deploy something that touches the DB will be through Github and atleast then it's reviewed.
But atm it feels a little impossible to store anything that's even remotely sensitive as it's a complete wild west. But I don't think Cloudflare offers the sort of permissions model I'm after.

I'm a Cloudflare admin, and I don't really want the permission to add records to the database directly through the UI

U

Unsmart•6/26/24, 6:58 PM

I mean realistically no platform offers that kind of permission model. But for all platforms you basically need to do the permission side of stuff in github actions where the github action can deploy the worker and not the user

U

Unsmart•6/26/24, 6:59 PM

I dont think cloudflare offers a read only view of workers resources though unless I am just missing it so they wont be able to use UI to view any D1/KV/etc stuff

ahh i missread, i thaught he meant storage per account

Similar Threads

Similar Threads

Similar Threads