#Creating a Web-Application connected to PostgreSQL

10 messages · Page 1 of 1 (latest)

tight locust
#

I am planning to develop a web application using Django that replaces the use of Excel files. The application should be able to capture the contents of up to five worksheets of an Excel file, with the first worksheet containing basic information such as creation date, name etc. . The input fields in Worksheets 2-5 are organized in multiple tables. Columns from one worksheet should be linked to columns in another worksheet, such as automatic filling.
Only users with the appropriate permissions should be able to access the application. A search function should allow users to search the contents of all worksheets by entering the name of the "file" which was entered in the first worksheet. The complete contents of all five worksheets should then be displayed.

What is the recommended approach for structuring the database? Should I design it in PostgreSQL, or does Django provide any assistance for my requirements? Or is another approach more appropriate?

wooden tundra
#

What assistance do you need? Have you looked into django docs?

tight locust
#

i have read some documentation regarding django-mptt, but as a beginner I am confused as to whether it is the right field to familiarize myself with.

wooden tundra
#

mptt? Why would you need it?

#

Except for linking between sheets you descriptions looks pretty simple and straight-forward

#

Linking part depend on what exactly you want to do with that. Full-in web version of excel would be relatively hard I guess

#

But still probably doesn't requires trees

tight locust
#

I think its a tree structure because my first "worksheet" holds the primary key. the other worksheets include more than one table, where specific colums are connected with each other. worksheet 4 for example is completly reliant on the data in worksheet 3.
How would you describe this structure?

#

it will be a prototype and it wont have all the functions given in excel. auto-filling and data-storage with fitting search options are in focus

wooden tundra
#

Sounds like simple relation fields