I like SQLite because it's simple and also because I believe it sticks to the 
standard, therefore I get the habit to use SQLite to learn standard SQL.

Today, I came to a page from the documentation, about a construct which is 
supported for compatibility with MySQL and elsewhere I learned (if not wrong) 
`INSERT OR REPLACE` is not standard SQL, which (the latter) defines a different 
while close `MERGE` instead.

So I feel may be I should not see SQLite as a strict standard SQL 
implementation and learn where it conforms to it (I care less about partial 
support) and where it deviates.

Reply via email to