fstephany

no profile record

comments

12 months agodiscuss

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

last yeardiscuss

You are not alone!

fstephany

last yeardiscuss

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

fstephany

2 years agodiscuss

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 years agodiscuss

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).