SQL Databases and the Firebase Database - The Firebase Database For SQL Developers #1

Welcome to the first video in the Firebase Database for SQL Developers series!

This lesson compares the fundamentals of SQL database to NoSQL databases like the Firebase Database.

[typingcat]

Are you Linus Sebastian's brother?

[mikkotan]

I hope to see the correct way of having one to many, and many to many relationship in firebase in the next videos

[pierbover]

Not having simple relationships and lacking complex queries are the biggest limitations of Firebase. Many NoSQL dbs have a way of doing that (Mongo, Rethink, etc). Why not Firebase? This is the main reason we will not be using Firebase on our next project.

[AlexPatterson]

any chance you could do a series on observables and firebase?

[thelakersfan]

Great video!! Looking forward to a better understanding of the Firebase Database in the next videos!! For developers with a background mostly in sql-like database structures it helps a lot to understand and change to the no-sql side.

[Guihgo]

#AskFirebase how to add random keys with values and after get them ? ( without know name's keys )

[theblackharted]

#AskFirebase Can you PLEASE do an updated video on the equivalent to content searching?? (WHERE description IS LIKE '%foo%'). I know you have the old blog post but it's outdated.

[ottoantao]

Wow.. amaze with this video.. now im beginning to understand more about Firebase..

[yavuzselimekim]

Hi David you are awesome. I'am using FirebaseRecylerAdapter. How can i filter firebase query before set it to adapter? I don't want to show the authenticated user in recylerview. #AskFirebase

[linuslangberg]

Thank you for this David :) Really useful for us SQL folks ;)

[aminozuur]

Well explained. Keep 'em coming !

[moseskarunia]

please make a video about how queries work in firebase!

[carlosbezerra]

Hello, we have a issue with firebase database about IPV6 networks. It don't work, we cant retrieve the data. Apple already reject our app because firebase database don't work properly in ipv6 network. Any solution or support for that? Thanks!

[johnmoses]

Can you create a video series on how to use firestore with php?

[weilieschok]

I am evaluating whether to use Firebase NoSQL or MySQL to be my backend storage. $$$ is more the key concern :)
Let say i need have 1000 employees, 50 departments and 200 available countries, it's considered as 3 collections in Firebase as far as i know.


Let say i need to update 10 employees, i would need to goto "edit screen" for 10 employees and each list out 50 departments, 200 countries in both dropdown box.
To update the 10 employees, does it mean i need to consume (50 + 200) x 10 + 10 = 2, 510 firebase read-usage?
Hopefully someone can address my concerns, as my edit page contain much more dropdown which the values come from DB.

If the admin list out 100 employees on screen, if he accidentally hit F5 (refresh) button, it will consume 100 read-usage/day, am i right?


Thanks for your inputs.

[natnaelalemayehu]

For any one starting nosql database with no prior experience with sql database, I encourage you to first see SQL database. You will make your life much joyful.

[realmuzafarumarov]

this is perfect. looking forward to the next one

[jeevanbahadurthapa]

if i send push message by selecting package from firebase console than push goes to all device but during sending to individual device it display problem."Invalid reg token, please check token format" Plz help me sir :(

[chrisdawes]

A millennial comparison of sql 10 years ago vs nosql - three times the code, same result... no-one writes sql boilerplate anymore...

Where do kids these days get their education? Most leading sql engines now have nosql built in also, so no need for firebase... or vendor lockin.

[WesleyOverdijk]

Or, use default. You don't have to manually go through your data. Lies! Corruption! Cool video though.