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.