SQL INTERFACE FOR CRUD OPERATIONS ON CLOUD FIRESTORE

• Main Author: Nur Hidayat Denira, Farhan
• Format: Final Project
• Language: Indonesia
• Online Access: https://digilib.itb.ac.id/gdl/view/74189
• Institution: Institut Teknologi Bandung

Cloud Firestore is a document-oriented NoSQL database developed by Google. Cloud Firestore provides two ways to access data, namely through Firebase Console and Cloud Firestore API. Cloud Firestore API has the disadvantages of specific syntax and limitations for complex queries, while the disadvantage of Firebase Console is that data management is less efficient because it must be done one by one. On the other hand, SQL is a very popular query language and is capable of performing complex queries. In this final project, a library has been created to perform SQL queries to Cloud Firestore. The library will translate SQL queries to Cloud Firestore API and then execute the queries on the database. The library can perform four statements namely INSERT, UPDATE, DELETE, and SELECT including some basic clauses in it. The library also supports some complex query types that Cloud Firestore API does not support such as JOIN, subquery, and aggregation functions. In this final project, an application has also been created as a graphical interface of the library. The library test results show that SQL queries have provided appropriate results. The use of SQL queries is also more efficient and makes it easier to manage data on Cloud Firestore compared to existing methods. Application testing results show that all features have run well.