Performance Best Practices, PostgreSQL SSH Tunnel, AI Powered Zendesk Ticket Assistant, and More! 

Welcome to our latest monthly round-up of Appsmith news, updates, and highlights!

This edition covers essential performance best practices, new database connection features, user interface improvements, and exciting community events. We've also included helpful assets and guides to implement in your Appsmith apps.

Whether you're an experienced Appsmith developer or just starting out, there is something for everyone here.

Appsmith significantly streamlines development, but even the best low-code tools are no substitute for software engineering best practices. This includes additional best practices for working within Appsmith’s unique architecture.

We compiled this resource that explains these performance aspects of Appsmith’s architecture, some of the common mistakes that lead to slower performing applications, and our recommendations for making the most efficient Appsmith apps possible.

We understand many of you are looking to minimize database management time. That's why we're thrilled to announce our transition from MongoDB to PostgreSQL! This move offers several key benefits:

• Better compatibility with major cloud providers' managed database services (AWS RDS or Azure Database), simplifying integration and management.

• Improved support for complex queries and scalability, enabling more powerful and efficient data operations.

• Simplified database management for your team, reducing the need for specialized NoSQL expertise.

We've officially launched a closed beta for this migration. You can join our closed beta and be part of this exciting transition! We offer two options: For new instances, switching to PostgreSQL is as simple as updating an environment variable. For existing MongoDB instances, we're providing a white-glove migration service to ensure a seamless transition.

This migration is ideal for teams aiming to streamline their cloud vendor management and leverage PostgreSQL's robust features.

PostgreSQL Migration Closed Beta

We've officially launched a closed beta for this migration. You can join our closed beta and be part of this exciting transition!

Register Now

Appsmith now supports connecting to PostgreSQL databases via SSH Tunnel, thanks to the valuable contribution from community member AnnaHariprasad5123.

This new feature enhances security by allowing users to configure SSH settings for PostgreSQL connections. The update includes a new "Connection method" option, improved error handling, and expanded test coverage.

• Streamlined notification system - We've replaced toast messages with more actionable debugger items, enhancing the overall debugging experience. This enhancement improves the user experience for all Appsmith developers, providing a cleaner and more focused interface when working on their applications. Now, errors are more actionable and contained within the debugger, allowing you to proceed with your app development without waiting for each toast message to disappear.

• Fixed currentRow calculation logic in table widget property pane for sorting and filtering - We've addressed an issue with the table widget's currentRow calculation logic. This improvement enhances the functionality, compatibility, and user interaction of the table widget in Appsmith.

We’ve had some recent, highly-valuable contributions to the Appsmith platform from community members. Please join us in recognizing and thanking them.

• AnnaHariprasad5123 added SSH Tunnel support for Postgres, a crucial security feature and improved the Select widget by adding a new feature to control when the remove button appears.

• Naveen-Goud improved Postgres table name identification and enhanced Mongo Collections sorting.

• ALOK9442 refined the tooltip box width for better visual consistency.

Thank you to these, and all community contributors for their time, expertise, and commitment to improving Appsmith.

• AI Powered Chart Generator Feat. Mermaid.js + ‪OpenAI‬ Assistant API — In this workshop, Joseph showed how to build an AI Assistant with the OpenAI API to generate charts from raw data.

• Building a Messenger App to Send CRM Leads to Slack and Tag Users — Slack's Bot Tokens allow devs to use the API as a bot-user instead of with their user account. Learn how to use a bot token to send Leads from a CRM to Slack as a new message, and tag specific team members.

• Building a Calendar Widget using FullCalendar.js & the Google Calendar API — Looking to integrate with Google Calendar data, or add a calendar view to your Appsmith app? Learn how to enable the Google Calendar API, list and create records from Appsmith, and build a custom calendar widget using FullCalendar.js.

• How Large Companies Manage User Access and Customer Data - Learn how large companies manage user access and customer data across multiple systems using SCIM.

• Building an AI Powered Zendesk Ticket Assistant - Build an AI-powered assistant for Zendesk ticket management using Appsmith. This article covers connecting to Zendesk's API, implementing AI-based text classification, and building a user interface for efficient ticket tagging.

• How to Reset Appsmith Account Password Without Email - This step-by-step offers a straightforward approach to regaining access to your Appsmith account using container logs.

• How We're Saving $200k+/yr With Our Own Appsmith Customer Support Solution - Are you spending a fortune on customer support tools that don't quite meet your requirements? Here’s how we built our own business support tools using Appsmith.

• Automating Customer Feedback Analysis with Appsmith, Fathom, Slack, and AI - Discover how to leverage low-code and AI to automate customer feedback analysis, delivering actionable insights to product teams and improving how your business responds to user needs.

To make the most of these updates, we strongly encourage you to upgrade to v1.39. You can check our release log for a complete list of new features and improvements in Appsmith.

We have an upcoming webinar on September 26th, where we'll be discussing the benefits and best practices of self-hosting your business-critical applications. Don't miss out on this valuable session – register now!

Catch you in the next update! 🫰