3 ms·
Queries are managed via a web interface. Nothing is known at compile time. > What does the SQLite SQL dialect give you that LINQ/functions do not? It's not ab
by bob1029 5y ago
Queries are managed via a web interface. Nothing is known at compile time.
> What does the SQLite SQL dialect give you that LINQ/functions do not?
It's not about SQLite's specific dialect. It's just about SQL. The relational algebra/calculi are capable of expressing any degree of complexity. LINQ (functions) require compile-time, which breaks our objectives.
- fifilura 5y agoI agree, I was once the on the implementation side of this. It was lovely. All day writing pure, terse, bug-free logic. Until that utopia started to itch... But the experience helped me to look for the SQL patterns in the logic of the codebase I am working with. Often there is very little. Mostly meaning that the rest is just an annoying heap of plumbing. It is not like I can magically make it go away, but it still seems unnecessary to me.