Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I had a look into a program's folder in Program Files of the Windows directory and I found that it has a lot of files with .db extension. I opened one with notepad and I saw that the first string in the file is sqlite 3. What is the difference between files ended with db and those with sqlite extensions ?

share|improve this question
What program is it? – Raystafarian Feb 27 '12 at 12:55

There needn't be a difference in the file format. File format is totally unrelated to the extension it is given. For good practice, we all agreed they should match so that we can identify files and their formats by their extension.

However there is nothing that will keep developers or users from using deviant extensions for established file formats.

Some use .db, others like to use .sqlite. Hell, if they want to use .abc (though highly unlikely) for their files, they can. It's just a matter of opening the file with the right program.

share|improve this answer

There is no huge difference between these two files, A .sqlite file is used to hold the SQLite database while the .db file is used by databases like Oracle, Paradox etc.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.