DEV Community

Discussion on: Should I use SQLite, PostgreSQL, or MySQL?

Collapse
dewofyouryouth_43 profile image
Jacob E. Shore

Well. I won't give a comprehensive list. But list a few examples that should give you an idea of what I'm talking about. Until MySQL 8.0 there wasn't even support for any window functions. In 8.0 there's minimal support for window functions. There's no support for row level security. Upsert constraints are reduced to INSERT or REPLACE (which is dicey).

Thread Thread
buphmin profile image
buphmin

So more of a functional limitation rather than a scalability one then right?