A very simple php/postgres web application to allow the fair division of the sentimental items from someone's estate through coordinate-based markers.
- Auto-resizing to a consistent width (800px by default) with GD library
- Click-to-claim interface with name-based markers
- Dynamic photo gallery from
original/
directory - Persistent marker storage in PostgreSQL
- PHP 7.4+ with GD extension
- PostgreSQL 12+
- Web server (Apache/Nginx)
- Modern web browser
- Clone repository:
git clone https://github.com/bmtwl/SentimentalEstateDivision
cd SentimentalEstateDivision
- Create PostgreSQL database:
createdb estate
psql estate -c "CREATE USER estate WITH PASSWORD 'password';"
psql estate -c "GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO estate;"
- Configure database credentials in
db.php
:
$host = 'localhost';
$dbname = 'estate';
$user = 'estate';
$pass = 'password';
- Create directories and set permissions:
mkdir original resized
chmod 775 resized
-
Add photos to
original/
directory -
Configure your webserver to serve this folder securely (outside of the scope of this readme). Consider http simple auth to protect it.
- Access via web browser at eg
http://your-server/SentimentalEstateDivision/
- Enter your name in the form
- Click anywhere on photos to place markers
- Markers persist automatically and appear for all users
- No authentication - use behind secure proxy
- Input sanitization for XSS prevention
- PostgreSQL prepared statements prevent SQL injection
MIT License - See LICENSE file