The original post: /r/selfhosted by /u/deepspace on 2024-11-10 00:31:45.

I have a relatively simple requirement. I have a database pertaining to suites in an apartment building. The key is the suite number. Every suite can one or more Owners, Occupants , KeyFOBS, Parking spaces, Storage lockers, Bicycle stalls, Dogs, Cats, and so on.

Each of these is stored in a separate table, and each table has the suite number as the first column. They can each have multiple entries for each suite. The Owners table, for example, would typically have one or two rows per suite and the columns would be Suite, Name, Address, Email, Phone, etc. The Occupants table could have up to six rows per suite, with columns like Suite, Name, Age, Gender, Email, Phone, etc.

I want to pull up a form for a suite, and be able to modify, add, or delete all the information for the suite on the same page. Owner details, Occupant details, Parking details, everything. When I save the form, the data should be written to the appropriate tables.

I have been trying all the Low/No code app generators that I could lay my hands on, and they are all great when dealing with a single table. But as soon as you put multiple tables into the mix, things get very messy, very quickly. None of them have an intuitive way of linking data between tables.

Any suggestions for an app generator that makes it easy to work with many tables? Preferably self-hosted, but I would also consider low-cost cloud hosting.

I have considered just writing the thing in Laravel, or something similar, but it has been 20 years since I wrote PHP code and I have no experience with Laravel, but I might do it if I could find a good example somewhere that I could modify for my needs.