SQLite is a file. It doesn't need auth any more than a text file your editor opens. The "auth" is in the OS not letting people access your files. That article s

SQLite is a file. It doesn't need auth any more than a text file your editor opens. The "auth" is in the OS not letting people access your files. That article seems to be talking about using SQLite to implement authentication for I guess web apps or something, and many/most sqlites are used for stuff that isn't anything like a server. Admittedly coders can still fuck that up by not setting file permissions right(as with any file), so that other users on the system can access it, but these days that seems to be a secondary line of defense, now that systems are mostly single user or container based, people usually don't have fully untrusted stuff running outside a VM.