Skip to content

Instantly share code, notes, and snippets.

@davehague
davehague / Chase-Partner-Offers-Bookmarklet.md
Last active September 19, 2024 14:05
Click all Chase Partner Offers Bookmarklet

Chase credit cards offer partner rebates, but you have to go in an manually click them. Use this script when you're on the offer page to click all of them, and then if you happen to purchase the item in the partner reward, you'll be alerted of a rebate via email!

Here's a guide on bookmarklets if you're not familiar with how they work.

Here's the code.

javascript:(function(){ var offers = document.querySelectorAll('div[data-testid="offerTileGridContainer"] mds-icon[type="ico_add_circle"'); if (offers) { var msg = `Found ${offers.length} unclicked offers!`; console.log(msg);  offers.forEach(function(offer) { var event = new MouseEvent('click', { bubbles: true, cancelable: true, view: window }); offer.dispatchEvent(event) }); var offerMessage = `Completed clicking ${offers.length} offers!`; alert(offerMessage) } else { alert('No element found with the specified data-testid.') }})() 
@davehague
davehague / html-live-reload.md
Last active September 19, 2024 14:05
Local Development - Live Reload for HTML/JS/CSS

Using NPM live server to watch HTML files. To avoid CORS issues and to work more quickly when developing a static HTML site locally, use a local server like live-server for development.

  1. Install live-server
npm install -g live-server
  1. Serve the project. Navigate to the root directory of your project and start live-server:
@davehague
davehague / Update Librechat.md
Last active September 19, 2024 14:05
Update Librechat

To pull the latest changes for LibreChat using Docker, while also considering the caching of images, you can follow these steps:

  1. Stop the running LibreChat container(s):
docker compose down
  1. CD to your librechat repository:
@davehague
davehague / Export Supabase Table Schemas.md
Last active March 4, 2025 15:50
Export Supabase Table Schemas

Setup

  1. Download and install pgAdmin
  2. Get your Supabase connection settings from the database settings page.

Export

In pgAdmin:

  1. Right click the schema and choose 'CREATE script' to script the schema
  2. Right click the schema and choose 'BACKUP...' to script the tables
@davehague
davehague / Supabase Multi-Project Project.md
Last active September 19, 2024 14:06
Supabase Multi-Project Project

Supabase only allows two projects to be active at any given time on their free tier. However, if you're like me and you like to explore and create a lot of projects, you'll be frustated with having to spin them down and up.

To solve this, use Postgres schemas. A PostgreSQL schema is a namespace that groups together database objects such as tables, views, indexes, data types, functions, and operators. It allows you to organize your data and objects within a database in a way that makes sense for your application.

Supabase actually has a page on how to use schemas. The short of it is below:

  1. Create a new schema
CREATE SCHEMA myproject
@davehague
davehague / Add_Existing_Project_To_Git.md
Last active February 1, 2025 22:08 — forked from alexpchin/Add_Existing_Project_To_Git.md
Add Existing Project To Git Repo

Adding an existing project to GitHub using the command line

  1. Create a new repository on GitHub. In Terminal, change the current working directory to your local project.

  2. Initialize the local directory as a Git repository.

    git init