This project synchronizes Star Wars planets and their related entities from the public API
https://swapi.dev into a local MySQL database using Laravel 12,
and displays the data through a Vue 3 frontend powered by Vite.

• 🔄 Sync planets, films, residents and related entities from SWAPI
• 🗄 MySQL relational database structure
• ⚙️ Artisan command for scheduled/manual synchronization
• 📊 Laravel Horizon for queue monitoring
• 🧵 Supervisor support for production queues
• ⚡ Vue 3 frontend with Vite bundler
• 📄 Paginated planet listing UI

app/
├── Console/Commands/       # swapi:sync command
├── Models/                 # Planet, Film, Person models
└── Services/Swapi/         # Synchronization service

database/
├── migrations/             # DB schema
└── seeders/

resources/
├── js/
│   ├── app.js              # Vite entry
│   ├── bootstrap.js
│   └── vue/
│       ├── App.vue
│       └── components/
│           └── PlanetList.vue
└── views/
    └── app.blade.php       # Vue mounting point

routes/
└── web.php

vite.config.js

• PHP 8.2+
• Laravel 12
• MySQL 8+
• Composer
• Redis (for queues)
• Ubuntu package:

  sudo apt install php-curl

• Node.js 18+
• NPM or Yarn

git clone https://github.com/elivol-git/star-wars-data-explorer.git
cd star-wars-data-explorer

composer install

cp .env.example .env
php artisan key:generate

Edit .env:

DB_DATABASE=planets
DB_USERNAME=planets_user
DB_PASSWORD=your_strong_password

QUEUE_CONNECTION=redis

CREATE DATABASE planets CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

CREATE USER 'planets_user'@'localhost'
IDENTIFIED BY 'your_strong_password';

GRANT ALL PRIVILEGES ON planets.*
TO 'planets_user'@'localhost';

FLUSH PRIVILEGES;

php artisan migrate

php artisan swapi:sync

This command can also be scheduled via Laravel Scheduler.

npm install

or

yarn install

npm run dev

Vite will start at:

http://localhost:5173

Laravel will load assets automatically via Vite.

npm run build

Compiled files will be placed in:

public/build

vite.config.js:

import { defineConfig } from 'vite';
import laravel from 'laravel-vite-plugin';
import vue from '@vitejs/plugin-vue';

export default defineConfig({
    plugins: [
        laravel({
            input: ['resources/js/app.js'],
            refresh: true,
        }),
        vue(),
    ],
});

composer require laravel/horizon
php artisan horizon:install
php artisan migrate

http://your-domain.test/horizon

[program:horizon]
process_name=%(program_name)s
command=php /var/www/planets/artisan horizon
autostart=true
autorestart=true
user=www-data
redirect_stderr=true
stdout_logfile=/var/www/planets/storage/logs/horizon.log
stopwaitsecs=3600

sudo supervisorctl reread
sudo supervisorctl update
sudo supervisorctl start horizon

php artisan serve

Open:

http://127.0.0.1:8000

sudo chown -R $USER:www-data storage bootstrap/cache
sudo chmod -R 775 storage bootstrap/cache

sudo chmod -R 775 storage/logs

sudo apt install redis-server
sudo systemctl enable redis
sudo systemctl start redis

docker compose -f docker-compose.yml -f docker-compose.dev.yml down -v
docker compose -f docker-compose.yml -f docker-compose.dev.yml up -d --build
docker compose exec app php artisan scrape:entity-images
sudo docker compose -f docker-compose.yml -f docker-compose.dev.yml exec app php artisan queue:work --memory=512 --max-jobs=50

Deployment to AWS EC2 uses two scripts:

./scripts/deploy-prod-ec2.sh

This script:

• Syncs code via rsync (excludes node_modules, .git, storage/, public/hot, etc.)
• Opens SSH session to EC2 instance for manual deployment trigger

Environment variables (optional):

EC2_IP=your.ip.address.here ./scripts/deploy-prod-ec2.sh
EC2_USER=ubuntu ./scripts/deploy-prod-ec2.sh
SSH_KEY=$HOME/.ssh/your-key.pem ./scripts/deploy-prod-ec2.sh

Once SSH'd into the server:

cd ~/starwars && bash scripts/deploy-server.sh

This script:

• Fetches DB password from AWS Secrets Manager
• Stops old containers
• Rebuilds and starts containers with docker compose up -d --build
• Waits for app to become healthy
• Displays container logs for debugging

# Local machine
./scripts/deploy-prod-ec2.sh

# On server (after SSH opens)
bash scripts/deploy-server.sh

That's it. DB password is fetched automatically from AWS Secrets Manager.

Open-source.
Free to use, modify, and distribute.

✨ May the Force be with your code.