Build a Node/Express API with TypeScript, MySQL on PlanetScale, and Web Scraping with Cheerio

No video

Build a Node/Express API with TypeScript, MySQL on PlanetScale, and Web Scraping with Cheerio

Рет қаралды 35,402

Күн бұрын

Looking for an API that doesn't exist? Go and build it yourself!
In this video, we'll create an API for characters from one of my favorite book series, Throne of Glass. We'll use Node/Express for the server and add TypeScript on top of it. Then we'll use Cheerio to web scape the Throne of Glass Wiki page and save the data into a PlanetScale database.
Github Repo - github.com/jam...
PlanetScale + Express - github.com/jam...
Setup TypeScript + Node - ultimatecourse...
STAY IN TOUCH 👋
Check out the Podcast - compress.fm
Newsletter 🗞 - www.jamesqquic...
Live streams on Twitch 🖥️ - / jamesqquick
Follow me on Twitter 🐦 - / jamesqquick
QUESTIONS...?
Join the Discord Server 💬 - / discord
Want to know what hardware and software I use? www.jamesqquic...
Learn Web Development 📖 - www.jamesqquic...

Пікірлер: 45

@pappapuddins 2 жыл бұрын

The fact that you are willing to step outside of your comfort zone so as not exclude anyone is amazing, there needs to be more like you.

@MaxProgramming 2 жыл бұрын

This is all what we have been waiting for!!!! Especially with Typescript 🥳

@JamesQQuick 2 жыл бұрын

I'm planning on doing more with TypeScript!

@davidtzirima9301 2 жыл бұрын

love those configuration have been looking for this thanks man

@JamesQQuick 2 жыл бұрын

Yay :)

@manugentoodrums 2 жыл бұрын

this is super dope mate!

@nedneo3255 2 жыл бұрын

정말 재밌는 네용입니다. 항상 잘 보고 있습니다. 감사합니다.

@migueljarias 2 жыл бұрын

Man PlanetScale looks super cool

@JamesQQuick 2 жыл бұрын

Yesssss!!! :)

@sneddonisaac 2 жыл бұрын

Please show how to deploy the node app - awesome vid btw love the channel

@Skylla54 2 жыл бұрын

Sick Workflow

@0xrod 2 жыл бұрын

What's that extension that auto completes your terminal commands?

@teofilomonteiro9427 2 жыл бұрын

I'm also want to understand, it looks so neat!

@boskameel 2 жыл бұрын

It’s probably Fig.

@nathanielcameron8006 2 жыл бұрын

James is muh favorite.

@JamesQQuick 2 жыл бұрын

My man!

@ReignOfKaka 2 жыл бұрын

Whoa that was cool 👍

@okayatbikes1909 2 жыл бұрын

Magic! 🤩

@JamesQQuick 2 жыл бұрын

Yeah it's fun stuff!

@abhishekmishra9841 2 жыл бұрын

Sir make full stack video with postgres react express or I do suggest create Dashboard management system please 🙏🏻❤️

@Behzad999able1 2 жыл бұрын

Thanks for sharing.

@tmxwll 2 жыл бұрын

Hello James, is it intended that you cant create more than one db on planetscale in your main org, but you can easily add anoter org and add a db? Thanks for your great content😊

@markhuggins9256 2 жыл бұрын

Not sure if the planetScale lib helps with any of this but scrub your params. /characters/; drop table Characters; :-)

@JamesQQuick 2 жыл бұрын

Such a good point. I oughta do a video about that!

@tn9753 2 жыл бұрын

Thank you.

@dominikkin2588 2 жыл бұрын

Hello, thank you for the tutorial. i will get to it once I'm done with current stuff. One question though: how is it with copyright issues when scraping data from this Wiki page? Especially when it comes to images? Is this all fine? Can we use this in our API? Thanks

@syrup8345 2 жыл бұрын

Hi I tried to use planetscale and the project without the CLI just for curiosity and interestingly the app.ts show me and error the DATABASE_URL is undefined Is it possible to need something extra for using the .env variables?

@syrup8345 2 жыл бұрын

Never mind :D I figured it out, needed the dotenv, import it and the dotenv config :D wii

@jeffz7310 2 жыл бұрын

how come after you installed all the packages, there is no package-lock.json file created? Just the package.json.

@horyekhunley 2 жыл бұрын

How can planetscale be used with java spring boot? While when i run the pscale connect dbName dbBranch --execute 'npm run dev' I get an error TypeError: Cannot read property 'substr' of null... Seems the issue is from const connection = mysql.createConnection(connectionString)

@NibbyBanana 2 жыл бұрын

I'm pretty sure you put in a SQL injection exploit in there.

@JamesQQuick 2 жыл бұрын

Great callout. I might do a video on that!

@joseywoermann 2 жыл бұрын

How?

@JamesQQuick 2 жыл бұрын

@@joseywoermann someone could send a sql string as the path parameter

@maelstrom57 2 жыл бұрын

How come your version of ts-node works with the import syntax? I get the error: TypeError [ERR_UNKNOWN_FILE_EXTENSION]: Unknown file extension ".ts" Every StackOverflow post I've seen says to remove "type": "module" from package.json but then I have to use CommonJS modules, which is kind of annoying. EDIT - Solved. I had to add this above "compilerOptions" in my tsconfig.json: "extends": "ts-node/node12/tsconfig.json", "ts-node": { "transpileOnly": true, "files": true, "compilerOptions": {} },

@JamesQQuick 2 жыл бұрын

Ah yes. There you go!!!