Chi San Fung tomathosauce

PSQL

Magic words:

psql -U postgres

Some interesting flags (to see all, use -h or --help depending on your psql version):

-E: will describe the underlaying queries of the \ commands (cool for learning!)
-l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)

While building a React Chrome extension using the create-react-app utility (v2.x), I came across the following error on loading my unpacked extension:

Refused to execute inline script because it violates the following Content Security Policy directive: “script-src ‘self’
blob: filesystem: chrome-extension-resource:”. Either the ‘unsafe-inline’ keyword, a hash (‘sha256-
GgRxrVOKNdB4LrRsVPDSbzvfdV4UqglmviH9GoBJ5jk=’), or a nonce (‘nonce-…’) is required to enable inline execution.

Basically, this error arises as Chrome (or almost any modern browser) will not allow inline scripts to get executed. This CSP restriction resulted in the above error as the build script in create-react-app bundles the .js files in <script> tags in the <body> of index.html.

	var sqlite3 = require('sqlite3').verbose();
	var db = new sqlite3.Database('data/demodb02');

	db.serialize(function() {
	db.run("CREATE TABLE IF NOT EXISTS counts (key TEXT, value INTEGER)");
	db.run("INSERT INTO counts (key, value) VALUES (?, ?)", "counter", 0);
	});

	// Usage:
	// 1. Visit http://www.thisamericanlife.org/radio-archives
	// 2. Paste this script into the developer console of your browser.
	// 3. Wait...
	// 4. Copy-paste the resulting XML into a file.
	//
	(function(){
	var jQuery = window.jQuery;

	var doc = document;

	#!/bin/bash

	# Thanks to https://gist.github.com/wenzhixin/43cf3ce909c24948c6e7
	# Execute this script in your home directory. Lines 17 and 21 will prompt you for a y/n

	# Install Oracle JDK 8
	add-apt-repository ppa:webupd8team/java
	apt-get update
	apt-get install -y oracle-java8-installer
	apt-get install -y unzip make # NDK stuff


	// No Security

	{
	"rules": {
	".read": true,
	".write": true
	}
	}

	<!DOCTYPE html>
	<html>
	<head><title>SOUND</title></head>
	<body>
	<div>Frequence: <span id="frequency"></span></div>
	<script type="text/javascript">

	var audioCtx = new (window.AudioContext \|\| window.webkitAudioContext)();
	var oscillatorNode = audioCtx.createOscillator();
	var gainNode = audioCtx.createGain();

	<?xml version="1.0" encoding="UTF-8"?>
	<project xmlns="http://maven.apache.org/POM/4.0.0"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
	<modelVersion>4.0.0</modelVersion>

	<groupId>pl.lafk</groupId>
	<artifactId>#APP</artifactId>
	<version>0.1</version>
	<name>#NAME</name>