Genealogy is a free and open-source family tree PHP application to record family members and their relationships, build with Laravel 11.
This TallStack application is build using :
- Laravel 11
- Laravel Jetstream 5 (featuring Teams)
- Livewire 3
- Alpine.js 3
- Tailwind CSS
- TallStackUI (featuring Tabler Icons)
- Laravel Filament 3 (only Table Builder)
-
A person can have 1 biological father (1 person, based on father_id)
-
A person can have 1 biological mother (1 person, based on mother_id)
-
A person can have 1 set of parents, biological or not (1 couple of 2 people, based on parents_id)
-
A person can have 0 to many biological children (n people, based on father_id/mother_id)
-
A couple can have 0 to many (plus) children (based on parents_id as a couple or father_id/mother_id individually)
-
A person can have 0 to many partners (n people), being part of 0 to many couples (opposite or same biological sex)
-
A person can be part of a couple with the same partner multiple times (remarriage or reunite)
-
A person can have 0 to many siblings (n people) (based on parents_id as a couple or father_id/mother_id individually)
-
A couple can be married or not, still together or separated in the meantime
-
At least PHP 8.3, 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.
This demo has 2 family trees implemented, BRITISH ROYALS and KENNEDY.
| Password | Purpose | |
|---|---|---|
| [email protected] | password | to access teams BRITISH ROYALS and KENNEDY as team owner |
| [email protected] | password | to access team BRITISH ROYALS as manager |
| [email protected] | password | to access team KENNEDY as editor |
| [email protected] | password | to access team BRITISH ROYALS as normal member |
| [email protected] | password | to access team KENNEDY as normal member |
| [email protected] | password | to access options reserved for the developer, like the user management and access to all persons in all teams |
| Role | Model | Permissions |
|---|---|---|
| Administrator | user (team member) | create, read, update, delete |
| person | create, read, update, delete | |
| couple | create, read, update, delete | |
| Manager | person | create, read, update, delete |
| couple | create, read, update, delete | |
| Editor | person | create, read, update |
| couple | create, read, update | |
| Member | person | read |
| couple | read |
- Light/Dark theme
- Fully responsive
- Multi-language, language setting saved in authenticated users profile
- Multi-timezone, timezone setting saved in authenticated users profile
- Multi-tenancy by Laravel Jetstream Teams, including Transfer Team Ownership
- Security through Laravel Jetstream Teams Roles & Permissions, 2FA & API can be enabled
- Offcanvas menu
- Multiple image upload with possibility of watermarking, photo carousel with navigation
- Multiple documents upload
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, on demand showing :
- INFO : All scheduled backups
- DEBUG : All executed database queries (off by default), only in local development mode
- DEBUG : All executed requests (off by default)
- WARNING : All detected N+1 queries, only in local development mode
- WARNING : All detected slow (> 250 ms) queries, 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
All activities (create, update, delete) on persons and couples are logged in the database.
Change history available on Persons.
- German (DE)
- English (EN)
- Spanish (ES)
- French (FR)
- Dutch (NL)
- Portuguese (PT)
- Vietnamese (VI)
- Simplified Chinese (ZH_CN)
Translations can be added by submitting a Pull Request to the project.
Translation integrity can be checked by issuing the command
php artisan translations:check --excludedDirectories=vendor
- GEDCOM import and export.
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
php artisan test
Feel free to submit Issues or Pull Requests, for bugs, suggestions or feature requests.
The documentation is included 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.