Skip to content

Instantly share code, notes, and snippets.

View sarahspak's full-sized avatar

Sarah Pak sarahspak

5 followers · 83 following
  • NYC
View GitHub Profile
@rain-1
rain-1 / LLM.md
Last active July 18, 2024 22:37
LLM Introduction: Learn Language Models

Purpose

Bootstrap knowledge of LLMs ASAP. With a bias/focus to GPT.

Avoid being a link dump. Try to provide only valuable well tuned information.

Prelude

Neural network links before starting with transformers.

@dylan-sessler
dylan-sessler / .psqlrc.sql
Created June 27, 2022 15:12
-- ---------------------
-- /*
-- _
-- _ __ ___ __ _| |
-- | '_ \/ __|/ _` | |
-- | |_) \__ \ (_| | |
-- | .__/|___/\__, |_|
-- |_| |_|
-- ---------------------
\set e '\\echo '
@l1x
l1x / safari.history.md
Last active May 23, 2024 04:32
SQL structure of Safari's history tables 
sqlite3 ~/Library/Safari/History.db
sqlite> .tables
history_client_versions  history_items            history_tombstones
history_event_listeners  history_items_to_tags    history_visits
history_events           history_tags             metadata
@verfriemelt-dot-org
verfriemelt-dot-org / .areadme.md
Last active July 26, 2023 11:23
psql config

psqlrc:

  • some infos at initial connect
  • predefined queries in ~/.psqlrc-include/ compiled by the _update.sh script into ~/.psqlrc-commands.sql which will be included within .psqlrc

image

typical worksetup:

  • portforwarding from remote to local host via ssh user@host -L 5432:127.0.0.1:5432
@tossmilestone
tossmilestone / Flake8.txt
Created March 30, 2018 06:55
Flake8 integrated with PyCharm
How to manually setup flake8 as PyCharm external tool
File / Settings / Tools / External Tools / Add
Name: Flake8
Program: $PyInterpreterDirectory$/python
Parameters: -m flake8 --max-complexity 10 --ignore E501 $FilePath$
Working directory: $ProjectFileDir$
Output Filters / Add
Name: Filter 1
@shortjared
shortjared / list.txt
Last active July 19, 2024 21:20
List of AWS Service Principals
a4b.amazonaws.com
access-analyzer.amazonaws.com
account.amazonaws.com
acm-pca.amazonaws.com
acm.amazonaws.com
airflow-env.amazonaws.com
airflow.amazonaws.com
alexa-appkit.amazon.com
alexa-connectedhome.amazon.com
amazonmq.amazonaws.com
@xgenvn
xgenvn / books.md
Created August 19, 2017 15:15 — forked from abstractart/books.md
Download free O'Reilly books
@drorm
drorm / schemaspy.cfg
Last active July 10, 2024 21:53
schemaspy for redshift
# type of database. Run with -dbhelp for details
schemaspy.t=redshift
# optional path to alternative jdbc drivers.
schemaspy.dp=./RedshiftJDBC42-1.2.7.1003.jar
# database properties: host, port number, name user, password
schemaspy.host=xxxxx.yyyy.eu-west-1.redshift.amazonaws.com
schemaspy.port=5439
schemaspy.db=test
schemaspy.u=test
schemaspy.p=***************
@schwartzmx
schwartzmx / redshift_long_running_queries.sql
Created May 17, 2017 03:52
find long running queries from the stl_query log
select u.usename,
q.userid,
q.query,
q.pid,
q.database,
q.querytxt,
listagg(q2.text, ' ') within group (order by q2.sequence) as querytxt2,
q.starttime,
q.endtime,
aborted,
@aparrish
aparrish / understanding-word-vectors.ipynb
Last active July 9, 2024 15:59
Understanding word vectors: A tutorial for "Reading and Writing Electronic Text," a class I teach at ITP. (Python 2.7) Code examples released under CC0 https://creativecommons.org/choose/zero/, other text released under CC BY 4.0 https://creativecommons.org/licenses/by/4.0/
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.