I have needed to extract information from a MySQL database on a regular basis and present the information in the form of 'business hours'. One of the biggest issues I have had is that whilst the business days and hours are static and can be filtered (see my article: MySQL limiting selection to business hours) The public holidays themselves change and as such I can't simply remove a specific day. In order to get around this, the easiest way I found was to create another table in MySQL to store the public holidays. In my schema, my table contained holidayID, HolidayName, HolidayState and HolidayDate. This allowed me

  I use MySql on a semi-regular basis to analyse data to determine trends and basic statistical information (e.g. min / max / avg) however, one of the issues is often I only care about the information when it occurs within business hours (which in my case is defined as Monday - Friday between 9am and 5pm. Whilst I was aware of WHERE x = y fields, e.g. where sensor = a which lets you only show values in the table where the field sensor = a, I must admit I was not aware of the weekday, hour and between operators. As a result i thought it would

The MIOPS 'Mobile Remote' (MMR) is the second smart trigger and the second sucessful crowdsourced campaign from MIOPS, with the first being their sucessful 'Smart' trigger (ST). The MMR is designed to connect to your supported DSLR or mirrorless camera, and your compatiable mobile device to function as a wireless trigger, or offer more advanced functionality which can include; Cable release Intervelometer Timelapse triggering (inc. bulb ramping) HDR Sound triggering Motion triggering Vibration triggering Combination of the above (scenario) The MMR differs from the ST in that it is smaller, does not have a screen and offloads all of the configuration and some of the functionality

Have a look at my review of the MIOPS smart trigger, a camera trigger that connects to your compatible camera and mobile device (Android / iOS) to allow more advanced functionality. Apologies for the poor quality of the video, stay tuned through as I will have more (and better quality) videos showing how some of the modes of the camera work. MIOPS website: http://bit.ly/2m5ABGd Visit our Website: http://bit.ly/2ujWacd Sign up for our Newsletter: http://bit.ly/2w8Cllj Disclosure: This device was provided to me at no cost by MIOPS for the purpose of this review. The video can also be viewed at: https://youtu.be/iqpva-fbXjo

Technology is moving at a rapid pace, with our handheld devices (e.g. mobile phones) becoming more and more capable. It was not that long ago that predictions were made that 512K was all the memory anyone would ever need in their life, now it is not uncommon to find machines with 1TB hard drives and greater. Sadly beyond the technical innovation that is being made with digital camera(s), I don't see them being more capiable. Each year we have the roundup of improved DSLR devices. Typically this includes numerous technical features (improved megapixel count, better resolution, better dynamic range) but rarely does it include improvements to