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.
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.
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.
I've often seen .sqlite
, some tools use .db3
.
Some example programs that use .sqlite
:
A similar question: What is the best extension name SQlite database files?
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With