Hi All, I'm trying to build some dashboard application which allows the user to connect to their database and run queries. The resultset then will be feed into the charts for rendering. I want to understand few things:
1. I guess from the documentation we could able to connect to database on fly and run queries from plain string. Do let me know are there any best practices to handle database connections on fly. As you could guess, each user might have different database sources configured. So imagine if I could create say 100 connections for each user (on different DB's sources) wont that be an overhead? Any suggesstions or patterns would be really helpful here. 2. Giving plain string directly to the Jooq system will be an security issue by any chance? Do the developer need to do the sanitization of the inputs? 3. Since user will be able to connect to their own data source, I want to show them their Tables on the UI. I want to filter out each table along with its column details, like each column foriegn key constraints, their type etc. Is that possible to do in all databases (remember user could connect to any database that let's say Jooq supports) Thanks for taking time to answering the questions. Kamal. -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
