GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO test GRANT USAGE, SELECT ON ALL SEQUENCES IN SCHEMA public TO test It would be better if you create a schema in the database but I am just lazy for this demo. So run CREATE USER test WITH PASSWORD ‘password’ It is important to grant permissions to user test. Then create a database named pern_transactions by CREATE DATABASE pern_transactions Also, I would like to create a user test for development. Open a terminal and run psql -U postgres and enter your password. Let’s first create a PostgreSQL database and a table. If you ask me what if the password is forgotten, well, there are solutions online, but I just reinstalled it. I just assume that you have already installed PostgreSQL and you remember your password. Then run npm init -y with everything set by default. Open a terminal and direct to the “server” folder. Inside the “spendbook” folder, create a new folder named “server” for the backend part. ServerĬreate a folder to include both the frontend and backend files. Also, you can add more functions to the tracker, such as adding categories, displaying a chart of the costs of different categories, displaying expenses in different time period and so on. The CSS files are left for you to implement. Postman can be used to test the Restful APIs. It uses an expense management tracker to explain every step. This article gives an example about how to build a web application by PERN (PostgreSQL, Express, React, Node) stack. Build an expense management tracker by PERN stack
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |