View RSS Feed

All Blog Entries

  1. Lilliput EBY701 Double Din Kits Now On Sale

    by , 05-26-2010 at 01:02 PM

    These double din kits bolt directly to many aftermarket bezels made by Scosche, Metra, and others for a seamless integration into your vehicle.

    • High Resolution Display up to 1024 x 768
    • New Model 2009 is 500:1 contrast ratio and LED back light
    • Improved anti-glare touch panel
    • VGA input & 2 Video inputs

  2. 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
  3. Hardware Review: XoByte miniSpark Startup/Shutdown Controller

    by , 05-17-2010 at 09:11 AM


    What is it?


    The XoByte miniSpark is a startup and shutdown controller that uses Wake-On-LAN capabilities to handle startup and shutdown of your laptop or PC.

    The Verdict: If you use a laptop or netbook as your car PC you should own a miniSpark. The people at XoByte have seemingly created the perfect solution to handling the startup and shutdown of a computer and it's associated accessories in the car. The one thing that impresses me the most is the control it gives the user, all while using only your LAN port and saving a precious USB port.



    What's in the box?

    The XoByte miniSpark comes with the main controller box, a 6-wire connector, and a pair of automotive fuse adapters for 12v power.


    Description:

    The XoByte miniSpark is a powerful device which allows control of a netbook,laptop, or personal computer's startup and shutdown capabilities through Wake-On-LAN technology. The real power in the miniSpark comes from the user's ability to control its various functions all from within the miniSpark Configuration GUI. This tool is compatible with Windows computers running XP or higher, and allows even beginner users to control the miniSpark's functions with both ease and simplicity.


    After a brief period in which the miniSpark checks to see if the device is connected, the GUI is presented. The top left box in the GUI is nothing more than a set of status indicators which give you the real-time view of each of the 2 inputs and 2 outputs of the miniSpark. If a WOL shutdown event occurs the miniSpark GUI will display the system status on the LED images and also via a pop-up which counts the time remaining to shutdown.


    The bottom left gives users the ability to use either of the 2 inputs to run the appropriate user-configurable shutdown command with the shutdown and startup delays specified. As if the basic settings weren't powerful enough, XoByte allows configuration of both outputs independently. This allows one miniSpark unit to individually shutdown and power up 2 different devices with there own unique settings. For advanced users this capability is invaluable because you can control things like USB hubs, lighting, and other self-powered devices independently of the PC. Each output can be controlled with either included inputs or totally manually through the miniSpark configuration utility. The outputs can also be delayed at startup or shutdown after the PC has been started or shutdown. The ability to set your pulse-width for outputs and to set repeating triggers means the XoByte miniSpark is as flexible as you will ever find a shutdown controller to be. There is even an API available which allows the control of the miniSpark configuration utility to be harnessed in a user-selected front end.


    Despite the flexibility of its software setup, the miniSpark is just as easy to install as any other automotive power supply. Because its not a fully-functional power supply, the miniSpark's red power wire can be powered through an 1-amp automotive fuse. XoByte was even kind enough to include a set of automotive fuse adapters so you can just plug into your vehicles fuse box to power the device. The black wire as in most cases is the ground. The white and green wires are input #1 and #2 respectively, and would in most cases be connected to the automobiles accessory or ignition lines. Should you only wish to use a single input the green wire can be ignored. Lastly, the brown and blue wires are #1 and #2 output wires. PCs that are not "magic frame" WOL capable will need to use one of the outputs to power on the PC through the ACPI lines.

    Once wired, the XoByte miniSpark hardware is ready to go. The only other notable feature would be the single green LED which shows the status of the miniSpark through a series of blinks.


    The Positive:

    • Small hideaway box, but so much power and control capabilities
    • Allows startup/shutdown control without opening up a laptop
    • Uses WOL technology, saving a USB port• Efficiently runs on less than 1 amp
    • A simple GUI which continues to be updated with more control features
    • Ability to control multiple accessory outputs with multiple individually controlled inputs
    • API available for front end integration

    The Negative:

    • Windows XP+ only
    • Computer must be WOL "Magic Frame" capatible for WOL use

    The Verdict:

    If you use a laptop or netbook as your car PC you should own a miniSpark. The people at XoByte have seemingly created the perfect solution to handling the startup and shutdown of a computer and its associated accessories in the car. The one thing that impresses me the most is the control it gives the user, all while using only your LAN port and saving a precious USB port.

    Updated 05-17-2010 at 11:24 AM by Sonicxtacy02

    Categories
    Product Reviews
  4. Fear of the Car Computer

    by , 05-14-2010 at 11:29 AM
    If you haven't noticed, in the last few days it seems that fear of hacking the car's computer is all the rage. Here are a few of the articles published.

    NYTime's Carsí Computer Systems Called at Risk to Hackers

    Popular Science's Proof-of-Concept CarShark Software Hacks Car Computers, Shutting Down Brakes, Engines, and More

    And today, Engadget's Hackers can remotely disable your car's brakes, create sensationalist headlines

    Updated 05-14-2010 at 11:35 AM by Heather

    Categories
    mp3Car News
  5. 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