Digital Cellar Notebook for Collectors & Sommeliers

Take 100% control of your wine collection, sensory tasting impressions, and cellar stock. Zero subscription fees, zero telemetry, zero cloud lock-in.

Licence: MIT Open Source Backend: PHP 7.4+ / 8.x Database: MariaDB / MySQL Zero Telemetry & Private Docker Compose Ready No Build Pipeline

The phpMyCellar Philosophy Why Self-Hosted?

Commercial wine apps frequently lock your tasting records and bottle valuations behind subscription walls, monetize your cellar habits, or risk disappearing overnight. phpMyCellar is built from the ground up to guarantee everlasting data independence and respect your privacy.

🔒
100% Data Sovereignty

Your cellar inventory, purchase prices, confidential notes, and merchant invoices reside securely in your own SQL database on your server, VPS, or home lab.

🍷
Designed for Real Wine Enthusiasts

Choice between 20-point and 100-point rating scales with optional WSET SAT evaluation, blind tasting mode, drinking windows, bottle formats (375ml to large formats), and storage bins.

📜
Interactive Hospitality

Share a real-time digital Carte des vins with dinner guests, tasting groups, or family to browse bottles that are ready to drink without exposing private costs.

✍️
Long-Form Story & Vintage Publishing

Document winery visits, horizontal/vertical vintage tastings, and cellaring milestones with an integrated rich-text story editor and photo publisher.

Comprehensive Cellar Features Built for Connoisseurs

🗄️
Cellar & Location Tracking

Organise bottles by rack, shelf, bin, or custom location. Track bottle formats, quantities, cost per bottle, and merchant delivery receipts with PDF invoices.

🏆
Dual-Scale Tasting Notes & WSET SAT

Draft detailed evaluations with a choice of 20-point or 100-point scales, plus optional WSET SAT qualitative criteria, drinking window forecasting, and blind tasting reveal mode.

🍴
Live Carte des Vins

Filter ready-to-drink wines by colour (Red, White, Champagne, Rosé, Sweet), grape variety, region, and producer for effortless table service.

📚
Producer & Vintage Encyclopedia

Maintain structured records of wine masters, appellations, vineyards, and historical vintage ratings aggregated automatically from your tasting log.

🛡️
Granular RBAC Security

Role-Based Access Control (Public, Reader, Contributor, Admin) with granular permission overrides, CSRF synchronizer tokens, and locked upload paths.

🎨
Customisable Theme & Branding

Tailor site title, tagline, accent colours (IndianRed, Burgundy, etc.), currency symbols, and static pages (Welcome, Impressum, Privacy) directly from the UI.

Interactive Carte des Vins (*Wine Menu*) Live Guest Preview

Here is an example of how your cellar's bottles appear in the shareable wine menu. Guests and tasting attendees can filter by style and vintage to pick the evening's selection:

Vintage & Wine Producer & Region Style / Variety Score Drink Window
2018 Morey-Saint-Denis 1er Cru
Red Wine 750ml
Domaine Dujac
Côte de Nuits, Burgundy, France
Pinot Noir 19 / 20 ✓ Peak (2024–2038)
2015 Sassicaia Bolgheri
Red Wine 750ml
Tenuta San Guido
Tuscany, Italy
Cabernet Sauvignon, Cabernet Franc 98 / 100 ✓ Ready to Drink
2012 Vintage Brut Champagne
Champagne 1500ml (Magnum)
Dom Pérignon
Épernay, Champagne, France
Chardonnay, Pinot Noir 19.5 / 20 ✓ Peak (2022–2045)
2020 Meursault Premier Cru Genevrières
White Wine 750ml
Domaine des Comtes Lafon
Côte de Beaune, Burgundy, France
Chardonnay 18.5 / 20 ✓ Ready to Drink
2005 Château d'Yquem
Sweet Wine 375ml (Half)
Château d'Yquem
Sauternes, Bordeaux, France
Sémillon, Sauvignon Blanc 20 / 20 ✓ Peak (2020–2080)

Quick Start Installation Fast & Lightweight

phpMyCellar requires no complex JavaScript build chains or heavyweight framework runtimes. You can deploy it locally via Docker or onto any standard Linux web server with PHP and MariaDB/MySQL.

Option 1: Docker Compose (Recommended for Local & Container Deployments)

Run the full application stack including MariaDB database with two shell commands:

bash — terminal
git clone https://github.com/dmueller-dev/phpMyCellar.git
cd phpMyCellar
docker compose up -d --build

Once started, open http://localhost:8080/install/ in your web browser to finish the web setup wizard and configure your admin account.


Option 2: Traditional Web Hosting (Apache / Nginx / VPS)

  1. Upload Codebase

    Copy the repository files to your web server document root (e.g. /var/www/html/ or public_html/).

  2. Configure Web Server & File Permissions

    For Apache, copy .htaccess.example to .htaccess. For Nginx, use the provided nginx.conf.example.
    Ensure write permissions on root directory (for .env), install/ (for installed.lock), and uploads/.

  3. Launch the Interactive Web Installer

    Navigate to http://your-domain.com/install/. The step-by-step wizard tests database credentials, executes migrations and seed data, creates the Super-Administrator account (user_id = 1), and configures initial site branding.

Component Requirement Recommended
PHP Runtime PHP 7.4+ PHP 8.1 / 8.2 / 8.3+
Database MariaDB 10.4+ / MySQL 8.0+ MariaDB 10.11+ (utf8mb4)
PHP Extensions mysqli, session, json gd / imagick, curl
Web Server Apache 2.4+ (mod_rewrite) or Nginx 1.18+ Apache / Nginx with HTTPS enabled

Documentation & User Manual Comprehensive Guides

phpMyCellar includes an in-depth user and administrator manual detailing cellar organization, scoring methodologies, role permissions, and database backup routines:

Open Source & Community

phpMyCellar is free, open-source software licensed under the MIT License. Contributions, issue reports, and feature proposals from fellow wine lovers and developers are welcome on GitHub!