I am tasked with creating a soultion for managing asset information for my organization, and I need to have it functional by the end of the week. That said, I am grateful for any and all help or advice leading to a workable solution for my problem space.
My current issue is adding database functionality to my app, which is intended to scan barcodes on asset tags and, presumably, pull up or even update information about that asset using some kind of database system.
I have begun implementing this system with SQLite and the related Ionic Native plugins, but have never really nailed down whether that is the correct solution to my problem.
My concerns are:
- Will using SQLite be a poor solution for the sake of database integrity when two users are scanning and editing concurrently?
- Is there a simple way to integrate database functionality without using SQLite, such as linking the app to a central database server with MySQL?
The cost-benefit ratio between these two options, using SQLite to get a quick fix and using a possibly more secure solution with MySQL, is still unclear to me, as I am hazy on which would take more effort and research to get working by Friday.
The database would be required to store and manage data about IT assets, including computer specs, (RAM, MAC address, service codes, et cetera) as well as contextual data, (ie, department and location). If this explanation helps us all find a solution together, then all the better!