search

dimitri / pgcharts

Turn your PostgreSQL queries into Charts
393 stars 24 forks source link

Stacked bar chart #9

Open Jacob-Kroeze opened 9 years ago

Jacob-Kroeze commented 9 years ago

I would like to use a stacked bar chart. What is left to do to implement that feature?

dimitri commented 9 years ago

Mostly Javascript I would presume, see https://github.com/dimitri/pgcharts/blob/master/web/js/query.js

Beware that if you use the command line version of pgcharts, it's caching the whole static file set in the binary's memory, so you will have to recompile each time you edit the javascript, which is a poor developer's environment.

That's because when using the lisp developer environment (Emacs, SLIME and Quicklisp) you can just edit the files and recompile lisp code on the fly and change things as you will.

It would be possible to add a configuration or CLI parameter to stop serving from cache in case you want to hack only on the web parts of pgcharts, without touching the embedded server code itself (URL mapping, processing, and unfortunately most HTML templates too). It doesn't make much sense to me because I just use the Lisp environment, feel free to comment about that option if you feel it's needed and welcome, but first have a look at how the HTML is produced currently...