Freek is a platform for learning and sharing knowledge in the fields of software development, web development, and technology trends. Users can learn about software engineering best practices, programming languages, and emerging technologies, and share their experiences and insights with the community to foster learning and collaboration.

FREEK.DEV

Evaluate the potential of SQLite as a replacement for MySQL and PostgreSQL in production web applications.

Is it time to ditch MySQL and PostgreSQL for SQLite?

Uh, no? As mentioned in the linked article (driving me crazy having to follow a link!), it doesn’t scale horizontally. So for a company like where I work, where multiple tenants are using a given server, each with their our schema, we wouldn’t be able to use SQLite.
…and we’ve been doing that in production for over a decade, so backups and all that are very “figured out.”
Definitely a case to know you tech before you jump in, but sure… use it for a toy app or something that you know won’t need to scale horizontally.

Depends on your use case, really…