News for hackers. Stuff that matters.
Re:SQLite – The “server-process-edition” branch by ris on Wednesday August 15, 2018 @08:07PM (#17770840)
Looks like I misremembered this (re 64bit integers) and it was one of the other slightly odd limitations SQLite has around rowids and foreign keys that caused me to abandon the last system I was designing with it...

As for what most concerned me most when using SQLite was the ease of which it would happily allow me to make broken queries and not raise a fuss, e.g. referencing non-GROUP BYed terms in an aggregation.

Re:SQLite – The “server-process-edition” branch by ak39 on Thursday August 16, 2018 @04:58AM (#17773100)
Hi ris,

Can you provide example(s) of the broken query with non-GROUP BY columns in an aggregation? (Or a reference link if this is well known - I've searched briefly but can't find anything.)

Re:SQLite – The “server-process-edition” branch by lmz on Thursday August 16, 2018 @08:49AM (#17774145)
Not the parent poster but it's queries like these:

Select user.id, user.name, sum(tx.amount) from user inner join txn on (user.id = txn.uid) group by user.id

User.name is not in the group by list so it is picked arbitrarily from the rows in the group. It's harmless here but not in all cases.

Re:SQLite – The “server-process-edition” branch by Groxx on Sunday August 19, 2018 @02:25AM (#17792887)
TBH I like the ability to do this. Sometimes you truly don't care which value you get, you just want one. Sometimes you have application-level constraints which mean the one it picks is guaranteed to be correct, but you can avoid the cost of enforcing that (at insertion time and at lookup time). It's a handy tool when it's appropriate.

But hell yes, tools should warn you about this loudly, as it's not generally correct.

Re:SQLite – The “server-process-edition” branch by yawaramin on Thursday August 16, 2018 @07:33PM (#17779276)
Did you file a bug report?