Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
add comment

1 Answer 1

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
add comment

Your Answer

 
discard

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.