function Comments - Answer Overflow

Topics

function

Explore posts from servers

DDeno ATApache TinkerPop TtRPC TTCTheo's Typesafe Cult DTDrizzle Team

•Created by function on 2/5/2025 in #help

CTE / WITH + alias

you mean @outranker, right?

11 replies

•Created by function on 2/5/2025 in #help

CTE / WITH + alias

👀

11 replies

•Created by function on 2/5/2025 in #help

CTE / WITH + alias

and i've checked out table aliases but as far as i can tell you can't use them for CTEs.

11 replies

•Created by function on 2/5/2025 in #help

CTE / WITH + alias

so i can't see the code you wrote

11 replies

•Created by function on 2/5/2025 in #help

CTE / WITH + alias

for some reason, that link just redirects me to just https://drizzle.run/ D:

11 replies

•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