Working with node dblite module on Windows

If you get an error with dblite module on Node JS on Windows, it could be caused by missing SQLite binaries in the system path. So make sure you download the sqlite binaries and add it to the system path so that it can be found by dblite when it is running on Node. Happy days!

I encountered this error while working on a clean install of Windows 10 on a brand new machine.

Converting a large text file into an sqlite database

Sometimes we need to deal with large text files that are more than some text editors can handle. I recently have to convert a large text file containing a list of words which contains more than 600,000 lines.  The file size was just under 100MB and to open it with a text editor was an exercise in frustration.  Continue reading “Converting a large text file into an sqlite database”