a table layout for viewing an entire table: Yupp (see lower-left).a form layout to add and modify entries: Yupp (see lower-right).PgAdmin (source: pgAdmin click image for larger variant)Īs the screenshot shows, it should match your needs quite fine: PgAdmin could be the tool of your choice: So most probably also not what you are looking for. Not really as a replacement for a "forms application". It does support foreign keys while editing and also while browsing the data.īut - like pgAdmin - it is more targeted at users which are happy to use SQL directly. I am not sure if you can edit the data in the results though (I have never used it)Ī more SQL centric tool is SQL Workbench/J. One tool that seems to be better for non-technical users is DBeauty which has a completely different approach because you define a meta model that helps users to browse the information. Neither of those has support for "foreign key dropdowns" if I'm not mistaken. There are two web-based projects that offer a nice UI and I think are better suited for unexperienced users: It has a clumsy user interface which is OK for technical people, but for someone who has no experience with databases it is most definitely not the right choice (this will probably change with the upcoming new version of pgAdmin which is a complete rewrite) Personally I would not recommend pgAdmin.
0 kommentar(er)
