Data analysis
19 Apr 2020
A SQLite database is perfect for projects where you want a small portable file. I find it has three big advantages over other database, which using it in this regard. First, it comes with the Python distribution so you don’t need to install or configure any addtional software. Second, the entire databae is stored in a single file making cloud storage super easy. And third, there is a light weight GUI plugin for Firefox called...
Miscellaneous
21 Feb 2020
If you’ve forgotten your password for WSL don’t worry, it can be easily reset by following the seven steps below. Open Bash on Ubuntu to take note of your Linux username (note that this may or may not match your Windows username) Close Bash on Ubuntu (if you leave it running the next command will fail) Open a Windows command prompt as Admin (Windows Key + X, A) Enter ubuntu config --default-user root to set...
Data analysis
17 Feb 2020
I’ve been using VBA for a while now and I usually lock the VBA project or use Unviewable+ when I need to deter others from viewing or messing with the code. However, I found that pressing ALT+F8 brings up a list of all available procedures. Which makes me wonder, what if someone else who knows about this trys to run a procedure they’re not supposed to? I could easily see how that might cause some...