{"repo":"my-telegram-bots/Pixiv_bot","free":true,"listed":false,"github":"https://github.com/my-telegram-bots/Pixiv_bot","clone":"git clone https://github.com/my-telegram-bots/Pixiv_bot.git","description":"A telegram bot","language":"JavaScript","stars":60,"topics":["telegram","pixiv","bot","ugoira","illust","telegraph","pixiv-bot"],"license":"MIT","category":"chat-messaging","readme_excerpt":"Pixiv bot Link: https://t.me/Pixiv bot Document: https://pixiv-bot.pages.dev (no stable build, only have master branch) requirement - Node.js 15 - ffmpeg - mp4fpsmod install (ArchLinux) sudo pacman -S pnpm pm2 ffmpeg unzip yay -S mongodb-bin mp4fpsmod git clone https://github.com/my-telegram-bots/Pixiv bot.git sudo systemctl enable pm2 mongodb --now cd Pixiv bot pnpm i cp config sample.js config.js # edit # vim config.js # nano config.js node initial.js # first run pm2 start --name pixiv bot app.js pm2 save sudo pm2 startup Breaking Changes Version 2.1.0 (February 2025) - PostgreSQL Migration ⚠️ BREAKING Major database migration from MongoDB to PostgreSQL. ⚠️ This is a breaking change that requires manual migration. What's Changed: - Database backend changed from MongoDB to PostgreSQL - Removed MongoDB wrapper layer, using direct SQL for better performance - New direct SQL API: getIllust() , updateIllust() - SQL injection prevention with parameterized queries - N+1 query optimization (40+ queries → 1 aggregated query) - Fast random sampling with indexed random value column - Performance indexes for 2.2M+ dataset Migration Steps: 1. Install PostgreSQL (if not already installed): 2. Update config.js - Add PostgreSQL configuration: 3. Run migration (if upgrading from MongoDB): 4. Restart bot : Environment Variables: - AUTO APPLY PATCHES=0 - Disable auto-apply schema patches (default: enabled) - DBLESS=1 - Run without database (testing mode) Automatic Migration Check: The bot wil","default_branch":null,"files":null,"tree":[],"storefront":"/r/my-telegram-bots","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/my-telegram-bots/Pixiv_bot/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}