What is the difference between *.sqlite and *.db file?

Question

What is the difference between a *.sqlite and a *.db file?

question from:https://stackoverflow.com/questions/5847067/what-is-the-difference-between-sqlite-and-db-file

Answer 1

You can name your SQLite database whatever you want. The content is not determined by the file ending but by a sequence of bytes which start every SQLite (3) file:

0x53 0x51 0x4c 0x69 0x74 0x65 0x20 0x66 0x6f 0x72 0x6d 0x61 0x74 0x20 0x33 0x00

which is ASCII for:

• SQLite format 3

In other words, it could be the same database content. There is no difference, as long as the creator did not put other bytes in it.

If you want to see if it is a SQLite 3 database, open the file in a hexeditor and look for the byte above or simply open it with the SQLite driver.