Discuss Scratch

kRxZy_kRxZy
Scratcher
1000+ posts

Scratch Info — Get info and statistics about Scratch projects and users!

redspacecat wrote:

kRxZy_kRxZy wrote:

right now are you just relying on file storage?
For what?
For user data, forum data, project data, etc.
redspacecat
Scratcher
500+ posts

Scratch Info — Get info and statistics about Scratch projects and users!

kRxZy_kRxZy wrote:

redspacecat wrote:

kRxZy_kRxZy wrote:

right now are you just relying on file storage?
For what?
For user data, forum data, project data, etc.
For form data I'm storing that, yah. User data and project data are calculated on request and not cached server side.
kRxZy_kRxZy
Scratcher
1000+ posts

Scratch Info — Get info and statistics about Scratch projects and users!

redspacecat wrote:

kRxZy_kRxZy wrote:

redspacecat wrote:

kRxZy_kRxZy wrote:

right now are you just relying on file storage?
For what?
For user data, forum data, project data, etc.
For form data I'm storing that, yah. User data and project data are calculated on request and not cached server side.
Wow! I though you'd be using sql databases or mongodb or something. Are you storing it locally on an ssd or something? And do you have backups, if it becomes corrupted…
redspacecat
Scratcher
500+ posts

Scratch Info — Get info and statistics about Scratch projects and users!

kRxZy_kRxZy wrote:

redspacecat wrote:

kRxZy_kRxZy wrote:

redspacecat wrote:

kRxZy_kRxZy wrote:

right now are you just relying on file storage?
For what?
For user data, forum data, project data, etc.
For form data I'm storing that, yah. User data and project data are calculated on request and not cached server side.
Wow! I though you'd be using sql databases or mongodb or something. Are you storing it locally on an ssd or something? And do you have backups, if it becomes corrupted…
For the forum data I'm using alwaysdata.net's free tier. I don't have any backups or anything lol, that might be a good idea.
kRxZy_kRxZy
Scratcher
1000+ posts

Scratch Info — Get info and statistics about Scratch projects and users!

redspacecat wrote:

kRxZy_kRxZy wrote:

redspacecat wrote:

kRxZy_kRxZy wrote:

redspacecat wrote:

kRxZy_kRxZy wrote:

right now are you just relying on file storage?
For what?
For user data, forum data, project data, etc.
For form data I'm storing that, yah. User data and project data are calculated on request and not cached server side.
Wow! I though you'd be using sql databases or mongodb or something. Are you storing it locally on an ssd or something? And do you have backups, if it becomes corrupted…
For the forum data I'm using alwaysdata.net's free tier. I don't have any backups or anything lol, that might be a good idea.
So you only have 1gb storage with 256mb ram, wow. I can really help with this, I'll make a pr with postgresql/mongodb/mariaDB/mysql and with an option to pick which one in an env and the server password and username and stuff. I also add backups.
redspacecat
Scratcher
500+ posts

Scratch Info — Get info and statistics about Scratch projects and users!

kRxZy_kRxZy wrote:

redspacecat wrote:

For the forum data I'm using alwaysdata.net's free tier. I don't have any backups or anything lol, that might be a good idea.
So you only have 1gb storage with 256mb ram, wow. I can really help with this, I'll make a pr with postgresql/mongodb/mariaDB/mysql and with an option to pick which one in an env and the server password and username and stuff. I also add backups.
Thanks, but I think I'm fine with how it is now.
It's not super fast but it's simpler.

You can still make a suggestion but I might not implement it yet, sorry.
medians
Scratcher
1000+ posts

Scratch Info — Get info and statistics about Scratch projects and users!

It should probably say 0 posts on this page
https://scratchinfo.quuq.dev/users/straightforwardness/posts
Also probably do not need the graphs here and the pie chart

Last edited by medians (Oct. 25, 2025 15:53:39)

kRxZy_kRxZy
Scratcher
1000+ posts

Scratch Info — Get info and statistics about Scratch projects and users!

redspacecat wrote:

kRxZy_kRxZy wrote:

redspacecat wrote:

For the forum data I'm using alwaysdata.net's free tier. I don't have any backups or anything lol, that might be a good idea.
So you only have 1gb storage with 256mb ram, wow. I can really help with this, I'll make a pr with postgresql/mongodb/mariaDB/mysql and with an option to pick which one in an env and the server password and username and stuff. I also add backups.
Thanks, but I think I'm fine with how it is now.
It's not super fast but it's simpler.

You can still make a suggestion but I might not implement it yet, sorry.
OK, but just keep this in mind:
If alwaysdata.net goes down or their databases go corrupt (because the website isn't too large and isn't much trusted) all your data is gone, same for the user data if your storeing it in a site like that, a simple and easy way is storing all data in a github repo e.g one repo for the forum and one for the user data and stuff.
It's free and easy
redspacecat
Scratcher
500+ posts

Scratch Info — Get info and statistics about Scratch projects and users!

medians wrote:

It should probably say 0 posts on this page
https://scratchinfo.quuq.dev/users/straightforwardness/posts
Also probably do not need the graphs here and the pie chart
Yeah that's an issue oops. I'll fix that.

Edit: Fixed

Last edited by redspacecat (Oct. 25, 2025 16:19:27)

redspacecat
Scratcher
500+ posts

Scratch Info — Get info and statistics about Scratch projects and users!

kRxZy_kRxZy wrote:

redspacecat wrote:

kRxZy_kRxZy wrote:

redspacecat wrote:

For the forum data I'm using alwaysdata.net's free tier. I don't have any backups or anything lol, that might be a good idea.
So you only have 1gb storage with 256mb ram, wow. I can really help with this, I'll make a pr with postgresql/mongodb/mariaDB/mysql and with an option to pick which one in an env and the server password and username and stuff. I also add backups.
Thanks, but I think I'm fine with how it is now.
It's not super fast but it's simpler.

You can still make a suggestion but I might not implement it yet, sorry.
OK, but just keep this in mind:
If alwaysdata.net goes down or their databases go corrupt (because the website isn't too large and isn't much trusted) all your data is gone, same for the user data if your storeing it in a site like that, a simple and easy way is storing all data in a github repo e.g one repo for the forum and one for the user data and stuff.
It's free and easy
I guess I kind of have backups because I download the data each week to make the leaderboards.
Also what do you mean by “user data”? I'm only using alwaysdata for storing forum data.

I guess I'll upload copies of the forum data to GitHub.

Edit: You can find it here: https://github.com/redspacecat/scratch-forums-data/releases/tag/data

Last edited by redspacecat (Oct. 25, 2025 16:20:30)

GT9169
Scratcher
68 posts

Scratch Info — Get info and statistics about Scratch projects and users!

That mod sounds pretty cool i might get it
unconstructable13
Scratcher
100+ posts

Scratch Info — Get info and statistics about Scratch projects and users!

redspacecat wrote:

Edit: You can find it here: https://github.com/redspacecat/scratch-forums-data/releases/tag/data
I find the CSV file very interesting!
There is something in this file that I really want to know more about which is this mysterious second value (the one I’m talking about is highlighted in bold, I couldn’t really explain it very well in words):
(post ID), 4, unconstructable13, (post timestamp)
redspacecat
Scratcher
500+ posts

Scratch Info — Get info and statistics about Scratch projects and users!

unconstructable13 wrote:

redspacecat wrote:

Edit: You can find it here: https://github.com/redspacecat/scratch-forums-data/releases/tag/data
I find the CSV file very interesting!
There is something in this file that I really want to know more about which is this mysterious second value (the one I’m talking about is highlighted in bold, I couldn’t really explain it very well in words):
(post ID), 4, unconstructable13, (post timestamp)
Oh, that's the subforum (category) that the post is in.
I'll add headers to the csv.

Edit: Done

Last edited by redspacecat (Oct. 25, 2025 18:00:50)

GT9169
Scratcher
68 posts

Scratch Info — Get info and statistics about Scratch projects and users!

Thanks
medians
Scratcher
1000+ posts

Scratch Info — Get info and statistics about Scratch projects and users!

Wow could never guess who this is (also such an interesting graph) :D
https://scratchinfo.quuq.dev/users/orthocenter/browserHistory
redspacecat
Scratcher
500+ posts

Scratch Info — Get info and statistics about Scratch projects and users!

medians wrote:

Wow could never guess who this is (also such an interesting graph) :D
https://scratchinfo.quuq.dev/users/orthocenter/browserHistory
Is that you lol
medians
Scratcher
1000+ posts

Scratch Info — Get info and statistics about Scratch projects and users!

redspacecat wrote:

medians wrote:

Wow could never guess who this is (also such an interesting graph) :D
https://scratchinfo.quuq.dev/users/orthocenter/browserHistory
Is that you lol
I wonder how many people you know that match these exact characteristics!!1!
https://scratch.mit.edu/users/orthocenter/favorites/
redspacecat
Scratcher
500+ posts

Scratch Info — Get info and statistics about Scratch projects and users!

medians wrote:

redspacecat wrote:

medians wrote:

Wow could never guess who this is (also such an interesting graph) :D
https://scratchinfo.quuq.dev/users/orthocenter/browserHistory
Is that you lol
I wonder how many people you know that match these exact characteristics!!1!
https://scratch.mit.edu/users/orthocenter/favorites/
Oh I didn't even look that, just windows vista.
redspacecat
Scratcher
500+ posts

Scratch Info — Get info and statistics about Scratch projects and users!

News:

I'm working on adding follower count leaderboards!

They'll probably be ready in the next few days/week.

Last edited by redspacecat (Nov. 6, 2025 16:02:15)

Powered by DjangoBB