- hackmd version: https://hackmd.io/1eeNAS1oQuSvMA0q6y_QuA?view
- gist version: https://gist.github.com/bluet/23e7697b86144561c4a3d804903d059d
[TOC]
- Extract 部份:取出要的資料、去雜訊、資料標準化、parsing...
- Transform:aggregation、mapping 、combined、Change Data Types
[TOC]
/* eslint-disable no-console */ | |
const EthCrypto = require("eth-crypto"); | |
const sigUtil = require("@metamask/eth-sig-util"); | |
const ethUtil = require("ethereumjs-util"); | |
async function test (provider, selectedAccount) { | |
// eslint-disable-next-line no-undef | |
const web3 = new Web3(provider); | |
// const accounts = await web3.eth.getAccounts(); | |
// selectedAccount = accounts[0]; |
# Replace [YOUR_DOMAIN_NAME] by your real domain | |
server.modules += ( "mod_setenv" ) # For HSTS | |
$SERVER["socket"] == "0.0.0.0:443" { | |
ssl.engine = "enable" | |
ssl.pemfile = "/etc/letsencrypt/live/[YOUR_DOMAIN_NAME]/combined.pem" | |
ssl.ca-file = "/etc/letsencrypt/live/[YOUR_DOMAIN_NAME]/fullchain.pem" | |
ssl.dh-file = "/etc/ssl/certs/dhparam.pem" |
[TOC]
This is a HOWTO for database record/value version control, not for schema.
I make some assumptions, and make no claims in how well supported this is or ever will be. I wanted to avoid using VMs because i've been working in containers for the last half decade. It made sense to just skip the middle man and use a machine type container system to run my minikube workloads.
Simply put, Juju does a fantastic job; but to stay objective I wanted to achieve minikube in LXD
as a functional alternative to juju deploy kubernetes-core
, or using KVM/VirtualBox in this solution.
pragma solidity ^0.4.16; | |
library SafeMath { | |
/** | |
* @dev Multiplies two numbers, reverts on overflow. | |
*/ | |
function mul(uint256 _a, uint256 _b) internal pure returns (uint256) { | |
// Gas optimization: this is cheaper than requiring 'a' not being zero, but the | |
// benefit is lost if 'b' is also tested. |
-- show running queries (pre 9.2) | |
SELECT procpid, age(query_start, clock_timestamp()), 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(query_start, clock_timestamp()), usename, query | |
FROM pg_stat_activity | |
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' |
{ Winters: 6.446, | |
Rasmussen: 4.8934, | |
Levy: 4.8123, | |
Miriam: 4.8345, | |
Brenda: 4.8083, | |
Elma: 4.8371, | |
Clarice: 4.5523, | |
Alana: 4.3095, | |
Patton: 5.2737, | |
Scott: 4.9223, |
I hereby claim:
To claim this, I am signing this object:
# Add "get_board_info" helper | |
$app->helper( | |
get_board_info => sub { | |
my $c = shift; | |
my $data_id = shift; | |
my @keys = @_; | |
my $aecv = AE::cv; | |
my %data; | |
$aecv->begin (sub { shift->send(\%data) }); # Outer CV |