Martín Acosta Dev martinacostadev

Node.js Deployment

Steps to deploy a Node.js app to DigitalOcean using PM2, NGINX as a reverse proxy and an SSL from LetsEncrypt

If you use the referal link below, you get $10 free (1 or 2 months) https://m.do.co/c/5424d440c63a

I will be using the root user, but would suggest creating a new user

	import { fontTitles } from "@/app/fonts";
	import BackButton from "@/components/BackButton";
	import ImageGenerator from "@/components/ImageGenerator";
	import Loading from "@/components/Loading";
	import PhoneNumber from "@/components/PhoneNumber";
	import { AspectRatio } from "@/components/ui/aspect-ratio";
	import getIcon from "@/utils/getIcon";
	import { getImageUrl } from "@/utils/getImage";
	import { createClient } from '@/utils/supabase/client';
	import { MapPin } from "lucide-react";

	/*

	Connect to SQL Server, run script and show in web with NodeJS

	Commands:

	npm init
	npm install
	npm install express
	npm install mssql

	// JS array equivalents to C# LINQ methods - by Dan B.

	// Here's a simple array of "person" objects
	var people = [
	{ name: "John", age: 20 },
	{ name: "Mary", age: 35 },
	{ name: "Arthur", age: 78 },
	{ name: "Mike", age: 27 },
	{ name: "Judy", age: 42 },
	{ name: "Tim", age: 8 }

	Error: Request failed with status code 404
	at createError (/usr/src/app/node_modules/axios/lib/core/createError.js:16:15)
	at settle (/usr/src/app/node_modules/axios/lib/core/settle.js:17:12)
	at IncomingMessage.handleStreamEnd (/usr/src/app/node_modules/axios/lib/adapters/http.js:236:11)
	at IncomingMessage.emit (events.js:323:22)
	at endReadableNT (_stream_readable.js:1204:12)
	at processTicksAndRejections (internal/process/task_queues.js:84:21) {
	config: {
	url: 'https://martinacosta.com.ar/api/coffees?password=undefined',
	method: 'get',

	https://www.digitalocean.com/community/tutorials/how-to-secure-apache-with-let-s-encrypt-on-ubuntu-18-04

	---

	Versión anterior de Ubuntu:

	https://www.digitalocean.com/community/tutorials/how-to-secure-apache-with-let-s-encrypt-on-ubuntu-16-04

	docker logs nombredocker > docker.log 2>docker.err

	Se guarda en la misma carpeta donde se ejecuta el comando. El archivo err contiene los errores que puedan surgir y que en consola con dockers logs no se llegan a leer.

	SET @oldsite='http://oldsite.com';
	SET @newsite='http://newsite.com';
	UPDATE wp_options SET option_value = replace(option_value, @oldsite, @newsite) WHERE option_name = 'home' OR option_name = 'siteurl';
	UPDATE wp_posts SET post_content = replace(post_content, @oldsite, @newsite);
	UPDATE wp_links SET link_url = replace(link_url, @oldsite, @newsite);
	UPDATE wp_postmeta SET meta_value = replace(meta_value, @oldsite, @newsite);

	/* only uncomment next line if you want all your current posts to post to RSS again as new */
	#UPDATE wp_posts SET guid = replace(guid, @oldsite, @newsite);