Open Lines Friday | The Low-Code Campfire #239

In this episode of the Low-Code Campfire by Plant an App, the host leads a comprehensive discussion on several technical topics with participants. The session kicks off with an exploration of SQL statement execution challenges within Plant an App, examining the use of stored procedures and efficient execution methods. The conversation transitions to discuss the utilization and documentation of stored procedures in EasyDNN News. Attention then shifts to the Plant an App AI connector, where its features, functionalities, and setup processes are reviewed. SQL issues re-emerge with a detailed analysis of deadlocks that surfaced with version 1.28, focusing on transaction encapsulation and its impact on user experience. The episode also covers practical solutions like hiding card fields in data table views and concludes with a method to obtain an application's data structure using a specific SQL command in the SQL console. 2:50 - Discussion on SQL Statement Execution 9:12 /// Discussion on the Use of Stored Procedures 13:33 /// Suggestion to Use CSV Source and Loop 18:59 - Discussion on EasyDNN News Stored Procedures 19:10 /// Discussion on how to know if the stored procedures are okay to use 19:22 /// Suggestion for documentation within the stored procedures 19:28 - Exploration of Plant an App AI Connector 21:35 /// Discussion on the AI connector's features and functionalities 28:47 /// Explanation on how to set up the AI connector 33:38 - SQL Deadlocks Issue in Plant an App 34:50 /// Explanation of the cause of the SQL deadlocks issue 37:42 /// Discussion on the potential workaround using SQL's read committed snapshot feature 39:14 - Understanding Deadlocks in SQL 40:33 /// Impact of Version 128 on SQL Transactions 43:50 /// How Deadlocks Affect User Experience 47:23 - Hiding Card Fields in Data Table View 48:16 /// Demonstration of the Workaround 51:51 /// Discussion on Default Behavior of Card Views 55:33 - Getting App Data Structure 56:04 /// Demonstration of SQL Command --- Join the low-code community in our weekly gathering. We get together to share techniques, challenges, and experiences in building apps with Plant an App. Learn more about the fastest way to build powerful web apps - https://www.plantanapp.com/ Why attend? • Gain a deeper understanding of Plant an App • Learn from the experiences of others • Demonstrate the techniques you've developed in your apps • Bring your challenges and get ideas from the Community and the Support team • Meet & connect with low-code enthusiasts & great people such as yourself Webinar Sign-Up: https://us02web.zoom.us/webinar/register/3616210110550/WN_FhoNwnH6R6CjTFUI8zNwGw Feedback & Requests: https://docs.google.com/forms/d/e/1FAIpQLSfS9QnchmxEg1Vq2M8KkYtf9Gw1R4ztoRnScPfkjMgylDtdtQ/viewform