4 ms·
Some questions: - Who is writing the queries, and what interface do they use? Are the SQL queries known at compile time, or does the user provide them to your
by justsomeuser 5y ago
Some questions:
- Who is writing the queries, and what interface do they use?
Are the SQL queries known at compile time, or does the user provide them to your compiled .NET program at runtime?
- What does the SQLite SQL dialect give you that Linq/functions does not?
- bob1029 5y agoQueries 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.