Database & Storage

Local and cloud databases, storage solutions, and data persistence

3
Easy Questions
3
Medium Questions
1
Hard Questions

Easy Questions (3)

What are all the difference between SQL and No SQL ?

View Details →CodeResources

What are all the difference between relational and non-relational databases ?

database
View Details →CodeResources

What is the difference between firestore database and realtime database in firebase ?

databasefirebase
View Details →CodeResources

Medium Questions (3)

( Crash Analytics , Exception , error) handling (like firebase analytics , Sentry)

firebase
View Details →CodeResources

What are all the different database you have used ? (like firebase , sql (sqfite) , app write , mango db)

databasefirebase
View Details →CodeResources

When using local database SQLite in Flutter, what is the difference between INNER JOIN vs LEFT JOIN?

fluttersqlitesqflitedatabasesql
View Details →CodeResources

Hard Questions (1)

I will describe a scenario, and you need to explain the complete flow of how you would handle it. For example: Suppose you are building a chat screen in a mobile application. When a user types a message and presses the Send button, the device may have no internet connection or very poor connectivity at that moment. How would you design the system to handle this situation? Would you prevent the user from sending the message until a stable internet connection is available, or would you store the message locally and send it automatically once the network connection is restored? Please explain the complete flow and the approach you would take.

architectureoffline-firstsyncdatabasenetworking
View Details →CodeResources