Deep Web of the ScribbleHub

Iamnotabot

marchioness of the Enpire
Joined
Jun 1, 2022
Messages
841
Points
133
What have you done, i was trying to hide dark side of this site. But you opened the gates, now all the secret file are expose. I have to do the W.I.P.E again because of you.
 

melchi

What is a custom title?
Joined
May 2, 2021
Messages
2,880
Points
153
Makes you wonder what the first story ever posted on the site was.

EDIT: Nevermind, it looks like it is reteach common sense
(can just do latest and look at the least latest)
 

CubicleHermit

Well-known member
Joined
Jan 5, 2022
Messages
144
Points
68
There isn’t another way he can store our stories, is there? He has to add our stories to a folder in the file structure, or else have to retrieve it directly from the database... which would be tedious for the number of novels (dropped or not) that have to be displayed. Well, I don’t know exactly how WordPress displays posts, so I guess you can take my words as a grain of salt. Also, these novels are hidden from the public, sure, but most of those are just translations hosted on the website.
I'd expect they're all in the database, at least as the source of truth; keeping track of multiple versions and relationships is something a database is much better at than a flat directory structure, and a few million chapters split across a few tens of thousands of stories isn't that much by DB standards.

Given how people usually speed up Wordpress, there is likely a pre-rendered copy on disk ether of everything or of frequently or recently viewed stories so that every read of a given story doesn't generate a DB call and a re-rendering of it.
 

CadmarLegend

@Agentt found a key in the skeletons.
Joined
Jan 3, 2021
Messages
1,956
Points
153
I'd expect they're all in the database, at least as the source of truth; keeping track of multiple versions and relationships is something a database is much better at than a flat directory structure, and a few million chapters split across a few tens of thousands of stories isn't that much by DB standards.

Given how people usually speed up Wordpress, there is likely a pre-rendered copy on disk ether of everything or of frequently or recently viewed stories so that every read of a given story doesn't generate a DB call and a re-rendering of it.
Yeah, I just looked at the documentation and a test site, and the posts are stored in the `wp-posts` table. Well, unless Tony changed some stuff when making the website theme.

It was also fun to find out that the chapters can hold up to 4 GiB of text (English). :blob_evil_two:

Screenshot 2023-01-06 at 4.52.03 PM.png
 

melchi

What is a custom title?
Joined
May 2, 2021
Messages
2,880
Points
153
I'd expect they're all in the database, at least as the source of truth; keeping track of multiple versions and relationships is something a database is much better at than a flat directory structure, and a few million chapters split across a few tens of thousands of stories isn't that much by DB standards.

Given how people usually speed up Wordpress, there is likely a pre-rendered copy on disk ether of everything or of frequently or recently viewed stories so that every read of a given story doesn't generate a DB call and a re-rendering of it.
Maybe I'm weird but all this talk of database constantly reminds me of log horizon's opening.
 

CubicleHermit

Well-known member
Joined
Jan 5, 2022
Messages
144
Points
68
That was an interesting OP. Got kind of old when they carried it over through Season 2.
 
Top