One other thing to add...in creating the demo I wanted to use the Shakespeare JSON data set that someone had shared at some point on here (they had shared the l

One other thing to add...in creating the demo I wanted to use the Shakespeare JSON data set that someone had shared at some point on here (they had shared the link). I ended up having a bit of difficulty using it at first because it had some extra tab characters throughout the file and PHP's json_decode() function didn't quite tell me exactly where the problem was. Other tools didn't seem to be useful either (online validators are only for small files typically and don't allow file uploads) and even Notepad++'s JSON related plugins didn't seem very helpful. I finally ended up using the JSON Streaming package available for PHP which allowed me to run through the file and identify some of the offending lines. Then I noticed a pattern of the tab character not being escaped in the line strings and just did a mass replace/removal of the tab characters in the file which then allowed me to create the sqlite shakespeare.db file included in the repository. This by itself might be useful for others to use as well in their own projects :-).