A quick/easy app to store Oscars predictions.
This app is all about "good enough". It is not secure and that's fine. The whole point is just to make predictions for a silly awards ceremony and compare with your friends.
Hosted at https://oscars-pool.pages.dev
With just, atlas, docker and node
just setup migrate worker
# start the Vue frontend in a separate terminal tab
just frontendWith only atlas, docker and node
cp .env.sample .env
cp .dev.vars.example .dev.vars
cp atlas.hcl.sample atlas.hcl
# start DB
docker-compose up -d
# apply DB migration
# If you don't want to use Atlas, just run the SQL files from the migrations directory
atlas migrate apply --env local
# install node dependencies
npm ci
# Start the Cloudflare worker backend
npm run dev
# Start the Vite server for the Vue frontend
npm run client:devWith docker and node
cp .env.sample .env
cp .dev.vars.sample .dev.vars
docker-compose up -d
# run migrations manually
for filename in migrations/*.sql; do docker exec db psql -U postgres -d local -f "/$filename"; done
# or if that loop syntax doesn't work:
# docker exec db psql -U postgres -d local -f migrations/20240208014006_full_schema.sql
# docker exec db psql -U postgres -d local -f migrations/20240208024216_insert_categories.sql
# docker exec db psql -U postgres -d local -f migrations/20240211233622_drop_rooms.sql
npm ci
npm run dev
npm run client:devUse Atlas to manage the DB.
- Exec into the DB container:
just psql - Inspect schema:
just schema-inspect - Apply schema changes:
just schema-apply - Generate SQL:
just migrate-diff - Apply "insert" migrations:
atlas migrate apply --env local --baseline 20240208024216 - Add new migration file:
atlas migrate new(after adding SQL, runatlas migrate hashto rehash) - Drop the DB and restart:
just down - Dump a remote database:
docker exec -it db pg_dump -d dbname -h host -p port -U user -f migrations/prod.sql- this works because
/migrationsis already bound to the container
- this works because