@petter Our team have experience with MS Azure SQL database integration and we have some suggestions that could enhance the documentation.
Clarify SQL Syntax Variations: We noticed differences in SQL syntax between databases. For example, the query syntax in MySQL differs from that in MS SQL. SELECT * FROM users LIMIT 200 may work for MySQL DB but for MS SQL it was SELECT TOP 200 * FROM users
Update Variable Parameters Information: The current documentation suggests using $1 for variable parameters in queries, which didn’t work in our case. We discovered that using @ParameterName was the correct approach for us.
Expand on Database Firewall Management: We faced challenges with database firewalls due to Bubble’s use of dynamic IP addresses. This can pose a problem for users trying to secure their databases. It would be beneficial to provide more detailed guidance on managing firewall settings, or information on how to handle IP whitelisting, especially for users not on dedicated plans that offer static IPs.
Include Paging Strategies: Given that the queries records limitation is 200 records per query response, it would be great to include a section on efficient paging strategies. This is particularly crucial for handling larger datasets and ensuring smooth data retrieval. Example by BuildIt Branding you can find it here. Another example by @augusto.salles here
Thanks @petter for keeping the community as part of your process. You have made huge difference to the new version of the documentation 