Bug 3178

Except general application/x-sqlite, KDE is going to have application/x-sqlite2
and application/x-sqlite3 to distinguish versions. Is this acceptable to add
these fd.org as well?

It's probably acceptable, but I'm wondering if it's that useful to make the
difference between v2 and v3 sqlite files. Aren't there incompatibility in the
file format between minor releases too ?

There are have plans to use SQLite 3.1 too (thus application/x-sqlite3-1 or so)
on KDE. AFAIK, SQLite creators try their best to avoid introducing
incompatibilities. Recent change (3.1) is because of important ALTER TABLE
stuff, incompatibilities were inavoidable. 
After SQLite3.1 I wouldn't expect there will be incompatibilities appearing
every month.

If two (or even three) mime types can be added, I am predicting this can improve
interoperability on free desktops, as more and more apps and libs are being
developed on top of SQLite.

Sorry, I had in mind db2/db3 in mind when I talked about incompatible changes
being done every releases, I guess having separate mime types for the various
sqllite versions is ok.

Thanks for your bug report and sorry for the late response!
What is the typical file extension of SQLite files?

There's no such defined for SQLite. Developers often treat SQLite as an
intermediate tool for implementing relational database, and thus we could look
at SQLite files in the same way as we're looking at files without any concrete
filename extensions. Quite similar as with ascii text files on unix (e.g.
INSTALL, README files).

So, I think Choosing any extenstion here could only add some confusion. 

SQLite file format can be considered as an subformat. Applications utilizing
sqlite format are defining their own stuctures within it, so look at all this as
text file versus xml file : the latter is still valid text file.

Hope this helped

Thanks, fixed in HEAD. With your patch, Nautilus is able to recognize my SQLite
files.

As wrote above, there two different SQLite formats. Some apps can support both,
some apps can support only newer or only older. There's no SQLite library that
fully supports both formats. To avoid problems with confusing "not recognized
format" errors, my proposal is to split the type now. Thanks. 

PS1: This is the way how the types are already defined and used in KDE.

PS2: I've mentioned about a mimetype for SQLite 3.1 or newer. I've dropped this
idea: it's impossible to distinguish between any of 3.x versions right now. 

--- freedesktop.org.xml.in.orig	2005-10-29 22:19:40.000000000 +0200
+++ freedesktop.org.xml.in	2005-10-29 23:04:38.000000000 +0200
@@ -173,10 +173,15 @@
     <glob pattern="*.smi"/>
     <glob pattern="*.sml"/>
   </mime-type>
-  <mime-type type="application/x-sqlite">
-    <_comment>SQLite database</_comment>
+  <mime-type type="application/x-sqlite2">
+    <_comment>SQLite2 database</_comment>
     <magic>
       <match type="string" value="** This file contains an SQLite" offset="0"/>
+    </magic>
+  </mime-type>
+  <mime-type type="application/x-sqlite3">
+    <_comment>SQLite3 database</_comment>
+    <magic>
       <match type="string" value="SQLite format 3" offset="0"/>
     </magic>
   </mime-type>

Thanks, committed.