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

sqlite file-extension
techno picture techno · May 1, 2011 · Viewed 23.3k times · Source

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

Answer

Christian picture Christian · May 1, 2011

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.

Related questions

What are the .db-shm and .db-wal extensions in Sqlite databases?

I am seeing some strange behavior with my application and the state of its database file after running some tests that close the database, delete it, and replace it with a test fixture. When I examine the database file with …

Read More
Sqlite3 database file extension

Possible Duplicate: SQlite extension name What is the conventional file extension for an sqlite3 database? In the question, SQlite extension name, it is claimed there is no conventional name for an sqlite database, but it has been a few years, …

Read More
Select first row in each GROUP BY group?

As the title suggests, I'd like to select the first row of each set of rows grouped with a GROUP BY. Specifically, if I've got a purchases table that looks like this: SELECT * FROM purchases; My Output: id | customer | total …

Read More