4 ms·
> I wish there was a modern language that compiled to SQL (like PRQL, but with data mutation). That is nice, but much better will be language that is relationa
by mamcx 4y ago
> I wish there was a modern language that compiled to SQL (like PRQL, but with data mutation).
That is nice, but much better will be language that is relational itself.
I'm working on one (https://tablam.org https://tablam.org) and you can even do stuff like:
for p in cross(products, qty) ?limit 10 do
print(p.products.price * p.qty)
end
The thing is be functional/relational only is too mind-bending and is very nice to work with procedural construct.
BTW my plan is that the query (?) section will compile to optimal executions defined per storage engine (memory, sqlite, mysql, redis, etc) `products ? price = 10.0` is executed on the server, not on the client.
- jasonhansel 4y agoInteresting! Have you looked at Datalog? In many ways it's the ideal purely relational language.
- mamcx 4y agoYes. I think is not friendly for end-users* and making this on Rust make it easy to plug-in iterators/generators so i go that way. (Also never wrap my head about how use it internally!)