5 ms·
Even better, use stored procedures / routines on top of views and only query the stored procedures from the frontend.
by thestepafter 3y ago
Even better, use stored procedures / routines on top of views and only query the stored procedures from the frontend.
- maxbond 3y agoI like it, but the only benefit we've retained at that point is eliminating round trips. Which is pretty significant. But we're still engaging in API design, we're just doing it in Sqlite.