Canvas Stats has been updated with 2025 stats - sh.itjust.works

Canvas Stats 2025 [https://canvasstats.com/] is now live! You can view how you rank out of 638 users, see how many pixels you places, how many of each color, and generate an image of all the pixels you placed. You can also compare how you did this year vs previous years. I am still working on a few more graphs/images for the overall canvas. The site layout might load weird on mobile, my goal was to get the stats up first, then I will go back and fix the design of the site. Let me know if there are any other stats you want to see on the site!

Database correction and update to Canvas Stats - sh.itjust.works

There was an error with the fediverse-auth on the Canvas site where after a certain point new logins started being logged as all lower case which created duplicates of 59 users and were treated as separate users. I have merged all of the duplicate accounts and rebuild the database. This also means that all of the stats on Canvas Stats are incorrect. I am updating the data for the app now. You can find the fixed database dump sql file on my github: https://raw.githubusercontent.com/TheRealMonte/sql-2024/main/canvas-2024-fixed-sql.sql [https://raw.githubusercontent.com/TheRealMonte/sql-2024/main/canvas-2024-fixed-sql.sql] The file is 33,568 kB. The SQL file has 4 tables: * users (user_id, username, ranking, total_pixels_placed) * colors (color_id, color_name, color_hex) * pixels (log_id, user_id, x_cord, y_cord, color_id, time_placed, is_mod_action, is_top, time_deleted) * top_cord (top_cord_id, user_id, x_cord, y_cord, count_placed) The users table includes the rank and total pixels placed for each user. Deleted pixels are not counted. There are 13 users who deleted every pixel the placed. They are still ranked, but their total pixel count is 0. The colors table includes the color ID, name, and hex which when joined with the pixels table can be used to easly select the color name or hex. The pixels table includes the username, x and y coordinates, color ID, the time the pixel was placed, if the pixel was a moderator placement, if the pixel can be seen in the final image, and the time the pixel was deleted or NULL. The top_cord table includes the x and y coordiantes for the coordinate each user placed the most pixels on along with the count. The only data not included here is the pixel color counts for each user. You an find the pixel color counts for a user by selecting: SELECT color_name, count(color_name) FROM public.pixels JOIN users on users.user_id = pixels.user_id JOIN colors on colors.color_id = pixels.color_id WHERE username = <username> GROUP BY color_name

View and download the pixels you placed during the event - Canvas Stats - sh.itjust.works

Another update to Canvas Stats app. You can now view your pixels you placed during the event in your browser and download the pixels as a png image! [https://sh.itjust.works/pictrs/image/cf1fe697-d205-4adc-ad8a-4e51ccabeade.png]

Update to Canvas Stats web app and making user pixel images - sh.itjust.works

I have update my web app with the new data from the sql log. Rankings should mostly be the same as the old data, but your total pixel count will be lower since deleted pixels no longer count. A new feature to the site is you can now see if your top coordinate placed is also another users top coordinate placed, which would mean you were probably battling it out over a pixel. I am also generating images of individual user’s pixels. If anyone is interested, just send me a DM. Here is an example of just the pixels that @[email protected] [https://lemmy.zip/u/rrconkle] placed: [https://sh.itjust.works/pictrs/image/ecb1b403-8edb-4262-86f1-f5c83408c64b.png] If you would prefer the background to be black instead of white, let me know in your DM.

5.25-inch floppy disks expected to help run San Francisco trains until 2030 - sh.itjust.works

Deadpool & Wolverine - teaser trailer - sh.itjust.works

Finished WDW haunted mansion to go with my DL mansion - sh.itjust.works

The WDW mansion is from HorizoneerDesign [https://www.etsy.com/listing/1473523338/the-haunted-mansion-walt-disney-world?click_key=063bbe9fb166d01c94f10a16319137d8e7143bcf%3A1473523338&click_sum=6c73a41a&ref=shop_home_active_9&crt=1].

Dogpile - sh.itjust.works