Changelog

We’re excited to announce that Infactory now supports direct connections to PostgreSQL databases! This unlocks a world of possibilities, making it easier to query, analyze, and integrate your data seamlessly. Along with this, we’ve introduced a Custom SQL tab on the PostgreSQL connection page, giving you more flexibility in writing and running SQL queries directly.

Additionally, we've made improvements to query autogeneration when connecting to PostgreSQL, streamlining the experience for users who want quick insights without manually crafting queries.

Fixes & Improvements

Performance Optimization

• Updated CloudWatch dashboards & alarms for better monitoring of our infrastructure.

• Switched runner hosts & backend API instances to more cost-effective AWS instance types.

• Enabled dynamic instance selection in Terraform to optimize costs (e.g., Spot instances for development).

• Implemented automatic Docker image pruning for self-hosted runners to keep environments clean.

UX/UI Enhancements

• Scrollable query lists for a smoother experience.

• Aligned query editor and chat window styles for consistency.

• Refined color scheme in the query editor to match Infactory’s design.

• Deploy button fixes – resets state after clicking and is now positioned more intuitively.

Bug Fixes

• Fixed S3 chunking issue to optimize large file uploads.

• Resolved CSV upload flow issues – improving performance and security.

• Fixed query execution errors that caused subsequent runs to fail.

• Addressed progressive chart breakage and improved auto-generated query quality.

With PostgreSQL integration and a host of performance upgrades, Infactory is now more powerful and efficient than ever. Let us know what you think! 🚀

This cycle, we focused on making Infactory more stable, secure, and user-friendly. We improved authentication, enhanced error handling, and fixed key UI/UX issues. Additionally, we made major improvements to our API and deployment processes to ensure smoother workflows.

Highlights

• Role-Based Authentication (RBAC)
  We introduced role-based authentication to enforce access control. Each user now has an org_admin role by default, limiting CRUD operations to their organization and preventing cross-organization data access.

• Smarter Page Titles
  Instead of falling back to a generic phrase like "Find knowledge in your data", pages now use more descriptive and relevant titles.

• Improved Cloud Deployment

  • Provisioned S3 buckets for deployment logs, improving logging and debugging for on-premise installations.

  • Migrated Cloudflare DNS management to Terraform, allowing for more structured and reproducible infrastructure updates.

• Landing Page Revamp
  We launched a new Landing Page, refining the first touchpoint with users and ensuring a smoother onboarding experience.

Fixes & Improvements

User Experience & Interface

• Fixed Infactory Assistant overflowing the screen in the Build page.

• Removed unnecessary console logs in chat, significantly improving performance.

• Syntax highlighter no longer re-renders on every keystroke, reducing lag.

• The query program editor now removes redundant code markers on first insertion.

Deployment & Infrastructure

• Updated CloudWatch alarms with longer-duration triggers for more reliable alerting.

• Fixed an intermittent network error affecting Docker builds.

• Resolved authentication issues in the dev environment to restore access control.

• Prevented running/deploying an empty query program, ensuring valid input.

• Improved API routing and request handling for better performance.

Data & Query Handling

• Fixed an issue where deployed query program buttons disappeared after deployment.

• Improved metadata extraction from query programs for better query generation.

• Fixed chart downloads, ensuring users can properly export visualized data.

• Added live chart customization options, giving users more control over how data is displayed.

Security & Access Control

• Fixed Invalid AZP Claim errors on authentication, ensuring smoother logins.

• Removed all outdated tests from GitHub since they were no longer functional.

Other Improvements

• Updated README with a Quick Start Guide for easier setup.

• Renamed CRUD directories and components to better reflect their purpose.

• Integrated APIGen Dataset for enhanced API recommendation functionality.

Thanks for your continued feedback! More exciting updates are on the way 🚀.