Wednesday, December 27, 2017

Got SQLite?

Screen Shot: Using Sphinx

Does you office pass around .db files as a convenient way to share data? Of course many file extensions are overloaded, so yes, to be clear, I'm talking about SQLite files, which require only the sqlite client, or many programming languages, to reveal their contents or accept new data.

In my courseware for IT workers, I tend to emphasize the efficacy with which SQLite might be used, as a simple way of keeping data organized. 

A database much more difficult to either tamper with or change inadvertently than a database, plus the format preserves the structure of a relational database, meaning the query engine is at your fingertips, if you just remember enough of the language (SQL).