2

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)?

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.