Projecty is a project management app based on spring.

My main objective is to create a free and open-source privacy project management application for everyone. I know that project data are really sensitive so you feel better when you are the owner of them. And for those who do not have a server, Projecty will be available on the hosted server completely for free (in the future).

The app has been divided into two separate projects. You can find front-end based on Vue at projecty-web-front-end.

1. After changes run ./build_image.sh in a project root directory to build application image.
2. Rundocker-compose up in a project root directory.

Data is stored in a volume db-data. During first run of database container the scripts from /sql-scripts directory will be executed.

1. Clone repository
2. Import it to your favourite IDE
3. Remember to edit application.properties

   spring.datasource.url=jdbc:mysql://db_host:db_port/db_name
   spring.datasource.username=db_user
   spring.datasource.password=db_password
   

   Make sure that this user have full access to database
4. Prepare DB for store oauth tokens; execute this SQL

   CREATE TABLE `oauth_access_token` (
    `token_id` varchar(255) DEFAULT NULL,
    `token` mediumblob,
    `authentication_id` varchar(255) NOT NULL,
    `user_name` varchar(255) DEFAULT NULL,
    `client_id` varchar(255) DEFAULT NULL,
    `authentication` mediumblob,
    `refresh_token` varchar(255) DEFAULT NULL,
    PRIMARY KEY (`authentication_id`)
   );
   CREATE TABLE `oauth_refresh_token` (
    `token_id` varchar(255) DEFAULT NULL,
    `token` mediumblob,
    `authentication` mediumblob
   );

5. Build the app, run it and enjoy
6. Remember to check if the timezone is set correctly

• JRE ≥ 1.8
• MySQL 8.0 compatible database

Your contribution is welcome. No matter who you are, you can help anyway. The most helpful is help with coding but graphic designers are also needed. If you are not a developer or graphic designer don't worry, you can help with translations, post on a blog, make a video, or tell your friend about Projecty. Your contribution will be appreciated.

Projecty is licensed under GNU GPL v3.0 http://www.gnu.org/licenses/gpl-3.0.html