Skip to content

Instantly share code, notes, and snippets.

@mr-linch
mr-linch / create-read-only-user.sql
Last active March 27, 2025 11:59
👁‍🗨 PostgreSQL: Create readonly user
-- create user (e.g. metabase)
create user metabase with encrypted password 'password';
-- allow user connect to db
grant connect on database site to metabase;
-- allow user access to schema
grant usage on schema public to metabase;
-- grant select on existing tables
@GiambiHuang
GiambiHuang / CustomContext.js
Last active October 30, 2019 05:16
State Management with React hooks and mock react-promise-middleware
import React, { useReducer, useCallback, useContext } from 'react';
const initialState = {
data: '',
isPending: false,
};
export const constant = {
FETCH_DATA: 'FETCH_DATA',
FETCH_DATA__PENDING: 'FETCH_DATA__PENDING',
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
<plist version="1.0">
<dict>
<key>Label</key>
<string>com.demo.daemon.plist</string>
<key>StartCalendarInterval</key>
<dict>
<key>Weekday</key>
@danazkari
danazkari / Smart Contracts with React (how to be the coolest kid on the block).md
Last active June 6, 2023 20:49
Smart Contracts with React (how to be the coolest kid on the block).md

Smart Contracts with React (how to be the coolest kid on the block)

Recommended snack and song:

220ml of dark roasted full bodied coffee brewed in french press accompanied by a banana while listening to [Liquid Tension Experiment]

tl;dr: You can go ahead and clone [this repo], it's got the end result of this in-depth tutorial bellow.

Here's what we will be doing for becoming smart-contract heroes! - Install the dev environment plus MetaMask. - Develop a very simple voting smart contract.

@haskaalo
haskaalo / tarcheatsheet.md
Last active March 15, 2025 23:47
Tar usage / Tar Cheat Sheet

Tar Usage / Cheat Sheet

Compress a file or directory

e.g: tar -czvf name-of-archive.tar.gz /path/to/directory-or-file

  • -c: Create an archive.
  • -z: Compress the archive with gzip.
  • -v: makes tar talk a lot. Verbose output shows you all the files being archived and much.
  • -f: Allows you to specify the filename of the archive.
@ggregoire
ggregoire / README.md
Created October 13, 2016 20:35
React: stopPropagation VS nativeEvent.stopImmediatePropagation

TL;DR

If you mix JS event listeners and React event listeners, you need

event.nativeEvent.stopImmediatePropagation()

Scenario

@josephspurrier
josephspurrier / values_pointers.go
Last active February 27, 2025 15:19
Golang - Asterisk and Ampersand Cheatsheet
/*
********************************************************************************
Golang - Asterisk and Ampersand Cheatsheet
********************************************************************************
Also available at: https://play.golang.org/p/lNpnS9j1ma
Allowed:
--------
p := Person{"Steve", 28} stores the value
@rgreenjr
rgreenjr / postgres_queries_and_commands.sql
Last active May 12, 2025 02:24
Useful PostgreSQL Queries and Commands
-- show running queries (pre 9.2)
SELECT procpid, age(clock_timestamp(), query_start), usename, current_query
FROM pg_stat_activity
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%'
ORDER BY query_start desc;
-- show running queries (9.2)
SELECT pid, age(clock_timestamp(), query_start), usename, query
FROM pg_stat_activity
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'