Re: Easy to use graphical reporting tools for SQL

[Lee Hinde]

https://github.com/epantry/django-sql-explorer

You can build the queries and they're available to whomever you want to
give access. This assumes they have access to the django app.



On Mon, Jul 20, 2015 at 2:09 PM, Kevin  wrote:

> In our office we have a Django application that uses a MySQL database.
> Often I am asked to produce various reports that can range from being basic
> dumps of query results or aggregate computations on query results. To do
> this I must connect to the Django shell to use the ORM or write the SQL
> directly. The problem is that it is impossible for the non-developers to
> access reports unless they ask a developer to create the queries, run them,
> and send the result back. This adds to lots of communication overhead and
> delays.
>
> Is there a basic free or open-source application that can connect to MySQL
> and allow non-developers to graphically build their own queries?
>
>
>

-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/CA%2BePoMzwo_KD_5NHPd7gtN1b9rrCi0F6b%3Do%3DqPYT%3D%3D2W%3DamwSw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: Easy to use graphical reporting tools for SQL

[Vijay Khemlani]

I guess any kind of report they want to generate will require some
knowledge of relational databases.

Considering that, I think Jasper Reports is a good tradeoff, It has a
graphical interface to create the queries, and the reports can be accessed
by anyone after it's query and design is done.

On Tue, Jul 21, 2015 at 4:20 PM, Stefano Probst  wrote:

> Know the "non-developers" SQL? I guest not, but if you can try MySQL
> workbench ..
>
> --
> You received this message because you are subscribed to the Google Groups
> "Django users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to django-users+unsubscr...@googlegroups.com.
> To post to this group, send email to django-users@googlegroups.com.
> Visit this group at http://groups.google.com/group/django-users.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/django-users/6a7f0ba0-137a-4160-8855-a4eb2e04adc1%40googlegroups.com
> 
> .
>
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/CALn3ei0cG%3DYJDcH_xZVPpi%2B8g6YkP3u%3DpRmTySEUPryVyVNEYg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: Easy to use graphical reporting tools for SQL

[Stefano Probst]

Know the "non-developers" SQL? I guest not, but if you can try MySQL 
workbench ..

-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/6a7f0ba0-137a-4160-8855-a4eb2e04adc1%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: Easy to use graphical reporting tools for SQL

[叶]

Maybe you can try navicat.
http://www.navicat.com/

2015-07-21 5:09 GMT+08:00 Kevin :

> In our office we have a Django application that uses a MySQL database.
> Often I am asked to produce various reports that can range from being basic
> dumps of query results or aggregate computations on query results. To do
> this I must connect to the Django shell to use the ORM or write the SQL
> directly. The problem is that it is impossible for the non-developers to
> access reports unless they ask a developer to create the queries, run them,
> and send the result back. This adds to lots of communication overhead and
> delays.
>
> Is there a basic free or open-source application that can connect to MySQL
> and allow non-developers to graphically build their own queries?
>
> --
> You received this message because you are subscribed to the Google Groups
> "Django users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to django-users+unsubscr...@googlegroups.com.
> To post to this group, send email to django-users@googlegroups.com.
> Visit this group at http://groups.google.com/group/django-users.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/django-users/6ab5432b-6a89-4942-b103-ca059dceaf98%40googlegroups.com
> 
> .
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/CA%2B7P_%2BsySnSBbTNhJPEDi5S%3DJEtoLdfTjVKaztdZYm7Low1N0Q%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Easy to use graphical reporting tools for SQL

[Kevin]

In our office we have a Django application that uses a MySQL database. 
Often I am asked to produce various reports that can range from being basic 
dumps of query results or aggregate computations on query results. To do 
this I must connect to the Django shell to use the ORM or write the SQL 
directly. The problem is that it is impossible for the non-developers to 
access reports unless they ask a developer to create the queries, run them, 
and send the result back. This adds to lots of communication overhead and 
delays.

Is there a basic free or open-source application that can connect to MySQL 
and allow non-developers to graphically build their own queries?

-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/6ab5432b-6a89-4942-b103-ca059dceaf98%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.