Skip to content

Instantly share code, notes, and snippets.

View Tristan-Trainual's full-sized avatar

Tristan-Trainual

View GitHub Profile
@jberkus
jberkus / gist:6b1bcaf7724dfc2a54f3
Last active August 6, 2024 08:04
Finding Unused Indexes
WITH table_scans as (
SELECT relid,
tables.idx_scan + tables.seq_scan as all_scans,
( tables.n_tup_ins + tables.n_tup_upd + tables.n_tup_del ) as writes,
pg_relation_size(relid) as table_size
FROM pg_stat_user_tables as tables
),
all_writes as (
SELECT sum(writes) as total_writes
FROM table_scans

Oh my zsh.

Install with curl

sh -c "$(curl -fsSL https://raw.githubusercontent.com/robbyrussell/oh-my-zsh/master/tools/install.sh)"

Enabling Plugins (zsh-autosuggestions & zsh-syntax-highlighting)

  • Download zsh-autosuggestions by
@carlosgruiz-dev
carlosgruiz-dev / Bookmarks.markdown
Last active December 10, 2024 00:21
Bookmarks

A

  • A bit of Vim - a book which aims to help you to learn how to use the Vim editor.
  • A.W.E.S.O.M. O - The really big list of really interesting open source projects.
  • AMP Project - The project enables the creation of websites and ads that are consistently fast, beautiful and high-performing across devices and distribution platforms.
  • APE - Angular JS REST Client.
  • ASCII Art - Real-Time ASCII Art Rendering Library
  • AST Explorer - A web tool to explore the ASTs generated by various parsers.
  • Advanced Bash-Scripting Guide - An in-depth exploration of the art of shell scripting by Mendel Cooper.
  • Advent of Code - is a series of small programming puzzles for a variety of skill levels.
@qoomon
qoomon / conventional-commits-cheatsheet.md
Last active December 30, 2024 03:35
Conventional Commits Cheatsheet

Conventional Commit Messages starline

See how a minor change to your commit message style can make a difference.

Tip

Have a look at git-conventional-commits , a CLI util to ensure these conventions, determine version and generate changelogs

Commit Message Formats

Default

Awesome Penetration Testing Awesome

A collection of awesome penetration testing resources.

Penetration testing is the practice of launching authorized, simulated attacks against computer systems and their physical infrastructure to expose potential security weaknesses and vulnerabilities.

Your contributions and suggestions are heartily♥ welcome. (✿◕‿◕). Please check the Contributing Guidelines for more details. This work is licensed under a Creative Commons Attribution 4.0 International License.

This project is supported by Netsparker Web Application Security Scanner

@rahularity
rahularity / work-with-multiple-github-accounts.md
Last active December 29, 2024 14:59
How To Work With Multiple Github Accounts on your PC

How To Work With Multiple Github Accounts on a single Machine

Let suppose I have two github accounts, https://github.com/rahul-office and https://github.com/rahul-personal. Now i want to setup my mac to easily talk to both the github accounts.

NOTE: This logic can be extended to more than two accounts also. :)

The setup can be done in 5 easy steps:

Steps:

  • Step 1 : Create SSH keys for all accounts
  • Step 2 : Add SSH keys to SSH Agent

A Quick Guide to Big-O Notation, Memoization, Tabulation, and Sorting Algorithms by Example

Curating Complexity: A Guide to Big-O Notation


A Quick Guide to Big-O Notation, Memoization, Tabulation, and Sorting Algorithms by Example

Curating Complexity: A Guide to Big-O Notation

@JoaoLages
JoaoLages / RLHF.md
Last active December 26, 2024 18:26
Reinforcement Learning from Human Feedback (RLHF) - a simplified explanation

Maybe you've heard about this technique but you haven't completely understood it, especially the PPO part. This explanation might help.

We will focus on text-to-text language models 📝, such as GPT-3, BLOOM, and T5. Models like BERT, which are encoder-only, are not addressed.

Reinforcement Learning from Human Feedback (RLHF) has been successfully applied in ChatGPT, hence its major increase in popularity. 📈

RLHF is especially useful in two scenarios 🌟:

  • You can’t create a good loss function
    • Example: how do you calculate a metric to measure if the model’s output was funny?
  • You want to train with production data, but you can’t easily label your production data