View RSS Feed

optikalefx

AT&T Speech To Text For Developers

Rate this Entry
by , 05-20-2010 at 03:52 PM (1810 Views)

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.

Submit "AT&T Speech To Text For Developers" to Digg Submit "AT&T Speech To Text For Developers" to del.icio.us Submit "AT&T Speech To Text For Developers" to StumbleUpon Submit "AT&T Speech To Text For Developers" to Google

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

Tags: cell, phone, att, text, speech Add / Edit Tags
Categories
Products and Technology

Comments

Leave Comment Leave Comment
View Thread

Last 3 Posts

IF one 1 order was 1 download yes that would work. But that is not the case. The same person can download software more than once without having to go through the whole buying process again, even if its free.

I have a different query for unique downloads, but this will count all the total downloads of all software for each developer, then sort that by which developer has the most downloads. Yes you could pad your own stats, but maybe ill put some time constraint on clicking it a million times. But there will be cases when you need to download the software more than once, and we need to track that as another download.
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
OK, I don't know how I managed to do that, but my reply appears to be above your original post... ?