Adding a PostgreSQL Database

앱(웹사이트)에 PostgreSQL 데이터베이스를 적용하는 방법을 정리하였습니다.

 

 

---

< PostgreSQL with Node and Express >

How to interact with a SQL database from within your JavaScript programs using PostgreSQL.

 

Article : How to set up a RESTful API with Node.js and PostgreSQL

Node.js, Express.js, and PostgreSQL: CRUD REST API example - LogRocket Blog

In this tutorial, you'll create CRUD REST API example using Node.js, Express.js, and PostgreSQL

 

 

Article : Build Your Own Blog Using Express, React, & Postgres.

Full Stack React: How to Build Your Own Blog Using Express, Hooks, & Postgres.

In this tutorial, you'll learn How to Build Your Own Blog Using Express, React, & Postgres.

 

 

Documentation : node-postgres module

Welcome

: node-postgres is a collection of node.js modules for interfacing with your PostgreSQL database.

 

 

---

< Deploying a PERN App to Heroku >

How to deploy a full-stack application using Heroku.

 

Article : Build a Node.js, Express, & PostgreSQL REST API

Build a Node.js, Express, & PostgreSQL REST API

In this tutorial, you will learn how to create and deploy a REST API built with Node.js, the Express web framework, and a PostgreSQL database.

 

 

Documentation : Heroku - Postgres Basics

Postgres Basics | Heroku Dev Center

In this documentation, you will learn about the basics of deploying a Postgres database with Heroku.

 

 

Documentation : Heroku - Connecting in Node.js

Heroku Postgres | Heroku Dev Center

In this documentation, you will learn how to connect to a Heroku Postgres database in Node.js.

 

 

---

< Using an ORM with Sequelize >

How to use the Sequelize ORM to add a layer of abstraction to your application.

 

Article : What is an ORM and Why You Should Use it

What is an ORM and Why You Should Use it

SELECT * FROM users WHERE email = 'test@test.com';

Object-relational-mapping is the idea of being able to write queries like the one above, as well as much more complicated ones, using the object-oriented paradigm of your preferred programming language.

var orm = require('generic-orm-libarry');
var user = orm("users").where({ email: 'test@test.com' });

 

 

Article : build REST API using Node.js, Express, Sequelize.js, PostgreSQL

Node.js, Express.js, Sequelize.js and PostgreSQL RESTful API

In this tutorial, you will learn how to build a REST API using Node.js, Express.js, Sequelize.js, and PostgreSQL. This is helpful for Understand the full process of creating an API that supports CRUD (Create, Read, Update, Delete) operations.

 

 

Documentation : Sequelize

Manual | Sequelize

Sequelize is a promise-based Node.js ORM tool for Postgres, MySQL, MariaDB, SQLite, Microsoft SQL Server, Amazon Redshift and Snowflake’s Data Cloud.

 

 

---

< Query Builders and Data Seeding >

How to use a query builder like Knex.js, seed your database with Faker.js, or use Mockaroo to practice building a database.

 

Article : Seeding your Database with Thousands of Users using Knex.js and Faker.js

Seeding your Database with Thousands of Users using Knex.js and Faker.js

How to seed your database using the Knex.js query builder and Faker.js data generator.

 

 

Documentation : Knex.js

Knex.js - A SQL Query Builder for Javascript

 

 

Article : Mockaroo – An easy way to generate millions of test data

Mockaroo – An easy way to generate millions of test data

Mockaroo is an online data generator for generating realistic test data

 

 

Documentation : mockaroo

Mockaroo - Random Data Generator and API Mocking Tool | JSON / CSV / SQL / Excel