next-postgres

This is an example of a web application with posts, comments and server side rendering. It is configured to be deployed to Zeit. It is code you can use without attribution, please enjoy.

An older version is deployed here.

Stack

• NextJS + Custom Express
• Emotion CSS-in-JS
• Postgres
• Sequelize: PostgresSQL ORM
• Passport for local authentication
• Redux
• Babel

Why is this useful? Why should I care?

• The UX and UI are garbage, that means everything you do will be better!
• Client and server are written in JavaScript.
• This is a production ready codebase you can use to test a concept you have.
• Server side rendering has been made simple.
• Maybe you want to get a head start at a hackathon.

Setup: Prerequisites

I use Homebrew to manage dependencies on a new laptop... You're welcome to use something else.

• Install Postgres: brew install postgres.
• Install Node 10+: brew install node. (Or update your node)

Setup: Quick newbies guide to Postgres

• On OSX, to run Postgres in a tab on the default port.

postgres -D /usr/local/var/postgres -p 5432

• Postgres config is stored in ./config.js.
• Local database: sampledb.
• Username and password as test.

First time Postgres instructions.

# Enter Postgres console
psql postgres

# Create a new user for yourself
CREATE ROLE yourname WITH LOGIN PASSWORD 'yourname';

# Allow yourself to create databases
ALTER ROLE yourname CREATEDB;

# Exit Postgres console
\q

# Log in as your new user.
psql postgres -U yourname

# Create a database named: sampledb.
# If you change this, update config.js
CREATE DATABASE sampledb;

# Give your self privileges
GRANT ALL PRIVILEGES ON DATABASE sampledb TO yourname;

# List all of your databases
\list

# Connect to your newly created DB as a test
\connect sampledb

# Exit Postgres console
\q

I also use a GUI called TablePlus if you don't like command line.

Setup: Run locally

In the root directory run these commands:

npm install
npm install -g sequelize-cli
sequelize db:migrate
npm run dev

Visit localhost:8000 in a browser to start development locally. You will need postgres running.

Deploy

Deploying with now-cli is as simple as

now

# after the deploy, alias to your domain, add "alias" to now.json first
now alias

Make sure you configure your alias for zeit.world

Secrets

You can update production secrets in now-secrets.json and now.json. You can add a secret to your Zeit deployment by typing

now secrets add database-username admin

Questions?

Feel free to slang any feels to @wwwjim.