Home automation, code, and everyday tech.
If you are working with automatic process, interfaces or anything that works in the background (with a new process every time) you are probably familiar with situations when something goes wrong (network failure, memory shortage…
Read article: Kill stuck process and tasks automatically – Advanced Task KillerBuilding a smart gas sensor for your home is an easy and fun project, which can also help to prevent serious damage. The gas plumbing in my house is rather old, and even though it…
Read article: Make your own smart gas sensor with MQ2 and ESP8266 WiFi ArduinoWhen working with different information systems sometimes you need to convert data files from one format to another. Not all systems can generate or export data in common or standard ways. Lately, I had to convert…
Read article: Convert Fixed-Width (Flat File) to Tab delimited or CSVI’ve developed a Notepad++ plugin that adds the option to keep only regex patterns in a text file. When working with large text files and wanting to extract specific data from them, such as log…
Read article: Keep Regex only matches in Notepad++ (Npp plugin)Using WiFi events on Arduino can be very useful, as I previously wrote in the article Best Practices on Connecting ESP8266 to WiFi Network. It helps in managing the wifi connection in the sketch’s code.…
Read article: ESP8266 WiFi events list with ArduinoWriting SQL queries can be considered by some as a form of art: everyone has a different style of writing and improving them (I’m talking about complex queries). Queries can achieve the same goal while being…
Read article: Make optimization to SQL query with SQL Server Management StudioAs part of my daytime job, I conduct professional interviews for candidates. For that, I’m always on the search for good interview questions. I regard a good question if it’s not too complicated, has a…
Read article: Interview Question: Select only Prime numbers from tableCalculating average time from DateTime field in MySql might come in handy in cases like getting the average arrival time, departure time, service sampling etc. In my case, I have a database with records on my…
Read article: Calculate average time from DateTime MySqlFirst of all, what is “Cookie Hijacking”? By Wikipedia, it’s an “exploitation of a valid computer session to gain unauthorized access to information or services in a computer system. In particular, it is used to…
Read article: Prevent cookie hijacking (session hacking)Sometimes it is necessary to delete files that are older than 1 day, a week, or even a year. We just don’t need them anymore, maybe they are irrelevant, take up a lot of space on our…
Read article: Delete files older than x days automatically
