lassegit

Performance optimized SQL query for MySQL 8

Original SQL query: https://www.reddit.com/r/SQLOptimization/comments/1jdd3zn/query_optimizations/

SQL optimizer (free): https://app.sqlai.ai/generators/sql-optimizer

-- Final optimized SQL query with output identical to the original
SELECT
  l.id,

lassegit

const bannedColos = [
  // Hong Kong/Macau
  'HKG',
  'MFM',
  // China
  'CGD',
  'FUO',
  'FOC',
 'CAN',

lassegit

#!/bin/sh

# Install docker
yum update -y
amazon-linux-extras install docker -y
service docker start
usermod -a -G docker ec2-user
systemctl enable docker

# Install docker-compose

lassegit

for i in *flac;do of="${i/.flac/.m4a}"; ffmpeg -i "${i}" -vn -acodec aac -b:a 320k -f mp4 -y "${of}";done

lassegit

Apply a list of functions to a value (right to left)

const compose = (...fns) => x => fns.reduceRight((y, f) => f(y), x);

const toSlug = compose(
  encodeURIComponent,
  join('-'),
  map(toLowerCase),
  split(' ')
);

lassegit

Bøger - Bücher:

• Viktor Frankl: Wer ein Warum zu leben hat: Lebenssinn und Resilienz
• Viktor Frankl: Ärztliche Seelsorge: Grundlagen der Logotherapie und Existenzanalyse
• Ian Kershaw: Das Ende

lassegit

Eric Elliott's "Composing Software" Series

A collection of links to the excellent "Composing Software" series of medium stories by Eric Elliott.

• The Rise and Fall and Rise of Functional Programming
• Why Learn Functional Programming in JavaScript?
• A Functional Programmer’s Introduction to JavaScript
• Higher Order Functions
• Reduce
• Functors & Categories
• [Composing

lassegit

Isolate the redux datalayer in a separate redux/ folder within your src/ folder:

src/
  |-components/
  |-containers/
  |-utils/
  |-redux/
    |-actions/
    |-reducers/

lassegit

Install dependencies

yarn add -D eslint babel-eslint eslint-config-airbnb eslint-config-prettier eslint-plugin-codebox eslint-plugin-import eslint-plugin-jsx-a11y eslint-plugin-prettier eslint-plugin-react husky prettier lint-staged eslint-plugin-react-hooks

Add to package.json scripts:

"scripts": {
  "lint": "yarn lint:js",
  "lint:fix": "./node_modules/eslint/bin/eslint.js . --fix --cache",
  "lint:js": "./node_modules/eslint/bin/eslint.js . --cache",
  "prepush": "yarn lint"

lassegit

import React from 'react';

const AppContext = React.createContext();

class AppContextProvider extends React.Component {
  state = {};

  render() {
    return (
      <AppContext.Provider value={this.state}>