COOP Template now available on postgresql.

[SebastiendOrnano]

COOP is the result of a personal project around the monitoring of building rehabilitation projects in mix mode involving professionals and private individuals. These projects are monitored and coordinated by a network of independent associations. This explains the name of the app and the section devoted to collaborative work.

COOP is a 3 in 1 modular app combining a website, teams workspaces and building rehab projects management. COOP is a multilevel user app : admin, supervisor, editor, viewer, public, with a possibility of group permissions at each level (if needed, COOP can be sliced down to one or two modules).

• The project management module allows to monitor project schedule through Gantt charts, team composition, workhours, expenses, wastes, carbon footprint, meetings schedules, map location, pictures gallery and documents . The module also include a supervisor dashboard with various stats and an address book.
• The workspace module includes various tools : FAQ, forum, chat, news, events.
• The website module includes standard features : About us, Contact form, FAQ, news, events, event registration. It includes also some tools to manage a small organization : members and membership follow up, document.
• The admin panel includes the users permissions management, a debug forum, help and process management, connections stats, list of choices and patterns management.

I am not an IT pro so I choose SQLPage to develop COOP. COOP code is very simple: basic SQL queries, SQLPage base (no custom components, no scripts), very academic query writing, very explicit file and folder names... The first version of COOP was develop with sqlite as database engine, but it was not consistent with the collaborative aim of COOP, so COOP was rewrite to work on Postgresql. Postgreql allows multiple connections in the same time and PostgreSQL offers much more features for further developments (for example : links to Postgis).

COOP can be used as a template, a draft to develop more complex apps around project management, or as a set of examples to discover SQLpage.

COOP was developed with SQLpage 0.35.2, Postgresql 16, linux mint 22.1. Development tools : VSCodium, DBeaver-CE, Pandoc, Retex (all free and open source apps, thanks to all developers !).

Install info are available in the readme file and explanations about the module in the wiki.

[lovasoa]

Thanks for sharing ! Do you have screenshots of your app with real data that you can share ?

[SebastiendOrnano]

admin dashboard :

supervisor project dashboard :

Gantt chart / workpackages :

stats of workhours on a workpackage :

workteam composition management :

pictures gallery :