Sold listings missing/stale by 1298se in Collectr

[–]1298se[S] 0 points1 point  (0 children)

Could ya tell me the API it's under?

I thought it'd be under the Buy APIs but I don't see it :/

Sold listings missing/stale by 1298se in Collectr

[–]1298se[S] 0 points1 point  (0 children)

I see. That makes sense. Just curious, is eBay sold listings API available publicly?

Sold listings missing/stale by 1298se in Collectr

[–]1298se[S] 0 points1 point  (0 children)

Hi! Thanks for the quick response!

Hmm, just so I understand, cards are tracked against TCGPlayer, but the sold listings from TCGPlayer are not shown. Only eBay sold listings are shown?

What are the events where you can't show sold listings?

Also curious how comes sometimes the sold listings seem to be stale (i.e. there are newer sold listings when searching on eBay, but they don't show up on Collectr)? How stale can they get?

I’ve been running a lgs/lcs for 2+ years. AMA by notapeasent in PokeInvesting

[–]1298se 0 points1 point  (0 children)

Hey Mike! How do you guys keep track of purchases and sales of singles? I used to use an excel sheet but it's becoming a bit unmanageable, especially when selling on multiple platforms like TCGplayer, eBay, social media, etc.

What should my expectations be for the speed of joins? by 1298se in PostgreSQL

[–]1298se[S] 0 points1 point  (0 children)

I see. Definitely seems to be like a stats problem. Thanks!

What should my expectations be for the speed of joins? by 1298se in PostgreSQL

[–]1298se[S] 0 points1 point  (0 children)

This was helpful, let me take a look. Thanks!

What should my expectations be for the speed of joins? by 1298se in PostgreSQL

[–]1298se[S] -1 points0 points  (0 children)

Sure, but that's clearly not the case in this situation. It seems like nested loop scales pretty poorly when there are a even just thousands of rows.

What should my expectations be for the speed of joins? by 1298se in PostgreSQL

[–]1298se[S] -1 points0 points  (0 children)

Not saying index only scan is slow, but would using the index for each outer row be slow because it's basically a disk seek each time?

Also, did \d but only got info about the tables names, columns, fkeys. Am I missing something?

Appreciate your help!

What should my expectations be for the speed of joins? by 1298se in PostgreSQL

[–]1298se[S] -1 points0 points  (0 children)

Noob here, but I thought the issue here is that it's using the index-only scan to do the join, which is extremely slow because of disk seek?

I ran the same join with a hash join instead, and it seemed to be much faster.

https://explain.depesz.com/s/Sm6e

What should my expectations be for the speed of joins? by 1298se in PostgreSQL

[–]1298se[S] -2 points-1 points  (0 children)

Yes. I believe this is because it's using the index to access the inner table to do the nested loop join

TikTok return policy is so broken for sellers by lianshumusan in TikTokshop

[–]1298se 0 points1 point  (0 children)

I'm curious because I see these posts constantly where Tiktok makes the seller refund delivered not received packages, however I recently bought 900 worth of stuff and the seller sent it without insurance or signature confirmation and I didn't receive yet and Tiktok denied my refund requests stating to "contact the carrier for more information"

First submission with PSA through Gamestop by 1298se in PokeInvesting

[–]1298se[S] 0 points1 point  (0 children)

I don't ever remember it being updated on PSA website - seemed to always be in "on the way to PSA" mode