The .db extension tells that it is a binary data file. The .sqlite extension invites users to open and mess it up. It depends on usage. sqlite file extension is for database files in SQLite format. Developers use .dat or .db to conceal format. sqlite files can be opened with SQLite or SQLite Browser. Note encrypted sqlite files need password. If unknown, likely cannot open. SQLite database, tables, data in single file allowing concurrent access. It locks during write which may fail or retry till timeout. Reads can multitask but writes sequential. The sqlite extension also in other types, maybe unsupported. SQLite file format and SQLite Browser developed together. Reading sqlite often done in SQLite Browser. Our sqlite tools: Opener, Converter. A sqlite file is lightweight SQL database itself using SQLite software. It implements full SQL database engine. SQLite database files often use .sqlite or .db extensions.
SQLite Browser
DB4S