Need of SQLite database in command window

Question

Why we make SQLite database by .db extension in command window instead of file if both have same work. What's the main difference

Aarti · Answer

Hi Monika It make sense to use an extension based on the database scheme you are storing; treat your database schema as a file format with SQLite simply being an encoding used for that file format. So you might use .bookmarks if it's storing bookmarks or .index if it's being used as an index. or .DB if it's being used as an Database file. Thanks.