News for hackers. Stuff that matters.

A comment on Why SQLite succeeded as a database (2016). Parent comment

Re:Why SQLite succeeded as a database (2016) by int_19h on Thursday February 20, 2020 @10:45PM (#22380787)
application_id is really meant for scenarios where the SQLite database is treated as a document - a file that is intended to be copied around by the user, and opened by the same or another app elsewhere.

According to their mailing list, the way to register your own ID is to submit a patch that adds your ID to the file.

[ Parent | on HN ]
Re:Why SQLite succeeded as a database (2016) by zzo38computer on Friday February 21, 2020 @02:23AM (#22381490)
I tried to do that, but maybe the message didn't go through.

Some of the application IDs are made up using hexadecimal (such as Fossil), and some using ASCII (everything else listed in the magic.txt file in the SQLite repository). I have used base thirty-six; I later saw RADIX-50 mentioned, which would be another way.

[ Parent | on HN ]