SQLite vs SQLite3: What Is the Difference?
SQLite is the database engine. SQLite3 commonly refers to its version 3 family, the sqlite3 command-line program, or a language binding. It is not a separate competing database product.
A file extension does not identify a version
Ordinary SQLite 3 databases may be named .db, .sqlite or .sqlite3. Changing the extension does not convert a database. SQLite Lab checks the file header, and cannot open encrypted files or older SQLite 2 database formats.
Check the engine version
sqlite_version() reports the library running this query, not when a database file was created. The workspace status bar also shows its loaded SQLite engine version.
SELECT sqlite_version();Python uses the name sqlite3
Python includes a sqlite3 module for working with SQLite databases. The Python module version and the linked SQLite library are different concepts. In Python, sqlite3.sqlite_version reports the linked library version. A database created in Python can be opened here when it is a complete, unencrypted SQLite snapshot.
Keep exploring
SQLite syntax reference · Practice with a learning path · Sample datasets
How to Open a .db File in Your Browser
Reference: Official SQLite documentation