vhscom / metaform Goto Github PK

Do not put any API keys that aren't public in a SvelteKit load function. There's currently no enforcement logic for this in the project. One approach to mitigate leaking private API keys in a SvelteKit load function is to use dotenv as shown here. However, those keys cannot be used in a Cloudflare edge function which uses a WebWorker runtime as opposed to Node.js.

Postgres trigger functions currently insert and upsert only. If you need to drop records from the database, here's a workaround:

drop table if exists export
drop table if exists page
drop table if exists block

Run that to purge the DB then rerun setup.sql to start fresh.

The vision for the db is to add a closure table to define the graph hierarchy and a related table to define block order. Bill Karwin is the expert and has left quite a bit of reference material on SO as well as some videos in various talks on YouTube.