Need of SQLite database in command window
Why we make SQLite database by .db extension in command window instead of file if both have same work. What's the main difference
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
AartiPosted Nov 18, 2011, 5:33 AM
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.