On 2015-09-14 06:17 PM, Simon Slavin wrote: > On 14 Sep 2015, at 3:38pm, Stephen Chrzanowski <pontiac76 at gmail.com> wrote: > >> *.SQL appears to be a common thing for not only Structured Query >> Language, but also "Squish message base lastread pointers" -- > Whatever the heck that is. > > I use *.SQL for text files which contain SQL commands, including the ones the > SQLite tool generates from '.dump'. > > I don't have a good answer about what extension to use for SQLite databases. > At the moment I seem to favour using the extension '.sqlite' but I'd be hard > pressed to make an argument for it. I wonder what I'll do when SQLite4 comes > along.
Yeah - I might add that sqlite is very often used as an application file format, which results in a myriad of extensions out there. There is no noticeable convention. I happen to see it lots because when developing the search functions, I use SQLitespeed and just point the search tool to the c:\users\xxx\appdata\ folder on any new system, enter *.* as the search text, tick "include sub-folders" and after about a minute I see a list of every SQLite database in the system. (Well, in Appdata anyway). There are usually loads, but I have never noticed any convention or extension being more prevalent than any other. It's usually just random - and where duplications occur, they usually belong to the same system. ".sqlite" is found somewhat, but if I had to pick one that seems most common, it would just be the: "*.db" (Security-win, I know) For reference, I just checked this pc (as described above) and these are all the valid SQLite DB's in Appdata with their extensions: (Your experience may differ) C:\Users\R.Smith\AppData\Local\Adobe\OOBE\opm.db C:\Users\R.Smith\AppData\Local\EvernoteNW\cookies C:\Users\R.Smith\AppData\Local\EvernoteNW\Local Storage\file__0.localstorage C:\Users\R.Smith\AppData\Local\EvernoteNW\Web Data C:\Users\R.Smith\AppData\Local\Evernote\Evernote\Databases\rsmith386.exb C:\Users\R.Smith\AppData\Local\Mozilla\Firefox\Profiles\tvs0coxp.default\OfflineCache\index.sqlite C:\Users\R.Smith\AppData\Local\Steam\htmlcache\Cookies C:\Users\R.Smith\AppData\Local\Steam\htmlcache\Local Storage\https_www.youtube.com_0.localstorage C:\Users\R.Smith\AppData\Local\Steam\htmlcache\Local Storage\http_steamcommunity.com_0.localstorage C:\Users\R.Smith\AppData\Local\Temp\Test1e499fd04-6213-4da6-97a3-209da4fd29eb.prmdc C:\Users\R.Smith\AppData\Roaming\Adobe\Bridge CS6\Cache\data\store C:\Users\R.Smith\AppData\Roaming\Atlantic\AIDB_SysData.cdb C:\Users\R.Smith\AppData\Roaming\Atlantic\AIDB_SysData_Backup.cdb C:\Users\R.Smith\AppData\Roaming\Dropbox\instance1\aggregation.dbx C:\Users\R.Smith\AppData\Roaming\Dropbox\instance1\config.db C:\Users\R.Smith\AppData\Roaming\FDM\SysData\FDM_LocData.rdb C:\Users\R.Smith\AppData\Roaming\FDM\SysData\FDM_Logs.rdb C:\Users\R.Smith\AppData\Roaming\FileZilla\queue.sqlite3 C:\Users\R.Smith\AppData\Roaming\IPView\SysData\Data\IPDB_CalcData.idb C:\Users\R.Smith\AppData\Roaming\IPView\SysData\Data\IPDB_ImptData.idb C:\Users\R.Smith\AppData\Roaming\IPView\SysData\Data\IPDB_ImptData_Old_Planners_Backup.idb C:\Users\R.Smith\AppData\Roaming\IPView\SysData\Data\IPDB_StdLists.idb C:\Users\R.Smith\AppData\Roaming\IPView\SysData\Data\IPDB_UserData.idb C:\Users\R.Smith\AppData\Roaming\IPView\Sys_Cache.cdb C:\Users\R.Smith\AppData\Roaming\Listary\UserData\History_v2.sqlite C:\Users\R.Smith\AppData\Roaming\Mozilla\Firefox\Profiles\tvs0coxp.default\content-prefs.sqlite C:\Users\R.Smith\AppData\Roaming\Mozilla\Firefox\Profiles\tvs0coxp.default\cookies.sqlite C:\Users\R.Smith\AppData\Roaming\Mozilla\Firefox\Profiles\tvs0coxp.default\evernote_webclipper.sqlite C:\Users\R.Smith\AppData\Roaming\Mozilla\Firefox\Profiles\tvs0coxp.default\formhistory.sqlite C:\Users\R.Smith\AppData\Roaming\Mozilla\Firefox\Profiles\tvs0coxp.default\healthreport.sqlite C:\Users\R.Smith\AppData\Roaming\Mozilla\Firefox\Profiles\tvs0coxp.default\permissions.sqlite C:\Users\R.Smith\AppData\Roaming\Mozilla\Firefox\Profiles\tvs0coxp.default\places.sqlite C:\Users\R.Smith\AppData\Roaming\Mozilla\Firefox\Profiles\tvs0coxp.default\reading-list.sqlite C:\Users\R.Smith\AppData\Roaming\Mozilla\Firefox\Profiles\tvs0coxp.default\storage\default\file++++C++Projects+Unity+Temp+TestProj1+tpWebGL+index.html\idb\2083995541%s2fFbid.sqlite C:\Users\R.Smith\AppData\Roaming\Mozilla\Firefox\Profiles\tvs0coxp.default\storage\default\https+++google.github.io\idb\3823323449mbvd.sqlite C:\Users\R.Smith\AppData\Roaming\Mozilla\Firefox\Profiles\tvs0coxp.default\storage\default\https+++uplay.ubi.com\idb\533021264u3pVlya.sqlite C:\Users\R.Smith\AppData\Roaming\Mozilla\Firefox\Profiles\tvs0coxp.default\storage\default\https+++www.maxmind.com\idb\581034704_b_Dmsmwaip.sqlite C:\Users\R.Smith\AppData\Roaming\Mozilla\Firefox\Profiles\tvs0coxp.default\storage\permanent\chrome\idb\2918063365piupsah.sqlite C:\Users\R.Smith\AppData\Roaming\Mozilla\Firefox\Profiles\tvs0coxp.default\storage\permanent\indexeddb+++fx-devtools\idb\478967115deegvatroootlss--cans.sqlite C:\Users\R.Smith\AppData\Roaming\Mozilla\Firefox\Profiles\tvs0coxp.default\storage\permanent\moz-safe-about+home\idb\818200132aebmoouht.sqlite C:\Users\R.Smith\AppData\Roaming\Mozilla\Firefox\Profiles\tvs0coxp.default\webappsstore.sqlite C:\Users\R.Smith\AppData\Roaming\Raptr\data\raptrguestccn4w8e2\chat_history.db C:\Users\R.Smith\AppData\Roaming\Raptr\data\videometa.sqlite C:\Users\R.Smith\AppData\Roaming\RifinBSR\Sys_DBs\BSTracker.rdb C:\Users\R.Smith\AppData\Roaming\RifinBSR\Sys_DBs\RIFIN_BSReader_Backup_20150625_193641.dbBackup C:\Users\R.Smith\AppData\Roaming\RifinBSR\Sys_DBs\RIFIN_BSReader_Backup_20150625_193726.dbBackup C:\Users\R.Smith\AppData\Roaming\RifinBSR\Sys_DBs\RIFIN_BSReader_Backup_20150625_194256.dbBackup C:\Users\R.Smith\AppData\Roaming\RifinBSR\Sys_DBs\RIFIN_BSReader_Backup_20150625_194850.dbBackup C:\Users\R.Smith\AppData\Roaming\RifinBSR\Sys_DBs\RIFIN_BSReader_Backup_20150722_014803.dbBackup C:\Users\R.Smith\AppData\Roaming\RifinBSR\Sys_DBs\RIFIN_BSReader_Backup_20150722_035033.dbBackup C:\Users\R.Smith\AppData\Roaming\RifinBSR\Sys_DBs\Sys_Cache.rdb C:\Users\R.Smith\AppData\Roaming\RIFinDS\DBScriptCache.sqlitedb C:\Users\R.Smith\AppData\Roaming\Skype\homoerectus\bistats.db C:\Users\R.Smith\AppData\Roaming\Skype\homoerectus\dc.db C:\Users\R.Smith\AppData\Roaming\Skype\homoerectus\eascache.db C:\Users\R.Smith\AppData\Roaming\Skype\homoerectus\keyval.db C:\Users\R.Smith\AppData\Roaming\Skype\homoerectus\main.db C:\Users\R.Smith\AppData\Roaming\Skype\homoerectus\media_messaging\emo_cache\asyncdb\cache_db.db C:\Users\R.Smith\AppData\Roaming\Skype\homoerectus\media_messaging\media_cache\asyncdb\cache_db.db C:\Users\R.Smith\AppData\Roaming\Skype\homoerectus\media_messaging\storage_db\asyncdb\storage_db.db C:\Users\R.Smith\AppData\Roaming\Skype\homoerectus\msn.db C:\Users\R.Smith\AppData\Roaming\Skype\homoerectus\qikdb\qik_main.db C:\Users\R.Smith\AppData\Roaming\Skype\homoerectus\relays.db C:\Users\R.Smith\AppData\Roaming\Skype\homoerectus\statistics.db C:\Users\R.Smith\AppData\Roaming\Skype\shared_dynco\dc.db C:\Users\R.Smith\AppData\Roaming\Skype\shared_httpfe\queue.db C:\Users\R.Smith\AppData\Roaming\Thunderbird\Profiles\6muvaz7g.default\blist.sqlite C:\Users\R.Smith\AppData\Roaming\Thunderbird\Profiles\6muvaz7g.default\calendar-data\deleted.sqlite C:\Users\R.Smith\AppData\Roaming\Thunderbird\Profiles\6muvaz7g.default\calendar-data\local.sqlite C:\Users\R.Smith\AppData\Roaming\Thunderbird\Profiles\6muvaz7g.default\content-prefs.sqlite C:\Users\R.Smith\AppData\Roaming\Thunderbird\Profiles\6muvaz7g.default\cookies.sqlite C:\Users\R.Smith\AppData\Roaming\Thunderbird\Profiles\6muvaz7g.default\formhistory.sqlite C:\Users\R.Smith\AppData\Roaming\Thunderbird\Profiles\6muvaz7g.default\global-messages-db.sqlite C:\Users\R.Smith\AppData\Roaming\Thunderbird\Profiles\6muvaz7g.default\permissions.sqlite C:\Users\R.Smith\AppData\Roaming\Thunderbird\Profiles\6muvaz7g.default\places.sqlite C:\Users\R.Smith\AppData\Roaming\Thunderbird\Profiles\6muvaz7g.default\signons.sqlite C:\Users\R.Smith\AppData\Roaming\Thunderbird\Profiles\6muvaz7g.default\storage.sdb C:\Users\R.Smith\AppData\Roaming\Thunderbird\Profiles\6muvaz7g.default\webappsstore.sqlite C:\Users\R.Smith\AppData\Roaming\TS3Client\settings.db C:\Users\R.Smith\AppData\Roaming\TS3Client\urls.db C:\Users\R.Smith\AppData\Roaming\Unity\WebViewProfile\cookies.sqlite C:\Users\R.Smith\AppData\Roaming\Unity\WebViewProfile\permissions.sqlite C:\Users\R.Smith\AppData\Roaming\Unity\WebViewProfile\places.sqlite