#StackBounty: #open-source #database #web #postgresql Frontend for CRUD operations Postgres

Bounty: 50

I need a frontend for CRUD Operations on a Postgres database. It has to be understandable also for persons without database background.

Also it would be nice if it is open source and free (and maybe web-based). I’ve tried with LibreOffice Base and with forms, but struggling with the following problem:

I have a "main"-table ‘Person’, a table ‘Hobby’ and a table ‘Friends’, all holding an ID (as PK) and several attributes.

To insert data into ‘Person’, I found the forms very easy to use.
But if I want to add Hobbies and Friends to Persons, the problems begin.

Since I found that in Postgres there is no possibility to store something like an array of foreign keys (see https://stackoverflow.com/questions/34156695/postgres-creating-a-table-with-an-array-of-foreign-keys) I modelled it in the database scheme as e.g. ‘Person_has_Hobby’ relation that holds foreign keys from persons and hobbies.

So manually inserting or editing is not the problem.

How can I get this kind of mapping in an easy useable way (WYSIWYG and maybe webbased, programming language is secondary for the moment)?

Get this bounty!!!

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.