Differences
This shows you the differences between two versions of the page.
|
dapm:laboratoare:08 [2020/04/06 01:26] sabina.horincar [SQLite and Firebase] |
dapm:laboratoare:08 [2020/04/13 13:00] (current) sabina.horincar [Exercises:] |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ===== Laboratorul 08. ===== | ===== Laboratorul 08. ===== | ||
| + | ===== SQLite and Firebase ===== | ||
| **SQLite** is an **open-source relational database** i.e. used to perform database operations on android devices such as storing, manipulating or retrieving persistent data from the database.\\ | **SQLite** is an **open-source relational database** i.e. used to perform database operations on android devices such as storing, manipulating or retrieving persistent data from the database.\\ | ||
| + | SQLite is a local database on Android device (data stored/processed on a device) with SQL interface. So, there is no need to perform any database setup or administration task.\\ | ||
| + | SQLite is a legacy, it is independent & absolutely free. Today several browsers,operating system and embedded systems use SQLite its a most deployed database engine. SQLite is file-based — the database consists of a single file on the disk, which makes it extremely portable and reliable.\\ | ||
| + | \\ | ||
| + | |||
| + | **FireBase** is a cloud service. FireBase is a NoSQL database. Data stored/processed in a cloud. To access them device need an internet connection. FireBase is suitable for real-time applications.\\ | ||
| + | |||
| + | Add Firebase to your Android project: https://firebase.google.com/docs/android/setup \\ | ||
| + | \\ | ||
| + | |||
| + | |||
| + | **What is NoSQL?**\\ | ||
| + | NoSQL databases, on the other hand, have dynamic schemas for unstructured data, and data is stored in many ways: They can be column-oriented, document-oriented, graph-based or organized as a KeyValue store. This flexibility means that:\\ | ||
| + | |||
| + | - You can create documents without having to first define their structure\\ | ||
| + | - Each document can have its own unique structure\\ | ||
| + | - The syntax can vary from database to database, and\\ | ||
| + | - You can add fields as you go.\\ | ||
| + | |||
| - | It is embedded in android bydefault. So, there is no need to perform any database setup or administration task.\\ | + | **What is SQL?**\\ |
| + | SQL databases use structured query language (SQL) for defining and manipulating data. On one hand, this is extremely powerful: SQL is one of the most versatile and widely-used options available, making it a safe choice and especially great for complex queries. On the other hand, it can be restrictive. SQL requires that you use predefined schemas to determine the structure of your data before you work with it. In addition, all of your data must follow the same structure. This can require significant up-front preparation, and, as with Town A, it can mean that a change in the structure would be both difficult and disruptive to your whole system.\\ | ||
| + | ====Exercises:==== | ||
| + | **This lab can be done in teams of 2 if max one person from the team doesn't have a laptop with Android Studio. The person without the Android laptop should take care of the documentation and the Android Studio part should be done together. **\\ | ||
| - | **Exercises:**\\ | + | 1. Create a document describing the pro & cons of using SQLite vs Firebase and pro & cons using SQL vs NoSQL (write it in Romanian, English or French)\\ |
| - | 1. Create a small document describing the advantages and disadvantages of using SQLite & Firebase\\ | + | |
| 2. Take a look at the following SQLitetutorial: http://tutorialscache.com/android-sqlite-tutorial/ \\ | 2. Take a look at the following SQLitetutorial: http://tutorialscache.com/android-sqlite-tutorial/ \\ | ||
| 3. Create another application using SQLite or Firebase. It can be a tutorial found online - put the link in the document. Upload the project on Github and write a short README file explaining the exercise and don't forget to include a VIDEO & PICTURES of the application. \\ | 3. Create another application using SQLite or Firebase. It can be a tutorial found online - put the link in the document. Upload the project on Github and write a short README file explaining the exercise and don't forget to include a VIDEO & PICTURES of the application. \\ | ||
| - | 4. Send the document including exercise 1 and the link of your tutorial or GitLab project to **sabina.horincar@gmail.com** until Monday (6 Apr) 20:00. | + | 4. Send the document including exercise 1 and the link of your tutorial and/or GitLab project to **sabina.horincar@gmail.com** until Monday (6 Apr) 20:00. |
