jukkatupamaki

AWS CDK

Blog posts

https://kvs-vishnu23.medium.com/is-aws-cdk-better-than-terraform-85194e7a42cd

• A neat explanation of how CDK works compared with Terraform
• The examples demonstrate well how HCL can be a bit clumsy

https://jsherz.com/aws/cdk/terraform/2023/04/29/terraform-vs-cdk.html

• Biggest concern regarding CDK seems to be state management and people changing managed infrastructure manually in AWS Console leading to CDK not knowing the truth

jukkatupamaki

Asserting async errors with Jest

Question: How to test what kind of error an async function throws and how to apply matchers to the rejected value?

Answer: You need to await the expect call and then inspect the rejects property of the returned Jest object.

async function doSomethingAsync(value?: string) {
  if (!value) throw new MyFancyError('Some error text');
 return value;

jukkatupamaki

How to make Auth0 Lock and Cross-Origin Authentication work in a single page app e.g. React / Angular / Ember etc.

3rd party cookies have been disabled in most browsers and it affects apps that use the Auth0 Lock.

Without proper configuration (which is pretty hard to find from Auth0's documentation) the app won't let users log in. This took me a hours of work to figure out how the changes should be implemented.

So what next

To fix the problem you need the following:

jukkatupamaki

How to convert a Heroku Postgres dump to plain text

Sometimes you need to search within backups but don't want to restore the dump to a real database.

Backup files produced by Heroku Postgres are compressed. So they need to be converted to plain text.

1. Download a backup file and name it e.g. input.dump
2. Convert input.dump to plain text using pg_restore:

jukkatupamaki

How to use check constraints with Knex.js and Postgres

Check constraints are useful for validating INSERT and UPDATE queries. With Knex.js, you have to use raw calls to add or drop constraints.

Add a constraint to check that my_column in my_table is at least 0:

knex.schema.raw(`
  ALTER TABLE
    my_table
 ADD CONSTRAINT

jukkatupamaki

Open psql and connect to your database.

Export a query to a CSV file

Use the \copy command to export data from a remote or local database to a local CSV file.

\copy (select id, name from products) to 'my-local-file.csv' csv header

jukkatupamaki

Commands:

• pbcopy - Copy to clipboard
• pbpaste - Paste from clipboard

Example: Pipe filenames to clipboard

$ ls -1 | pbcopy 

These commands are useful if copied text should be 100% the same as the output. Selecting and copying text in terminal always has more whitespace than needed or one or two characters are missing. So this is a perfect solution to avoid those.

jukkatupamaki

If <></> triggers a syntax error in Visual Studio Code, try the following:

1. Switch file's language mode to TypeScript React
2. Switch file's language mode back to JavaScript React

The error should be gone.

jukkatupamaki

import { Knex } from 'knex'

export async function up(knex: Knex): Promise<any> {
  await knex.schema.createTable('test_setup', (table: Knex.TableBuilder) => {
    table.integer('foobar');
  });
}

export async function down(knex: Knex): Promise<any> {
  await knex.schema.dropTable('test_setup');

jukkatupamaki

{
  "name": "react-example-app",
  "version": "1.0.0",
  "description": "Demonstrates usage of React, React Router and Express.",
  "main": "server.js",
  "scripts": {
    "test": "echo \"Error: no test specified\" && exit 1",
    "start": "node server.js",
    "ensure-dirs": "mkdirp frontend\\dist && mkdirp frontend\\dist\\scripts && mkdirp frontend\\dist\\styles && mkdirp frontend\\dist\\assets",
    "prewatch": "npm run ensure-dirs && npm run copy-assets && npm run copy-index",