Miscellaneous query optimizations on appview (#1766) #721

	name: build-and-push-bsky-aws
	on:
	push:
	branches:
	- main
	env:
	REGISTRY: ${{ secrets.AWS_ECR_REGISTRY_USEAST2_PACKAGES_REGISTRY }}
	USERNAME: ${{ secrets.AWS_ECR_REGISTRY_USEAST2_PACKAGES_USERNAME }}
	PASSWORD: ${{ secrets.AWS_ECR_REGISTRY_USEAST2_PACKAGES_PASSWORD }}
	IMAGE_NAME: bsky-app-view

	jobs:
	bsky-container-aws:
	if: github.repository == 'bluesky-social/atproto'
	runs-on: ubuntu-latest
	permissions:
	contents: read
	packages: write
	id-token: write

	steps:
	- name: Checkout repository
	uses: actions/checkout@v3

	- name: Setup Docker buildx
	uses: docker/setup-buildx-action@v2

	- name: Log into registry ${{ env.REGISTRY }}
	uses: docker/login-action@v2
	with:
	registry: ${{ env.REGISTRY }}
	username: ${{ env.USERNAME}}
	password: ${{ env.PASSWORD }}

	- name: Extract Docker metadata
	id: meta
	uses: docker/metadata-action@v4
	with:
	images: \|
	${{ env.REGISTRY }}/${{ env.IMAGE_NAME }}
	tags: \|
	type=sha,enable=true,priority=100,prefix=,suffix=,format=long

	- name: Build and push Docker image
	id: build-and-push
	uses: docker/build-push-action@v4
	with:
	context: .
	push: ${{ github.event_name != 'pull_request' }}
	file: ./services/bsky/Dockerfile
	tags: ${{ steps.meta.outputs.tags }}
	labels: ${{ steps.meta.outputs.labels }}
	cache-from: type=gha
	cache-to: type=gha,mode=max

Provide feedback