Firebase

Firebase, Inc.

Type of business	Subsidiary
Founded	September 2011 (2011-09)[1]
Headquarters	San Francisco, United States[2]
Area served	Global
Founder(s)	James Tamplin, Andrew Lee[3]
Industry	Mobile backend as a service, Mobile application development
Products	Analytics, Cloud Messaging, Authentication, Realtime Database, Cloud Firestore, Storage, Hosting, ML Kit, Remote Config, Test Lab, Crash Reporting, Notifications, App Indexing, Dynamic Links, Invites
Parent	Google
Website	firebase.google.com
Launched	April 2012[4]

Firebase is a mobile and web application development platform developed by Firebase, Inc. in 2011, then acquired by Google in 2014.^[5]

History

Firebase evolved from Envolve, a prior startup founded by James Tamplin and Andrew Lee in 2011. Envolve provided developers an API that enables the integration of online chat functionality into their websites. After releasing the chat service, Tamplin and Lee found that it was being used to pass application data that weren't chat messages. Developers were using Envolve to sync application data such as game state in real time across their users. Tamplin and Lee decided to separate the chat system and the real-time architecture that powered it. They founded Firebase as a separate company in April 2012.^[6]

Firebase Inc. raised seed funding in May 2012. The company further raised Series A funding in June 2013.^[7] In October 2014, Firebase was acquired by Google.^[8] In October 2015, Google acquired Divshot to merge it with the Firebase team. Since the acquisition, Firebase has grown inside Google and expanded their services to become a unified platform for mobile developers. Firebase now integrates with various other Google services to offer broader products and scale for developers. In January 2017, Google acquired Fabric and Crashlytics from Twitter to join those services to the Firebase team.^[9][10] Firebase launched Cloud Firestore, a Document Database, in October 2017.^{[11][12][13][14]}

Services

package com.modelpaper.mad.it17121002;

import android.content.ContentValues; import android.content.Context; import android.database.Cursor; import android.database.sqlite.SQLiteDatabase; import android.database.sqlite.SQLiteOpenHelper; import android.util.Log;

import java.util.ArrayList;

public class DBHandler extends SQLiteOpenHelper {

   public DBHandler(Context context) {
       super(context, "user_db", null, 1);

   }

   @Override
   public void onCreate(SQLiteDatabase db) {

       String createQuery = "CREATE TABLE "+UserProfile.Users.TABLE_NAME +
               "( "+UserProfile.Users.COL_ID +" INTEGER PRIMARY KEY AUTOINCREMENT ,"+UserProfile.Users.COL_USERNAME+" TEXT UNIQUE," +
               UserProfile.Users.COL_PASSWORD +" TEXT, "+UserProfile.Users.COL_GENDER +" TEXT, "+UserProfile.Users.COL_DOB +" TEXT"+")";

       Log.d("createQuery",createQuery);

       try {
           db.execSQL(createQuery);
       }
       catch (Exception e){
           e.printStackTrace();
           Log.e("Exception",e.getMessage());
       }

   }

   @Override
   public void onUpgrade(SQLiteDatabase db, int i, int i1) {

       String createQuery = "CREATE TABLE "+UserProfile.Users.TABLE_NAME
               +"( "+UserProfile.Users.COL_ID +" INTEGER PRIMARY KEY AUTOINCREMENT ,"
               +UserProfile.Users.COL_USERNAME+" TEXT,"
               + UserProfile.Users.COL_PASSWORD +" TEXT,"
               +UserProfile.Users.COL_GENDER +" TEXT, "
               +UserProfile.Users.COL_DOB+" TEXT"+")";

       Log.d("createQuery",createQuery);

       try {
           db.execSQL(createQuery);
       }
       catch (Exception e){
           e.printStackTrace();
           Log.e("Exception",e.getMessage());
       }

   }

   public boolean addInfo(UserProfile.Users users){

       SQLiteDatabase db = this.getWritableDatabase();

       String insertQuery = "INSERT INTO "+UserProfile.Users.TABLE_NAME
               +"("+UserProfile.Users.COL_USERNAME
               +","+UserProfile.Users.COL_PASSWORD+","
               +UserProfile.Users.COL_GENDER+","
               + UserProfile.Users.COL_DOB+") "

               + "VALUES('"+users.getUsername()
               +"','"+users.getPassword()
               +"','"+users.getGender()
               +"','"+users.getDob()+"')";

       Log.d("insertQuery",insertQuery);

       try {
           db.execSQL(insertQuery);
           return true;
       }
       catch (Exception e){
            e.printStackTrace();
            Log.d("Exception",e.getMessage());
       }

       db.close();
       return false;
   }

   public boolean updateInfor(UserProfile.Users users){

       SQLiteDatabase db = this.getWritableDatabase();

       ContentValues values = new ContentValues();

       String username = users.getUsername();
       String password = users.getPassword();
       String dob = users.getDob();
       String gender = users.getGender();
       int id = users.getId();

       values.put(UserProfile.Users.COL_DOB,dob);
       values.put(UserProfile.Users.COL_GENDER,gender);
       values.put(UserProfile.Users.COL_PASSWORD,password);
       values.put(UserProfile.Users.COL_USERNAME,username);

       int result = db.update(UserProfile.Users.TABLE_NAME,values,
               UserProfile.Users.COL_ID+" = ?"
               ,new String[]{String.valueOf(id)});

       if(result >0)
           return true;

           return false;
   }

   public ArrayList<UserProfile.Users> readAllInfor(){

       ArrayList<UserProfile.Users> userList = new ArrayList<>();

       SQLiteDatabase db = this.getWritableDatabase();

       String readAllQuery = "SELECT * FROM "+UserProfile.Users.TABLE_NAME;

       Cursor cursor = db.rawQuery(readAllQuery,null);

       if(cursor.moveToFirst()){
           do{
               UserProfile.Users users = UserProfile.getProfile().getUser();

               users.setId(Integer.parseInt(cursor.getString(0)));
               users.setUsername(cursor.getString(1));
               users.setPassword(cursor.getString(2));
               users.setGender(cursor.getString(3));
               users.setDob(cursor.getString(4));

               userList.add(users);

           }while (cursor.moveToNext());
       }

       return userList;

   }

   public UserProfile.Users readAllInfor(String userName){

       SQLiteDatabase db = this.getWritableDatabase();

       String readSingleQuery = "SELECT * FROM "+ UserProfile.Users.TABLE_NAME+" WHERE "+ UserProfile.Users.COL_USERNAME + " =  '"+ userName+"'";

       Cursor cursor = db.rawQuery(readSingleQuery,null);

       if(cursor.moveToFirst()){

           UserProfile.Users users = UserProfile.getProfile().getUser();

           users.setId(Integer.parseInt(cursor.getString(0)));
           users.setUsername(cursor.getString(1));
           users.setPassword(cursor.getString(2));
           users.setGender(cursor.getString(3));
           users.setDob(cursor.getString(4));

           return users;
       }

      return null;
   }

   public UserProfile.Users readAllInfor(int id){

       SQLiteDatabase db = this.getWritableDatabase();

       String readSingleQuery = "SELECT * FROM "+ UserProfile.Users.TABLE_NAME+" WHERE "+ UserProfile.Users.COL_ID + " =  '"+ id+"'";

       Cursor cursor = db.rawQuery(readSingleQuery,null);

       if(cursor.moveToFirst()){

           UserProfile.Users users = UserProfile.getProfile().getUser();

           users.setId(Integer.parseInt(cursor.getString(0)));
           users.setUsername(cursor.getString(1));
           users.setPassword(cursor.getString(2));
           users.setGender(cursor.getString(3));
           users.setDob(cursor.getString(4));

           return users;
       }

       return null;
   }

   public void deleteInfo(String username){

       SQLiteDatabase db = this.getWritableDatabase();

       String deleteQuery = "DELETE FROM "+ UserProfile.Users.TABLE_NAME+" WHERE "+ UserProfile.Users.COL_USERNAME +" = '"+ username +"' ";
       Log.d("deleteQuery ",deleteQuery);
       db.execSQL(deleteQuery);
       db.close();
   }

}

Open source projects

References

External links

• Official website