- Set up a Postgres database with any hosting provider. Supabase is our favorite, but you can choose anybody you like.
- Sign into Bracket
- Set up your primary source, and select Postgres as your secondary source.
- Select “I want Bracket to generate the table for me,” name your table (or use the suggested name), and click “Continue”
Some things to keep in mind
- Bracket standardizes the field names from your primary source into snake case to make your field names Postgres-friendly.
- Bracket automatically creates a primary key field called
bracket_pkey, which takes on a UUIDv4 value.
- Bracket also automatically creates a datetime field called
bracket_updated_at, which takes on the datetime at which a record is created or updated, whichever is more recent. Bracket uses this field to make syncing real-time.
- Finally, Bracket creates a Postgres function called
bracket_update_timestamp(), which gets applied to