Xetera

Restoring a supabase dump to local postgres

Supabase contains a ton of extra schemas, roles and extensions that prevents restoring a local db from a supabase db. There are some tools out there but thery're all tedious to use. Here's how you can do it with a single pg_dump command

pg_dump --exclude-schema graphql --exclude-schema auth --exclude-schema graphql_public \
  --exclude-schema pgsodium --exclude-schema pgbouncer --exclude-schema storage \
  --exclude-schema realtime --exclude-schema vault --exclude-extension pgsodium \
 --exclude-extension pg_graphql --exclude-extension supabase_vault \

	// Yes this is vibe coded. It worked fine for me
	package main

	import (
	"encoding/json"
	"fmt"
	"io"
	"net/http"
	"os"
	"path/filepath"

	#! /usr/bin/env python3
	import requests
	import os
	import pathlib

	SONARR_TOKEN = os.environ.get("SONARR_TOKEN")
	# directory where hardlinks will be created for renaming purposes
	HARDLINK_TARGET = os.environ.get("HARDLINK_TARGET")
	# DRY_RUN=true to test without touching the filesystem
	DRY_RUN = os.environ.get("DRY_RUN", "false").lower() == "true"

	#! /usr/bin/env python3
	import requests
	import os
	import pathlib

	RADARR_TOKEN = os.environ.get("RADARR_TOKEN")
	# directory where hardlinks will be created for renaming purposes
	HARDLINK_TARGET = os.environ.get("HARDLINK_TARGET")
	# DRY_RUN=true to test without touching the filesystem
	DRY_RUN = os.environ.get("DRY_RUN", "false").lower() == "true"

	const file = await import(process.argv[2], { assert: { type: "json" } })

	function getValues(obj) {
	const values = []
	if (typeof obj !== "object") {
	return values
	}

	for (const key of Object.keys(obj)) {
	if (typeof obj[key] === "object") {

	const MagicImageBytes = {
	640: 0b1011001001110011n,
	300: 0b0001111000000010n,
	64: 0b0100100001010001n,
	} as const;

	/**
	* Converts a spotify link to a new size.
	*
	* @see

	const CARD_NUMBER = "1234123412341234"
	const CARD_OWNER = "John Doe"
	const CARD_CVV = 999
	const CARD_EXPIRY = "3/26"

	// Change above this line

	function typeString(elementId, str, callback) {
	let element = document.getElementById(elementId)
	if (!element) {

	[
	{
	"storeId": "d1d14969-c3e3-e711-80e0-005056010583",
	"storeName": "Kahve Dünyası - Promenade",
	"storeCode": "509",
	"city": "HAWALLİ",
	"state": "AL KUWAİT",
	"district": "AL MOTASEM STREET",
	"country": "KUVEYT",
	"address": "Inside The Sultan Center, Al Motasem Street, Al Kuwait Hawalli",

	from typing import Optional
	import requests
	import re
	import datetime


	def check_turkish_ban_date(site: str) -> Optional[datetime.date]:
	"""
	Looks up when a site (domain + tld) was banned in turkey.
	Returns None if the site isn't banned.