crawl Comments - Answer Overflow

crawl

Posts Comments

DTDrizzle Team

•Created by rubberduckies on 5/29/2024 in #help

using array of ids as a where clause, using magic sql operator

the " seem to break the query afterwards

11 replies

DTDrizzle Team

•Created by rubberduckies on 5/29/2024 in #help

using array of ids as a where clause, using magic sql operator

the reason why a simple array join doesnt seem to work here is because it would make it a parameterized query and convert [1,2,3,4] to a single parameter of "1,2,3,4"

11 replies

DTDrizzle Team

•Created by rubberduckies on 5/29/2024 in #help

using array of ids as a where clause, using magic sql operator

but you should def verify and make sure this isnt some user fed data that could be injected here

11 replies

DTDrizzle Team

•Created by rubberduckies on 5/29/2024 in #help

using array of ids as a where clause, using magic sql operator

so just doing WHERE x IN (${sql.raw(variantIds.join(','))}) will for now at least not make your site explode

11 replies

DTDrizzle Team

•Created by rubberduckies on 5/29/2024 in #help

using array of ids as a where clause, using magic sql operator

ran into a similar issue where an array of values was interpreted completely wrong with the sql tagged template

11 replies

DTDrizzle Team

•Created by rubberduckies on 5/29/2024 in #help

using array of ids as a where clause, using magic sql operator

If you don’t need the data escaped you can use sql.raw here

11 replies

DTDrizzle Team

•Created by nelsonprsousa on 3/27/2024 in #help

Sub query with sql magic operator (for common table expression)

With recursive still being an open resolved PR it makes it kinda hard to write queries like this and combine them, you just have to end up writing the whole query manually

3 replies

DTDrizzle Team

•Created by nelsonprsousa on 3/27/2024 in #help

Sub query with sql magic operator (for common table expression)

Just ran into the same issue

3 replies

DIAdiscord.js - Imagine an app

•Created by dawnniie on 1/17/2024 in #djs-questions

djs memory usage in bun

Thus your memory usage is higher, but it should be stable regardless

21 replies

DIAdiscord.js - Imagine an app

•Created by dawnniie on 1/17/2024 in #djs-questions

djs memory usage in bun

The GC running more lax than the one from v8 already says a lot why it uses more memory, it keeps things in memory longer or takes a longer time to remove references

21 replies

DIAdiscord.js - Imagine an app

•Created by dawnniie on 1/17/2024 in #djs-questions

djs memory usage in bun

I don't think this is the case

21 replies

DIAdiscord.js - Imagine an app

•Created by dawnniie on 1/17/2024 in #djs-questions

djs memory usage in bun

sorry but no one can just "say" that without looking at an inspector

21 replies

DIAdiscord.js - Imagine an app