Copple kiwicopple
steve-chavez
/ Dockerfile
Last active
September 27, 2022 17:29
Metarest: create database objects from Supabase client libs
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| FROM postgres | |
| RUN metaDependencies="git \ | |
| ca-certificates \ | |
| build-essential" \ | |
| && apt-get update \ | |
| && apt-get install -y --no-install-recommends ${metaDependencies} \ | |
| && apt-get install -y build-essential \ | |
| && apt-get install make \ | |
| && cd /tmp \ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| MARKDOWN = pandoc --standalone --from markdown+smart --to html --css theme.css | |
| all: $(patsubst %.md,%.html,$(wildcard *.md)) Makefile | |
| clean: | |
| rm -fv $(patsubst %.md,%.html,$(wildcard *.md)) | |
| publish: | |
| aws-3.7 s3 sync . s3:/<BUCKET> --exclude "*" --include "*.html" --include |
mateuszwenus
/ save_restore_dependencies.sql
Last active
August 31, 2024 14:28
PostgreSQL: How to handle table and view dependencies
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| create table deps_saved_ddl | |
| ( | |
| deps_id serial primary key, | |
| deps_view_schema varchar(255), | |
| deps_view_name varchar(255), | |
| deps_ddl_to_run text | |
| ); | |
| create or replace function deps_save_and_drop_dependencies(p_view_schema varchar, p_view_name varchar) returns void as | |
| $$ |