Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to build a no install, client-side only, database web app

Where I work it is pretty restricted in terms of IT. I do not have access to an SQL Server or a Web server so things like Apache, PHP, mySQL etc are all off the table. No server side anything.
The PCs on the network cannot see each other (so installing WAMP and opening firewall ports wouldnt work...besides...we cant install anything either...all locked down), this is due to group policy restrictions. However there are plenty of shared drives that we all can use. Currently we are getting by using Microsoft Access but it is clunky.
We need to move towards tablets so managers can see info as they walk around. My building is a massive warehouse, hence the driver for the solution im trying to build.

So the question is this. I want to build a web app that displays KPIs/reports. It will need to have some type of database behind it so I can store data in which I can then retrieve via Javascript or something similar (remember I can only use client-side technolgies). Whether that's JSON or XML i dont really mind.
Multiple people will need access at the same time.

So to sum up

Can't install anything
No access to a web server or anything that resembles a web server
Do have shared drives so could store a NoSQL/JSON/XML file to share there
Client-side technologies only
PCs on the network cannot see each other
Cannot use any internet or cloud storage solutions as they are blocked

Im completely lost, any solutions?

like image 957
zoonosis Avatar asked Nov 07 '13 22:11

zoonosis


People also ask

Is database on the client side?

Web application architecture has traditionally featured HTML, CSS, and JavaScript on the client and a database on the server. Among the most surprising HTML5 APIs, therefore, are client-side databases.

What is client side web application?

In web development, 'client side' refers to everything in a web application that is displayed or takes place on the client (end user device). This includes what the user sees, such as text, images, and the rest of the UI, along with any actions that an application performs within the user's browser.

How can we store data in JavaScript without database?

You can use web storage. From W3Schools: With web storage, web applications can store data locally within the user's browser. Before HTML5, application data had to be stored in cookies, included in every server request.


1 Answers

I would check out PouchDB. http://pouchdb.com/

Pure Javascript and stores the data locally on the users machine.

In the future if you ever wanted to connect it to a server side database, you can connect it to CouchDB.

like image 134
ryan1234 Avatar answered Oct 06 '22 00:10

ryan1234