GeekThis

Providing Programming, Development, and Linux Tutorials

USB Sniffing and Programming
  • Posted on April 5, 2018

USB Sniffing and Programming

This post is going to cover how to take a USB device and write software that can interact with the device without having publicly available documentation. I came about writing this post when I found an old AverMedia RECental USB button in a box of electronics. I wanted to repurpose the button and this is the result of that process. The device used while writing this tutorial was a very simple in that it only sent two different interrupts (pressed / released) along with a method to create LED animations.
  • Posted on March 22, 2018

Monitor Website Status with Twitter

After spending many hours working on your website, you want to ensure that it stays up and running. There are many tools available to monitor the status of your website and infrastructure such as system logs for identifying bugs and monitoring how much traffic is being received. Then there are third party services like StatusCake and Uptime Robot that ping your servers frequently and attempt HTTP requests and compare the result to predefined rules.
  • Posted on March 8, 2018

Website Admin Panel on Private Network

Running your website’s administration panel on a private network can help increase security along with increase your website’s performance if you perform demanding administrative tasks. This post will cover the idea of running a website admin panel on a private network instead of making it public while still having full control over the public site’s data. I haven’t yet done this in a production environment, but the site I’m currently working on will most likely implement a method similar to the one below.
  • Posted on February 22, 2018

Improving Website Pagination Speed with MySQL

Nearly every website implements some sort of pagination of data. Pagination is the process of splitting large sets of information into multiple pages (i.e. search results, emails, etc). In most cases for pagination to work, the total number of items for the dataset must be calculated to know total number of pages. This is commonly done by performing two SQL queries, one to receive the data for the current page and another to count the total number of rows to later calculate the total number of pages.
  • Posted on February 8, 2018

Google Drive Create Envelope Template

Creating an envelope is most office suites only requires you to dive one or two levels into a menu. As for Google Drive, this just isn’t the case. It’s possible to change a Google Drive document’s page setup by navigating to “File - Page Setup”, but there are only eleven predefined paper formats you can choose from. To change the actual dimensions of the Google Drive document, you need to use a Google Apps Script that changes the documents dimensions.