Home

Awesome

Welcome to Remix!

Setup?

Configure the database ft. Railway App(PostgreSQL)

Use Data Proxy URLs

For running on the edge, you'd be required to use the Prisma Data Platform (Data Proxy URLs) to interact with your cloud DB instance(no local connections allowed). Get connection string of the form prisma://aws-us-east-1.prisma-data.com/?api_key=... from the data platform, by connecting your cloud DB instance.

Setup Prisma

  1. Set the DATABASE_URL in the .env file to point to your existing database. If your database has no tables yet, read https://pris.ly/d/getting-started
  2. Set the provider of the datasource block in schema.prisma to match your database: postgresql(for us). There are other configs we're not using like mysql, sqlite, sqlserver (Preview) or mongodb (Preview).
  3. Run npx prisma db pull to turn your database schema into a Prisma schema
  4. Open the .env file and place the connecting string(Postgres Connection URL) against DATABASE_URL. Prisma is smart enough to use this by its special annotation in the /prisma/schema.prisma file env("DATABASE_URL"). Keep postgresql as the DB type
  5. Run npm run generate to generate the Prisma Client (with Data Proxy enabled) . You can then start querying your database.

Misc Steps

Others

To open studio use npx prisma studio

Development

You will be running several processes during development:

# in one tab, start the remix dev server
$ npm run dev

If you'd like to change any aspects of this behavior, see how the commands are configured in your package.json file

Open up http://127.0.0.1:8787 and you should be ready to go!

Deployment

Use wrangler to build and deploy your application to Cloudflare Workers. If you don't have it yet, follow the installation guide to get it setup. Be sure to authenticate the CLI as well.

If you don't already have an account, then create a cloudflare account here and after verifying your email address with Cloudflare, go to your dashboard and set up your free custom Cloudflare Workers subdomain.

Once that's done, you should be able to deploy your app:

npm run deploy