View RSS Feed

Products and Technology

  1. iPad - Keeping Your Eyes on the Road with Gestures.

    by , 06-14-2010 at 12:11 AM

    Embed this video



    Justin Riley shows off us, on his custom iPad mount, how you can easily control some basic iPad functions with lots of gestures. After you do the quick 2 minute jailbreak (you wanted to do it anyway) you can enable a plethora of gesture controls. Slide from bottom up, top down, from status bar, tap and hold, pinch and even shake. And you can actually assign these gestures to anything you want.

    So you basically end up with a 9.7 inch touch pad, which IMO is easy to use w/o looking at the screen at all. Drive Responsibly™.

    Updated 06-14-2010 at 12:21 AM by optikalefx

    Categories
    Products and Technology
  2. Custom iPad Mounts

    by , 06-03-2010 at 12:13 PM

    Embed this video



    Justin Riley has fabricated a really well finished bolt-in kit for the iPad. (wifi or 3g). This particular kit fits into the 2005-2007 Subaru Impreza/WRX and STi. (They all have the same dash).

    This bolt-in kit is a 1:1 replacement for the stock dash. Basically just pop out the old one, and put this in there. It has protection for the iPad, and when used with the Apple iPad Dock will charge and deliver audio. (via the 3.5mm cable)

    This kit for the Subaru series will be available on the mp3Car Store soon.
  3. AT&T Speech To Text For Developers

    by , 05-20-2010 at 03:52 PM

    Embed this video



    AT&T Has proven speech to text. Their goal is to allow developers to integrate this technology into their apps. This demo is done on a Blackberry but at the show she had an iPhone and an Android device running these same features. Once iPhone has multi tasking it will be able to run in the background.

    Now that a lot of states are instituting strict cell phone laws, this type of technology will really find a home with all kinds of developers.

    Check out Vlingo's blog If you want some serious detail on the matter.

    Updated 05-20-2010 at 04:00 PM by optikalefx

    Tags: cell, phone, att, text, speech Add / Edit Tags
    Categories
    Products and Technology
  4. SQL with SUM, group, order, left join, exclude and limit

    by , 05-13-2010 at 08:00 AM
    So I came across a scenario where I need to know the top developers of applications based on how many times their software has been downloaded.

    There are 3 tables involved here.
    The developers table
    the orders_software table
    the orders_software_downloads table

    The whole goal is get this information with 1 Sql query.The basic relationships are as follows:
    there are many developers in the developer table
    there are many softwares to 1 order in the orders_software table
    there are many downloads to 1 software to 1 order in the orders_software_downloads table.

    So we select the developer name from the developer table, and the download count from the orders_software_downloads table. Left join to get all the tables together. Exclude counts that are null. Then group the results by the owner of each software. Which is a row of the software table.

    This will be a great case to use SUM

    we can modify the download count to sum(download_count) and as long as we have that group by, it will sum up the group.



    So sql will look like this:

    SELECT developer.name, SUM(orders_software_download.download_count) as sum
    FROM software
    LEFT JOIN orders_software on software.id = orders_software.software_id
    LEFT JOIN orders_products_download on orders_products.orders_software_id = orders_products_download.id
    WHERE orders_software_download.download_count IS NOT NULLGROUP BY software.software_owner
    ORDER BY sum DESC
    LIMIT 11

    And then from this the result will give you an array of the top developers where you can know who the developer is an how many times in total their software was downloaded

    Updated 05-13-2010 at 10:01 AM by optikalefx

    Categories
    Products and Technology
  5. Software Review - Destinator 9 for iPhone

    by , 05-03-2010 at 09:06 AM

    What is it?

    Destinator 9 is Intrinsync's entry into the rather crowded iPhone GPS space. The app comes with real-time traffic, integrated maps, POIs, Weather, and Google search integrated.

    The Verdict:

    Destinator has made it's way onto the first page of my iPhone. The feature rich GPS app has replaced the multiple GPS apps if for no other reason than the superior graphical interface. Having tested the TomTom, Navigon, and Waze, Destinator seems to have the most updated maps, most features and the ability to route to contacts or google results is a huge plus. The ability to download a trial before purchase will explain why to spend the extra money on this app versus the others. The app is very large(updates are normally 1.6 GB+) and must be downloaded over wifi and tends to be slow to open. Once running it does not drain the battery horribly like the TomTom and if you close it the destination is retained so youc an conserve some battery on long drives.
    Navigator 9 is available now at ITunes StoreScreenshots

    Description

    Destinator 9 uses voice guided turn-by-turn directions with Navteq Maps with a graphical display in either 2D or 3D. Traffic conditions, points-of-interest information, and weather information are included when available. Multi-Stop trips can be imported or destinations can be set by tapping on a location on a map, selecting addresses from contacts, or using the traditional address import methods. To augment the address imports you can select by town, street, intersection, or Latitude/Longitude. The app is available as a free trial download with a splash screen that can be toggled off to try the app initially. Once you purchase the app, you get additional features including speed limit notification and warnings. Upon starting the app, you are able to control your ipod collection from within the program. You can also check the real-time traffic and weather from the bottom menu. During navigation the display will change throughout your trip to show the overhead signs on the highway, as well as lane directions to guide you both visually and vocally. You can view the directions either vertically or horizontally and the display changes automatically with orientation of the iphone. The app start up is very slow as I think it loads all the maps, however once it starts the gps finds your location very quickly. Much better than on the competing apps. The maps have been up to date and the app seems to be getting updated about once every couple weeks. The app is also available for Windows Mobile and Android

    The Positive:
    • Graphical Interface is easy to use
    • 3D view shows upcoming street signs
    • Background shows current weather
    • Google Search integration
    • Real-Time Traffic
    • Maintains Destination
    • Up-to-Date Maps
    • Ipod Controls Integrated
    • Speed Limit Warnings

    The Negative:
    • Slow to open
    • Very Large Download
    • Does not have the standard "Take me Home" option
    • $69.99 Price

    Updated 05-03-2010 at 09:12 AM by Heather

    Categories
    Products and Technology , Product Reviews