Tobi tobilg

Built this as one off script to post a bunch of records to bluesky based on a given csv to bootstrap https://bsky.app/profile/cdk.dev

sonnet 3.5 wrote all the code

How we incorporate next and cloudfront (2018-04-21)

Feel free to contact me at [email protected] or tweet at me @statisticsftw

This is a rough outline of how we utilize next.js and S3/Cloudfront. Hope it helps!

It assumes some knowledge of AWS.

Goals

Serverless plugin author's cheat sheet

This cheat sheet provides a detailed overview of the exposed lifecycle events and available commands (and entrypoints) of the Serverless framework, that can be hooked by plugins (internal and external ones). The document is structured by the commands invoked by the user.

Lifecycle events are shown as the globally available outer events (all providers) and sub lifecycle events that are provider specific in the called order. Currently only the AWS provider is shown. If you have information about the other provider,

	-- Query the API directly and flatten the nested JSON structure
	WITH raw_data AS (
	SELECT * FROM read_json_auto('https://public.api.bsky.app/xrpc/app.bsky.feed.getAuthorFeed?actor=did:plc:edglm4muiyzty2snc55ysuqx&limit=10')
	),
	unnested_feed AS (
	SELECT unnest(feed) as post_data FROM raw_data
	)
	SELECT
	-- Post basics
	post_data.post.uri as post_uri,

	INSTALL AWS;
	LOAD AWS;
	CALL load_aws_credentials();
	CREATE TABLE ct_raw AS SELECT * FROM read_json('s3://YOUR_CT_BUCKET_WITH_A_DATE_PREFIX/*.gz', maximum_depth=2);
	CREATE TABLE ct as SELECT unnest(Records) as Event FROM ct_raw;
	CREATE TABLE cloudtrail_events AS SELECT json_extract_string(event, '$.eventVersion') AS eventVersion,
	json_extract_string(event, '$.userIdentity.type') AS userType,
	json_extract_string(event, '$.userIdentity.principalId') AS principalId,
	json_extract_string(event, '$.userIdentity.arn') AS userArn,
	json_extract_string(event, '$.userIdentity.accountId') AS accountId,

	WITH generate_date AS (
	SELECT CAST(RANGE AS DATE) AS date_key
	FROM RANGE(DATE '2009-01-01', DATE '2013-12-31', INTERVAL 1 DAY)
	)
	SELECT date_key AS date_key,
	DAYOFYEAR(date_key) AS day_of_year,
	YEARWEEK(date_key) AS week_key,
	WEEKOFYEAR(date_key) AS week_of_year,
	DAYOFWEEK(date_key) AS day_of_week,
	ISODOW(date_key) AS iso_day_of_week,

	---

	#
	# This template example assumes a UserPool and UserPoolDomain exist.
	# The function of this is to produce a custom resource with an attribute
	# that can be referenced for DNSName of an Route53::RecordSet AliasTarget.
	#
	# AliasTarget:
	# HostedZone: Z2FDTNDATAQYW2
	# DNSNAME: !GetAtt UPDomain.CloudFrontDistribution

	<?xml version="1.0" encoding="UTF-8"?>

	<opml version="1.0">
	<head>
	<title>AWS RSS feeds 2019-04-22</title>
	</head>
	<body>
	<outline text="AWS" title="AWS">
	<outline type="rss" text="Infrastructure & Automation" title="Infrastructure & Automation" xmlUrl="https://aws.amazon.com/blogs/infrastructure-and-automation/feed/" htmlUrl="https://aws.amazon.com/blogs/infrastructure-and-automation/"/>
	<outline type="rss" text="AWS Developer Blog" title="AWS Developer Blog" xmlUrl="http://feeds.feedburner.com/AwsDeveloperBlog" htmlUrl="https://aws.amazon.com/blogs/developer/"/>

	/*
	This example was built using standard create-react-app out of the box with no modifications or ejections
	to the underlying scripts.

	In this example, i'm using Google as a social provider configured within the Cognito User Pool.

	Each step also represents a file, so you can see how I've chosen to organize stuff...you can do it however
	you'd like so long as you follow the basic flow (which may or may not be the official way....but its what I found that works.
	The docs are pretty horrible)

-module.exports.handler = (event, context, callback) => {
-  let position = event.position || 0;
-  do {
-    ... // process the tasks in small batches that can be completed in, say, less than 10s
-    // when there's less than 10s left, stop
-  } while (position < totalTaskCount && context.getRemainingTimeInMillis() > 10000);
-  if (position < totalTaskCount) {
-    let newEvent = Object.assign(event, { position });