Genealogy is a free and open-source (family tree) application to record family members and their relationships, build with PHP (Laravel 11).

This application is build using :

• Laravel 11 (featuring Vite)
• Laravel Jetstream 4 (featuring Teams)
• Livewire 3
• Tailwind CSS
• TallStackUI
• Laravel Filament (only Table Builder)
• Tabler Icons

1. A person can have 1 biological father (1 person, based on father_id)

2. A person can have 1 biological mother (1 person, based on mother_id)

3. A person can have 1 set of parents, biological or not (1 couple of 2 people, based on parents_id)

4. A person can have 0 to many biological children (n people, based on father_id/mother_id)

5. A person can have 0 to many partners (n people), being part of 0 to many couples (opposite or same biological sex)

6. A person can be part of a couple with the same partner multiple times (remarriage or reunite)

7. A couple can have 0 to many children (based on parents_id as a couple or father_id/mother_id individually)

8. A couple can be married or not, still together or separated in the meantime

• At least PHP 8.2, supporting Laravel 11.
  
• At least MySQL 8.0.1 or MariaDB 10.2.2 or an equivalent database, supporting Recursive Common Table Expressions.

This project is open-sourced software licensed under the MIT license.

https://genealogy.kreaweb.be/

This demo has 2 family trees implemented, BRITISH ROYALS and KENNEDY.

• Light/Dark
• Fully responsive
• Multi-language, English, Dutch and German already implemented, language setting saved in authenticated users profile
• Multi-tenancy by Jetstream Teams
• Security through Jetstream Teams Roles & Permissions, 2FA & API can be enabled
• Offcanvas menu
• Multiple image upload with possibility of watermarking, photo carousel with navigation

This application has a built-in Backup Manager :

• Backups can be initiated and managed manually
• Backups can be scheludeld by issuing a cron job on your development or production server
• An e-mail will be send after each backup

This application has a built-in Log Viewer showing :

• INFO : All scheduled backups
• DEBUG : All executed database queries, but only in local development mode
• WARNING : All detected N+1 queries, but only in local development mode
• ERROR : All detected errors

This application has a built-in User management & logging, available to the developer :

• User statistics by country of origin
• User statistics by year, month, week or day

• GEDCOM import and export (help gladly accepted).

Both the ancestors and descendants family trees are build using Recursive Common Table Expressions (Recursive CTE). This prevents the N+1 query problem generating the recursive tree family elements and dramatically improves performance.

create a new project folder, cd into the folder

git clone https://github.com/MGeurts/genealogy.git .

cp .env.example .env

make the needed changes regarding name, url, database connection & mail server

composer install

php artisan key:generate

php artisan storage:link

php artisan migrate:fresh --seed

npm install & npm run build

php artisan serve or npm run dev

cp env.docker .env

run following command to initialize project

docker run --rm \
    -u "$(id -u):$(id -g)" \
    -v "$(pwd):/var/www/html" \
    -w /var/www/html \
    laravelsail/php83-composer:latest \
    composer install --ignore-platform-reqs

run docker containers

./vendor/bin/sail up -d

./vendor/bin/sail artisan key:generate

./vendor/bin/sail artisan storage:link

./vendor/bin/sail artisan migrate:fresh --seed

./vendor/bin/sail npm install & npm run build

./vendor/bin/sail artisan serve or npm run dev

php artisan test

Feel free to submit Issues or Pull Requests, for bugs, suggestions or feature requests.

The documentation is built-in the applications help. Visit the demo project to read the documentation.

If you like this project, please consider giving it a star and spread the word. Thank you.

This application is based on an original idea by Nafies Luthfi. Thanks for your excellent work.

This Laravel application is designed and developed by kreaweb.be.