A simple personal tea tracker — import a CSV, browse your collection, explore stats, and visualize your tea-drinking habit on a calendar.
TeaKeeper is a lightweight web application designed for tea enthusiasts who want to track their tea consumption over time. Whether you're exploring flavor preferences or just building a tea diary, this app provides an intuitive interface to log and analyze your tea-drinking habits.
- Import & Export – Upload tea data via CSV or export your collection for backup
- Full CRUD operations – Add, edit, browse, and delete individual tea entries
- Calendar view – Monthly calendar with color-coded tea days and per-date detail view
- Statistics dashboard – View top brands, monthly distribution, and flavor breakdown
- Multi-year support – Track your tea habits across multiple years
- Responsive design – Works seamlessly on desktop, tablet, and mobile devices
Home Page
Teas Table
Calendar View
Statistics Dashboard
Import / Export
The app accepts CSV files with the following format:
drink_date,brand,tea_name,flavor
2025-01-15,Fructus,Earl Grey,Bergamot
2025-01-16,dmBio,Peppermint,Mint- The header row is optional
flavoris optional per row
Create a MySQL database named tea_keeper using phpMyAdmin or CLI.
Import the SQL schema located in data/backups/tea_keeper.sql.
Edit includes/database.php with your database credentials.
Run the project locally using any PHP 8+ web server:
php -S localhost:8000Or use XAMPP, WAMP, or Apache.
Open the site and import data/default.csv to load sample tea entries.
- Open the application in your browser
- Use the Import feature to upload your tea data
- Browse all entries in the Teas table
- View your tea-drinking patterns in the Calendar view
- Explore insights and trends in the Statistics dashboard
- Export your data anytime for backup or external use
This project is licensed under the MIT License.
See the LICENSE file for more details.