Jukka Tupamäki jukkatupamaki

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

Switch file's language mode to TypeScript React
Switch file's language mode back to JavaScript React

The error should be gone.

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.

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

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

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.

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

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:

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;

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

	{
	"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",

	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');