pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedBI tools and PostgreSQL
3+ messages / 3 participants
[nested] [flat]
* BI tools and PostgreSQL
@ 2013-11-04 19:18 Victor Tan <victortcs@gmail.com>
2013-11-04 20:05 ` Re: BI tools and PostgreSQL Simon Riggs <simon@2ndQuadrant.com>
2013-11-04 20:49 ` Re: BI tools and PostgreSQL David Johnston <polobo@yahoo.com>
0 siblings, 2 replies; 3+ messages in thread
From: Victor Tan @ 2013-11-04 19:18 UTC (permalink / raw)
To: pgsql-admin
BI tools all generate SQL with varying levels of optimization. However, do
any of you know of any BI tools that are more PostgreSQL aware in that they
can generate queries that take advantage of extensions like hstore, arrays
etc?
Hstore and JSON data types use non-standard syntax within PostgreSQL - not
that I know of anything in the SQL standards that say how to handle KV
types in the style of hstore.
Which BI tools, if any, either are aware of PostgreSQL in this way or at
least minimize hindrances to using these types of data types or extensions?
- Victor Tan
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: BI tools and PostgreSQL
2013-11-04 19:18 BI tools and PostgreSQL Victor Tan <victortcs@gmail.com>
@ 2013-11-04 20:05 ` Simon Riggs <simon@2ndQuadrant.com>
1 sibling, 0 replies; 3+ messages in thread
From: Simon Riggs @ 2013-11-04 20:05 UTC (permalink / raw)
To: Victor Tan <victortcs@gmail.com>; +Cc: pgsql-admin
On 4 November 2013 19:18, Victor Tan <victortcs@gmail.com> wrote:
> BI tools all generate SQL with varying levels of optimization. However, do
> any of you know of any BI tools that are more PostgreSQL aware in that they
> can generate queries that take advantage of extensions like hstore, arrays
> etc?
>
> Hstore and JSON data types use non-standard syntax within PostgreSQL - not
> that I know of anything in the SQL standards that say how to handle KV types
> in the style of hstore.
> Which BI tools, if any, either are aware of PostgreSQL in this way or at
> least minimize hindrances to using these types of data types or extensions?
Probably the same number as support SQLSwerver sparse columns, MiSQL
equivalents and Mogno BSON.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: BI tools and PostgreSQL
2013-11-04 19:18 BI tools and PostgreSQL Victor Tan <victortcs@gmail.com>
@ 2013-11-04 20:49 ` David Johnston <polobo@yahoo.com>
1 sibling, 0 replies; 3+ messages in thread
From: David Johnston @ 2013-11-04 20:49 UTC (permalink / raw)
To: pgsql-admin
Victor Tan wrote
> BI tools all generate SQL with varying levels of optimization. However,
> do
> any of you know of any BI tools that are more PostgreSQL aware in that
> they
> can generate queries that take advantage of extensions like hstore, arrays
> etc?
>
> Hstore and JSON data types use non-standard syntax within PostgreSQL - not
> that I know of anything in the SQL standards that say how to handle KV
> types in the style of hstore.
>
> Which BI tools, if any, either are aware of PostgreSQL in this way or at
> least minimize hindrances to using these types of data types or
> extensions?
>
> - Victor Tan
Native support is probably "zero" as Simon is implying.
Most BI ends up needing scalar values for calculations and display. Two
dynamics resulting because of this: either you have to supply your own SQL
in the BI tool and perform the needed conversions or you can create a BI
integration layer within your model so the tools can hit pre-defined schema
with the conversions already in place and the SQL the tools generate can be
used as-is.
I get what you are saying but all I am coming up with more questions to ask
regarding your use-case. For better and worse most tool developers want to
be vendor agnostic to the largest degree possible. The good news is there
are a number of open-source projects that may suffice and that with a strong
enough need a PostgreSQL specific module could be developed. Unless you are
willing to try and sponsor some of that work I'd suggest being open with you
needs and desires and give others a chance to buy into and leverage the
ideas and suggestions and thus ideally increase the demand for such.
David J.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/BI-tools-and-PostgreSQL-tp5776892p5776910.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2013-11-04 20:49 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2013-11-04 19:18 BI tools and PostgreSQL Victor Tan <victortcs@gmail.com>
2013-11-04 20:05 ` Simon Riggs <simon@2ndQuadrant.com>
2013-11-04 20:49 ` David Johnston <polobo@yahoo.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox