I would be interested in a full text search solution like sphinx search or elastic search, are there

I would be interested in a full text search solution like sphinx search or elastic search, are there any plans for this?

typesafeui•2/12/24, 10:18 PM

is there a way to do

env.DB.prepare('select * from table where id in (?)').bind([1,2,3]).all()

env.DB.prepare('select * from table where id in (?)').bind([1,2,3]).all()

NOTE: the above code does not work

typesafeui•2/12/24, 10:19 PM

because the two alternatives I see is querying the whole db and filtering with js or querying for each one

Unsmart•2/12/24, 10:20 PM

const ids = [1,2,3]

env.DB.prepare(`select * from table where id in (${ids.map(() => '?').join(', ')})`).bind(ids).all()

const ids = [1,2,3]

env.DB.prepare(`select * from table where id in (${ids.map(() => '?').join(', ')})`).bind(ids).all()

Unsmart•2/12/24, 10:20 PM

something like that basically

UUnsmart ```ts const ids = [1,2,3] env.DB.prepare(`select * from table where id in (${id...

typesafeui•2/12/24, 10:21 PM

trying this is it still safe tho? i feel like you can still break it somehow

typesafeui•2/12/24, 10:21 PM

safe from sql injection

Unsmart•2/12/24, 10:21 PM

It would be safe all you are doing is mapping the

UUnsmart It would be safe all you are doing is mapping the `?`s

typesafeui•2/12/24, 10:21 PM

ohhh

Original message was deleted

typesafeui•2/12/24, 10:22 PM

I see what you are saying

typesafeui•2/12/24, 10:22 PM

than yeah def safe

typesafeui•2/12/24, 10:22 PM

thanks for the help!

typesafeui•2/12/24, 10:23 PM

The final one would become this

env.DB.prepare(`select * from table where id in (${ids.map(() => '?').join(', ')})`).bind(...ids).all()

env.DB.prepare(`select * from table where id in (${ids.map(() => '?').join(', ')})`).bind(...ids).all()

Ddown I would be interested in a full text search solution like sphinx search or elast...

Max (@rozenmd)•2/12/24, 11:09 PM

fts5 is available

VVy No, D1 GA is planned for early April.

Elia•2/13/24, 12:23 AM

Does GA mean we can also use it outside of workers?

EElia Does GA mean we can also use it outside of workers?

Unsmart•2/13/24, 12:26 AM

You technically can already with the API (though not recommended to use). Recommended is to create a worker proxy.

Afaik there's not any plans for "outside of workers" beyond what you can do today.

UUnsmart You technically can already with the API (though not recommended to use). Recomm...

Elia•2/13/24, 12:51 AM

As long as it's allowed to proxy through workers that's fine with me

Elia•2/13/24, 12:52 AM

Any chance they'll upgrade the limits before GA? (e.g. talking max storage, SQL operators, etc.)

EElia As long as it's allowed to proxy through workers that's fine with me

Vy•2/13/24, 1:15 AM

We're working on max storage. What additional SQL operators ar eyou looking for?

MMax (@rozenmd)fts5 is available

downOP•2/13/24, 7:11 AM

I know, but it's nowhere near as sophisticated as a search engine.

ZZiga Zajc What is the average latency added when we use D1 thru HTTP API?

Hello, I’m Allie!•2/13/24, 7:19 AM

Depends on where you are

Hello, I’m Allie!•2/13/24, 7:19 AM

All requests go through Core(iirc), so if you are far away then it takes longer

Hello, I’m Allie!•2/13/24, 7:20 AM

Even worse if your DB is close to you

ZZiga Zajc for example Hetzner datacenter in Nuremberg and Falkenstein (Germany)

Hello, I’m Allie!•2/13/24, 7:24 AM

Run it through a Worker, would be a lot faster

ZZiga Zajc The problem is that I'm making this project open source, so it can be self-hoste...

Hello, I’m Allie!•2/13/24, 7:28 AM

I would just note that D1 really isn’t meant to be accessed that way, and thus I doubt it will every be very performant

ZZiga Zajc wait why D1 HTTP API wasn't build on Cloudflare Workers from the start?

Hello, I’m Allie!•2/13/24, 7:29 AM

It is, afaik. But the entirety of api.cloudflare.com is routed to Core

ZZiga Zajc so users / self-hosters wouldn't need to deploy their own D1 proxy on workers

Hello, I’m Allie!•2/13/24, 7:30 AM

Because D1 is a DevPlat DB, which means it performs best when used from other DevPlat products

Hello, I’m Allie!•2/13/24, 7:30 AM

Like Workers/Functions

ZZiga Zajc I could probably completely replicate D1 HTTP API in workers. So normal self-hos...

Hello, I’m Allie!•2/13/24, 7:36 AM

Wait, do you mean you would make requests for them?

HHello, I’m Allie!It is, afaik. But the entirety of api.cloudflare.com is routed to Core

Max (@rozenmd)•2/13/24, 7:44 AM

It isn't (yet) - it was easier to take an existing approach we used often than to start something new, since the aim is to make the Workers platform better, not to make a standalone db

Max (@rozenmd)•2/13/24, 7:44 AM

D1's API will be run from Workers :soontm:

MMax (@rozenmd)It isn't (yet) - it was easier to take an existing approach we used often than t...

Hello, I’m Allie!•2/13/24, 7:46 AM

TIL

Hello, I’m Allie!•2/13/24, 7:46 AM

Might also help to be able to hit EuroCore, even when PDX isn't down

HHello, I’m Allie!Might also help to be able to hit EuroCore, even when PDX isn't down

Max (@rozenmd)•2/13/24, 7:47 AM

It runs in both in an active/active config

Hello, I’m Allie!•2/13/24, 7:48 AM

Nvm