17 |
1,462 |
| JOINED: |
Nov 2023 |
| STATUS: |
OFFLINE
|
Although not really directly related to this forum (at least as things are), I decided to create this thread in this section.
In this thread I am going to talk about my ATS archive, the copy I made of the posts, threads and forums from ATS before it became inaccessible.
I know other people also made their own copies, and their opinions, comments, etc. are welcome.
After all, my idea was to preserve all the information ATS members created during all those years.
At the end of last year I was able to create a site to show the information with a look similar to ATS when viewed by a someone not logged in, but because of threats of legal action because of (possible) copyright problems made me take the site offline and make it private, as I'm not interested in having problems with something I thought was good for everyone.
So, at the moment, this is what I have:
- 14 public boards, including one for forums that got "orphaned" for some reason;
- 121 forums, including the "orphaned" forums mentioned above;
- 780.643 threads;
- 22.902.993 posts.
A couple of weeks ago I remembered that I didn't have any posts from the huge "Japan declares 'nuclear emergency' after quake" thread, as some kind of problem made it disappear from view.
Using the Internet Archive's Wayback Machine I was able to recreate the first 304 pages, but that thread had more than 1400, so it's still a work in progress.
1 |
696 |
| JOINED: |
Jan 2025 |
| STATUS: |
OFFLINE
|
Nice!
What a treasure for posterity ya got there!
Thank you and well done!
4 |
25 |
| JOINED: |
Jun 2025 |
| STATUS: |
OFFLINE
|
Just curious, what about all those podcasts? You archiving those too?
17 |
1,462 |
| JOINED: |
Nov 2023 |
| STATUS: |
OFFLINE
|
(04-12-2026, 02:39 PM)TrueAmerican Wrote: Just curious, what about all those podcasts? You archiving those too?
No, just the posts and most of the images. I couldn't find the images that were uploaded with the old version of the code.
17 |
1,462 |
| JOINED: |
Nov 2023 |
| STATUS: |
OFFLINE
|
I forgot to say that the posts are on an SQL Server database, and including indexes (and full-text indexes) it's around 100 GB. The images take another 123 GB.
Some people suggested I put the database on a torrent, so people could download it, but for that I think I would need to convert it into a different format.
1 |
14 |
| JOINED: |
Apr 2025 |
| STATUS: |
OFFLINE
|
(04-12-2026, 04:37 PM)ArMaP Wrote: I forgot to say that the posts are on an SQL Server database, and including indexes (and full-text indexes) it's around 100 GB. The images take another 123 GB.
Some people suggested I put the database on a torrent, so people could download it, but for that I think I would need to convert it into a different format.
Would there be any way to just zip the files and pack it in a nice .torrent?
Also, very glad to see you posting about this!
"Whatever is rejected from the self, appears in the world as an event."
17 |
1,462 |
| JOINED: |
Nov 2023 |
| STATUS: |
OFFLINE
|
(04-12-2026, 04:44 PM)MojoMaddness Wrote: Would there be any way to just zip the files and pack it in a nice .torrent?
Also, very glad to see you posting about this!
Zipped SQL Server databases, usually, are around 10% or their original size, so it would be something around 10 GB. An SQL Server database with that size needs a full or developer version of SQL Server, the free SQL Express doesn't allow databases that big.
I tried to convert it to a MySQL database, but I had some problems. Then I remembered that I didn't have the Japan thread. 
4 |
25 |
| JOINED: |
Jun 2025 |
| STATUS: |
OFFLINE
|
(04-12-2026, 03:43 PM)DenyIgnorance.com Wrote: I have those. I uploaded them to archive.org for anyone that wants to listen.
https://archive.org/details/ats_podcast_archive
So you think that's all of them? Or does that go to a point and then the rest are lost? I remember a few in particular that don't seem to be in there. And I wouldn't mind if you'd credit #1624 Reach in the listing near the end to TrueAmerican instead of TheUndisclosed...Unless you can't change it... I remember one I didn't see was Quakes Trigger Quakes... from soficrow I believe....Not there that I saw... Also quite a few tunes I uploaded as well are not there. I dunno, maybe it's just the naming, they could be in there as just a number. In any case, thanks for doing that, I found a couple in there I hadn't heard in forever, lol, like that crazy blues tune "Sweet Touch" Benevolent Heretic and I did together... sort of.... That was a trip to hear again. She gave me a raw vocal. That was it.
37 |
1,244 |
| JOINED: |
Apr 2025 |
| STATUS: |
OFFLINE
|
(04-12-2026, 04:50 PM)ArMaP Wrote: Zipped SQL Server databases, usually, are around 10% or their original size, so it would be something around 10 GB. An SQL Server database with that size needs a full or developer version of SQL Server, the free SQL Express doesn't allow databases that big.
I tried to convert it to a MySQL database, but I had some problems. Then I remembered that I didn't have the Japan thread.
can you query your SQL database to generate HTML files directly using T-SQL to make static html pages or briefly rehost it and use a tool like wget or HTTrack to mirror the site to your local machine as static files and then zip, torrent, and seed the output? Then it would be able to be opened by anyone with zero skill and no need for developer software just a browser
17 |
1,462 |
| JOINED: |
Nov 2023 |
| STATUS: |
OFFLINE
|
(04-12-2026, 09:17 PM)ReturnofBroccoli Wrote: can you query your SQL database to generate HTML files directly using T-SQL to make static html pages or briefly rehost it and use a tool like wget or HTTrack to mirror the site to your local machine as static files and then zip, torrent, and seed the output? Then it would be able to be opened by anyone with zero skill and no need for developer software just a browser
That's a good idea, I just need to find the disk space to try it.
|
