Should I know enough to build a working crud app now?

Hello,

I’m working through the Backend Developer course, and I just finished the module on deploying with Heroku.

So now I know how to
~ Use SQL commands to interact with a database
~ set up a RESTful API with Node.js
~ Deploy a postgres backend with Heroku

It seems that these building blocks should be enough to build and deploy a simple crud app where I could post, put, and delete from a table, such as “users”. But I feel like I’m missing one (or maybe two) important connections to bring this all together and make such an app functional.

If the Codecademy lessons DO intend to help me put all this together, then I’m perfectly happy to simply continue on my path. But when I look ahead, it seems like the upcoming lessons will be moving on from this skill. They’re going into testing, then design principles, then API development.

Does anybody know of a good tutorial or something that might help me complete a crud app with Express, Postgresql, and deploy that app on Heroku?

Thanks in advance for any insight!

Hi there.
Check out this tutorial on PostgreSQL: PostgreSQL: What is a Database | Course | 2019 - YouTube
And this library to connect your PostgreSQL database with Node: https://node-postgres.com/

I feel the same way, having completed everything up to here, I need to review all of this in a real project, not some half working boilerplate…

1 Like

Well said, Leo.

I did manage to build my CRUD app. It required me to read quite a few articles, and even to guess a few things for myself. There are dozens of tutorials available, but for some reason, none of them ventured into how to ‘put’ and ‘delete’ from the front end.

This video provided many of the “holes” that were missing in my understanding.

1 Like

Thanks! I’ll definately check it out in the next days! What app did you build ?

1 Like

I re-built an old app that I’d originally done with Ruby on Rails. It arranges students into groups based on what topics they haven’t yet passed off.

What are you working on?

I’m fetching real estate deals from France’s public API and allowing saving them along with searches. :smiley:

Hopefully I can get something neet to add to my portefolio!

That sounds like a cool app. Let me know how it progresses.

Hey Jeff,

After 5 weeks of work, I finally have my first website : a web tool which allows to search and display real estate deals in France.

I would say nothing was simple, but getting acquired to a styling library and deploying were the most difficult parts for me.

I will make another post with a link to my github once my code is refactored but for now, here it is :slight_smile: https://dealfinder.onrender.com/

Any advices or comments are welcome!

Bye

Well done, Leo! Your site is visually appealing. I’d love to learn how to include a map like you’ve done.

Cheers!

-Zee (Jeff)

Thanks for the feedback ! I went with google map for javascript (as well as a package called google map react). You can check it out in the developer console, or later when I upload the clean code to my github.

Have a good one!