\[On magic numbers listed in \<SQLite-source-root\>/src/magic.txt ...\] > This is still recommended path forward? It is recommended if you want "utilities such as file(1)" to report something other than "SQLite3 Database" when given your particular DB files. It is up to you to determine whether to go to this trouble. To assess that, you need to consider how the "magic" text will be made to appear in the /usr/share/misc/magic configuration file used by the "file" utility on systems where your particular DB files are likely to appear and have provenance unknown to those who actually need to discover it. Given those predicates, an unqualified "recommended" seems a bit much in most cases. > If we're intending to do things the "Right Way" (TM) ... (Chuckle) In my opinion, you or others in your organization are far better poised to decide what "the Right Way" is.