Sqlite3 database file extension

sqlite file-extension
leech picture leech · Sep 12, 2011 · Viewed 24.1k times · Source

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, and i'm wondering if a standard has emerged or barring that if there is a generally accepted standard.

Ultimately what I want to do is make it obvious to future coders what the file is.

I haven't worked very much with sqlite, and so i've never actually seen the file extension in the wild. I want to follow convention if there is one.

Answer

Jens Mühlenhoff picture Jens Mühlenhoff · Sep 12, 2011

I've often seen .sqlite, some tools use .db3.

Some example programs that use .sqlite:

  • Mozilla Firefox
  • Mozilla Thunderbird
  • Several Addons for Mozilla applications
  • Mumble

A similar question: What is the best extension name SQlite database files?

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
What is the difference between *.sqlite and *.db file?

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

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