On 14 Sep 2015, at 5:48pm, Brian Willner <BWillner at seacorp.com> wrote:

> You
> could argue the same applies to SQLite file naming conventions as well.

May work for Windows.  On the Mac (and other forms of Unix) the 'file' command 
looks at the file header and, thanks to SQLite's consistent file headers, will 
identify it for you:

178:~ simon$ sqlite3 ~/Desktop/test
SQLite version 3.8.10.2 2015-05-20 18:17:19
Enter ".help" for usage hints.
sqlite> CREATE TABLE a(b INT);
sqlite> .quit

178:~ simon$ file ~/Desktop/test
/Users/simon/Desktop/test: SQLite 3.x database
178:~ simon$ 

Simon.

Reply via email to