SQLite vs other DB Engines review

This site is supposedly database enginee agnostic. I have seen some slants in their reporting but fairly neutral. The link below talks about all the advancedments in 2018 in SQLite. And the charts compare it to the latest versions of the “competitors”. I am using the term competitors loosely there.

I think it is an interesting read. take with grain of salt.


Interesting article. The author states:

Well… of course I want to know more. Looked it up here:
Window Functions It says…

Not sure what that means. Or how one might use this most important “modern” SQL feature. Maybe someone would be willing to pose a practical example. In theory, of course.

The article linked by Scott has a link to a video explaining a lot of new features:

Interesting article.
Especially differences to MySQL and PostgreSQL.