Proposal for changes in README.md file #243

adriatic · 2022-06-08T22:12:37Z

adriatic
Jun 8, 2022

The most important issue is to define the process of creating and using the database - the README.md states

If you don't already have Postgres setup locally, it can be a little tricky to do so. If you're on a Mac, Postgres.app is a tried-and-true solution. We don't have recommendations for other platforms, but one thing we do recommend is using railway.app—even for local development—since it trivializes this whole process.

This does not seem to be the case today, so I am providing the description of the process below, inspired by this YouTube presentation How to Install PostgreSQL and PgAdmin 4 on Mac OS. The Windows equivalent will be added soon

Step 1: Point the browser to https://www.postgresql.org/
Step 2: Click on the download link
Step 3: Click on macOS link on the download page
Step 4: Click on download the installer link to get EDB certified installer
Step 5: On the page Download PostgreSQL pick the version 14.3 for mac OSX
Step 6. Follow the installation instructions
Step 7: run the downloaded postgresql-14.3-1-osx.dmg package which will start EDB PostgreSQL Setup Wizard. Take all default settings that are proposed by the wizard
Step 8: Once the Wizard finishes, you can verify the installation of all component by issuing the command ps -ef | grep postgres. You should see:

nik$ ps -ef | grep postgres
  504 48772 48771   0  6:54PM ??         0:00.00 postgres: logger   
  504 48774 48771   0  6:54PM ??         0:00.01 postgres: checkpointer   
  504 48775 48771   0  6:54PM ??         0:00.02 postgres: background writer   
  504 48776 48771   0  6:54PM ??         0:00.02 postgres: walwriter   
  504 48777 48771   0  6:54PM ??         0:00.03 postgres: autovacuum launcher   
  504 48778 48771   0  6:54PM ??         0:00.16 postgres: stats collector   
  504 48779 48771   0  6:54PM ??         0:00.00 postgres: logical replication launcher   
  501 49879  2395   0  8:26PM ttys002    0:00.00 grep postgres

The .env file content

DATABASE_URL=postgresql://...
TEST_DATABASE_URL=postgresql://...
# PRISMA_HIDE_UPDATE_MESSAGE=true
# LOG_LEVEL=trace

# You can get these from your Stripe Test Dashboard
#
STRIPE_PK=pk_test_WzB2E9l7QV...
STRIPE_SK=sk_test_iNX3iS1hvbuF...

# You can get this one from the Stripe CLI by running:
#
# ```
# stripe listen --api-key=sk_test_... --print-secret
# ```
#
# `--api-key` should be the same as your `STRIPE_SK`
#
# See: https://stripe.com/docs/stripe-cli
#
STRIPE_WEBHOOK_SK=whsec_...

# You can get this by running `yarn rw g secret`
#
SESSION_SECRET=B9qda5AraUcj42fdW58YBTmXhWVT3ZKJyK9LQQcA...

API Keys are on the page https://dashboard.stripe.com/test/apikeys

adriatic · 2022-06-09T01:01:58Z

adriatic
Jun 9, 2022
Author

With the above .env file, the command yarn rw dev ran successfully creating the following output

nik$ yarn rw dev
gen | Generating TypeScript definitions and GraphQL schemas...
gen | 47 files generated
api | Building... Took 531 ms
api | Debugger listening on ws://127.0.0.1:18911/e5cb09ef-d2fd-4db4-9a27-b8ba0bf3cf1c
api | For help, see: https://nodejs.org/en/docs/inspector
api | Starting API Server...
api | Importing Server Functions... 
api | /graphql 177 ms
api | /auth 29 ms
api | /checkouts 1 ms
api | /sessions 1 ms
api | /stripeWebhooks 1 ms
api | ...Done importing in 210 ms
api | Took 256 ms
api | API listening on http://localhost:8911/
api | GraphQL endpoint at /graphql
api | 20:57:16 🌲 Server listening at http://[::]:8911
web | assets by path static/js/*.js 4.19 MiB
web |   asset static/js/app.bundle.js 3.57 MiB [emitted] (name: app) 1 related asset
web |   asset static/js/src_pages_ResetPasswordPage_ResetPasswordPage_js.chunk.js 133 KiB [emitted] 1 related asset
web |   asset static/js/src_pages_LoginPage_LoginPage_js.chunk.js 133 KiB [emitted] 1 related asset
web |   asset static/js/src_pages_SignupPage_SignupPage_js.chunk.js 133 KiB [emitted] 1 related asset
web |   asset static/js/src_pages_ForgotPasswordPage_ForgotPasswordPage_js.chunk.js 126 KiB [emitted] 1 related asset
web |   + 5 assets
web | assets by path img/*.png 54.2 KiB
web |   asset img/flight.png 25.4 KiB [emitted] [from: public/img/flight.png] [copied]
web |   asset img/invisibility.png 20.4 KiB [emitted] [from: public/img/invisibility.png] [copied]
web |   asset img/folding.png 8.37 KiB [emitted] [from: public/img/folding.png] [copied]
web | asset README.md 1.9 KiB [emitted] [from: public/README.md] [copied]
web | asset favicon.png 1.7 KiB [emitted] [from: public/favicon.png] [copied]
web | asset index.html 483 bytes [emitted]
web | asset robots.txt 24 bytes [emitted] [from: public/robots.txt] [copied]
web | Entrypoint app 3.62 MiB (3.37 MiB) = static/js/runtime-app.bundle.js 50.7 KiB static/js/app.bundle.js 3.57 MiB 2 auxiliary assets
web | orphan modules 1.04 MiB [orphan] 417 modules
web | runtime modules 34.2 KiB 18 modules
web | modules by path ../node_modules/ 2.8 MiB 890 modules
web | modules by path ./src/ 144 KiB
web |   modules by path ./src/components/ 70.4 KiB 16 modules
web |   modules by path ./src/pages/ 41 KiB 9 modules
web |   modules by path ./src/*.css 23.1 KiB 4 modules
web |   modules by path ./src/*.js 5.89 KiB 2 modules
web |   + 1 module
web | asset modules 1.64 KiB
web |   data:image/svg+xml;charset=utf-8,%3Csvg viewBox=%.. 351 bytes [built] [code generated]
web |   data:image/svg+xml;charset=utf-8,%3Csvg viewBox=%.. 329 bytes [built] [code generated]
web |   data:image/svg+xml;charset=utf-8,%3Csvg viewBox=%.. 332 bytes [built] [code generated]
web |   data:image/svg+xml;charset=utf-8,%3Csvg viewBox=%.. 331 bytes [built] [code generated]
web |   data:image/svg+xml;charset=utf-8,%3Csvg viewBox=%.. 332 bytes [built] [code generated]
web | webpack 5.72.1 compiled successfully in 5608 ms
api | 20:57:19 🌲 incoming request GET xxx /auth?method=getToken
api | 20:57:19 🌲 request completed 19ms
api | 20:57:19 🌲 incoming request GET xxx /auth?method=getToken
api | 20:57:19 🌲 request completed 1ms
api | 20:57:19 🌲 incoming request GET xxx /auth?method=getToken
api | 20:57:19 🌲 request completed 0ms
api | 20:57:19 🌲 incoming request GET xxx /auth?method=getToken
api | 20:57:19 🌲 request completed 0ms
api | 20:57:19 🌲 incoming request POST xxx /graphql
api | 20:57:19 🐛 Parsing request to extract GraphQL parameters
api | 20:57:19 🐛 Processing GraphQL Parameters
api | 20:57:19 🐛 Execution start
api | 20:57:19 🐛 
api | Received GraphQL operation:
api | 
api | 20:57:19 🐛        operationName:
api | 20:57:19 🐛        variables:
api | 20:57:19 🐛 graphql-server GraphQL execution started: Products
api | (node:50693) ExperimentalWarning: buffer.Blob is an experimental feature. This feature could change at any time
api | (Use `node --trace-warnings ...` to show where the warning was created)
api | 20:57:19 🌲 incoming request GET xxx /auth?method=getToken
api | 20:57:19 🌲 request completed 2ms
api | 20:57:19 🌲 incoming request POST xxx /graphql
api | 20:57:19 🐛 Parsing request to extract GraphQL parameters
api | 20:57:19 🐛 Processing GraphQL Parameters
api | 20:57:19 🐛 Execution start
api | 20:57:19 🐛 
api | Received GraphQL operation:
api | 
api | 20:57:19 🐛        operationName:
api | 20:57:19 🐛        variables:
api | 20:57:19 🐛 graphql-server GraphQL execution started: Products
api | 20:57:19 🌲 incoming request POST xxx /graphql
api | 20:57:19 🐛 Parsing request to extract GraphQL parameters
api | 20:57:19 🐛 Processing GraphQL Parameters
api | 20:57:19 🐛 Execution start
api | 20:57:19 🐛 
api | Received GraphQL operation:
api | 
api | 20:57:19 🐛        operationName:
api | 20:57:19 🐛        variables:
api | 20:57:19 🐛 graphql-server GraphQL execution started: Products
api | 20:57:19 🌲 incoming request POST xxx /graphql
api | 20:57:19 🐛 Parsing request to extract GraphQL parameters
api | 20:57:19 🐛 Processing GraphQL Parameters
api | 20:57:19 🐛 Execution start
api | 20:57:19 🐛 
api | Received GraphQL operation:
api | 
api | 20:57:19 🐛        operationName:
api | 20:57:19 🐛        variables:
api | 20:57:19 🐛 graphql-server GraphQL execution started: Products
api | 20:57:20 🐛 Execution end
api | 20:57:20 🐛        result:
api | 20:57:20 🐛 graphql-server GraphQL execution completed: Products
api | 20:57:20 🌲 request completed 1.1s
api | 20:57:20 🐛 Execution end
api | 20:57:20 🐛        result:
api | 20:57:20 🐛 graphql-server GraphQL execution completed: Products
api | 20:57:20 🌲 request completed 1s
api | 20:57:20 🐛 Execution end
api | 20:57:20 🐛        result:
api | 20:57:20 🐛 graphql-server GraphQL execution completed: Products
api | 20:57:20 🌲 request completed 1.1s
api | 20:57:20 🐛 Execution end
api | 20:57:20 🐛        result:
api | 20:57:20 🐛 graphql-server GraphQL execution completed: Products
api | 20:57:20 🌲 request completed 1.1s
api | 20:58:03 🌲 incoming request GET xxx /auth?method=getToken
api | 20:58:03 🌲 request completed 1ms

0 replies

adriatic · 2022-06-14T19:24:14Z

adriatic
Jun 14, 2022
Author

I stuffed only the text from the data above - left the log from yarn rw dev in this discussion item

0 replies

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Proposal for changes in README.md file #243

{{title}}

{{editor}}'s edit

{{editor}}'s edit

Replies: 2 comments

{{title}}

{{title}}

Select a reply

Proposal for changes in README.md file #243

adriatic Jun 8, 2022

Replies: 2 comments

adriatic Jun 9, 2022 Author

adriatic Jun 14, 2022 Author

adriatic
Jun 8, 2022

adriatic
Jun 9, 2022
Author

adriatic
Jun 14, 2022
Author