如何构建一个无安装,仅限客户端的数据库Web应用程序

时间:2021-09-26 16:33:00

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.

我工作的地方在IT方面受到很大限制。我无法访问SQL Server或Web服务器,因此Apache,PHP,mySQL等都不在桌面上。没有任何服务器端。网络上的PC看不到对方(因此安装WAMP和打开防火墙端口无法工作......除此之外......我们无法安装任何东西......全部锁定),这是由于组策略限制。但是,我们都可以使用大量共享驱动器。目前我们正在使用Microsoft Access,但它很笨重。我们需要转向平板电脑,以便管理人员可以随时查看信息。我的建筑是一个巨大的仓库,因此我试图建立解决方案的驱动力。

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.

所以问题是这个。我想构建一个显示KPI /报告的Web应用程序。它需要在它后面有一些类型的数据库,所以我可以存储数据,然后我可以通过Javascript或类似的东西检索(记住我只能使用客户端技术)。无论是JSON还是XML,我都不介意。多人需要同时访问。

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

无法安装任何东西无法访问Web服务器或任何类似于Web服务器的东西确实有共享驱动器因此可以存储NoSQL / JSON / XML文件以共享客户端技术只有网络上的PC无法看到对方无法使用任何互联网或云存储解决方案,因为它们被阻止

Im completely lost, any solutions?

我完全迷失了,任何解决方案?

3 个解决方案

#1


1  

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

我会查看PouchDB。 http://pouchdb.com/

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

纯Javascript并将数据本地存储在用户计算机上。

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

将来,如果您想将其连接到服务器端数据库,可以将其连接到CouchDB。

#2


1  

sqlite.org is a self contained, serverless, database

sqlite.org是一个独立的,无服务器的数据库

#3


0  

Here's what I would implement in your situation:

以下是我将在您的情况下实施的内容:

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

Backbone.js与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:

Backbone提供了构建健壮的客户端应用程序的好方法,stackmob可以托管你的数据库,这是一个免费的教程:

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

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

#1


1  

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

我会查看PouchDB。 http://pouchdb.com/

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

纯Javascript并将数据本地存储在用户计算机上。

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

将来,如果您想将其连接到服务器端数据库,可以将其连接到CouchDB。

#2


1  

sqlite.org is a self contained, serverless, database

sqlite.org是一个独立的,无服务器的数据库

#3


0  

Here's what I would implement in your situation:

以下是我将在您的情况下实施的内容:

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

Backbone.js与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:

Backbone提供了构建健壮的客户端应用程序的好方法,stackmob可以托管你的数据库,这是一个免费的教程:

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

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