Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Sqlite3 database file extension [duplicate]

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.

like image 313
leech Avatar asked Sep 12 '11 15:09

leech


People also ask

What is the file extension for SQLite database?

SQLITE3 files are often used for storing embedded SQL-based databases for iPhone apps and other mobile applications. NOTE: SQLite database files often use the extensions . SQLITE or . DB.

How do I open a .SQLite file?

Open a command prompt (cmd.exe) and 'cd' to the folder location of the SQL_SAFI. sqlite database file. run the command 'sqlite3' This should open the SQLite shell and present a screen similar to that below.


1 Answers

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?

like image 195
Jens Mühlenhoff Avatar answered Oct 05 '22 15:10

Jens Mühlenhoff