Creating PostgreSQL Database Models with Sequelize 

Seriously I Miss this type of tutorials

Hi Ben, Thank you very much for taking the time to create this series. It's what I've been looking for. I've been looking for a nice series on Graphql with React so I'm looking forward to watching the other videos. Do you have a Patreon or any other place where I could pay you a beer? :) Thank you very much again for the great work.

Hi Ben, You can also install sequelize-cli, then run the following command to have basic model setup "node_modules/.bin/sequelize init" This command will setup the config and models folder. After having config files edited to your project, you can run the following command for creating db: "node_modules/.bin/sequelize db:create" For creating models: "node_modules/.bin/sequelize model:generate --name model_name --attributes attribute1:type,attrib2:type"

What tool did you use to mock out your tables and relationships? Looks really useful. I always try to write it all out and I think the visualization would help me immensely.

Hi Ben! Nice series, Thank you for sharing! These are the things that I am looking for. I am not a ninja on Javascript world, but I am currently working on a VueJs project & Laravel as backend. My question is, why did you choose Sequelize over KnexJs?

And I believe you are the best in the whole world :p - You have used the believe word many time in this video in case u forgot why I am commenting like this haha - Thank you Ben for such outstanding content

Great video! In a previous video you had alluded to wanting to making all of your column names lowercase aka postgres friendly. Did you disregard this because the column names you camel-cased are relations/foreignKeys? Just wondering because of your previous comments why you may have done it this way.

Thanks so much for this tutoail. its the best on i can find teaching postgres and node. your a rock star!

Great series!!!! Great video!!!!! What is the purpose of this in index.js? Couldn't find it anywhere in the documentation. models.sequelize = sequelize models.Sequelize = Sequelize

Hi Ben! Video is great to learn. I am facing an issue to create a model for existing table's in a pg database. I should restrict them recreating the table's because i have huge data stored in it.Share your idea please

Thank you, Ben! Awesome part! But I just have some troubles, so it doesn't work until i install 'pg' in project. It is a question for me, why i should did it, but you got it all fine without this package. And after all i get warning from sequelize: sequelize deprecated String based operators are now deprecated. So in index.js i add operatorsAliases: false in options. So i want to ask you about this warning. What is it about? And what i should do? Thank a lot!

Hey, great video series. How do you navigate in the editor so quickly?

Nice video. I've been looking for this

can you do a video on sequelize indexing with postgres

What did you use to create database design?

Both Sync and Migrations are used to create tables in database right? Why must we use sync in order to fetch it back to the database, any ideas on that? cause I'm confused with using them?

Does anyone know what is used to create the visualization of the data flow for your tables at the very beginning of the video?

Great video!

you have babel for import (in node8 with .mjs, but not done yet) and destructuring (which is already in node) so why don't you use `.associate = ({ User }) => {...}`?

really helpfull. how to add associations to existing tables?

Question for you, Ben. In your models, from the very beginning, you went without an ID on your user, instead going with username, email and password. Yet you still reference userId in authorization, as well as with foreign keys in other tables. If you aren't creating a user_id in your models, where is it coming from to use elsewhere? Could you possibly explain a little bit of that? Thanks!

Awesome!

For those who's code didn't create table you can use this, If you haven't any babel or resolver then you can write const models = { User: require('./user')(sequelize,Sequelize), Channel: require('./channel')(sequelize,Sequelize), Message: require('./message')(sequelize,Sequelize), Team: require('./team')(sequelize,Sequelize), }

Thank-you for this great tutorial. I am running into an issue that I can't figure out. I initially created a User model with username and password for the columns. When I save and restart my server, I see the console drops the table if it exists and creates everything and it reflects correctly on the database. However, I needed to add firstName and lastName as fields on the table. When I save, it looks like it updates the table, but my database doesn't reflect the new information. The only way I can get it to update is if I put in force: true as you did in the sync statement. That would be fine, but then it drops all the existing data from the table. How would I add a column on an existing table without having to drop it completely?

for channel and messages you wrote 1:M, but isn't that a channel belons to one team, one message belongs to one channel, and one user? so 1:1? or am I missing something?

hi Ben, can I use Mongodb instead of PostgreSQL ?

Hey its working ! ... i just don't get it how sequelize connects without giving it the url of the database when connecting ?? how does it know where the database is running while the connection function has only username and password ?

Hey Ben I am getting this crazy error. Do you know why? /Users/user/Desktop/slack-clone-server/node_modules/sequelize/lib/dialects/postgres/connection-m anager.js:29 throw new Error('Please install \'' + (sequelize.config.dialectModulePath || 'pg') + '\' module manually');

is there a way to create a database if it does not exist ?

IMPORTANT: use 'pg' version '^6.4.1' or earlier. version 7+ will not work with this code

Can you show How Can I make this in 2020? Class number one also.

why did u not use nosql db here? how do u decide to use rdbms?

What extensions are you using

I am having serious problem setting up PostgreSQL

Why Member table don't have id or primary key?

getting error "please install pg manually" what should i do?

Hey man I don't know why my code is not gonna work even if I wrote totally same with you. just keep occurring this god damn error like 'sequelize.import is not a function' I'm doing this on window OS and I did everything you did at your previous videos

F A C E . J P G

This is one the reasons why I like typed languages like Java. Mapping associations is dead easy in Java with JPA annotations. Sequelize is quite ugly.

Hi Ben, thanks for the great fully fledged series. I stumbled across it while looking for styled components examples. When I saw the example is using GraphQL on top of it I figured I could just base my next project off this. What would be great is if you could switch out the whole postgreSQL part with Prisma, which under the hood also uses postgreSQL. Check it out: blog.graph.cool/introducing-prisma-1ff423fd629e?gi=47a16554dd6f

where is part 2?

Hi Ben, I keep getting sequelize deprecated error: sequelize deprecated String based operators are now deprecated. Please use Symbol based operators for better security, read more at docs.sequelizejs.com/manual/tutorial/querying.html#operators checked the guide but kind of not resolving the issue, any comments?

I'm getting: "Unhandled rejection SequelizeConnectionError: role "postgres" does not exist" and my slack database is still empty when i type \d. Do you know what I'm missing? i've used postgres on my computer before so im not sure what the error means