Remix.run Logo
drivebyhooting 12 hours ago

My issue with SQL is lack of composability and difficulty of debugging intermediate results.

mamcx 5 hours ago | parent | next [-]

Yes, SQL is poor.

What could be good is relational + array model. I have some ideas on https://tablam.org, and building not just the language but the optimizer in tandem I think will be very nice.

asadm 12 hours ago | parent | prev [-]

is it a language problem though? it's just lack of tooling.

theLiminator 12 hours ago | parent [-]

The dataframe paradigm (a good example being polars) is another good alternative that's more composable (imo).

fifilura 7 hours ago | parent [-]

It is true. I still hate it. I think because it always offers 10 different ways to do the same thing. So it is just too much to remember.