BlueT - Matthew Lien - 練喆明 bluet

## mariadb-temporal-table.md

      
              1 file
            
          
              3 forks
            
          
              0 comments
            
          
              4 stars
            
          
                bluet
                / mariadb-temporal-table.md
            
            
              Last active
              July 6, 2020 08:29
            
              
                Versioning database data with MariaDB Temporal Table
              
          
    MariaDB Temporal Table


hackmd version: https://hackmd.io/Iwe0MVlwRpOMZ70W1ZwPtQ?view
gist version: https://gist.github.com/bluet/5ebdfb65f486e01c13175dcdedf27906

[TOC]
Description

This is a HOWTO for database record/value version control, not for schema.

  
## Database Naming Convention and Data Warehouse Design Principles.md

      
              1 file
            
          
              8 forks
            
          
              0 comments
            
          
              29 stars
            
          
                bluet
                / Database Naming Convention and Data Warehouse Design Principles.md
            
            
              Last active
              November 13, 2023 13:12
            
              
                Database Naming Convention and Data Warehouse Design Principles
              
          
    Database Naming Convention and Data Warehouse Design Principles


hackmd version: https://hackmd.io/1eeNAS1oQuSvMA0q6y_QuA?view
gist version: https://gist.github.com/bluet/23e7697b86144561c4a3d804903d059d

[TOC]
ETL: From Data Lake to Data Warehouse


Extract 部份：取出要的資料、去雜訊、資料標準化、parsing...
Transform：aggregation、mapping 、combined、Change Data Types


## eth-pubkey-tests.js
/* 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];
	/* 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];