Leonardo Ferrari leonardo2204

## S3-Static-Sites.md

      
              1 file
            
          
              99 forks
            
          
              58 comments
            
          
              533 stars
            
          
                bradwestfall
                / S3-Static-Sites.md
            
            
              Last active
              April 10, 2024 16:40
            
              
                Use S3 and CloudFront to host Static Single Page Apps (SPAs) with HTTPs and www-redirects. Also covers deployments.
              
          
    S3 Static Sites

⚠ This post is fairly old. I don't keep it up to date. Be sure to see comments where some people have posted updates
What this will cover

Host a static website at S3
Redirect www.website.com to website.com
Website can be an SPA (requiring all requests to return index.html)
Free AWS SSL certs
Deployment with CDN invalidation


## exclude.sql
CREATE EXTENSION btree_gist;

CREATE TABLE room_reservations (
    room_id integer,
    reserved_at timestamptz,
    reserved_until timestamptz,
    canceled boolean DEFAULT false,
    EXCLUDE USING gist (
        room_id WITH =, tstzrange(reserved_at, reserved_until) WITH &&
    ) WHERE (not canceled)
	CREATE EXTENSION btree_gist;

	CREATE TABLE room_reservations (
	room_id integer,
	reserved_at timestamptz,
	reserved_until timestamptz,
	canceled boolean DEFAULT false,
	EXCLUDE USING gist (
	room_id WITH =, tstzrange(reserved_at, reserved_until) WITH &&
	) WHERE (not canceled)