Repairing an SQLite Database

This post gives instructions on how to check for errors and make a clean copy of a corrupted SQLite3 database. Checking for errors in an SQLite3 database:1. Make a backup of all the sqlite3 databases. They are located in the storage folder for your data storage. For example x:\storagenode\storage\bandwidth.db, where x:\storagenode is the data folder … Read more

Front-End-Checklist Asana Template and CSV / Google Sheet

The Front-End-Checklist project is an “exhaustive list of all elements you need to have / to test before launching your website / HTML page to production.” It covers many important things in accessibility, performance, and SEO. You can get this checklist in CSV or JSON format below. FrontEndChecklist_Template.csv [import to Asana] Front-End-Checklist.json Google Sheet To … Read more

Open Broken Link Document NoSuchBucket

Why is this happening? Amazon is moving away from storing files at s3.amazonaws.com/bucketName/file to bucketName.s3.amazonaws.com/file How to get access to the document? Easy, Enter your URL here:   <error> <code>NoSuchBucket</code> <message>The specified bucket does not exist</message> <bucketname>oasdf</bucketname> <requestid>A4EA86FD5249D765</requestid> <hostid> i58y3EbUeVOUvpGRxSW6raoyn/lQ/WjSa3i3+OyQNcHOH+H/UJR62+FKylNxh84oWCPtNYENmRg= </hostid> </error>

pdftotext usage flags / commands

pdftotext pdftotext version 0.43.0 Copyright 2005-2016 The Poppler Developers – http://poppler.freedesktop.org Copyright 1996-2011 Glyph & Cog, LLC Usage: pdftotext [options] [] -f : first page to convert -l : last page to convert -r : resolution, in DPI (default is 72) -x : x-coordinate of the crop area top left corner -y : y-coordinate of … Read more

Apartment Scam Warning

If you see an apartment listing these images and possibly the video below, it is most certainly a scam. Many users have found this scammer across craigslist in different cities and states. They all seem to point to a similar pattern: I’m renting my expensive apartment for city X. I am a traveling nurse/aid-worker/whatever and … Read more

The Boring Company Tunnels: EVs Only

Gasoline and diesel vehicles produce a large sum of poisonous emissions from the tailpipe. Vehicles are confined in a small space as with the tunnels being built by Elon Musk’s “The Boring Company”, the amount of ventilation required to keep the air breathable would be a huge cost burden to the construction of small tunnels … Read more