Daniel M's Avatar
Last Activity: 21 hours ago

Daniel M

9,834 POSTS



12 years HERE

Activity Log
6 days ago Updated List
22 days ago Updated List
22 days ago Updated List
6 months ago Updated List
Wales, U.K. Location
Web Designer Occupation

Showing Comments 1 to 4 of 387
  1. 12-30-22
    Thanks. Always happy to answer questions about it. A lot of what I learned early on I learned from just picking people's brains. Always worked better than tutorials and the like.
  2. 12-30-22
    Yeah, basic SQL. I think you'd be pretty at home with this software (or newer software otherwise a lot like it) from that.

    Yeah, it's definitely been a learning experience. Not a lot of formal learning, just a lot of "learn about that part of the car when it breaks" learning. But after a long enough time that covers most of it anyway.
  3. 12-30-22
    Yeah, it's a lot easier now I think. Shoulda done it years ago, really.

    Dynamic stuff can go too far. When I started programming my data wasn't normalized at all. Then I learned about joins and grabbing things on the fly and did that for everything...until it reached a certain level of traffic and/or complexity, at which point it can be necessary to go back to caching, to repeating data, in select circumstances. Kinda comes full circle like that. But in this case it goes very fast without caching.
  4. 12-29-22
    Assuming I'm understanding correctly, it already does that. It logs every single film on every ballot as individual rows in a database. It doesn't iterate anything, though, it just counts them dynamically as needed (ditto on point totals, which aren't stored anywhere but are simply calculated from the rankings on request).

    The ballot table contains the userid, the TMDB id, the film's rank on the ballot, the total number of films on the ballot it was part of (so we can de-weight shorter ballots), and the time submitted.

    Before wiping the table clean for the next countdown I copy and rename it, so it's all preserved at the same level of detail, theoretically allowing us to count all sorts of stuff across countdowns, at least from the point we started doing it this way.

    As for next list, not sure. Presumably another genre list. War films was a close second last time, I think?
Playtime   2/07/15
I want to watch this film again already, and I can feel this becoming one of my all time favourite films that

Waking Life   11/21/14
I remember last year when I was in my university accommodation I had this really long lucid dream, it was more

Shame   11/02/14
By the end of the film nothing has really been achieved, we know nothing that we did not know about these cha

Fury   11/02/14
The film lacks (almost) any kind of morality or human balance that make the most powerful war pieces so fascin

View All Reviews (71)
Daniel M has not joined any clubs.