rphlmr

import cachified, {
  type CacheEntry,
  type Cache,
  totalTtl,
} from "@epic-web/cachified";
import { ImageResponse } from "@vercel/og";
import { LRUCache } from "lru-cache";

import { serverDb } from "~/database/.server/db";
import { type PlaygroundId } from "~/database/types";

rphlmr

$ rsync -avn . /dev/shm --exclude-from .dockerignore

What this will do, is try to sync your current directory with the empty in-memory folder /dev/shm verbosely and dry-run (don't actually copy anything) the --exclude-from option reads glob patterns in the same format as .gitignore and .dockerignore

https://gist.github.com/sgdan/1cc6a8becc023d3b9b2c7b9dd379f102?permalink_comment_id=5123473#gistcomment-5123473

rphlmr

import type { ActionFunctionArgs, LoaderFunctionArgs } from '@remix-run/node';
import {
  ClientActionFunctionArgs,
  ClientLoaderFunctionArgs,
  useFetcher,
  useLoaderData,
} from '@remix-run/react';
import { enqueueActions, fromPromise, setup } from 'xstate';
import { useActor } from '@xstate/react';
import { useEffect, useRef } from 'react';

rphlmr

#
# See https://fly.io/docs/reference/configuration/ for information about how to use this file.
#

app = "my-app"
primary_region = "cdg"
kill_signal = "SIGINT"
kill_timeout = "5s"
swap_size_mb = 256

rphlmr

/* -------------------------------------------------------------------------- */
/*                                 More here;                                 */
/* -------------------------------------------------------------------------- */
// https://gist.github.com/rphlmr/0d1722a794ed5a16da0fdf6652902b15

export function distinctOn<Column extends AnyColumn>(column: Column) {
  return sql<Column["_"]["data"]>`distinct on (${column}) ${column}`;
}

export function jsonBuildObject<T extends SelectedFields>(shape: T) {

rphlmr

Supabase RLS Policy functions and Postgres transaction configuration association

source

Supabase's RLS Policy functions	PgTransaction config to set	Description
auth.uid()	set_config('request.jwt.claim.sub', <current_user_uid>, true)	<current_user_uid> comes from your own way to get the current user uid
auth.email()	set_config('request.jwt.claim.email', <current_user_email>, true)	<current_user_email> The current user email
auth.role()	set_config('request.jwt.claim.role', <current_user_role>, true)	<current_user_role> The current user role
auth.jwt()	set_config('request.jwt.claim', <current_user_jwt>, true)	<current_user_jwt> The current user jwt token. 🚨 I'm note sure about the config name, found nothing in Supabase repo

rphlmr

/**
 * App Install Manager
 *
 * Author: @rphlmr
 */

/**
 * You will be surprised by the code below.
 *
 * `beforeinstallprompt` is an event really hard to work with 😵‍💫

rphlmr

import { getSession, session } from "remix-hono/session";
import { pathToRegexp } from "path-to-regexp";

/**
 * Add protected routes middleware
 *
 */

app.use(
    protect({

rphlmr

#!/bin/bash

RED="\e[31m"
ENDCOLOR="\e[0m"

echo "⏳ Checking for type errors..."

# Run tsc and capture the output
TYPE_ERRORS=$(tsc --project ./tsconfig.json 2>&1)

rphlmr

import { createId } from "@paralleldrive/cuid2";

/**
 * @param message The message intended for the user.
 *
 * Other params are for logging purposes and help us debug.
 * @param cause The error that caused the rejection.
 * @param context Additional data to help us debug.
 * @param name A name to help us debug and filter logs.
 *