function Comments - Answer Overflow

Topics

function

Explore posts from servers

DDeno ATApache TinkerPop TtRPC TTCTheo's Typesafe Cult DTDrizzle Team

•Created by function on 1/30/2025 in #❓-help

Throw NOT_FOUND on nullish

i appreciate it 🙏

5 replies

•Created by function on 1/30/2025 in #❓-help

Throw NOT_FOUND on nullish

🥺

5 replies

•Created by function on 1/30/2025 in #help

Get all authors with latest book

anyway, thanks a lot for the solution and for the docs link.

11 replies

•Created by function on 1/30/2025 in #help

Get all authors with latest book

i didn't take it as an attack, i just felt a bit like i just didn't have the skills to find or come up with this, since the subquery example doesn't use limit but an aggregate function. i just wanted to express that i think me not finding a solution wasn't for lack of trying.

11 replies

•Created by function on 1/30/2025 in #help

Get all authors with latest book

can't test right now but that looks like exactly what i'm looking for, thank you. your recommendation to read the docs hurts a bit because i spent a lot of time reading the docs, specifically looking for solutions to this greatest-n-per-group problem, and couldn't come up with something. i was unaware you could use "limit" inside "with".

11 replies

•Created by function on 1/30/2025 in #help

Get all authors with latest book

SELECT a.author_id, a.author_name, b.book_id, b.book_title, b.release_date
FROM authors a
JOIN books b ON a.author_id = b.author_id
WHERE b.release_date = (
    SELECT MAX(b1.release_date)
    FROM books b1
    WHERE b1.author_id = b.author_id
);

SELECT a.author_id, a.author_name, b.book_id, b.book_title, b.release_date
FROM authors a
JOIN books b ON a.author_id = b.author_id
WHERE b.release_date = (
    SELECT MAX(b1.release_date)
    FROM books b1
    WHERE b1.author_id = b.author_id
);

11 replies

•Created by function on 1/28/2025 in #❓-help

How can i check if an error is a TRPC Error in the browser?

Solved: https://trpc.io/docs/client/vanilla/infer-types#infer-trpcclienterror-types

3 replies

•Created by function on 1/28/2025 in #help

[Solved] Drizzle Studio blocked by CORS, mkcert "no security databases found"

that worked 🎉 thanks a ton!

3 replies

•Created by function on 10/11/2024 in #help

Deno.serve() + sharp + streams

anyway, thank you for your input

34 replies

•Created by function on 10/11/2024 in #help

Deno.serve() + sharp + streams

one solution that i can see is if sharp could output a ReadableStream right away

34 replies

•Created by function on 10/11/2024 in #help

Deno.serve() + sharp + streams

i guess toWeb being slow (and maybe broken?) is on node

34 replies

•Created by function on 10/11/2024 in #help

Deno.serve() + sharp + streams

i'm not sure which side - deno or sharp - can improve in this combination

34 replies

•Created by function on 10/11/2024 in #help

Deno.serve() + sharp + streams

just for reference

34 replies

•Created by function on 10/11/2024 in #help

Deno.serve() + sharp + streams

https://github.com/lovell/sharp/issues/4234

34 replies

•Created by function on 10/11/2024 in #help

Deno.serve() + sharp + streams

i have an issue of type question open on the sharp github to maybe figure something out

34 replies

•Created by function on 10/11/2024 in #help

Deno.serve() + sharp + streams

that method was added in node v17 but is still experimental

34 replies

•Created by function on 10/11/2024 in #help

Deno.serve() + sharp + streams

node has Readable.toWeb() which is supposed to do exactly what i need but is like 3x slower than any other method and also broken for me (image get served but is blank)

34 replies

•Created by function on 10/11/2024 in #help

Deno.serve() + sharp + streams

i can only explain this difference with the stream conversion

34 replies

•Created by function on 10/11/2024 in #help

Deno.serve() + sharp + streams

which are native bindings, so the processing should always take the same time

34 replies