Re: [sqlite] Using application_id

2019-11-19 Thread Christian Gauger-Cosgrove
Pardon the "double post" as it were. I was handily informed the mailing list strips attachments. Therefore, for those interested, here's text versions of the header file (rad50.h) and the actual C that does the RADIX-50 conversions (rad50.c): /*

Re: [sqlite] Using application_id

2019-11-19 Thread Christian Gauger-Cosgrove
On 19/11/2019, Dominique Devienne wrote: > On Tue, Nov 19, 2019 at 2:00 AM Peter da Silva wrote: >> The return of RADIX-50. >> >> https://en.wikipedia.org/wiki/DEC_Radix-50 > > Thanks! I might go with this going forward. --DD > To make life easier for those desiring to experience the Wonders of

Re: [sqlite] Using application_id

2019-11-19 Thread Dominique Devienne
On Tue, Nov 19, 2019 at 2:00 AM Peter da Silva wrote: > > > If you stick to lower or upper case letters, could encode up to 6 chars > in the app_id. --DD > > The return of RADIX-50. > > https://en.wikipedia.org/wiki/DEC_Radix-50 Thanks! I might go with this going forward. --DD PS: I tend to

Re: [sqlite] Using application_id

2019-11-18 Thread Peter da Silva
> If you stick to lower or upper case letters, could encode up to 6 chars in > the app_id. --DD The return of RADIX-50. https://en.wikipedia.org/wiki/DEC_Radix-50 ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] Using application_id

2019-11-18 Thread Tobias Leupold
Hi Clemens! Thanks for your fast reply! And/or how can one "register" an application id to prevent collisions? Submit a patch here. In my case, that would be: --- magic.txt.orig 2019-11-18 18:12:00.957789352 +0100 +++ magic.txt 2019-11-18 18:13:13.055463773 +0100 @@ -29,4

Re: [sqlite] Using application_id

2019-11-18 Thread Dominique Devienne
On Mon, Nov 18, 2019 at 2:41 PM Clemens Ladisch wrote: > Tobias Leupold wrote: > Apparently, authors or 'private' file formats do not bother to register > their IDs. > Indeed, there's little point, as those are rarely "public". I tend to chose a 4 letter prefix related to the kind of

Re: [sqlite] Using application_id

2019-11-18 Thread Clemens Ladisch
Tobias Leupold wrote: > In the docs, a magic file is linked ( https://www.sqlite.org/src/ > artifact?ci=trunk=magic.txt ) with "registered" formats. > > Is there another list with "taken" application ids? No. Apparently, authors or 'private' file formats do not bother to register their IDs. >

[sqlite] Using application_id

2019-11-18 Thread Tobias Leupold
Hi list! I recently learned about the PRAGMA application_id feature of SQLite, which is really nice to be able to identify an application-specific SQLite database at the file system level, even with versioning support via the user_version header. SQLite encourages to use an SQLite database as