fstephany

no profile record

comments

12 miesięcy temudiscuss

I agree with you that dynamic query building can be tedious with a pure SQL approach. The use case you are describing can be solved with something alone the lines of:

  WHERE organization = $1
     AND ($2 IS NULL OR starts_with(first_name, $2)
     AND ($3 IS NULL OR birth_date > $3)

With SQLx you would have all the params to be Options and fill them according the parameters that were sent to your API.

Does that make sense?

fstephany

w zeszłym rokudiscuss

You are not alone!

fstephany

w zeszłym rokudiscuss

Oh wow, thank you. I didn't know nested CSS was a real thing nowadays.

fstephany

2 lata temudiscuss

I have the same feeling performance-wise with the laptop I bought in 2020 with a Ryzen 7 4800H.

But it's a heavy brick with a short battery life compared to the M1/2/3 Mac.

fstephany

2 lata temudiscuss

It makes me think of https://moldabledevelopment.com/

You do not code in the visual environment but it helps you to create tools to visualize exactly what you want/need to see. The interactivity is hard to beat and once you are used to it, you can quickly create visualizations that you can throw away (or keep).