Re: [sqlite] Typical suffixes of sqlite database files

2016-10-21 Thread jonathon
On 20/10/2016 23:17, Rolf Ade wrote: > What suffixes to sqlite database files do you use or see in the wild? Too many for suffix identification to be a viable option. One program I use, has 20 different suffixes, for the SQLite databases that it utilizes. Most of its competitors use between 3

Re: [sqlite] Typical suffixes of sqlite database files

2016-10-21 Thread Simon Slavin
On 21 Oct 2016, at 12:17am, Rolf Ade wrote: > What suffixes to sqlite database files do you use or see in the wild? If you're writing a general utility for SQLite databases you can not depend on anything. The two suffixes '.db' and '.dat' can mean anything at all. The

Re: [sqlite] Typical suffixes of sqlite database files

2016-10-21 Thread Clemens Ladisch
Rolf Ade wrote: > What suffixes to sqlite database files do you use or see in the wild? > > There are for sure > > .db (e.g. firefox) > .sqlite[23]? These are the most likely ones. But you cannot use the file name to exclude files from the selection; you have to allow all files. Regards,

Re: [sqlite] Typical suffixes of sqlite database files

2016-10-21 Thread Eric Grange
> What suffixes to sqlite database files do you use or see in the wild? .sql3 .dat On Fri, Oct 21, 2016 at 7:46 AM, Jean-Christophe Deschamps wrote: > At 01:17 21/10/2016, you wrote: > > What suffixes to sqlite database files do you use or see in the wild? >> > > I

Re: [sqlite] Typical suffixes of sqlite database files

2016-10-20 Thread Jean-Christophe Deschamps
At 01:17 21/10/2016, you wrote: What suffixes to sqlite database files do you use or see in the wild? I routinely/always use .sq3 but that's only a personal convention. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

[sqlite] Typical suffixes of sqlite database files

2016-10-20 Thread Rolf Ade
Hello, I'm asking this for further discussion of a deficiencies of emacs sql-mode w/ sqlite databases (https://debbugs.gnu.org/cgi/bugreport.cgi?bug=23566). What suffixes to sqlite database files do you use or see in the wild? There are for sure .db (e.g. firefox) .sqlite[23]?