txlog/server v1.18.6

on GitHub

🚀 Release v1.18.6

This release focuses on performance optimizations for the /packages and /assets endpoints, along with a critical bug fix for the dashboard.

⚡ Performance Improvements

/packages Endpoint

• Introduced a materialized view (mv_package_listing) for faster package listing queries
• Previously, each request executed multiple complex CTEs scanning the entire transaction_items table
• Now uses pre-computed data with dramatically improved query performance
• Added scheduled job to refresh the materialized view every 5 minutes for near real-time data

/assets Endpoint

• The os field is now stored directly in the assets table
• Previously, each request executed expensive LEFT JOIN LATERAL subqueries to fetch the OS from the latest execution
• Now uses a simple direct query on the assets table
• Updated UpsertAsset to save the OS with each execution, ensuring real-time OS information

🐛 Bug Fixes

• Fixed "Replaced assets" card on dashboard not showing any results
  • The previous query incorrectly looked for hostnames with multiple active assets
  • By design, only one asset can be active per hostname
  • Now correctly identifies hostnames with assets that were deactivated (replaced) in the last 30 days

🐳 Docker Image

docker pull cr.rda.run/txlog/server:v1.18.6

🔗 Links

• Full Changelog: v1.18.5...v1.18.6
• Documentation: https://github.com/txlog/server
• Issues: https://github.com/txlog/server/issues