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

What people said

Recommends Wilik · 2016-12 · Stack Overflow · on “getKey() returns value instead of ID”

You are not supposed to store your data like that in Firebase / NoSQL database. I suggest you to watch this playlist Firebase for SQL Developers [this video] and read Structure Your Database [LINK] If you don't want to change your database structure, read my updated answer @MaartenWeyns

Recommends John O'Reilly · 2017-01 · Stack Overflow · on “Firebase: how to sort, filter and paginate a query on 'huge many-to-many" relation?”

As a "nosql" database, Firebase doesn't have ability to directly do joins the way you can with SQL databases. The following series (by Firebase guys) gives a good overview of this [this video]

Recommends Alex Mamo · 2017-05 · Stack Overflow · on “Using Firebase Database with large data some queries”

Yes, it is possible to migrate to Firebase even if your database is very large. To archieve this, i suggest you watch this tutorial, The Firebase Database For SQL Developers [this video] . Even if Firebase is a NoSQL Database, i'm sure you'll be very familiar in short time. Yes, the key for doing this is to have the data as flatten as possible. Please take a look at this tutorial [LINK] . Will be very helpful. If you'll be able to have a Firebase database as much as possible, as it described in the tutorial above, you'll be able to have less to pay. For pricing, take a look here [LINK] !. Hope it helps.

Recommends James Poag · 2017-05 · Stack Overflow · on “Can I retrieve queries based on two properties?”

The short answer is no. From the docs: You can only use one order-by method at a time. Calling an order-by method multiple times in the same query throws an error. [LINK] You can limit the Range of data using a filter function: [LINK] Be sure to watch the Firebase for SQL devs [this video] series. Specifically, the video on denormalization [LINK] (#6) and the follow up Multi-path updates (#7). Multipath updates can be performed server side using Cloud function triggers [LINK] .

Recommends Eduardo Vargas · 2017-06 · Stack Overflow · on “Angular 2 Firebase - How can I realize SQL behaviour?”

For your Firebase questions coming from a sql background this playlist will help you a lot [this video] Most of the time you can just insert the firebase service in your component and do the logic there. If you need extra services(not Firebase) or don`t want to duplicate your code is probably better to have just a TeacherService and then depends if you want to lazy load your courses you create a CourseService. If in the same screen you show the teachers and the courses you can do all in one service. So to resume it is better to model your service after your views. if you gonna use firebase in your service you can do something like: import { AngularFire, FirebaseListObservable } from 'angularfire2

Recommends James Poag · 2017-06 · Stack Overflow · on “How can I make relational database in firebase?”

Jen, thank you and the rest of the Firebase team for such great videos!! I would probably also link to this series: [this video] with emphasis on denormalization and to use the cloud functions to propagate updates.

Recommends MuruGan · 2017-09 · Stack Overflow · on “firebase CRUD issue when chaining server?”

Your using older version of firebase, try to use new version of firebase i.e 4.3.1 Firebase Documentation for latest version [LINK] Go through this link, it will really helpful for you. I hope. Please feel free to ask any doubts regarding and this See this firebase for SQL developers, it will be more useful for CRUD Operations [this video]

Recommends cutiko · 2017-09 · Stack Overflow · on “Firebase how to avoid data conflict”

There is a great series of videos [this video] in which is explained that Firebase-Database as a nosql provide advantages as speed and data flexibility but also make the developer's responsibility to maintain data coherence. So what you want is the opposite of what you need, you want data normalization but actually, you need data denormalization . Your data structure will reflect the content that the user is consuming. Your data structure is equivalent to your information architecture. As Frank van Puffelen explained you can use multi-updates using the ´updateChildren()´ method. Also, you can use Firebase Functions [LINK] as a server-side way to sustain business logic. In the long run clients and

Recommends Georgios S. · 2017-11 · Stack Overflow · on “How to write back end server code in Firebase”

As you already know firebase is a nosql database so you need to denormalize your data. I would suggest watching some very useful firecasts from David East like this one [this video] and refer to the firebase blog as well! [LINK] Follow the updated links provided in the article as well!

Recommends glutengo · 2017-12 · Stack Overflow · on “Better way of filtering data with Cloud Firestore”

If you want more information on more complex queries, you can follow this playlist: [this video] But don't expect too much, unfortunately, some solutions are quite painful to watch...