On 2019-10-26 4:38 p.m., Thomas Kurz wrote:
The features you name don't take away from the "liteness", they are all quite
small and useful.
Yes of course they are useful, I wouldn't deny that. But they are prioritized
over SQL-basics, that's what I'm confused about.
What do you mean by "SQL-basics"?
If you mean the list from your next post, there's very little basic about those
and many are quite complicated.
I agree with adding more ALTER TABLE options but that's about it.
Omitting RIGHT JOIN is good, that's a misfeature and LEFT JOIN does everything
useful it does.
Omitting SHOW TABLES or similar MySQL-only things is good, those are
misfeatures, and querying INFORMATION_SCHEMA does everything better and in a
more standard and composable way.
Anything to do with temporal and spatial is actually quite complicated, both
data types and constraints, and omitting those is quite reasonable.
-- Darren Duncan
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users