How to build a no install, client-side only, datab

2019-04-23 01:10发布

问题:

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?

回答1:

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.



回答2:

Here's what I would implement in your situation:

Backbone.js with https://www.stackmob.com/

Backbone provides a great way to build a robust client side app, and stackmob can host your db, here is a free tutorial:

https://www.udemy.com/learn-backbonejs-stackmob/



回答3:

sqlite.org is a self contained, serverless, database