William Kylespeare

the first 15 second I felt like I clicked the wrong video 😂

When he said 'To sequel or not to sequel that is the question' i was in tears. Truly one of the best lines of all times

In fact the "relational" part of database does not refer to the relations between different tables, but to the relational model as laid out by E.F codd. In this model, tables are called Relations and rows are called tuples.

Your explanation are nice If you show slides and image to explain it will be much better and much easier for beginners to relate things you say and understand better

Was really stuck with what setup to choose for a new project. I use SQL at work and NoSQL for side projects and have always felt more comfortable with NoSQL. Your last point about choosing whatever you're most comfortable with really resonated with me, great video!

Nice, quick explanation and that top-left corner perfectly aligned with room’s corner line👍

I always get confused on these two DBs but you explanation was very clear and made a lot of sense

I love your channel!!! Can't stop watching. All your content is the best ☺️

best overview and comparison i've got so far! thanks a lot! 👍

Love this video! I greatly appreciate the perspective!

SQL can handle many connections (you made it sound like SQL can only manage a handful of connections). If there is an appearance of “slowness” it’s likely related to the isolation level \ locking, which can be managed with good database design (9/ 10 times perf issues are attributable to poor developer choices). The choice between the two systems should be about isolation level requirements , scale (data volume \ geo-distribution) and the actual data model being stored. If you’re dealing with high transaction financial data, your likely not gonna go no sql. Likewise, if your storing IOT data then no sql is going to be better. If you’re never going to shard your data, mongodb is not worth it as SQL will outperform it.

I absolutely love the intro and the entire explaination

This actually really helped me understand both! Currently I’m learning MySQL with php and I may consider using react with it. I say MySQL I enjoy for your explanation of the great structure and columns and I care about readability. Though I may learn mongodb in larger scale applications in the future. Since mongodb sounds great for big projects

Thank you man, is just what I was looking for!

3:05 Redis saves data to the disc periodically and loads it on startup.

That sloved my confusion... thanks 😊 And im also waiting for Javascriptsimplified course to reopen registration.

Really appreciate the way you explained this controversial topic. Keep it up bro

That's the explanation I needed. Thanks a lot man.

bro sold his all furniture to buy a guitar 🎸

Huge thanks. I think if you add a table of comparing these two type would be much better for summarizing.

Man, you speak very fast but with a excellent pronunciation. It is really good for me, since I'm learning english. xD. Excellent comparative, and thank you for comment about Json in PostgreSQL.

Correct me if I'm wrong but if you're familiar with DBMS concepts you can adapt to both SQL and Nosql right?

Amazing explanation , always motivates me to learn futher

Hey what do you think of services like Firebase in context of whether or not it'd be the future of database? Also is the pricing worth it?

I've been dabbling in SQL a lot more lately. I'm actually considering building my newest project using it as the database. Most likely going to go with PostgreSQL. Thanks for the content Kyle. Much love my friend!

bigger companies use tons of different database types for different purposes but imo if u learn how to optimize SQL databases really well then u can apply these concepts to the other types

Amazing explanation sir!

Great explanation!

a video I wish I had watched when I was making my research on the topic a while ago

Kyle, I never thought to ask.. did you do the intro riff yourself??

Kyle, you're great teacher!

This is first unbiased video I have watched till now. Everyone else telling that NoSql is just better and whatever advantage they tell can also be applied on SQL

A legit conclusion. Both technologies are proportionally good. The SQL allows vertical scaling, while NoSQL - horizontal scaling. The SQL simplifies the usage of MVC, MVVM, Object Validation and bindings, while the NoSQL simplifies the ability to make changes into projects (very useful for e-commerce dbs). The idea to use JSON data as TEXT in SQL is promising as something intermediate.

So to sum-up SQL - fast to read - you can count on constant a format NoSQL - fast to write - hard to update - better at handling lots of connections at the same time (why?) - better at scaling - good for unstructured data

I like your keyboard typing sounds , Can I ask you for a link on amazon for this keyboard? Thank you. : )

This was helpful. It would be even more helpful if you provide brief reasons for each claim on why SQL or NoSQL is better. For example, why is it usually quick to write but harder to read from a NoSQL DB?

Really nice start with the William Shakespeare

Another excellent video

Hello Kyle, big fan of your videos ! I don't understand why wou say that non-relational databases can be more "fuzzy" because the data written goes though less checks compared to a SQL db. If I take MongoDB for example you have to create a model that define what kind of data to expect (and possibly further restrictions) and to setup some validation criteria that data has to go through to be stored in the database. Have a nice day.

Nearing 500k subs! What an achievement!

Fast Fast and very every useful. Thanks

Nice explained 💪🏻

Best practice for me : Sql for Database and Firebase Remote Config as a json config for the App

Watched the rest of your video, is NoSQL databases easier to use in comparison to MySQL?

4:54 Isn’t one of the benefits of a nosql database like mongodb is that you optimize for reads by having denormalized data at the cost of more costly writes?

thank you for this!

I will learn both of these.

Please make this series of comparing different technologies like SSR vs CSR, React vs Vue, Tailwind vs Bootstrap etc

I wonder, what about encoding foreign characters? I made a project with MySQL and I had lots of problems with encoding Japanese (language learning website). I hope other databases are set to support utf-8 by default. I had to set up encoding in like maybe 4 places for it to work...

Hey man, usually a fan of the videos but I feel like this one fell pretty short. Alot of surface explanation without any real world examples which I feel would help extremely

oh man, you brought Sheksphere.... love you man.

I still do not understand why would I use noSQL when I could simulate it in mySQL by (for example) adding a text field that contains some json. Is ti much faster? Or is there something else I'm missing)

Awesome, thank you.

I came here to appreciate PostgreSQL and your Ibanez lady

thanks your explanation is very good. SQL is the best for relational data.

Imo you missed the most important feature of sql databases, which is ACID transactions. That's the fundamental stone of pretty much every enterprise application

This guy legit looks better than most of the male models appearing on product advertisements and could easily land ads showcasing hair products.

What database should I use for a messenger app

Will you make a tutorial on game development

sorry love your vids super strong content but wasn't the quote from hamlet, or was that part of the joke ??

I get the feeling that you've never worked as a database administrator for any large-scale system. Some of the things you said make no sense to me at all. There's a huge difference between a normalized, relational database in a production corporate database vs. a transient data store in an app or a website.

Hi Web dev Simplified; I would like to create my first CRUD app learning REACT at the moment. Soon I will start learning node.js and afterwards MySQL. I know how to perform basic queries within tables in a database but not between multiple tables. I am familiar with creating new database and creating new tables too. My question is I am decent on the front end could you provide resources which teach how to use a backend technology alongside MySQL or even postgreSQL to store your data for a basic blog app. My thoughts are to create a blog app which will allow a maximum of at least 10 people to create a very simple profile and post messages on a board. No securities, no cookies something locally from my hard drive. Figured I start small and work my way up. Any guidance would be appreciated.

Among the people who talk about programming on youtube, I prefer your approach. You always bring the subject well summarized, contextualized and didactic. It is complex to do simple things, isn't it? ... Only those who have very clear reasoning can do this. The simple fact that you put the noSQL image as branches of a tree, already shows your skill. Keep it up... and you will be helping to build a solid foundation for the evolution of technology.

What is Chris Pine doing here ? Also sick Jackson ,just chillin in the corner

What a creative intro 😂😂

If you use it properly then there are zero joins in NoSQL database and reading is faster than SQL. Cost of 1 GB storage is super low. So you can repeat data without worry.

If i use a SQL database as a NoSQL the performance would be the same? For example, using PostgreSQL Json column.

love you sir

Hello! Coming from NoSQL (Mongo) to SQL What I don't like with Mongo is that if you delete a document (A) in one model that references another document from another model (B), then B is not deleted, you need to handle this manually If I understand well, there is no such problem with SQL databases ?

you missed one of the main points, the acid vs base model. most of the time, I see those models as one of the main decision maker on what to use.

Thank you.

I use Mongo cause the logo looks cool 😎

Hmmm, I'm storing json data to MySQL atm.

For Internet of Things like Smart Energy Meters, which will be a better solution for storing the data?

Thanks

I would like this entire video as a text document 😂

I want to create a database in order to receive data from the Arduino meteorological monitoring device (temperature - irrigation speed - humidity). The degree of measurement is sent every 30 minutes, so what is the best type of database

MySQL also supports JSON columns.

i was looking for it 🤣

how can i work on SQL as Team in local host database ?

Which one is better for mobile?

omg I swear I just thinking about this question in few minutes before open youtube and then... this happened

Make video about mysql or mongodb with redis as a cache

Sir plz plz make a video on blob type url in js

thx a lot

With some illustration and diagram the video would have been much more interactive and interesting

Play something with that guitar

Just depends on what your app needs.

MySQL do have JSON type column too

good video, userfull for me

thanks

good job

Definitely need some images, slides during the explanations.

MySQL is great for correlational studies, especially for routine data. However, it takes time to organize the tables. No-SQL is great for chaotic and dynamic based data. Think of data tracking a bipolar person.

I'd lean towards a NoSQL database is starting a new project with potentially large amounts of data. The biggest weakness isn't reading data, it's searching data, this problem is true for both paradigms. Most large applications get around this by using an index like SOLR or Elastisesrch to grab the UID for a row and then query the database with those UIDs. That is very responsive. What really makes the NoSQL approach attractive is you're not bound to a schema that requires a lot of work to change. If you want to change your data structures a bit, you just have to change the mappers.

at first I thought that you're gonna be explaining Shakespeare's play 🤣

Framer Motion for React please 🔥🔥🔥

Is there some morse code or som'n in how much he's blinking?

can you tell me which database would be easy to use with React?