Calculating distance using MySQL
One of the cool things about MySQL 5.7 is the fact that it supports a few spatial convenience functions (since 5.7.6), allowing one to do operations on geometric values. One of those convenience [...]
Calculating distance between two points on the Earth
Because of the near-spherical shape of the Earth (technically an oblate spheroid) , calculating an accurate distance between two points requires the use of spherical geometry and trigonometric [...]
How to check if an email address exists without sending an email?
We have all been doing email address validation for a very long time to make sure that the email is correctly formatted. This is to avoid users entering wrongly formatted email address but still [...]
Regex – How to match everything except a particular pattern?
Match everything except for specified strings You could use a look-ahead assertion: (?!999)\d{3} This example matches three digits other than 999. But if you happen not to have a regular [...]
Test Emails Locally with MailCatcher
One of the more difficult things to test when you’re developing a website on your local setup is emails. Whether it’s order confirmation emails for an ecommerce site or an email [...]
About /robots.txt
In a nutshell Web site owners use the /robots.txt file to give instructions about their site to web robots; this is called The Robots Exclusion Protocol. It works likes this: a robot wants to [...]
How to empty your DNS cache on Windows, Mac and Linux?
Each time you type the name of a site, your computer’s operating system retrieves the corresponding IP address from your Internet Service Provider. In order to speed up the connection to [...]
List of MIME Types by Content Type
Here is an extensive list of MIME types broken up by the content they define. MIME (Multipurpose Internet Mail Extensions) is an internet standard that is used to identify the types of content [...]