Re: [sqlite] Typical suffixes of sqlite database files

[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 and 5 suffixes
for the SQLite databases that they utilize.

Use the magic number.  Much more reliable, easier to maintain, and less
chance of a false positive.

jonathon

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Typical suffixes of sqlite database files

[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 Unix 'magic' utility looks for the SQLite file header.  It checks the 
beginning of the file for "SQLite format 3" I think.  This is a far better test 
than depending on the extension.

Simon.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Typical suffixes of sqlite database files

[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,
Clemens
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Typical suffixes of sqlite database files

[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 routinely/always use .sq3 but that's only a personal convention.
>
>
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Typical suffixes of sqlite database files

[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
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Typical suffixes of sqlite database files

[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]?

  .fossil (Fossil)

  .fslchout (Fossil)

What else do you see? Ideally with source (application / framework)

Thanks.

rolf

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users