Thank you everyone for all your support and kind words! You can also catch me on my own channel and on instagram :) Check it out here: RUclips: ruclips.net/user/aniakubow Instagram: instagram.com/aniakubow
Can you please stop reading text from the paper / screen. It sounds so unnatural and hard to understand because at some moments of time you may reader faster than needed. Also it looks creepy
Great video exposing the underlying structures and differences! My choice between them always comes down to the number of data tables that need to be related in different or dynamic ways and if any external systems need access to the same data. If I have multiple tables that I will be grabbing data from where relationships are defined in different ways depending on what is being requested sometimes with dynamic queries. Then you can create indexes based on these different situations. The other thing is external access to the db by reporting/other external products. If these is true I will use SQL. If I am treating the blocks of data more like groups of related objects (either able to be dynamic or non-dynamic schemas) and primarily using it in a custom programming project then I will choose NoSQL for the massively increased speed and ease of use in programming (using a DB that has a .net 6+ library). As no external systems need to hit it (as they would be part of the project) the more 'open' SQL system is not required. Typically I will use a code-based schema, so we have a static schema that is easily modifiable and definable. I don't use graphql as queries can spiral out massively very quickly ;P
Great video, however i would say some points in cons and pro’s could be softened. I.e., you can scale mysql horizontally with replicas; you have to think about schema and migration in both paradigms as everyone needs robust and consistent applications. You need to write migrations for nosql and support all variations of data in your app, this may be a not easy task. Sql data normalisation wasn’t invented to save data, rather to avoid data anomalies. You can have denormalised tables for optimisation purposes. Indexes allow to optimize read speed in sql. Etc. Also, while comparing, data amount matters. Are we building whatsapp? Then we need every nanosecond we can get. If it’s a regular blog or ecommerce site with tens of thousands items, you don’t need sharding. You’d spend more time designing partition key and indexes for nosql then in sql like posrgres. If you have a lot of log-like data, in sql to speed up writes, you can rotate the table like logs, have many tabels with suffixes cut by date or something.
Have fun! As part of my job, I do a lot of backend development and designing and querying relational databases can be very satisfying as you get better at it. Small piece of advice: avoid MYSQL if you can, as there are much better free and open source alternatives such as PostgreSQL and even Microsoft SQL Server Express if your app is not too big.
Putting our time and effort in activities and investments that will yield a profitable return in the future is what we should be aiming for .success depends on the action or steps you take to achieve it.
THE GOSPEL Moreover, brethren, I declare unto you the gospel which I preached unto you, which also ye have received, and wherein ye stand; 2 By which also ye are saved, if ye keep in memory what I preached unto you, unless ye have believed in vain. 3 For I delivered unto you first of all that which I also received, how that Christ died for our sins according to the scriptures; 4 And that he was buried, and that he rose again the third day according to the scriptures: - 1 Corinthians 15: 1-4 KJV Greater love hath no man than this, that a man lay down his life for his friends. - John 15:13 KJV SAVALATION For God so loved the world, that he gave his only begotten Son, that whosoever believeth in him should not perish, but have everlasting life. - John 3:16 KJV For God sent not his Son into the world to condemn the world; but that the world through him might be saved. John 3:17 Jesus saith unto him, I am the way, the truth, and the life: no man cometh unto the Father, but by me. - John 14:6 KJV Neither is there salvation in any other: for there is none other name under heaven given among men, whereby we must be saved. Acts 4:12 For if, when we were enemies, we were reconciled to God by the death of his Son, much more, being reconciled, we shall be saved by his life. Romans 5:10 But he was wounded for our transgressions, he was bruised for our iniquities: the chastisement of our peace was upon him; and with his stripes we are healed. - Isaiah 53:5 For by grace are ye saved through faith; and that not of yourselves: it is the gift of God: Not of works, lest any man should boast. Ephesians 2:8-9 And saying, The time is fulfilled, and the kingdom of God is at hand: repent ye, and believe the gospel. - Mark 1:15 KJV He that believeth on the Son hath everlasting life: and he that believeth not the Son shall not see life; but the wrath of God abideth on him. - John 3:36 KJV Who hath saved us, and called us with an holy calling, not according to our works, but according to his own purpose and grace, which was given us in Christ Jesus before the world began. 2 Timothy 1:9 For the Son of man is come to seek and to save that which was lost. Luke 19:10 The Lord is not slack concerning his promise, as some men count slackness; but is longsuffering to us-ward, not willing that any should perish, but that all should come to repentance. 2 Peter 3:9 He that believeth and is baptized shall be saved; but he that believeth not shall be damned. Mark 16:16 For as in Adam all die, even so in Christ shall all be made alive. 1 Corinthians 15:22 For scarcely for a righteous man will one die: yet peradventure for a good man some would even dare to die. But God commendeth his love toward us, in that, while we were yet sinners, Christ died for us. Romans 5:7-8 I am the door: by me if any man enter in, he shall be saved, and shall go in and out, and find pasture. John 10:9 That if thou shalt confess with thy mouth the Lord Jesus, and shalt believe in thine heart that God hath raised him from the dead, thou shalt be saved. 10 For with the heart man believeth unto righteousness; and with the mouth confession is made unto salvation. 11 For the scripture saith, Whosoever believeth on him shall not be ashamed. - Romans 10:9-11 KJV
Where in Ukraine or Russia do you liev Ania. You look gorgeus. Yes sorry, i am single, i rather would have been raised in India or Indonesia, that is why i am single I guess.
Great video, however i would say some points in cons and pro’s could be softened. I.e., you can scale mysql horizontally with replicas; you have to think about schema and migration in both paradigms as everyone needs robust and consistent applications. You need to write migrations for nosql and support all variations of data in your app, this may be a not easy task. Sql data normalisation wasn’t invented to save data, rather to avoid data anomalies. You can have denormalised tables for optimisation purposes. Indexes allow to optimize read speed in sql. Etc. Also, while comparing, data amount matters. Are we building whatsapp? Then we need every nanosecond we can get. If it’s a regular blog or ecommerce site with tens of thousands items, you don’t need sharding. You’d spend more time designing partition key and indexes for nosql then in sql like posrgres. If you have a lot of log-like data, in sql to speed up writes, you can rotate the table like logs, have many tabels with suffixes cut by date or something.
Thank you everyone for all your support and kind words! You can also catch me on my own channel and on instagram :) Check it out here:
RUclips: ruclips.net/user/aniakubow
Instagram: instagram.com/aniakubow
💞
Can you please stop reading text from the paper / screen. It sounds so unnatural and hard to understand because at some moments of time you may reader faster than needed. Also it looks creepy
@@fuckcorporati0ns lmao tru it looks creepy
@@fuckcorporati0ns can you do better?
@@sholle7 it is not about who can do better, why you even asking...
Great video exposing the underlying structures and differences!
My choice between them always comes down to the number of data tables that need to be related in different or dynamic ways and if any external systems need access to the same data.
If I have multiple tables that I will be grabbing data from where relationships are defined in different ways depending on what is being requested sometimes with dynamic queries. Then you can create indexes based on these different situations. The other thing is external access to the db by reporting/other external products. If these is true I will use SQL.
If I am treating the blocks of data more like groups of related objects (either able to be dynamic or non-dynamic schemas) and primarily using it in a custom programming project then I will choose NoSQL for the massively increased speed and ease of use in programming (using a DB that has a .net 6+ library). As no external systems need to hit it (as they would be part of the project) the more 'open' SQL system is not required. Typically I will use a code-based schema, so we have a static schema that is easily modifiable and definable.
I don't use graphql as queries can spiral out massively very quickly ;P
Watching this now!! Thanks Ania!!
Thank you!!!
great content!! thanks again for the lesson Ania!!
This is just a video I am looking for! Thanks, Ania!!
So great to hear 😀
Great video, however i would say some points in cons and pro’s could be softened.
I.e., you can scale mysql horizontally with replicas; you have to think about schema and migration in both paradigms as everyone needs robust and consistent applications. You need to write migrations for nosql and support all variations of data in your app, this may be a not easy task.
Sql data normalisation wasn’t invented to save data, rather to avoid data anomalies. You can have denormalised tables for optimisation purposes. Indexes allow to optimize read speed in sql. Etc.
Also, while comparing, data amount matters. Are we building whatsapp? Then we need every nanosecond we can get. If it’s a regular blog or ecommerce site with tens of thousands items, you don’t need sharding. You’d spend more time designing partition key and indexes for nosql then in sql like posrgres.
If you have a lot of log-like data, in sql to speed up writes, you can rotate the table like logs, have many tabels with suffixes cut by date or something.
Thank you so much for these tutorials!
Amazing work on the explanation, trying it definitely
Thanks, Ania!
15:30 I always get a syntax error because '013s3' is not an integer.
Wealth of info, Ty 👍🏽
great summary! ty
Thank you for creating this. You explained everything really well. Subscribed to your channel too.
Thank you I appreciate it 🙏
thank you for sharing database
Będzie oglądane 👊 Pozdrawiam 🔥
Super!!!
You have explained it so well that i have understood in 2 hours but Two years of college teaches me nothing. You are great 👍👍👍👍
Any words on backup and restore databases?
U look like khalisi from game of throne
I just started my journey with SQL.
Ok
Ok
Pleasse dont ok me :(
Have fun! As part of my job, I do a lot of backend development and designing and querying relational databases can be very satisfying as you get better at it.
Small piece of advice: avoid MYSQL if you can, as there are much better free and open source alternatives such as PostgreSQL and even Microsoft SQL Server Express if your app is not too big.
ruclips.net/video/FzlpwoeSrE0/видео.html
For SQL, how was it possible to insert and Id of string '013s3' to a column of integer type?
It’s a string
I have no patience to hear for an hour! Google already answered it!
No pineapple on pizza! 42:45
No pizza without pineapple!
😂😂 - gotta love me some pineapple pizza 🍕
Love you ania ❤️
❤️
@@aniakubow big fan ❤️❤️
11:28
Great
Good
NoSQL is better
Love u, real Filisiti Sm❤oke
I'd use anything Ania says to...
Are you Targeryen ...keep it up
👑🐉
Yo denerys back teaching
For your voice alone, the video would be worth it.
👏👏
Putting our time and effort in activities and investments that will yield a profitable return in the future is what we should be aiming for .success depends on the action or steps you take to achieve it.
@frankcicinelli
Instant click!!!!!
😍
Not helpful to me right now. Maybe sometime in the future.
Super cute
You have beautiful eyes
এমন একটা টীচার পাইলে সারাদিন ওয়েব ডিজাইন শিখতাম। 😶
Khalisi...
🐉👑
1st
THE GOSPEL
Moreover, brethren, I declare unto you the gospel which I preached unto you, which also
ye have received, and wherein ye stand; 2 By which also ye are saved, if ye keep in memory what I preached unto you, unless ye have believed in vain. 3 For I delivered unto you first of all that which I also received, how that Christ died for our sins according to the scriptures; 4 And that he was buried, and that he rose again the third day according to the scriptures:
- 1 Corinthians 15: 1-4 KJV
Greater love hath no man than this, that a man lay down his life for his friends. - John 15:13 KJV
SAVALATION
For God so loved the world, that he gave his only begotten Son, that whosoever believeth in him should not perish, but have everlasting life.
- John 3:16 KJV
For God sent not his Son into the world to condemn the world; but that the world through him might be saved. John 3:17
Jesus saith unto him, I am the way, the truth, and the life: no man cometh unto the Father, but by me.
- John 14:6 KJV
Neither is there salvation in any other: for there is none other name under heaven given among men, whereby we must be saved. Acts 4:12
For if, when we were enemies, we were reconciled to God by the death of his Son, much more, being reconciled, we shall be saved by his life. Romans 5:10
But he was wounded for our transgressions, he was bruised for our iniquities: the chastisement of our peace was upon him; and with his stripes we are healed. - Isaiah 53:5
For by grace are ye saved through faith; and that not of yourselves: it is the gift of God: Not of works, lest any man should boast. Ephesians 2:8-9
And saying, The time is fulfilled, and the kingdom of God is at hand: repent ye, and believe the gospel.
- Mark 1:15 KJV
He that believeth on the Son hath everlasting life: and he that believeth not the Son shall not see life; but the wrath of God abideth on him.
- John 3:36 KJV
Who hath saved us, and called us with an holy calling, not according to our works, but according to his own purpose and grace, which was given us in Christ Jesus before the world began. 2 Timothy 1:9
For the Son of man is come to seek and to save that which was lost. Luke 19:10
The Lord is not slack concerning his promise, as some men count slackness; but is longsuffering to us-ward, not willing that any should perish, but that all should come to repentance. 2 Peter 3:9
He that believeth and is baptized shall be saved; but he that believeth not shall be damned. Mark 16:16
For as in Adam all die, even so in Christ shall all be made alive. 1 Corinthians 15:22
For scarcely for a righteous man will one die: yet peradventure for a good man some would even dare to die. But God commendeth his love toward us, in that, while we were yet sinners, Christ died for us. Romans 5:7-8
I am the door: by me if any man enter in, he shall be saved, and shall go in and out, and find pasture. John 10:9
That if thou shalt confess with thy mouth the Lord Jesus, and shalt believe in thine heart that God hath raised him from the dead, thou shalt be saved. 10 For with the heart man believeth unto righteousness; and with the mouth confession is made unto salvation. 11 For the scripture saith, Whosoever believeth on him shall not be ashamed.
- Romans 10:9-11 KJV
wow, so beautiful woman.
Where in Ukraine or Russia do you liev Ania. You look gorgeus. Yes sorry, i am single, i rather would have been raised in India or Indonesia, that is why i am single I guess.
unbelievable levels of attention seeking
You can put that in your own channel's "About" section, you don't have to comment it on other people's videos.
seems like personal branding is more important than coding nowadays. Ask google
i don't understand, what problem do you 2 have with this woman, the video was pretty good.
Very respectfully i have to say you are a Goddess, that said amazing content
I can not understand your accent lady Ania
Very good comparison. It’s a question that a lot of devs ask 🫲🏻🙏
Great video, however i would say some points in cons and pro’s could be softened.
I.e., you can scale mysql horizontally with replicas; you have to think about schema and migration in both paradigms as everyone needs robust and consistent applications. You need to write migrations for nosql and support all variations of data in your app, this may be a not easy task.
Sql data normalisation wasn’t invented to save data, rather to avoid data anomalies. You can have denormalised tables for optimisation purposes. Indexes allow to optimize read speed in sql. Etc.
Also, while comparing, data amount matters. Are we building whatsapp? Then we need every nanosecond we can get. If it’s a regular blog or ecommerce site with tens of thousands items, you don’t need sharding. You’d spend more time designing partition key and indexes for nosql then in sql like posrgres.
If you have a lot of log-like data, in sql to speed up writes, you can rotate the table like logs, have many tabels with suffixes cut by date or something.