Android Question What's best approach for using HTML front-end (Bootstrap) and SQLite backend

[neomewilson]

I have an application I'd like to develop using Bootstrap as my user interface with SQLite as my database back-end and Android users as the initial target. I have read lots of posts around Webview, HTTPUTil2 library and the HTTP Server.

Questions: What would you suggest as the best way to design this application using what views and libraries? With Bootstrap as my user interface the application that uses a series of forms and graphs provided through the HTML, CSS, JavaScript then does:

1. Webview provide all that I need to pass data from the forms to the database?
2. Will Webview allow me to read the data back to the HTML front-end to create graphs on some of the forms?
3. Is the HTTP server examples I've looked at needed so the HTTP server exist on the device that I am installing that finished application on?

Looking for guidance as I am still a new to this platform and finally have an application I want to build using it.

 

[Erel]

Where is the SQLite database located? On the device?

 

[neomewilson]

Where is the SQLite database located? On the device?

Yes, that is the desire. In time I may extend the application to the idea of having a full desktop version but the initial idea is for all to be installed on the device.

 

[neomewilson]

Any ideas on how I should approach this. I didn't hear anything after I posted my response that I plan on having the SQLite database on the device.

Many thanks for any guidance.

 

[Erel]

Working with local databases is much simpler. Just load the database with the SQL library. You don't need any server or html.