Chi San Fung tomathosauce

## gist:f0ef85a2123a2e1fcf8052dcf09eef90

      
              1 file
            
          
              3 forks
            
          
              12 comments
            
          
              20 stars
            
          
                amad-person
                / gist:f0ef85a2123a2e1fcf8052dcf09eef90
            
            
              Last active
              August 12, 2023 17:38
            
              
                Bypass CSP restrictions in create-react-app Chrome extensions
              
          
    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.

  
## pom.xml
<?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>

## make-sounds.html
<!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();

## database.rules.json

// No Security

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

## ubuntu-cli-install-android-sdk.sh
#!/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

## thisamericanlive-archive.js
// 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;

## The_Jaunt.md

      
              1 file
            
          
              13 forks
            
          
              17 comments
            
          
              175 stars
            
          
                Schemetrical
                / The_Jaunt.md
            
            
              Last active
              June 30, 2024 13:37
            
              
                The Jaunt by Stephen King
              
          
    Chapter 1

"This is the last call for Jaunt-701," the pleasant female voice echoed through the Blue Concourse of New York's Port Authority Terminal. The PAT had not changed much in the last three hundred years or so - it was still gungy and a little frightening. The automated female voice was probably the most plesant thing about it. "This is Jaunt Service to Whitehead City, Mars," the voice continued. "All ticketed passengers should now be in the Blue Concourse sleep lounge. Make sure your validation papers are in order. Thank you."The upstairs lounge was not at all grungy. It was wall-to-wall carpeted in oyster gray. The walls were an eggshell white and hung with plesant nonrepresentational prints. A steady, soothing progression of colors met and swirled on the ceiling. There were one hundred couches in the large room, neatly spaced in rows of ten. Five Jaunt attendants circulate, speakingin low, cherry voices and offering glasses of milk. At one side of the room was the entranceway, flanked by armed guar

  
## nodejs_db_with_restapi.js
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);
});


## postgres-cheatsheet.md

      
              1 file
            
          
              1139 forks
            
          
              66 comments
            
          
              3530 stars
            
          
                Kartones
                / postgres-cheatsheet.md
            
            
              Last active
              July 23, 2024 09:14
            
              
                PostgreSQL command line cheatsheet
              
          
    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)
	<?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>
	<!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();
	#!/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
	// 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;
	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);
	});