gnzjgo gnzjgo

## normcore-llm.md

      
              1 file
            
          
              216 forks
            
          
              38 comments
            
          
              2771 stars
            
          
                veekaybee
                / normcore-llm.md
            
            
              Last active
              July 3, 2024 22:14
            
              
                Normcore LLM Reads
              
          
    Anti-hype LLM reading list

Goals: Add links that are reasonable and good explanations of how stuff works. No hype and no vendor content if possible. Practical first-hand accounts of models in prod eagerly sought.
Foundational Concepts


Pre-Transformer Models


## ingest_data_to_tb_deduplicate.sh
# full process. Ingests data from postgres to tb, calculates duplicates, inserts them to a new datasource and removes the rows from that datasource that appear in the original one.

source $(pwd)/.env


# related, to ingest data from postgres: https://blog.tinybird.co/2019/10/14/the-one-cron-job-that-will-speed-up-your-analytical-queries-in-postgres-a-hundred-fold/
echo 'Ingesting most recently update jobs'
psql $HEROKU_POSTGRES_URL -c "COPY (SELECT id, url, job_title, company, description, description_cleaned, date_posted, now() FROM job WHERE COALESCE(description, '') <> '' AND updated_at > now() - interval '70 minutes') TO STDOUT WITH (FORMAT CSV)" | curl -F csv=@- "https://api.tinybird.co/v0/datasources?name=jobs&mode=append&token=$TINYBIRD_ADMIN_TOKEN";


## nvmCommands.js
// check version
node -v || node --version

// list locally installed versions of node
nvm ls

// list remove available versions of node
nvm ls-remote

// install specific version of node

## iterm2.md

      
              1 file
            
          
              403 forks
            
          
              73 comments
            
          
              1950 stars
            
          
                squarism
                / iterm2.md
            
            
              Last active
              July 2, 2024 11:48
            
              
                An iTerm2 Cheatsheet
              
          
    Tabs and Windows


Function
Shortcut


New Tab
⌘ + T


Close Tab or Window
⌘ + W  (same as many mac apps)


Go to Tab
⌘ + Number Key  (ie: ⌘2 is 2nd tab)


Go to Split Pane by Direction
⌘ + Option + Arrow Key


Cycle iTerm Windows
⌘ + backtick (true of all mac apps and works with desktops/mission control)
	# full process. Ingests data from postgres to tb, calculates duplicates, inserts them to a new datasource and removes the rows from that datasource that appear in the original one.

	source $(pwd)/.env


	# related, to ingest data from postgres: https://blog.tinybird.co/2019/10/14/the-one-cron-job-that-will-speed-up-your-analytical-queries-in-postgres-a-hundred-fold/
	echo 'Ingesting most recently update jobs'
	psql $HEROKU_POSTGRES_URL -c "COPY (SELECT id, url, job_title, company, description, description_cleaned, date_posted, now() FROM job WHERE COALESCE(description, '') <> '' AND updated_at > now() - interval '70 minutes') TO STDOUT WITH (FORMAT CSV)" \| curl -F csv=@- "https://api.tinybird.co/v0/datasources?name=jobs&mode=append&token=$TINYBIRD_ADMIN_TOKEN";
	// check version
	node -v \|\| node --version

	// list locally installed versions of node
	nvm ls

	// list remove available versions of node
	nvm ls-remote

	// install specific version of node
Function	Shortcut
New Tab	`⌘` + `T`
Close Tab or Window	`⌘` + `W` (same as many mac apps)
Go to Tab	`⌘` + `Number Key` (ie: `⌘2` is 2nd tab)
Go to Split Pane by Direction	`⌘` + `Option` + `Arrow Key`
Cycle iTerm Windows	`⌘` + `backtick` (true of all mac apps and works with desktops/mission control)