Skip Navigation
Canvas
Canvas

Canvas — The Fediverse’s r/place

July 12th, 2025 @ 4am UTC

Links

Timelapses

Members
2,297
Posts
66
Active Today
375
Created
2 yr. ago
  • Canvas @toast.ooo
    Monte @sh.itjust.works

    Database correction and update to Canvas Stats

    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. The canvas Stats app has been updated with the new data.

    You can find the fixed database dump sql file on my github: https://raw.githubusercontent.com/TheRealMonte/data-files/main/2024/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

  • Canvas @toast.ooo
    Monte @sh.itjust.works

    View and download the pixels you placed during the event - Canvas Stats

    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!