139
Full Timelapse, Canvas Poster, Database Dump | Canvas 2024 (sc07.tv)
submitted 3 months ago* (last edited 3 months ago) by grant@toast.ooo to c/canvas@toast.ooo
8 comments fedilink hide all child comments

Full Timelapse: PeerTube, YouTube, Raw File

Full Image: https://cdn.sc07.company/canvas/2024/finished.png

Canvas poster

🚨🚨🚨 You can now pre-order the posters!!

https://sc07.shop

These are pre-orders, the first orders will be shipped out August 1st following the shipping information listed on the site

Most countries are supported if yours is not listed, send me an email hello@sc07.company or comment below πŸ’œ

Instance Stickers

Proceeds from instance stickers go to their respective instances πŸ’ž

Direct Donations

If you would like to directly donate to Canvas w/o making any purchases, I accept donations via Stripe πŸ’œ

(i wasn't clear on the stripe page that the fediverse handles would be public, so this is a placeholder until i get confirmation they all want it public or not)

Support

If you are having issues with the website, send an email to hello@sc07.company

Database Dump

the old system for pixel placement logs was flawed, and someone suggested the brilliant idea of just publishing the database dump, it already has all the information anyway

no ip addresses, or ban logs only pixel placements (with username), pixel moderation logs and palette settings

https://cdn.sc07.company/canvas/2024/canvas-stripped.sql.txt

Canvas Repo - Canvas Timelapse Repo

you are viewing a single comment's thread
view the rest of the comments
[-] plactagonic@sopuli.xyz 6 points 3 months ago

Is there a way to look up where are pixels that individual users put?

I consider buying it and putting pins or something in the few places where I left my mark.

[-] grant@toast.ooo 12 points 3 months ago

There is no tools right now that allow that to happen

but the database dump is tagged in this post which would allow for people to make those tools πŸ™

[-] plactagonic@sopuli.xyz 4 points 3 months ago* (last edited 3 months ago)

I thought that it is stripped of user data only pixel placements.

Edit: looked at it now and with my ~50 pixels placed it is possible to find it without tools.

[-] grant@toast.ooo 6 points 3 months ago

Sorry, I phrased it badly πŸ˜…

There's no user table (from the server) but each pixel is tagged with whoever placed the pixel

I've edited my original post so it doesn't confuse more people

[-] the_real_monte@sh.itjust.works 6 points 3 months ago

I can help you out if there is something you are looking for. I have a script that I can run on my computer to generate an image of just one user's pixels, or a group of users. I have not gone through the new data yet, but should have something by the end of today.

[-] plactagonic@sopuli.xyz 4 points 3 months ago

Thanks, DM of the few pixels I placed (mostly randomly- there is cool art I can help with fill, I am bored so I will extend the trans flag...) would be highly appreciated.

I would be surprised if there are more than 20 of my pixels on the final canvas.

this post was submitted on 18 Jul 2024
139 points (98.6% liked)

Canvas

2083 readers
1 users here now

Canvas β€” The Fediverse’s r/place

2024 Concluded!

Get a print!

Links

Timelapses

founded 1 year ago
MODERATORS
grant@toast.ooo
Ategon@programming.dev
sugar@toast.ooo