pkmncollectors feedback spec

[rax]

If you don't care about pkmncollectors, you can ignore this post. LJ's fuckage is the impetus for making a new feedback system, but really pkmncollectors needed one anyway. I feel nervous about writing this myself (god I am so fucking rusty it is embarrassing) but I have done things like this many years ago and also Krinn said she would help and

Comments

[paperoid]

Reading this, seems like you've got all the necessary bases covered. Though a general question is how to deal with the practice of revising feedback. Many users will leave negatives and adjust them to neutrals after things get fixed up. I think being able to edit previous feedbacks is a bit too much to ask, but having the option to delete previous ones should definitely be implemented later.

[entirelycliched]

In my personal opinion, the ability to revise feedback isn't totally necessary. If a user deems it necessary to leave negative feedback, they had a negative experience, period. Just because they finally get their item or proof of shipment several months later doesn't make the experience they went through even neutral. Neutral means shipping was really slow without explanation, payments were delayed without reasonable cause, etc. When I am considering buying something from someone, if they have negative feedback that I view as legitimate, I personally skip the purchase regardless of whether or not the feedback was revised. I think many people feel the same because no one wants to fight a battle for what should be a simple transaction.

[rax]

I think for a version 1 at least it's reasonable to require mod input to take things back? There might be cases where you'd want to do so ("my housemate took the package to her room and sat on it for a month, oops") aside from negotiating with the seller, but they seem exceptional enough to handle specially for now, probably?

[entirelycliched]

Well, the thing is that I have never witnessed someone leave negative feedback without making multiple attempts to get in contact with the person. If a mistake like your example is made, the seller would then either provide proof of shipment or look for the package when prompted.

On ebay, you can respond to a negative feedback to give your version of what happened and whether or not you issued a refund/made an attempt to correct the transaction. But regardless, a bad experience that warrants negative feedback (especially since people are so reluctant to leave it) cannot be undone... the stress, frustration, and confusion all still occurred.

[rax]

Last night I dreamed about making the database have a table of usernames and then a table for each usernames, but I don't think that's a version 1 feature; if pkmncollectors gets to 10000 transactions in a couple of years, then the database might hit 40MB of RAM in two years as it is now, maybe (if each transaction is 4K which is unlikely). It's always possible to change this later; I don't think it's worth doing right now. If you know more about databases and think I'm wrong, let me know!

[meguroco]

So, my boyfriend was reading over this, and he asked me to drop a reply to this, since he doesn't have an LJ account YET (I will force him to make one, one day, haha...):

"This seems like a pretty reasonable spec and you are thinking the same as I am as far as sqlite + Python is concerned. I've never worked with OpenID before (aside from using it to login to things myself) but it seems a reasonable idea.

As far as the database schema goes, I would caution against 1 table per user. Something more like:

One table for users
One table for feedback with two foreign keys to the user table (person leaving feedback, person receiving feedback)

That schema is a lot more scalable than creating an entire table for every user in the system.

If you already have an Apache server that can run Django or something I could look into doing this over my vacation with my family in the next two weeks. It sounds like an interesting project."

[rax]

Hmm, what about buy/sell/trade?

[eredien]

I think having a database like this is a very good idea. As paperoid said, the ability to revise feedback is important.