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

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!

I have updated Canvas Stats 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 @rrconkle@lemmy.zip placed:

If you would prefer the background to be black instead of white, let me know in your DM.

Another feature I added was overall stats for the event.

![](https://lazysoci.al/api/v3/image_proxy?url=https%3A%2F%2Fsh.itjust.works%2Fpictrs%2Fimage%

Small disclaimer this is from the txt log which is not exactly complete, there are few pixels missing here and there.

One second of the video is about 30 minutes of drawing (one frame contains 1 minute of drawing, 30 frames per second)

Also a little bit of bragging - couldn't resist the challenge and got this all glued together in Python! Which is obviously a valid tool for this considering the rich data processing ecosystem.
Well maybe except the video generation part... definitely except the video generation - Pyav - bindings for ffmpeg, are really badly documented, luckily they have at least good enough examples.

The short story of how:

• little bit of python script to convert the txt log into csv
• from csv to pandas, there I made a few cleaning passes to get the "format" just right (mainly dealing with the mod_fill action)
• pyav, ffmpeg and the world of video - oh boy:
  • for each one minute of drawing data
  • replay them over the canvas (numpy RGB array)
  • embed

Hi everybody! I have finished building a web app that allows you to search for a user and view their stats from the event! The app will tell you your overall ranking, number of pixels placed, the coordinate you placed the most pixels on, and how many of each color you placed.

I will probably add more features to the website, but I wanted to get something out there so everyone could see how they did.

Thanks @grant@toast.ooo for providing the data.

Here is the link to the web app.

[Idea] If you don't want to see huge flags taking space over actual drawings in the Canvas, pick the biggest flag that you can find to deface.

As long as a lot of people are doing that, the ones templating larger flags will be forced to reduce their layouts and give more room for actual drawings.

[Reasoning] When it comes to country flags, I think that the immense majority of the users can be split into four groups:

1. The ones who don't want to see country flags at all.
2. The ones who are OK with smaller flags, but don't want to see larger ones.
3. The ones who want to see a specific large flag taking a huge chunk of space.
4. The ones who want to see the whole canvas burning, like the void.

I'm myself firmly rooted into #1, but this idea is a compromise between #1, #2 and #4.

Typically #3 uses numbers (and/or bots) to seize a huge chunk of the canvas to their flags. Well, let's use numbers against it then. As long as #1, #2 and #4 are trying to wreck the

After I finished working on my drawing, I spent some extra time on the event drawing small custom/abstract flags inspired from generated flags from my flag generator, placed on random locations of tiny available spaces on the canvas. Mainly just to help fill the canvas, but overall, that was a cool and fun idea.

I drew a total of 40 flags, but not all of them managed to survive until the end of the event. So, I double-checked and counted all the survived flags, and in total, there are 34 survived flags on the canvas. If you managed to find all of them, I'll reveal a huge list of locations in the comments!

These are some of the mini flags, for a bit of a hint.

Just from "a quick query" by the admin.

there'll be a better one later, this is just a quick query

Hey everyone! Thanks for participating in Canvas. I wanted to make a thread to collect together suggestions people have that can be worked on before the next Canvas.

Feel free to also throw in suggestions for future Events we can build and run for the fediverse.

Ill be collecting suggestions together and making issues for them in the repository for myself or some other contributors to work on (the projects open source so anyones free to contribute! https://git.sc07.company/sc07/canvas Feel free to reach out to me and I can help get you set up with the codebase)

GET YOUR PIXELS INNNN