Knowledgebase - saayam-for-all/docs GitHub Wiki

This doc lists all the "Eureka" items that we find during our journey. If you have spent considerable amount of time to learn some thing new, then you should add this to this doc to save the time for others for NOT to go through the same pain. Thanks.

Storing Non-Standard File Types in GitHub Wiki

Saayam's request handling flow is created using a browser-based diagramming tool "Drawio". The original '.drawio' file needed to be uploaded to the 'request' repository on GitHub Wiki. However, the Wiki only supports uploading 'GIF, JPEG, JPG, MOV, MP4, PNG, SVG, WEBM' file types. Therefore, the '.drawio' file was added to the 'doc' folder within the 'request' repository's code section.

Error when uploading non-supported file to GitHub WiKi

Need to Translate SQL Queries Between Different Database Types?

The jOOQ Parser offers a solution for translating SQL statements into different dialects, allowing users to convert SQL queries from one database type to another without starting from scratch.

For example, if you have .sql files with queries written for a PostgreSQL database and need to convert them to MySQL, you can use the jOOQ online SQL translation tool.

Additionally, tools like Gemini, ChatGPT, and Copilot can also assist with SQL translation.