Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
locksley
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
10 ms
·
31.
▲
by
locksley
14y ago
Thanks for the pick up.
32.
▲
by
locksley
14y ago
Yeah this would be interesting and I can certainly do it for popular searches. To do it for all items would require collection of lots of data in my own database though. Will have a think about this.
33.
▲
by
locksley
14y ago
That's a good point. Ebay takes around 9% and Paypal around 3%. After postage, it'll cost you around 15% of sale.
34.
▲
by
locksley
14y ago
Thanks! Similarly, I've convinced my grandma to use this.
35.
▲
by
locksley
14y ago
Ebay's API might have a 'condition' property, I shall check. In the meantime it's probably just as effective to put the condition as a query, i.e "iPhone 5 used"
36.
▲
by
locksley
14y ago
Hmmm, this is difficult to fix because it relies on Ebay's search engine. The only solution I could think of is to add a 'price filter slider' on the results page. This way, you could set the limits to how much you think Dexter Season 6 sho
37.
▲
by
locksley
14y ago
Hey thanks! I'm just using a filter of 2 standard deviations within the median at the moment. Any ideas on how to do it more effectively?
38.
▲
by
locksley
14y ago
Ah balls. I'm on it.
39.
▲
by
locksley
14y ago
Hey you sure about that? Seems to be fine for me. But there are two obvious clusters. Perhaps two different LCD models? http://www.getmarketprice.com/results/thunderbolt-LCD/
40.
▲
by
locksley
14y ago
This was crazy, thanks for letting me know! My servers surprisingly seemed to handle it ok with one minor crash.
41.
▲
by
locksley
14y ago
You don't like the charts? I'm guess a stats nerd so I like to see that stuff haha. I like your feature suggestion, just put it in my product backlog.
42.
▲
by
locksley
14y ago
That's a good idea. I'm planning to build a pricing filter slider on the results page because it seems most people have a rough idea how much an item is worth. Your problem was the reason why I filtered out results below $100. There's just
43.
▲
by
locksley
14y ago
Yeah, that's on the product backlog! But I'm a full time law student doing this as a side project in order to learn how to code. NEED MOAR ENGINEERS
44.
▲
by
locksley
14y ago
Thanks for the comments! I actually originally intended this for the buyer! I wanted an iphone for myself, so I scraped the 'completed listings' page on ebay, and converted it to csv to build a histogram in excel. The data is up to the minu
45.
▲
by
locksley
14y ago
Ahh, thanks for the heads up. I'm using a URI Escape function on the search terms and that might be breaking something. Looking into it now.
46.
▲
by
locksley
14y ago
Thanks! Yeah, I've come across Pricenomics but found their data inconsistent and the sample size too small with ebay results. They're doing good work nonetheless and their front end rapes mine haha. I ain't much of a designer.
47.
▲
by
locksley
14y ago
Wow, had no idea they could be making so much. I've come across their "Research API" before but didn't think too much about it. Will have a look into it now. Thanks man
48.
▲
by
locksley
14y ago
At the moment I'm filtering out items 2 standard deviations out of the median. It catches the ridiculous cases, i.e. when some fool tries to get away with selling an iphone for $6000 (yes I've seen this before). Perhaps I need to filter it
49.
▲
by
locksley
14y ago
Thanks for the feedback! Really appreciate it
50.
▲
by
locksley
14y ago
Ah Crap, thanks for letting me know. I'll patch it up tomorrow, it's 12:30am here in Melbourne!
51.
▲
by
locksley
14y ago
The most useful tip I could give you (if you're building on rails and deploying to heroku) is to use a Unicorn Webserver. It allows your to handle far more concurrent requests. This article explains it better than I ever will. http://blog.
52.
▲
by
locksley
14y ago
This was my weekend project. I made it after being frustrated at not knowing what a fair price for an iphone 5 would be on eBay. I posted this a month ago but wasn't ready for HN traffic. Learnt about load testing the hard way and have opti
53.
▲
Show HN: I made a site that calculates the market price of items on ebay
(getmarketprice.com)
87 points
by
locksley
14y ago
|
61 comments
54.
▲
Ask HN: What if there was Github for Legislation?
1 points
by
locksley
14y ago
|
0 comments
55.
▲
by
locksley
14y ago
Is this a YC startup?
56.
▲
by
locksley
14y ago
Yeah sure, it's a scraper. The histogram is then built out of the 200 results retrieved from 'completed listings', minus the ones that weren't sold. The X/Y scatter plot is built from the 200 upcoming results, intended as a way to find good
57.
▲
by
locksley
14y ago
Sorry! It should be ok now.
58.
▲
by
locksley
14y ago
I made this in rails over a couple of weekends after learning how to code late last year. The inspiration came from wanting to buy an iPhone 5 from ebay but not knowing what a fair price should be. After a writing a script to calculate this
59.
▲
Show HN: I made a site that calculates the market price of items on ebay.
(getmarketprice.com)
15 points
by
locksley
14y ago
|
11 comments
60.
▲
Just Because Facebook Clones Your App, It Doesn’t Mean You’re Dead
(allthingsd.com)
1 points
by
locksley
14y ago
|
0 comments
More ›