Paul Logston logston

## PDL-Advanced-SQL-Questions.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                logston
                / PDL-Advanced-SQL-Questions.md
            
            
              Last active
              March 26, 2024 21:01
            
          
    Warm Ups

How can we look around the data?

\l
\dt
\d

What does the users table look like?

  
## custom_build.sh
#!/usr/bin/env bash

# Exit on error.
set -o errexit

# Install reqs as usual.
pip install -r requirements.txt

# Run migrations if needed.
python manage.py migrate

## fill-form.py
import sys
import time

from selenium import webdriver
from selenium.webdriver.common.by import By


def main(url):

    driver = webdriver.Firefox()

## Unordered Insertion Sort.ipynb

      
              1 file
            
          
              0 forks
            
          
              1 comment
            
          
              0 stars
            
          
                logston
                / Unordered Insertion Sort.ipynb
            
            
              Last active
              September 2, 2023 19:05
            
          
      Sorry, something went wrong. Reload?
      Sorry, we cannot display this file.
      Sorry, this file is invalid so it cannot be displayed.
      
          Viewer requires iframe.
      
    
## MultilineDocs.java
/**
 * An example of docs using multiline comments.
 **/
public class MultilineDocs {
   /**
    * A simple method.
    *
    * @param arg1 An arg.
    **/
   public void aMethod(int arg1) {} // end aMethod()

## config.sh
#!/bin/bash
echo 'PATH=${PATH}:/usr/sbin' >> ~/.profile
source ~/.profile
sudo apt update && sudo apt-get install -y tcpdump nmap dnsutils tmux

## send-server-codes.py
"""
Back up at https://gist.github.com/logston/088bf6e2435fe8ecac41ab18a93a012a
"""
import base64
import csv
import getpass
import smtplib
import time
import random
from email.mime.multipart import MIMEMultipart

## docker-compose.yml
version: '3.2'

services:
    cdb_node_1:
        container_name: cdb_node_1
        image: cockroachdb/cockroach:v20.1.3
        volumes:
           - cdb_node_1:/cockroach/cockroach-data
        command: start --insecure --join=cdb_node_1,cdb_node_2,cdb_node_3 --advertise-addr=cdb_node_1
        ports:

## DoubleClickVim.scpt
on run {input}
	set the_path to POSIX path of input
	set cmd to "vim " & quoted form of the_path
	tell application "Terminal"
		activate
		tell application "System Events"
			keystroke "b" using {control down}
			delay 0.1
			keystroke "c"
			keystroke return

## map.html
<!DOCTYPE html>
<html lang="en">
  <head>
    <!-- Required meta tags -->
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">

    <!-- Bootstrap CSS -->
    <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/css/bootstrap.min.css" integrity="sha384-Gn5384xqQ1aoWXA+058RXPxPg6fy4IWvTNh0E263XmFcJlSAwiGgFAW/dAiS6JXm" crossorigin="anonymous">
	#!/usr/bin/env bash

	# Exit on error.
	set -o errexit

	# Install reqs as usual.
	pip install -r requirements.txt

	# Run migrations if needed.
	python manage.py migrate
	import sys
	import time

	from selenium import webdriver
	from selenium.webdriver.common.by import By


	def main(url):

	driver = webdriver.Firefox()
	/**
	* An example of docs using multiline comments.
	**/
	public class MultilineDocs {
	/**
	* A simple method.
	*
	* @param arg1 An arg.
	**/
	public void aMethod(int arg1) {} // end aMethod()
	#!/bin/bash
	echo 'PATH=${PATH}:/usr/sbin' >> ~/.profile
	source ~/.profile
	sudo apt update && sudo apt-get install -y tcpdump nmap dnsutils tmux
	"""
	Back up at https://gist.github.com/logston/088bf6e2435fe8ecac41ab18a93a012a
	"""
	import base64
	import csv
	import getpass
	import smtplib
	import time
	import random
	from email.mime.multipart import MIMEMultipart
	version: '3.2'

	services:
	cdb_node_1:
	container_name: cdb_node_1
	image: cockroachdb/cockroach:v20.1.3
	volumes:
	- cdb_node_1:/cockroach/cockroach-data
	command: start --insecure --join=cdb_node_1,cdb_node_2,cdb_node_3 --advertise-addr=cdb_node_1
	ports:
	on run {input}
	set the_path to POSIX path of input
	set cmd to "vim " & quoted form of the_path
	tell application "Terminal"
	activate
	tell application "System Events"
	keystroke "b" using {control down}
	delay 0.1
	keystroke "c"
	keystroke return
	<!DOCTYPE html>
	<html lang="en">
	<head>
	<!-- Required meta tags -->
	<meta charset="utf-8">
	<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">

	<!-- Bootstrap CSS -->
	<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/css/bootstrap.min.css" integrity="sha384-Gn5384xqQ1aoWXA+058RXPxPg6fy4IWvTNh0E263XmFcJlSAwiGgFAW/dAiS6JXm" crossorigin="anonymous">