7 Commits

Include renames

Author	SHA1	Message	Date
paul	f053f42b6d	fix: comprehensive PostgreSQL/SQLite compatibility fixes ... Critical fixes for database compatibility issues: INSERT operations: - Fix all INSERT queries to use .returning('id') - Handle both PostgreSQL (returns objects) and SQLite (returns IDs) - Fixed in: events.js, adminArchives.js, adminEvents-enhanced.js, create-test-event.js Date operations: - Replace SQLite-specific db.raw("datetime('now', '+30 days')") - Use JavaScript Date objects for cross-database compatibility - Fixed in: adminArchives.js Database utilities: - Add dbCompat.js utility for handling database differences - Provides consistent API for inserts, dates, booleans, and DB-specific operations - Centralized database compatibility logic Migration: - Add migration 023 documenting PostgreSQL compatibility requirements - Ensures future developers are aware of compatibility needs This resolves all 'not iterable' errors and ensures the application works correctly with both PostgreSQL (production) and SQLite (development).	2025-07-14 20:38:37 +02:00
paul	85e7fbe73f	chore: clean up unnecessary deployment files ... - Remove deploy/ folder with complex Docker Swarm configs - Remove local development scripts referencing non-existent docker-compose.local.yml - Remove setup scripts for files that already exist - Remove docker-compose.dev.yml in favor of unified approach - Keep certbot/, CHANGELOG.md, docker-compose.prod.yml, and production guide This simplifies the repository structure and removes confusing duplicate deployment approaches, making it clearer for new users.	2025-07-14 20:25:18 +02:00
paul	349e7c7eb1	feat: add GitHub issue and PR templates ... - Add bug report template with environment details - Add feature request template with use case section - Add documentation improvement template - Add security vulnerability template with warnings - Add question template for support - Add issue template config with helpful links - Add comprehensive pull request template - Update mirror workflow to exclude production guide These templates will help maintain quality contributions and streamline the issue/PR process on GitHub.	2025-07-14 20:15:10 +02:00
paul	be07438915	docs: major repository restructure for GitHub public release ... - Create comprehensive README.md optimized for GitHub/SEO - Consolidate deployment instructions into single DEPLOYMENT.md - Add all standard GitHub documentation files: - CONTRIBUTING.md with development guidelines - CODE_OF_CONDUCT.md for community standards - SECURITY.md with vulnerability reporting - CHANGELOG.md following Keep a Changelog format - Simplify deployment with single docker-compose.yml - Remove complex deployment configurations (Swarm, Traefik) - Add backup script for easy maintenance - Update .github-mirror-exclude to hide complex configs - Remove redundant documentation files This prepares PicPeak as a professional open-source alternative to PicDrop and Scrapbook.de with clear, simple deployment.	2025-07-14 20:12:14 +02:00
paulandClaude	1db08b1e9b	feat: add Gitea workflows for selective GitHub mirroring ... - Add three different approaches for mirroring to GitHub - Approach 1: Filter out sensitive files on a separate branch - Approach 2: Use git archive with .gitattributes exclusions - Approach 3: Use rsync for flexible file filtering - Add exclusion lists for sensitive files and directories - Protect production configs, environment files, and private data This allows maintaining a public GitHub mirror while keeping sensitive configuration and data private on the Gitea instance. 🤖 Generated with [Claude Code](https://claude.ai/code) Co-Authored-By: Claude <[email protected]>	2025-07-14 14:14:39 +02:00
paulandClaude	10649691de	feat: implement automatic version incrementing with CI/CD strategy ... - Add Gitea Actions workflow for automatic version bumping - Update test workflow to run linting and tests - Configure Drone to build images with version tags - Separate concerns: Gitea Actions for versioning, Drone for Docker builds - Version format: MAJOR.MINOR.PATCH (auto-increment patch) - Add comprehensive CI/CD strategy documentation This prevents race conditions between Gitea Actions and Drone CI by: 1. Gitea Actions handles version bump and creates git tag 2. Tag creation triggers Drone to build Docker images 3. Both systems work sequentially, not in parallel 🤖 Generated with [Claude Code](https://claude.ai/code) Co-Authored-By: Claude <[email protected]>	2025-07-13 19:55:35 +02:00
paulandClaude	0b550cdaf6	feat: add Gitea Actions test workflow and setup documentation ... - Add simple test workflow to verify Gitea Actions functionality - Create comprehensive setup guide for troubleshooting Actions - Include runner installation and registration steps - Document common issues and solutions 🤖 Generated with [Claude Code](https://claude.ai/code) Co-Authored-By: Claude <[email protected]>	2025-07-12 09:28:06 +02:00