Recently I build a PHP script for dynamically downloading files, and I came across the need to provide the right Mime-Type for each file I set to download. I wrote a function in PHP that gets file extension (with or without the dot prefix) and returns the correct Mime-Type.
If you are working with automatic process, interfaces or anything that works in the background (with a new process every time) you probably familiar with situations when something goes wrong (network failure, memory shortage etc) and our automatic process gets stuck.
Building 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 is checked regularly by professionals from the gas company when they come to replace the gas tanks, I still want […]
When 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 a huge Fixed-Width file to a Tab-delimited one in order to load it to my system, so I thought I’d share one quick way of doing so.
I’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 files or data files, it’s convenient to be able to filter out everything in one click.
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.
In this post, I wanted to share with you the list (as far as I know) of events.
Writing 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 written in various and sometimes completely different way. While improving and optimizing a query should first and foremost include making sure that everything is written correctly and there are no logical errors, I wanted to share a tool, that some of you might not know, which can help make queries more efficient in times where you’re just not sure how to improve it further.
As 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 number of ways to solve, and if needed, can be solved programmatically with SQL or C / C# / JAVA languages.
Now that I’m done with asking the prime number question (I need to change questions every now and then), I thought I will post the solution here.
Calculating 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 arrival to work, and I wanted to calculate time average time that I arrive by the office, and then calculate how much time I spend in traffic, depending on when I leave my home.