4 ms·
I'm still just absurdly happy that it now has a bunch of math functions in the latest release: https://sqlite.org/lang_mathfunc.html https://sqlite.org/lang_mat
by chunkyks 6y ago
I'm still just absurdly happy that it now has a bunch of math functions in the latest release: https://sqlite.org/lang_mathfunc.html https://sqlite.org/lang_mathfunc.html
- dvfjsdhgfv 6y agoOut of curiosity: what is your use case and why do you prefer to use them in the DB instead of the application itself?
- smitty1e 6y agoIf you can put the logic into the SQL and filter some data out, that's likely to be a performance win. Whether the team benefits from tarting up the SQL beyond SELECT * is worth examining, however.
- sitkack 6y agoSo you can filter and join on computed values. What if there is no application?
- dvfjsdhgfv 6y agoI never thought about this - how would you present the data to the user then if there's no application?
- happysadpanda2 6y agoThe "DB" guy at my workplace is regularly asked about certain stats from the production db, he runs some query, dumps it in a csv-formatted file and mails that to whoever asked for it.
- chunkyks 6y agoGenerally I like to be able to ask questions of my database directly in a sql editor window. There's all sorts of cases where that is useful.
- jhayward 6y agoIndexes over computed fields can be quite handy.