嵌入式CRUD Web应用程序 [英] Drop-in CRUD web application
问题描述
一个大约有20个表的简单数据库,上面散布着唯一的约束,主键和外键关系。这是仅供内部使用的数据库。只有两三个人可以直接访问数据。其中只有一个人有资格成为DBA。
A simple database with about 20 tables, sprinkled with unique constraints, primary keys, and foreign key relationships. This is a database for internal use only. Only two or three people will have direct access to the data. Only one of those people is qualified to be a DBA.
该数据库是使用DbSchema和PostgreSQL 9.1开发的。
The database was developed using DbSchema and PostgreSQL 9.1.
该项目本身旨在成为一个简单的原型,但使用干净的数据。
The project itself is meant to be a quick-and-dirty prototype, but using clean data. Authentication and security are non-issues.
我想提供一个简单的基于Web的问题CRUD应用程序,以便无需参与DBA即可解决任何数据错误。
I'd like to supply a simple web-based CRUD application so that any data errors can be resolved without having to get the DBA involved.
什么您是否建议您使用该软件公开一个简单的Web界面,使非DBA能够更新数据?
What software would you recommend that exposes a simple web interface that allows non-DBAs the ability to update data?
为了弄清楚它是否是Java应用程序,这是我所设想的简单性:
To clarify, if it was a Java application, here is the simplicity I envision:
- 下载
jar
文件(例如crud-web-app.jar
)。 - 运行:
- Download a
jar
file (e.g.,crud-web-app.jar
). - Run:
java -jar crud-web-app.jar --username=postgres --password=password --host=localhost:5432 --database=database --listen=127.0.0.1:8080
相关
phpPgAdmin 接近了,但我认为可能会更简单(例如,对非DBA的威胁较小)。
Related
phpPgAdmin comes close, but I thought there might be something simpler (i.e., less intimidating for non-DBAs).
有什么建议吗?
谢谢!
推荐答案
在不编写任何代码的情况下生成CRUD:
To generate CRUD without writing any code:
- PHP Generator
PostgreSQL PHP Generator是PostgreSQL GUI前端,可让您可以为选定的表,视图和查询生成高质量的PHP脚本,以通过网络进行更新。
PostgreSQL PHP Generator is a PostgreSQL GUI frontend that allows you to generate high-quality PHP scripts for selected tables, views, and queries for updates over the web.
- http://demo.sqlmaestro.com/
免费版本相当广泛,商业版本包含大量功能。使用该工具,大约花了30分钟(从软件下载开始)为两个表生成CRUD页面。该软件自动为外键关系提供下拉菜单。
The free version is fairly extensive, the commercial version includes a vast number of features. Using the tool, it took about 30 minutes (from the software download) to generate CRUD pages for two dozen tables. The software automatically provides drop-downs for foreign key relationships.
以下屏幕截图显示了运行发电机的输出:
The following screen shot shows the output from running the generator:
这篇关于嵌入式CRUD Web应用程序的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!