初心 shoshin

Building a Static Site from Scratch

The technologies used, problems faced, and lessons learned building a static site

Why?

One, I wanted the Ikea effect of building my own blog from scratch.

Two, I feel that off-the-shelf static site generators (SSGs) like Hugo and Jekyll don't provide me with the control I want, especially when it comes to templating languages and themes.

Three, I did it for the learning experience. I'd rather spend my time learning technologies more reusable than a pre-built SSG framework. In building this site, I learned about utility-first CSS (Tailwind), the N+1 problem and eager loading, variable fonts, the difference between various image formats, modern website layouts/design, and semantic HTML/a myriad of HTML tags that I didn't know existed. I refreshed my memory of PHP, Laravel, MVC, Sqlite, building CICD pipelines, and AWS (mostly S3, CloudFront, Athena). More importantly, it was good practice designing a system from scratch.

Where To Start?

First, what do SSGs offer?

The biggest problems I have with SSGs are with templates, layouts, and themes. Handling themes on my own is no problem. I can easily style the site the way I want with Tailwind. Then what about templates and layouts? What about the other problems?

PHP has been the de facto HTML templating language since the 90s 1, and layouts are also a cinch — just nest your PHP files within other PHP files. PHP can handle Markdown conversion via 3rd party libraries, and it has a built-in web server via php -S addr:port (php artisan serve if you're using Laravel) 2.

That leaves building. For that, I use wget to save a static version of my site from the local server. Then I just need to push that to my S3 bucket. I have added all of my build and deploy scripts to Github Actions, so that my site builds and deploys upon pushing to github/main.

PHP/Laravel it is.

Site Structure

I want to keep things as simple as possible. The home page (chrisdempewolf.com) is just a list of my posts. Individual posts are accessed under chrisdempewolf.com/posts/{post}. Analogously for tags. Aside from that, I have an about page and my resume (see links at top). EDIT: I have since added a stats page built every Wednesday at midnight using GoAccess and Github Actions and an RSS feed.

For individual categories like recipes, notes, or projects, I plan to simply use tags. This way, I can add new categories without changing the site structure.

The Database

When running my local Laravel server (or the build server on Github), I use SQLite to store two entities — posts and tags along with a pivot table, post_tags. This is an ephemeral database that is rebuilt everytime I build my site. That begs the question, why even use a database?

I'm using a database for two reasons:

  1. A relational database, as the name implies, keeps track of relationships without any extra work on my part.
  2. Laravel expects to read from a database, so using Sqlite is as simple as setting DB_CONNECTION=sqlite.

Let's explore the first point.

Keeping Track of Relationships with a DB

There is a many-to-many relationship between posts and tags. Each tag has its own page that is dynamically generated with a list of all the posts associated with that tag, and for each post, there is a list of tags in the metadata.

This can be somewhat tricky to set up in memory. It would require scanning the metadata of each of my posts and building a map of the relationships. I'd then need to have logic to rebuild the map upon changes to posts or tags. A relational database takes care of all this for me.

On to the second point.

Laravel Expects to Read from a Database

I could use a flat JSON/Yaml file or in-memory object to store entities and their relationships. In addition to the extra processing mentioned above, I'd also have to customize my models to read from a JSON file, I couldn't define a nice, clean schema like I can with migrations, and I'd have to write my own query logic.

An Sqlite DB is a flat file. Mine is 192 KiB and builds in about 1.4 seconds. It readily solves all my problems with no extra processing, and Laravel is already well equipped to work with it. Doing anything else feels like going against the grain.

time begin; php artisan migrate:fresh; and php artisan db:seed; end
...
________________________________________________________
Executed in    1.40 secs      fish           external
   usr time  600.66 millis    0.56 millis  600.10 millis
   sys time  378.58 millis    2.69 millis  375.90 millis

Database Schema Overview

In a relational DB, many-to-many relationships are modeled with 3 tables3 — two for the two entities and a third to store the relationships between them. For example, say slug is the primary key for posts and tag (the tag name) is the primary key for the table tags. The third table, post_tags has two columns — slug and tag to indicate which posts are associated with which tags and which tags are associated with which posts.

Here's what that looks like.

The posts, tags, and post_tags tables, respectively :

CREATE TABLE "posts" (
                "slug" VARCHAR(255) PRIMARY KEY,
                "title" VARCHAR(255),
                "subhead" VARCHAR(255),
                "body" TEXT NOT NULL,
                "created_at" TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
                "updated_at" TIMESTAMP DEFAULT CURRENT_TIMESTAMP);

CREATE TABLE tags (
             "tag" VARCHAR(255) PRIMARY KEY,
             "description" VARCHAR(255));

CREATE TABLE "post_tags" (
                "slug" VARCHAR(255) NOT NULL,
                "tag" VARCHAR(255) NOT NULL,
                primary key ("slug", "tag"));

Each of these tables maps to a model in Laravel. I can then use Laravel's ORM, Eloquent.

The root directory of my site is just a method on my PostController:

public function index() {
    return view('posts', ['posts' => Post::all()]);
}

A simple SELECT *.

How can I get all posts for a tag? Here's the relevant portion from the PostController:

return view('post', ['post' => $post,
                     'tags' => PostTag::where('slug', $slug)->pluck('tag')]);

One line!

To be fair, there was a bit of work I had to do on the models to make them aware of the relationships between posts, tags, and post_tags. Enter Eloquent relationships.

Eloquent Relationships

Eloquent allows you to define relationships on your models via methods. It does this by providing various types associated with each type of relationship (one-to-one, one-to-many, many-to-many, etc.). To define a relationship, you need to implement a method on your model that returns the appropriate relationship type.

In my case, I implemented a method that returns BelongsToMany on both the Post model and the Tag model. Here's what that method looks like on the Tag model:

public function posts(): BelongsToMany
    {
        return $this->belongsToMany(
            Post::class,
            PostTag::class,
            'tag',
            'slug',
            'tag',
            'slug'
        );
    }

There's a lot of parameters here, but it's not too bad. The first parameter to belongsToMany tells Eloquent that a Tag can have many Post s. The second parameter (PostTag::class) tells Eloquent that Tag s are related to Post s via PostTag (the post_tags table) AKA a "pivot table"4.

The remaining fields are IDs. You don't always have to explicitly pass IDs to Eloquent relation methods. I do, because I have custom ID fields for all my tables. The third parameter tells Eloquent that tag is the foreign key on the post_tags table. The fourth argument tells Eloquent that slug is the foreign key on the posts_tags table for posts. The fifth argument tells Eloquent that tag is the key for the tags table. Finally, the sixth argument tells Eloquent that slug is the key for the posts table.

All this allows me to use that nice chain syntax from above: $posts = $tag->posts()->get();.

But that's not all. It also allows for something called "eager loading".

Avoiding N+1 with Eager Loading

Eager loading is Eloquent's way of averting the N+1 query problem. Here's how you use it.

Say I have the following code:

$posts = Post::all();

foreach ($posts as $post) {
    foreach ($post->tags as $tag) {
        echo $tag->name;
    }
}

This results in N+1 queries — 1 to fetch all posts and N to fetch the tags for each post. If you query the DB directly, you would just do a join, but Eloquent has no idea that we are going to fetch the tags for each post when we call Post::all();. This is, in fact, a common problem with all ORMs.

Now that we've defined our relationships on each model, we can tell Eloquent that we are going to fetch each post's tags (i.e, use eager loading).

$posts = Post::with('tags')->get();

foreach ($posts as $post) {
    foreach ($post->tags as $tag) {
        echo $tag->name;
    }
}

The key thing to note here is ::with('tags'). This makes Eloquent eagerly load the tags along with the posts. Instead of running N+1 queries, we're now only running 1 query5!

Eloquent does this by attaching an array of Tag s to each Post when you call Post::with('tags')->get(). You can see this by running php artisan tinker and comparing the two outputs—lazy and eager.

Good point... Eager loading is definitely not necessary for such a tiny site. It wasn't too much extra work, and I thought it was a good learning experience. 🤷🏻‍♂️

Seeding and Migrations

Seeding

As mentioned, I store all of my posts in a database. This allows me to easily handle the many-to-many relationship between posts and tags. But I need to actually import the posts.

I realize it's a huge anti-pattern, but so far I've been using DB seeders for this purpose. It allows me to programmatically load my posts without leaving artisan while taking advantage of Laravel's built-in seeding functionality.

However, I would like to migrate away from this, since this is not the intended purpose of seeders. Instead, I plan to create a custom artisan command to update my posts table to reflect my resources/posts directory. This will remove the anti-pattern while allowing me to continue using artisan.

Migrations

My blog is a single-person project with an ephemeral database that can be (and is) rebuilt in about a second, so migrations don't serve their usual purpose of version-controlled schema changes. But they're still the standard way to tell Laravel how to construct my database. Hence, I have migrations to create the posts, tags, and post_tags tables.

I've gone ahead and created new migrations when making schema changes (adding a description column to my tags table, for example), though I suppose I could've just kept a single definitive migration file that defines the whole schema. I decided to not deviate from tradition.

return new class extends Migration
{
    public function up(): void
    {
        Schema::table('tags', function (Blueprint $table) {
            $table->text('description')->nullable();
        });
    }

    public function down(): void
    {
        Schema::table('tags', function (Blueprint $table) {
            $table->dropColumn('description');
        });
    }
};

Creating a New Post

I made a custom Artisan command to make a new post: php artisan make:post <title> <tags>. For this post, I ran php artisan make:post "Building a Static Site from Scratch" "tech php". This slugifys the title and creates a new file, resources/posts/building-a-static-site-from-scratch.md.

After the new post has been imported to the DB, I can go to the URL <host>/posts/building-a-static-site-from-scratch.

It loads the post view, which is a Blade template:

@extends('layout')

@section('title')
    {{ $post->title }}
@endsection
@section('content')
    {!! $post->body !!}
@endsection

Building and Deployment

Building

I want a static site. Hosting them is cheap (free), and as fast and secure as you can possibly be. In order to use Laravel to make a static site, I use wget to save a static version from the local server. The command looks like this:

wget \
--directory-prefix=output/ \
--html-extension \
--convert-links \
--recursive \
--level=10 \
--page-requisites \
--timestamping \
--adjust-extension \
--no-host-directories \
http://localhost:8000

Here's an explanation of the options used:

Not the prettiest build method, but, in my opinion, it's worth it to have complete control over my site.

Deployment

After the output directory is built, I run aws s3 sync ./output s3://chrisdempewolf.com --size-only --delete to sync my S3 bucket. I save the output of this command to a log file. This way, I can parse the log file to see which files changed, so I know which paths to invalidate in Cloudfront, so I don't have to invalidate /*.

Here's the relevant portion of my Github Actions config:

- name: Deploy to S3
  run: |
    aws s3 sync ./output s3://chrisdempewolf.com --size-only --delete 2>&1 | sed 's|\r|\n|g' | tee s3-log.txt
  shell: bash
- name: Invalidate cache
  run: |
    aws cloudfront create-invalidation --distribution-id FOOBAR --paths $(cat s3-log.txt | awk '$1 ~ /upload/ {print $4}' | sed 's|s3://chrisdempewolf.com||' | tr '\n' ' ')
  shell: bash

Next Steps

Characters

Not a technical consideration, but I'm adding a few characters to my blog for dialogues, to help clarify things, and to liven things up a bit. I've seen a few other blogs implement this idea and I usually think it's a welcome addition.

MDX

Aside from a car, MDX is a combination of Markdown and JSX. So you can use React components in your Markdown.

I have a few things like these^ dialogues, blockquotes with sources, images with captions, etc. that Markdown can't handle well 6. Heretofore, I just manually copy-and-paste these when I need them. A parametrized component would be cool, though.

UPDATE: I found out about Laravel Components. Components allow me to enter parametrized blocks of HTML while writing Markdown. I have since made components for each character, images, and blockquotes with a caption. I also made IntelliJ live templates for each of these, so I can just type ximg while writing a post and IntelliJ inserts the parameterized template.

I needed to tell the PostController to render Blade. To do that, I pass the entire post as a string to Blade::render($body, [], true). Et voilà.

Conclusion

This certainly is not the most popular method for building static sites, but I like it, and it works for me. For once, I feel like I am in complete control over all aspects of my site. I can easily add new features and change my site's layout or theme. Plus, I learned (and am learning) a lot.

And the IKEA effect is real. I'm far prouder of this blog than I ever was of my Hugo and Jekyll blogs.

Footnotes


  1. Blade makes this even easier. And you can still use raw PHP if you need. ↩︎

  2. There are indeed PHP SSGs, but the whole reason I switched to PHP was to avoid off-the-shelf SSGs. ↩︎

  3. Or they should be if your DB is properly normalized. ↩︎

  4. It's convention in Laravel for model names to be singular, and table names to be plural (Post and posts). This makes sense, because a table holds many rows, while a model represents a single row from that table. ↩︎

  5. If you want to see this live on your site, install the DebugBar and click on the DB tab. It will show you all the queries made while fetching the current view! ↩︎

  6. I know there are some Markdown extensions that fix some of these problems (I've used them in a previous project). I might give them a shot, but I honestly don't have a lot of confidence in Parsedown. ↩︎


Return to top