My experience with Reddit's API only extends to using PRAW for posting a submission in real time. I've been looking to start a scheduling tool like SocialRise, however I lack understanding on how some of the features work.

1. How does the scheduling actually work? My idea was to have the website just write entries into a database with the posts & date time they need to be posted at, then have my python script check each minute if there's a new post that needs submitting. I have a feeling that this is far from an efficient approach to scheduling posts.
   Side note: The scheduling page also displays data in real time (more on point 2) such as the flairs available on the community or if media/url posts are disallowed.
2. How does the website scan for data in realtime? So you have features like the subreddit analysis where you input a subreddit's name and it gives you freshly scraped data such as description, members, best times to post, graphs of activity, most used keywords and so on. How does this happen in real time? What's the process between the user inputting the subreddit name and the website displaying all the data?

Since I'm only a bit experienced with PRAW and not experienced with developing websites, I'd like to learn how these two things work in beginner terms.