3 ms·
Wow, a project describing itself as a “Next generation ORM” that… doesn’t do joins, with no way to optimise queries. Perhaps they mean “Next generation” as in,
by misnome 3y ago
Wow, a project describing itself as a “Next generation ORM” that… doesn’t do joins, with no way to optimise queries.
Perhaps they mean “Next generation” as in, the 1987 TV series sense. Which would still be a long time after the concept of joins…
- djbusby 3y agoTo boldly go where the problem was solved ages ago
- pstuart 3y agoThere's One Weird Trick™ in managing joins in this case -- create views that implement the joins and then just treat it as yet another table. Bonus feature is creating a consistent way of working with that relation using native DB tools. ;-)
- cultofmetatron 3y agothat works great till your database gets big. Then you will watch your memory use skyrocket to perform joins into that view and it will F@#$@# your shit up. eventually it will take so much time to construct your view table that you'll tiemout your connection pool. to be clear, dont' use views in production queries. you WILL regret it. source: made this mistake.