Account Options

  1. Sign in
The old Google Groups will be going away soon.
Switch to the new Google Groups.
Google Groups Home
« Groups Home
Sharing Data
There are currently too many topics in this group that display first. To make this topic appear first, remove this option from another topic.
There was an error processing your request. Please try again.
flag
  Messages 1 - 25 of 38 - Collapse all  -  Translate all to Translated (View all originals)   Newer >
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 
From:
To:
Cc:
Followup To:
Add Cc | Add Followup-to | Edit Subject
Subject:
Validation:
For verification purposes please type the characters you see in the picture below or the numbers you hear by clicking the accessibility icon. Listen and type the numbers you hear
 
Brad  
View profile  
 More options Nov 6 2010, 4:45 pm
From: Brad <rbg...@gmail.com>
Date: Sat, 6 Nov 2010 13:45:17 -0700 (PDT)
Local: Sat, Nov 6 2010 4:45 pm
Subject: Sharing Data
I'm working on a new website which aims to give all Android developers
much more information about what's happening with the market and some
tools to see how their apps are doing in relation to other apps. As
part of the services, we are going to supply a downloadable .csv file
containing all apps on the market, their market ratings, the index of
where they are in the "Popular" order (if they show up at all), and
two other rating systems we have developed (which are considerably
better than the market ratings), and another file containing a list of
all developers. The files will be available to anyone who wants to
download them.

While programming this it has occurred to me many times that a lot of
the work I'm doing is being duplicated in whole or in part by most of
the people on this list, and if we cooperated a little we could save
each other a ton of work and/or bandwidth. For instance, the file I
will share that contains the app information will contain the package
name of the app, so any dev that is working with this API could use it
to download the complete app information much more efficiently than
trying to get it by the different techniques we are all using to try
to get complete lists from the market. And the file with dev info
could be used to pull all the dev's apps fairly efficiently.

SO... my thought was that if I supplied these files to everyone it
would make all our lives easier... but to do it I need to be sure my
own data is very up to date. I'm wondering if some other devs on this
list who have fairly complete data would be willing to share it with
me, so I can share it with everyone. If just a few of us cooperated we
could save everyone a lot of time and effort.

Anyone willing to help out?

OH... the first test file I created for the apps is available here :

http://nocrappyapps.com/media/app_ratings/androidappratings-2010-11-0...

It's not complete, and the fields (in order) are:
My id #
package name
market rating
No Crappy Apps Rating
User Rating

Hope to hear from a bunch of you !

Thanks

Brad.


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Ian  
View profile  
 More options Nov 7 2010, 1:37 pm
From: Ian <ian.shaun.tho...@gmail.com>
Date: Sun, 7 Nov 2010 10:37:47 -0800 (PST)
Local: Sun, Nov 7 2010 1:37 pm
Subject: Re: Sharing Data
Ive been thinking of something like this too.. It would be great if
one of the major sites made an API to interface its information.

On Nov 6, 3:45 pm, Brad <rbg...@gmail.com> wrote:


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Johnny Lee  
View profile  
 More options Nov 8 2010, 5:03 am
From: Johnny Lee <johnnylee...@gmail.com>
Date: Mon, 8 Nov 2010 18:03:25 +0800
Local: Mon, Nov 8 2010 5:03 am
Subject: Re: [android-market-api] Re: Sharing Data
+1

Regards,
Johnny


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Brad  
View profile  
 More options Nov 8 2010, 3:13 pm
From: Brad <rbg...@gmail.com>
Date: Mon, 8 Nov 2010 12:13:11 -0800 (PST)
Local: Mon, Nov 8 2010 3:13 pm
Subject: Re: Sharing Data
What kind of information are you looking for?

On Nov 7, 10:37 am, Ian <ian.shaun.tho...@gmail.com> wrote:


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Brad  
View profile  
 More options Nov 8 2010, 4:11 pm
From: Brad <rbg...@gmail.com>
Date: Mon, 8 Nov 2010 13:11:52 -0800 (PST)
Local: Mon, Nov 8 2010 4:11 pm
Subject: Re: Sharing Data
I should have added that I have already decided to share the
information, and if people let me know what they want, I can easily
add more fields, but I think most people will still need to use the
API to pull some information... I'm just hoping to supply the
information people need to get fairly complete data without having to
poll for every possible combination of Locale,  category, view type,
SDK version, operator, app Type, and order type. I've been doing it,
and I'm now to the point of running 1,000 queries for every one that
returns new or updated information. It's an incredible waste of
resources and bandwidth.

For now, I'll put out one file of app package names (with current
version id) because it's the only unique identifier for an app, and by
having the current version, anyone could determine if they need to
update their information for that app. The other file will be
developer id's, and it's only real purpose is to make sure the list is
complete... If I have all the dev Id's I should have all the apps. So,
my hope is that other dev's will supply me with any package names, and
dev id's, I'm missing. Then I can pull them and make them available to
anyone who wants them.

I'm hoping that a few of you will be willing to write something to
compare my list's against yours and send me a list of anything I'm
missing. If it gets to the point where I am fairly confident that I've
got everything, then I would consider making a file available
including all the app info, including the extended info... but if I do
that, the file would be big enough to cause some problems if people
downloaded it constantly, so I'd have to only allow access to it from
a web service or web page and limit the number of downloads per
developer to one a day or so.

If you want to help, send me a .csv file of dev id's and package names
(separate files) and I'll whip up a program to read and compare
them... It won't matter if you send duplicates. It just needs to be a
single field per row with either the dev id or package name.

On Nov 7, 10:37 am, Ian <ian.shaun.tho...@gmail.com> wrote:


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
dernasherbrezon  
View profile  
 More options Nov 11 2010, 1:35 pm
From: dernasherbrezon <dernasherbre...@gmail.com>
Date: Thu, 11 Nov 2010 10:35:14 -0800 (PST)
Local: Thurs, Nov 11 2010 1:35 pm
Subject: Re: Sharing Data
Hi Brad,

I've made android market crawler and now have ~22k applications. You
could search applications by package name using API. Access is open
for everyone and free. You could find docs here:
http://checkware.ru/warenet.html

Hope that might help

On Nov 7, 12:45 am, Brad <rbg...@gmail.com> wrote:


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Peter Vukadinov  
View profile  
 More options Nov 11 2010, 1:53 pm
From: Peter Vukadinov <p.vukadi...@gmail.com>
Date: Thu, 11 Nov 2010 20:53:44 +0200
Local: Thurs, Nov 11 2010 1:53 pm
Subject: Re: [android-market-api] Re: Sharing Data

Hi dernasherbrezon,

is your database updated frequently ?

I make a fast check for same application returned from this site and
information fetched from android market and seems taht your info is not up
to date.

Cheers

On 11 November 2010 20:35, dernasherbrezon <dernasherbre...@gmail.com>wrote:


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
dernasherbrezon  
View profile  
 More options Nov 11 2010, 2:00 pm
From: dernasherbrezon <dernasherbre...@gmail.com>
Date: Thu, 11 Nov 2010 11:00:20 -0800 (PST)
Local: Thurs, Nov 11 2010 2:00 pm
Subject: Re: Sharing Data
Hi Peter,

Not yet. I get 503 exception while using the same loginid for quering
by category/price/etc, so now I'm working on improving algorithm.
Silly, that we are all doing the same things.

On Nov 11, 9:53 pm, Peter Vukadinov <p.vukadi...@gmail.com> wrote:


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Brad  
View profile  
 More options Nov 11 2010, 8:17 pm
From: Brad <rbg...@gmail.com>
Date: Thu, 11 Nov 2010 17:17:32 -0800 (PST)
Local: Thurs, Nov 11 2010 8:17 pm
Subject: Re: Sharing Data
Ok... I'll have a look at it and see if you have any I don't.
Thanks...

You might want to try my file also... I've got 64,000+ apps in it
right now, and I'm generating the file nightly (about 20 minutes after
midnight UTC time). I mention the format for pulling the latest file
in one of the messages above. As of tonight it only contains the
fields I mention above, but tonight I am going to change it to put the
current version number in it, and also the developer id. It will make
it much more useful for anyone else. I'll post back here after I've
made the change, and give the field list and let you know the file
name. I'm going to see if I can just write the same file name every
time, so that whenever you pull it, it will be the last one generated.

Oh.. on a related note.. Does anyone know what the total apps in the
market right now.... I've been working on the assumption that there
over 70,000 apps, but now I hear the actual number today could be over
100,000.

What's the highest number anyone has?

On Nov 11, 10:35 am, dernasherbrezon <dernasherbre...@gmail.com>
wrote:


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Marc Lester Tan  
View profile  
 More options Nov 11 2010, 8:42 pm
From: Marc Lester Tan <mail...@gmail.com>
Date: Fri, 12 Nov 2010 09:42:29 +0800
Local: Thurs, Nov 11 2010 8:42 pm
Subject: Re: [android-market-api] Re: Sharing Data

Hi guys,

I checked just now and i have 112,494 distinct package names in my database
(http://www.appcellar.com). If somebody is compiling the list now I can give
the data. I'm fetching all applications per version/locale/author once a
day.

Marc

twitter: mharkus
blog: http://blogs.marctan.com

http://www.appcellar.com | http://www.appalert.co


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Brad Gies  
View profile  
 More options Nov 11 2010, 8:47 pm
From: Brad Gies <rbg...@gmail.com>
Date: Thu, 11 Nov 2010 17:47:12 -0800
Local: Thurs, Nov 11 2010 8:47 pm
Subject: Re: [android-market-api] Re: Sharing Data

Yeah... if you can send the package name to me.. or make them available
somewhere, I'll add the information, and it should be in my file
whenever it is recreated.

Thanks... I'd really appreciate it.

Sincerely,

Brad Gies
-----------------------------------------------------------------------
Bistro Bot - Bistro Blurb
http://bgies.com            http://nocrappyapps.com
http://bistroblurb.com      http://forcethetruth.com
http://ihottonight.com
-----------------------------------------------------------------------
Everything in moderation, including abstinence (paraphrased)

Every person is born with a brain... Those who use it well are the successful happy ones - Brad Gies

Adversity can make or break you... It's your choice... Choose wisely - Brad Gies

Never doubt that a small group of thoughtful, committed people can
change the world. Indeed. It is the only thing that ever has - Margaret Mead

On 11/11/2010 5:42 PM, Marc Lester Tan wrote:


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Marc Lester Tan  
View profile  
 More options Nov 11 2010, 11:01 pm
From: Marc Lester Tan <mail...@gmail.com>
Date: Fri, 12 Nov 2010 12:01:57 +0800
Local: Thurs, Nov 11 2010 11:01 pm
Subject: Re: [android-market-api] Re: Sharing Data

Here it is: http://static.appcellar.com/appmarketlist.csv.gz Enjoy!

Marc

twitter: mharkus
blog: http://blogs.marctan.com

http://www.appcellar.com | http://www.appalert.co


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Brad Gies  
View profile  
 More options Nov 12 2010, 12:01 am
From: Brad Gies <rbg...@gmail.com>
Date: Thu, 11 Nov 2010 21:01:58 -0800
Local: Fri, Nov 12 2010 12:01 am
Subject: Re: [android-market-api] Re: Sharing Data
Hah... that'll give me something to do tonight :). But seriously...
thanks... it's much appreciated.

By the way, Marc, I've been on your site a couple of times and it's
really well done..

I'll make it available on my site for anyone else that wants it.
Probably won't be finished tonight, because the way I'm creating the
file right now requires me to pull the info from the market before it
goes into the table I'm pulling the data from, but in the next day or
two it should be done.

Really, really much appreciated and I'll try to figure out how to give
you credit when someone pulls the file from my site.

Sincerely,

Brad Gies
-----------------------------------------------------------------------
Bistro Bot - Bistro Blurb
http://bgies.com            http://nocrappyapps.com
http://bistroblurb.com      http://forcethetruth.com
http://ihottonight.com
-----------------------------------------------------------------------
Everything in moderation, including abstinence (paraphrased)

Every person is born with a brain... Those who use it well are the successful happy ones - Brad Gies

Adversity can make or break you... It's your choice... Choose wisely - Brad Gies

Never doubt that a small group of thoughtful, committed people can
change the world. Indeed. It is the only thing that ever has - Margaret Mead

On 11/11/2010 8:01 PM, Marc Lester Tan wrote:

...

read more »


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Marc Lester Tan  
View profile  
 More options Nov 12 2010, 12:15 am
From: Marc Lester Tan <mail...@gmail.com>
Date: Fri, 12 Nov 2010 13:15:47 +0800
Local: Fri, Nov 12 2010 12:15 am
Subject: Re: [android-market-api] Re: Sharing Data

Thanks Brad! No problem. Just giving back to the community :D, I will write
a script to dump the data there at least once every week.

Marc

...

read more »


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Brad Gies  
View profile  
 More options Nov 12 2010, 7:02 pm
From: Brad Gies <rbg...@gmail.com>
Date: Fri, 12 Nov 2010 16:02:03 -0800
Local: Fri, Nov 12 2010 7:02 pm
Subject: Re: [android-market-api] Re: Sharing Data
Marc,

That would be fantastic.. Thanks very much...  I think I will add some
of the fields you sent to my file also... because I noticed while
looking through your data and comparing it to mine that in some cases
you had a higher number for "Market Rating Count" than I did, and
sometimes I has a higher number than you did. It's obviously just a
matter of who updated the number last... but I found it helpful for me
because if your number was higher I used that to schedule that app for
an update. If you're interested in using my file to do the same for you,
I should have most of the data pulled from the market by the end of the
weekend, and I'll change the format at that time.

For anyone else that want to use your file.. I'll save them some time...
if they use MySQL

I just created a new file in my MySQL called appmarketlist (to match the
name of Marc's file), and using your fields (NO ID FIELD), then I used
this command to import it :
mysqlimport -u root --fields-enclosed-by \" --fields-terminated-by ,
DBNAME PATH_TO_FILE\appmarketlist.csv

Obviously, change the db name and path to what you need.. and WOW... is
that import ever fast!!! It imported all 112,000 rows in about a second.
Hah.. but it did take almost an hour to get the syntax right :). After
it was done I added the id field and it was ready to use.

Sincerely,

Brad Gies
-----------------------------------------------------------------------
Bistro Bot - Bistro Blurb
http://bgies.com            http://nocrappyapps.com
http://bistroblurb.com      http://forcethetruth.com
http://ihottonight.com
-----------------------------------------------------------------------
Everything in moderation, including abstinence (paraphrased)

Every person is born with a brain... Those who use it well are the successful happy ones - Brad Gies

Adversity can make or break you... It's your choice... Choose wisely - Brad Gies

Never doubt that a small group of thoughtful, committed people can
change the world. Indeed. It is the only thing that ever has - Margaret Mead


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
chrissky  
View profile  
 More options Nov 15 2010, 12:54 am
From: chrissky <back5...@gmail.com>
Date: Sun, 14 Nov 2010 21:54:47 -0800 (PST)
Local: Mon, Nov 15 2010 12:54 am
Subject: Re: Sharing Data
Brad,
A tremendous contribution. One additional field request - price!

 - Chris


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
styler  
View profile  
 More options Nov 15 2010, 5:43 pm
From: styler <styler1...@gmail.com>
Date: Mon, 15 Nov 2010 14:43:06 -0800 (PST)
Local: Mon, Nov 15 2010 5:43 pm
Subject: Re: Sharing Data
Youre updating 112k apps every night? How do you get around the 503's?
What is the interval in which you are querying?

On Nov 11, 7:42 pm, Marc Lester Tan <mail...@gmail.com> wrote:


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Marc Lester Tan  
View profile  
 More options Nov 15 2010, 8:36 pm
From: Marc Lester Tan <mail...@gmail.com>
Date: Tue, 16 Nov 2010 09:36:08 +0800
Local: Mon, Nov 15 2010 8:36 pm
Subject: Re: [android-market-api] Re: Sharing Data

Yup, although I think some of them are failing already. Haven't checked for
a few months. 503's can be prevented by using several gmail accounts. I
bought a domain from google then bulk upload the list of users. Some
accounts will return 503's eventually but then you just have to refresh them
by creating another set of users then bulk upload. I'm aware that my catalog
doesn't have the 2.2 apps.

Marc


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
styler  
View profile  
 More options Nov 15 2010, 9:47 pm
From: styler <styler1...@gmail.com>
Date: Mon, 15 Nov 2010 18:47:13 -0800 (PST)
Local: Mon, Nov 15 2010 9:47 pm
Subject: Re: Sharing Data
See I have acquired ~30 domains with the android keyword and I'm
currently piecing together a site in php. However I'd like to just be
able to have it run with as little monitoring effort, and time will
tell if the 503 leaves. They talk about using an exponential back-off
algorithm when you get the 503's. I still don't know if that means 20
minutes or 2 days or what. I guess you never know with that.

So your accounts do get banned for life?

On Nov 15, 7:36 pm, Marc Lester Tan <mail...@gmail.com> wrote:


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Marc Lester Tan  
View profile  
 More options Nov 16 2010, 3:01 am
From: Marc Lester Tan <mail...@gmail.com>
Date: Tue, 16 Nov 2010 16:01:10 +0800
Local: Tues, Nov 16 2010 3:01 am
Subject: Re: [android-market-api] Re: Sharing Data

I use exponential back-off as well but limited up to 1 minute only. If after
X tries using different google accounts, then drop the particular request
and move on to the next.


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
styler  
View profile  
 More options Nov 16 2010, 2:30 pm
From: styler <styler1...@gmail.com>
Date: Tue, 16 Nov 2010 11:30:16 -0800 (PST)
Local: Tues, Nov 16 2010 2:30 pm
Subject: Re: Sharing Data
so are you using setQuery at all, or how do you discover the new
applications are they are published on the market?

On Nov 16, 2:01 am, Marc Lester Tan <mail...@gmail.com> wrote:


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Marc Lester Tan  
View profile  
 More options Nov 17 2010, 10:33 am
From: Marc Lester Tan <mail...@gmail.com>
Date: Wed, 17 Nov 2010 23:33:43 +0800
Local: Wed, Nov 17 2010 10:33 am
Subject: Re: [android-market-api] Re: Sharing Data

I have a separate thread that fetches all the 800 authors (newest apps
first) then add the authors to my db if it doesn't exist yet. then same
process goes on (fetch all authors from db, fetch their apps..so on and so
forth.....)

Marc

twitter: mharkus
http://appalert.co | http://www.appcellar.com

...

read more »


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Tyler Williamson  
View profile  
 More options Nov 17 2010, 10:34 am
From: Tyler Williamson <styler1...@gmail.com>
Date: Wed, 17 Nov 2010 09:34:38 -0600
Local: Wed, Nov 17 2010 10:34 am
Subject: Re: [android-market-api] Re: Sharing Data

That seems like a good idea! Cool thanks!

On 11/17/2010 9:33 AM, Marc Lester Tan wrote:

...

read more »


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Marc Lester Tan  
View profile  
 More options Nov 17 2010, 10:43 am
From: Marc Lester Tan <mail...@gmail.com>
Date: Wed, 17 Nov 2010 23:43:18 +0800
Local: Wed, Nov 17 2010 10:43 am
Subject: Re: [android-market-api] Re: Sharing Data

Btw, just to add to the info, I'm also spawning one thread per category and
fetch all 800 authors for each category (newest apps first)

Marc

twitter: mharkus
http://appalert.co | http://www.appcellar.com

On Wed, Nov 17, 2010 at 11:34 PM, Tyler Williamson <styler1...@gmail.com>wrote:

...

read more »


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Tyler Williamson  
View profile  
 More options Nov 17 2010, 10:47 am
From: Tyler Williamson <styler1...@gmail.com>
Date: Wed, 17 Nov 2010 09:47:38 -0600
Local: Wed, Nov 17 2010 10:47 am
Subject: Re: [android-market-api] Re: Sharing Data

You have something going on with your site, I'm guessing there is some
javascript that is causing this but in chrome, on the top 200 pages,
your site freezes.

On 11/17/2010 9:43 AM, Marc Lester Tan wrote:

...

read more »


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Messages 1 - 25 of 38   Newer >
« Back to Discussions « Newer topic     Older topic »