This is the fourth day of my participation in the August Text Challenge.More challenges in August

preface

In the last article we talked about how to build a simple example of next.js using the Serverless Framework. This time we will do a full stack project

The installation

We assume that you have Serverless Framework installed

Run commands on the terminal

sls 
Copy the code

Select Full Stack to create the project

Enter the project name and wait until the installation is complete. Upload the project directly or use serverless Deploy to upload the project

Your directory should look like this at this point

directory

  • API Ullstack-serverless-API Background API interface
  • Db fullstack-serverless-db Cloud database
  • Frontend Website static site
  • VPC Fullstack-serverless – VPC // Private network

Tencent Cloud Interface

  • Serverless application, a static site built with VUE and node.js Express backend service

  • Private network

  • FallStack – cloud API function

  • PostgreSql database

After the project is deployed online, we open the Website application

fullstack-serverless-frontend-1255469424.cos-website.ap-guangzhou.myqcloud.com

Fill in some random data in the form

The rest of the code here is easier to understand. This postgreSql database is my first experience. I did not find the relevant configuration in the code. I searched the official website of Tencent Cloud for a long time, and finally found that he was uploading

But there is no management interface in Tencent cloud, is it better to have a visual interface on the online ah, joke about it

Postgresql = postgresQL = postgresQL = PostgresQL = PostgresQL = PostgresQL = PostgresQL = PostgresQL = PostgresQL = PostgresQL

What is postgreSqlPostgreSQL

PostgreSqlPostgreSQL is a free object-relational database server (ORDBMS) distributed under a flexible BSD license.

PostgreSQL developers pronounce it post-ress-Q-L.

PostgreSQL’s Slogan is “The world’s most advanced Open source relational database.”

Install postgreSqlPostgreSQL client software

  • Postgre download and install SQL tutorial: www.runoob.com/postgresql/…
  • Tencent cloud link postgre cloud.tencent.com/document/pr SQL tutorial…

After following the installation tutorial,

Start the PG admin software

Right click on Server

Create a Server service

Fill in the username and password that you uploaded

Here you need to open the Internet in Tencent cloud, host and port number

Open it and fill in host and port number

I’ll just hit Save

How do I view the table structure

How do I view table data

Right-click in the table structure section to execute the command

Select the select command

A jump SQL command is automatically generated, which can be clicked to query the current table

As expected and mysql this relational database basic consistent