swapnil95
Joined 9 years ago
Karma
47
Submissions
9
Member since
Mar 30
Recent submissions
Comment · 9 years ago
Comment · 9 years ago
I have not used Boquet but going through their documentation it looks like they help developers to get rid of SQL by providing some Javascript plugin in order to filter the reporting data from the database.
SQueaLy's approach is a bit different. It is rather focused on writing powerful and dynamic SQL queries. SQueaLy uses JinjaSQL behind the scenes which gives you the power to use JINJA inside the SQL query. For more details, check out JinjaSQL here - https://github.com/hashedin/jinjasql
With JinjaSQL in the scene, you can access real-time variables related to
- A logged-in user
- Web session
- URL query parameters
inside your SQL queries.
You can then use Jinja templating inside the SQL query to handle conditional statements or create macros based on these real time variables
Comment · 9 years ago
- Fine-grained authorized REST APIs
- Cron based scheduled emails embedded with reports
- Auto-generated documentation for all the REST APIs using swagger
- More than just SQL - SQueaLy uses JinjaSQL behind the scenes which gives you power to use JINJA inside the SQL query.
You can refer the readme for more details
Comment · 9 years ago
Yes you got it right. The focus of SQueaLy is on providing fine grained authorized REST APIs with auto generated documentation for all the REST APIs using swagger.
Comment · 9 years ago
Hey, I have replied to your issue on github
Comment · 9 years ago
On the web frontend, we paginate the reports and so it is supposed to be responsive with large datasets. We tested this with around 10K rows, we'll surely scale-up our tests for this.
BTW which charting library are you using for your reports?
Comment · 9 years ago
Thanks Josh. Hope to get more feedbacks from you.
Soon we will be adding support for Mssql and Cassandra also