csharpforevermore

Frontend Development

Looking for something else? Take a look at the awesome collection of other awesome lists.

• Guides
  • Bento: a collection of guides for web development.
  • Hack Design: An easy to follow design course for people who do amazing things.
  • Designer School: A group of passionate professionals teaching web development
  • Web Style Guide - 3^rd Edition covers all the elements from CSS and typography to HTML and the structure of prose.
• Talks To Help You Become A Better Front-End Engineer In 2013

csharpforevermore

csharpforevermore

import glob
import sys
import pandas


def read_filenames(names):
    for arg in names:
        if "*" in arg:
            for file in glob.glob(arg):
                yield file

csharpforevermore

import numpy
import pandas

numpy.random.seed(0)
index1 = pandas.MultiIndex.from_product(
    [['A'], ['b'], ['one', 'two']],
    names=['City', 'Street', 'House']
)

index2 = pandas.MultiIndex.from_product(

csharpforevermore

DB

SQL Cheatsheet

• https://github.com/enochtangg/quick-SQL-cheatsheet - A quick reminder of all relevant SQL queries and examples on how to use them.

DB Diagrams

• https://dbdiagram.io/ - A free and simple tool to draw ER diagrams by just writing code.

Misc

csharpforevermore

SELECT STRAIGHT_JOIN categories.id, categories.title, categories.game_count, categories.display_order FROM `categories` INNER JOIN `category_namespaces` ON `category_namespaces`.`category_id` = `categories`.`id` WHERE `categories`.`type` IN ('ClickJogos::GameCategory') AND `categories`.`published` = 1 AND (category_namespaces.namespace = 'jgo') ORDER BY 
CASE
WHEN categories.id LIKE '447%' THEN 1
WHEN categories.id LIKE '448%' THEN 2
ELSE 3
END, categories.game_count DESC;

csharpforevermore

<#
Rename-Files.ps1
#>


# Find all wmv-files with a string "oldstring" and replace "oldstring" with "newstring" in the filename
Get-ChildItem *.wmv -Filter "*oldstring*" | ForEach { Rename-Item $_ -NewName $_.Name.Replace("oldstring","newstring") }


# Change the file extension of all .jpeg files to .jpg