Theme with archive of posts organized chronologically

[markstos]

I don’t think there’s an easy way to do this with Ghost. There’s some newer discussion with some example SQL to get a list of months or years that contain posts and the count for each month. What’s missing is connecting the result that query with the frontend templates:

Filter Posts by Date Block

The solution by @denvergeeks would work, but involves selecting the details of every post from the database, sending a lot of data to the frontend that will be discarded, and then having the browser process every post to come up with the result. Here’s example of what it looks like to query this data directly using SQL. I’ve provided an example of querying the by-month counts and also by-year counts. You can see the report that both queries take “0.00” seconds for a small dataset, and this woul…