Here we use PostgreSQL instead of SQLite with the prebuilt static frontend.
For when you really need to debug some deployment stuff locally.
Before the first run, do the OurBigBook Web PostgreSQL setup.
Then, after every modification
and then visit the running website at: localhost:3000/
npm run build-prod
npm run start-prod
To optionally nuke the database and create the demo data:
or alternatively to start from a clean database:
npm run seed-prod
psql -c "DROP DATABASE ourbigbook"
createdb ourbigbook
psql -c 'GRANT ALL PRIVILEGES ON DATABASE ourbigbook TO ourbigbook_user'
You can inspect the database interactively with:
and then running SQL commands.
psql ourbigbook