Skip to content

Instantly share code, notes, and snippets.

View nicosuave's full-sized avatar

Nico Ritschel nicosuave

View GitHub Profile
@transitive-bullshit
transitive-bullshit / claude-code-prompts.js
Last active August 4, 2025 17:09
Unminified prompts and tool definitions for Claude Code
// Claude Code is a Beta product per Anthropic's Commercial Terms of Service.
// By using Claude Code, you agree that all code acceptance or rejection decisions you make,
// and the associated conversations in context, constitute Feedback under Anthropic's Commercial Terms,
// and may be used to improve Anthropic's products, including training models.
// You are responsible for reviewing any code suggestions before use.
// (c) Anthropic PBC. All rights reserved. Use is subject to Anthropic's Commercial Terms of Service (https://www.anthropic.com/legal/commercial-terms).
// Version: 0.2.9

Notes on migrating from RouterProvider to framework

Official documentation: https://reactrouter.com/upgrading/router-provider

Issues

  1. Vite config. If the vite config contains a root property it needs to be removed. If you are running vitest coverage reports you may want to move it to test.root or it will show coverage for the entire project. Any paths relative to root need to be adjusted as well, e.g. if you have publicDir set to ../public it should be set to just public (or removed as that is the default).

  2. Vitest. You don't want the reactRouter plugin running for tests, so setup as

@hamelsmu
hamelsmu / follow_theirs.py
Last active November 26, 2024 14:27
"I'll have what they are having" for bluesky. The motiviation is to mimic who someone else is following who reports they are having a good experience on bluesky!
def follow_user_follows(client, target_user):
"Follow everyone the target_user is following."
cursor = None
total_followed = 0
while True:
# Step 1: Fetch a batch of accounts the target user is following
# https://docs.bsky.app/docs/api/app-bsky-graph-get-follows
response = client.app.bsky.graph.get_follows({
@ianmcook
ianmcook / request-body.json
Last active February 25, 2025 15:28
Use the Snowflake SQL REST API from a shell script with curl and jq to execute a query and download the result partitions in Arrow format
{
"statement": "SELECT * FROM MYTABLE",
"resultSetMetaData": {
"format": "arrowv1"
},
"timeout": 60,
"database": "MYDATABASE",
"schema": "MYSCHEMA",
"warehouse": "MYWAREHOUSE",
"role": "MYROLE"
@z3z1ma
z3z1ma / sql_ls.py
Last active January 25, 2025 22:10
A simple language server implementation for SQLMesh using PyGLS
#!/usr/bin/env python
"""A Language Server Protocol (LSP) server for SQL with SQLMesh integration."""
import asyncio
import gc
import io
import logging
import re
import typing as t
import weakref
@Artefact2
Artefact2 / README.md
Last active August 5, 2025 06:30
GGUF quantizations overview
@veekaybee
veekaybee / normcore-llm.md
Last active August 4, 2025 17:37
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

Screenshot 2023-12-18 at 10 40 27 PM

Pre-Transformer Models

import time
# Make sure you have duckdb==0.7.0. Earlier versions might fail with GIL problems ( https://twitter.com/mr_le_fox/status/1620535141675433986 )
import duckdb
import s3fs
from fsspec.implementations.cached import SimpleCacheFileSystem
# Create the s3 file system. This one does not have caching
@mheffner
mheffner / fly.toml
Last active September 24, 2023 14:50
Running a Mastodon server on Fly.io (plus some stuff)
app = "mastiff"
primary_region = "iad"
kill_signal = "SIGINT"
kill_timeout = 5
processes = []
[build]
image = "tootsuite/mastodon:v3.5.5"
@joelonsql
joelonsql / PostgreSQL-EXTENSIONs.md
Last active July 31, 2025 15:49
1000+ PostgreSQL EXTENSIONs

🗺🐘 1000+ PostgreSQL EXTENSIONs

This is a list of URLs to PostgreSQL EXTENSION repos, listed in alphabetical order of parent repo, with active forks listed under each parent.

⭐️ >= 10 stars
⭐️⭐️ >= 100 stars
⭐️⭐️⭐️ >= 1000 stars
Numbers of stars might not be up-to-date.