Database Structure Project
Database development with MYSQL and Firebase
Database Development Project: MYSQL
MYSQL was used as a data key storage for my HTML/Javascript projects as well as planning and illustrating my data structure for my ionic coding project
MYSQL is essentially a backbone to my coding projects. In my project, I used MYSQL to create unique data keys which i could encode together with Javascript functions so that those data keys and IDs can encapsulate information from user inputs and the data can be reused for other uses like CRUD functions, presenting data function, search function etc.
I also recorded the different keys and IDs into a word data dictionary which gives a full description and properties of the key or ID, and gave an example of what can they key or ID be used for.
By doing this, it also clarifies my data structure and it is efficient for data handling.
View the full project:
Firebase Database Development Project
Firebase was used for ionic framework project for user authentication, creating data collections, storing data, storing external document data for which it could be used in my website
One thing i really like a lot about firestore database is that it is very clear how to use it. It is quite simple, for example if I wanted to start a data collection all I have to press the "+ start collection" button and key in the different data fields I want this collection to capture and when coding it on my ionic programming, I just have to link the relevant data fields and the auto generated data key storage code.
I was also able to use the Google and Facebook user authentication which is relatively simple as compared to other programming language, all I had to do was plugin cordova Google and Facebook APIs and It could work well.
Firestore was mainly used for displaying and capturing data in my ionic project. To view more on this project, click here
