ยท
๐ Pickful Update | Feb 1
This update fixes repost/quote UI and referral code registration logic, strengthens points system and payment security with database locking and wallet validation, optimizes follow queries for better performance, and adds unique index on post codes to ensure data integrity.
Hey Pickful community!
We've made a series of important updates to the Pickful platform to provide a more stable and secure user experience.
โจ UI Improvements
Repost & Quote Features
- Fixed vertical alignment of repost icon to match like and comment icons
- Improved quote modal layout with dark mode support
- Replaced blocking success modal with lightweight toast notification
Notification Cards
- Fixed notification card display issues in dark mode
๐ Security Enhancements
Admin Permission System Upgrade
- Migrated admin authentication from hardcoded IDs to database field management
Points System Transaction Safety
- Implemented database locking mechanism for points operations to prevent race conditions
Payment Verification Strengthened
- Added wallet address format validation for VIP payment flow
- Improved error handling for better system stability
Push Notification Security
- Migrated VAPID keys to secure credentials storage
โก Performance Optimization
Query Efficiency
- Optimized user follow relationship queries, significantly reducing database load
- Improved feed loading speed for better browsing experience
Data Write Optimization
- Optimized post content sync mechanism to reduce unnecessary database writes
- Points changes now execute after transaction commit to ensure data consistency
๐ Bug Fixes
Registration Flow
- Fixed referral code logic to distinguish between "referrer's code" and "user's own code"
- Made referral code validation optional for smoother registration
Draft Feature
- Fixed draft list display issue
- Added parameter validation for draft auto-save
๐ Data Integrity
- Added unique index on post short codes to prevent collision in edge cases
- Added idempotency check for registration bonus to prevent duplicate rewards
Thank you for using Pickful! If you have any questions, please don't hesitate to contact us. #product
The #Pickful Team
February 1, 2026
Repost this post?
Share with your followers.
Reply