Download the PHP package kirilldakhniuk/dead-drop without Composer
On this page you can find all versions of the php package kirilldakhniuk/dead-drop. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download kirilldakhniuk/dead-drop
More information about kirilldakhniuk/dead-drop
Files in kirilldakhniuk/dead-drop
Package dead-drop
Short Description Export and import your database tables with fake data
License MIT
Homepage https://github.com/kirilldakhniuk/dead-drop
Informations about the package dead-drop
Dead Drop
Export and import database tables with fake data. Share database dumps without exposing real user information.
Features
- Export tables to SQL with upsert syntax
- Replace sensitive data with Faker-generated values
- Cloud storage support (S3, DigitalOcean Spaces)
- Works with SQLite, MySQL, and PostgreSQL
Installation
Publish the config and migrations:
Basic Usage
The commands are interactive. To specify a database connection:
Date Filtering
Filter exports by date range interactively:
Custom intervals support natural language dates via Carbon.
Facade API
Configuration
Edit config/dead-drop.php:
Options
Data Anonymization
List fields to anonymize:
The package auto-detects common fields and applies appropriate Faker methods:
| Field | Faker Method | Example |
|---|---|---|
| safeEmail | [email protected] | |
| name | name | Jane Doe |
| phone | phoneNumber | (555) 123-4567 |
| address | address | 123 Main St |
| city | city | New York |
| ip | ipv4 | 192.168.1.1 |
Auto-detected fields include: email, name, first_name, last_name, phone, address, city, state, zip, country, company, job_title, website, url, ip, ssn, credit_card, and more.
Custom Faker Methods
Specify the Faker method for more control:
See all available methods at fakerphp.github.io.
Upsert Support
Exports use upsert syntax for safe re-imports:
- SQLite:
INSERT OR REPLACE - MySQL:
INSERT ... ON DUPLICATE KEY UPDATE - PostgreSQL:
INSERT ... ON CONFLICT DO UPDATE
Default Values
For partial column exports, add defaults for required fields:
Password fields are automatically hashed with bcrypt.
Cloud Storage
Configure cloud uploads in .env:
Install the AWS SDK:
DigitalOcean Spaces
Add to config/filesystems.php:
Configure in .env:
Programmatic Usage
Troubleshooting
NOT NULL constraint errors - Add defaults for required fields you're not exporting.
Foreign key constraint errors - Import parent tables first, or disable foreign key checks temporarily.
Duplicate entry errors - This shouldn't happen with Dead Drop exports since they use upsert syntax. External SQL files may cause this.
Requirements
- PHP 8.2+
- Laravel 11.x
License
MIT
Created by Kirill Dakhniuk
All versions of dead-drop with dependencies
illuminate/console Version *
illuminate/database Version *
illuminate/filesystem Version *
illuminate/support Version *